Matrix (Time Express) Export
From sbv.wiki
One total line for the whole pay period (not each day separately).
Employees that are ExcludeFromPayrollExport will not be on the report.
Pay types marked as ExcludedFromPayroll will not be on the report.
Export path works with merge fields.
- Employee ID,
- Department ID,
- Diff Payroll Code, If the export code is only one latter then it will put it in this column (used for diffs).
- Benefit/Other Payroll Code, If the export code is more than one latter then it will put it in this column (used for all other pay types besides Reg and OT) Reg and OT should not have an export code at all as Matrix wants them blank.
- Regular Hours, Hours amount for all pay types that are Type: "Not Overtime".
- Overtime Hours, Hours amount for all pay types that are Type: "Overtime".
- Not in use 1,
- Not in use 2,