File Formats

Alterra Export File Formats

Incentives Export File

Person Number	Source
Effective Date	Paid Activity Date
Pay Code	Incentive -> Pay Code
Amount	Total Hours worked for date
Business Structures/Job	Paid Activity -> Business Structure
Labor Category Level Id	Staff Profile -> Teaching Wage Position ID

Wages Export File

There will be one line for each paid activity for each instructor for each day

Field Name	Field Source
Person Number	Payroll ID
InDate	Date
InTime	Start Time of Paid Activity
InOverrideType	Hardcoded "Punch In"
InBusiness StructureJOb	Paid Activity -> Business Structure
InLCL1	Staff Profile -> Teaching Wage Position ID
InLCL2
InLCL3
InLCL4
InLCL5
InLCL6
InWorkRule
InTimeZone
InComment1
InComment1Note1
OutDate	Date
OutTime	End Time of Paid Activity
OutOverrideType	Hardcoded to = "Punch Out"
OutBusiness StructureJOb	Paid Activity -> Business Structure
OutLCL1	Staff Profile -> Teaching Wage Position ID
OutLCL2
OutLCL3
OutLCL4
OutLCL5
OutLCL6
OutWorkRule
OutTimeZone
OutComment1
OutComment1Note1
DeductionRuleToCancel