Mt. Buller

Overview

Payroll Contact	Ross
Payroll System	CH21
Files Required	Timekeeping - Wages and Incentives combined in a single file
Header Row	NO HEADER
SFTP	NO - Manual
Payroll Frequency	Weekly - 7 days worth of date in the payroll file
File Naming Requirement	Require a .dat file (currently flaik only offers .csv)
Transfer Time	Currently Monday at 2:15 pm

Payroll Export Fields

Paid Activity -> Paycode	110 - Regular PAy
Incentive -> Paycode	315 - Allowance, 360 Incentive
Paid Activity -> Jobcode	RTP Activity Code

Timekeeping File Format

Wage Payline Format (Regular Pay - Paycode 110)

Vendor Name	Width	Format	flaik origin of data for file
Whitespace	8
Staff No.	5	Left Align	Staff Profile -> Payroll ID
Whitespace	13
Pay Period	6	DDMMYY	Apr 10: All Activities on date report is created rather than date activity occured Timekeeping Report Date: DDMMYY
Whitespace	4
Pay Code	3		Paid Activity -> Paycode
Whitespace	1
Hardcoded String	4	"0000"
Activity Code	4		Paid Activity -> Jobcode
Hardcoded String	2	"00"
Work Hours	4	HHMM	Apr10: Wage lines should be grouped and the Work Hours Summed if all of these things are identical [Payroll ID | Pay Code | Activity Code | Hourly Wage] Length of Paid Activity 2 hours and 30 minutes = 0250
Whitespace	1
Hardcoded String	2	"00"
Hourly Wage	4	DDCC	Staff Profile -> Hourly Wage

Incentive Payline Format (Incentive - Paycode 360)

Whitespace	8
Staff No.	5	Left Align	Staff Profile -> Payroll ID
Whitespace	13
Pay Period	6	DDMMYY	Apr 10: All Incentives on date report is created rather than date activity occured Timekeeping Report Date: DDMMYY
Whitespace	4
Pay Code	3		Incentive -> Paycode
Whitespace	1
Hardcoded String	4	"0000"
Activity Code	4		Paid Activity -> Jobcode
Hardcoded String	2	"00"
Work Hours	4		Apr10: Incentive lines should be grouped and the Work Hours Summed if all of these things are identical [Payroll ID | Pay Code | Activity Code | Hourly Wage] Length of Paid Activity 2 hours and 30 minutes = 0250
Whitespace	1
Hardcoded String	2	"00"
Hourly Wage	4		Hourly Amount of Incentive / Allowance

Requirements

• Fixed width spacing rather than .csv

• Combine Wage Lines - should be grouped and the Work Hours Summed if all of these things are identical [Payroll ID | Pay Code | Activity Code | Hourly Wage]

• Combine Incentive Lines - should be grouped and the Work Hours Summed if all of these things are identical [Payroll ID | Pay Code | Activity Code | Hourly Wage]