Alterra

Payroll System	Kronos/UKG
Transfer Method	SFTP with PGP Encryption
Files Used	Wages Incentives
Frequency	Daily
Time	10:00 pm (local time)

Overview

Payroll System	Workday
Transfer Method	SFTP with PGP encryption
Files	Wages (Dual Punch) · Incentives (Paycode Edit)
Frequency	Daily, 10:00 pm local
Filenames	dual_punch_<resort>_<YYYYMMDD>_<HHMM><AM/PM>.csv · paycode_edit_<resort>_<YYYYMMDD>_<HHMM><AM/PM>.csv

flaik produces the two files below. The Position IDs used to map each instructor to the correct wage are supplied by Workday through the Workday → flaik interface.

Wages file — Dual Punch

One row per work segment; each row carries a complete punch pair (In + Out). An instructor with several segments in a day gets one row per segment. Only the columns below are populated — every other column in the header (LCL2–LCL6, WorkRule, TimeZone, Comment1, Comment1Note1, DeductionRuleToCancel) is always left blank.

Column	flaik source / value
PersonNumber	Staff Profile → Payroll ID
InDate / OutDate	Segment date (yyyy-mm-dd)
InTime / OutTime	Segment start / end (HHMM, 24-hour)
InOverrideType / OutOverrideType	Hardcoded Punch In / Punch Out
InBusiness StructureJOb / OutBusiness StructureJOb	Paid Activity → Business Structure, formatted <code>/Employee
InLCL1 / OutLCL1	Staff → Wage Position ID

Within a row, the In and Out business structure and Position ID always match.

PersonNumber,InDate,InTime,InOverrideType,InBusiness StructureJOb,InLCL1, ... ,OutDate,OutTime,OutOverrideType,OutBusiness StructureJOb,OutLCL1, ...
900001,2026-01-15,0830,Punch In,100100/Employee,P900001, ... ,2026-01-15,1230,Punch Out,100100/Employee,P900001, ...
900001,2026-01-15,1230,Punch In,100200/Employee,P900001, ... ,2026-01-15,1630,Punch Out,100200/Employee,P900001, ...
900002,2026-01-15,0900,Punch In,100300/Employee,P900002, ... ,2026-01-15,1500,Punch Out,100300/Employee,P900002, ...

All values shown are illustrative — not real employee, position, or cost-centre data.

Incentives file — Paycode Edit

One row per employee, per pay code, per business structure. Amounts are dollar values.

Column	flaik source / value
Person Number	Staff Profile → Payroll ID
Effective Date	Paid Activity → Date (yyyy-mm-dd)
Pay Code	Incentive → Paycode (e.g. Incentive - SKS Combined, Incentive USA)
Amount	Calculated incentive dollars for that employee + pay code + business structure
Business Structures/Job	Paid Activity → Business Structure, formatted <code>/Employee
Labor Category Level Id	Staff → Wage Position ID

Person Number,Effective Date,Pay Code,Amount,Business Structures/Job,Labor Category Level Id
900001,2026-01-15,Incentive - SKS Combined,45,100200/Employee,P900001
900001,2026-01-15,Incentive USA,30,100200/Employee,P900001
900002,2026-01-15,Incentive - SKS Combined,52.50,100300/Employee,P900002

All values shown are illustrative — not real employee, position, or cost-centre data.