Mt. Ashland

Overview

EXPORT FILE META DATA
Timekeeping Type	isolve payroll specialities Timeworks Plus
Timekeeping Type	Mt Ashland
Paycodes/Business Structures	Not Used
Beta Program	Incentives
Payroll Contact	Colleen
Payroll System	isolve payroll specialities - timeworks plus
Files Required	TIMEKEEPING
Header Row	Yes
SFTP	No
Payroll Frequency	Every 2 weeks
File Naming Requirement
Transfer Type
Date Required	Ideal Delivery Date - End of November

File Format

Note

• Incentives will only be pulled from Paid Activities with the Wage Type = Teaching

• The payroll file will only include Teaching and Training wage Types. Non-Teaching and Private Request are not mapped into the payroll export file.

• The comma in the name field makes the header/colums appear misaligned if opened in spreadsheet

• The private request $10 per hour incentive must be manually added to each instructor in Staff Management and will not take effect until the following day.

NAME	Data populated from:
Legal	Harcoded = "E110"
PayGroup	Hardcoded = "Bi Weekly"
Division	Hardcoded = "01"
Department	Harcoded = "09"
Key (Employee Code)	flaik -> Payroll ID
Name	Last Name, First Name
LaborValue2
E_Regular Hours_Hours	Sum of the instructors Teaching Wage hours worked for 2 week period
E_Overtime @ Flat_Hours
E_Sick_Hours
E_Vacation_Hours
E_Holiday_Hours
E_Double Time_Hours
E_Holiday OT_Hours
E_Request Bonus_Dollars	Private Request Hourly Incentive Pay needs to be sent as a dollar amount (additional $10 an hour for requests)
E_Training Rate2_Hours	Sum of Instructors Training Wage hours worked for the 2 week Period
E_Bonus_Dollars
E_Wages Paid_Dollars
D_Cash Advance

Other Requirements

Private Request Incentive Pay - ($10 an hour) needs to be sent as a dollar amount applied Hourly.

Other Notes

flaik Term	Export FIle	Snowsports	Payroll File
Teaching Wage	Regular Hours	Teaching Lessons	E_Regular Hours_Hours
Training Wage	Training Rate 2	Support Hours	E_Training Rate2_Hours