Cardrona 2024 Onwards

UNIQUE FUNCTIONALITY

4 Types of Paylines

Field Name	PayCode	Quantity	RateCode	CostCentreCode	RateAmount
Wage	Paycode from Paid Activity	Hours	Job Code	PA Business Structure	blank
Incentive	Paycode always EXTRA from Incentive	Hardcoded = 1	blank	PA Business Structure	Dollar Amount
Allowance (Base Inc)	Allowance Paycode (A2, A5 etc) from Staff Inc	Hours	blank	PA Business Structure	blank
Benefit Line (auto gen)	Hardcoded = WRKD	Hardcoded = 1	blank	blank	blank

PA - Abbreviation for Paid Activity

Benefit Days

These are payroll export lines are created in the back end through code. These allow the payroll system to track benefit days worked. An extra line should be automatically generated in the payroll file for each instructor for each day worked that day with the paycode = WRKD and the quantity = 1

Overview

Payroll System	Pay Global
Transfer Method	fortnightly (2 weeks of data to be included in extract)
Header Row	NO HEADER ROW
Frequency	Currently Manual, awaiting SFTP
File Naming Conventions	Date file generated, business unit, system "29042022CardronaFlaik"

Custom Fields

Field Name	Source	Export Column Name
PayCode	Paid Activity, Incentive	PayCode
JobCode	Paid Activity -> Jobcode	RateCode
CostCenterCode	Paid Activity -> Business Structure	CostCenterCode

Payroll Export Requirements

Payroll Requirements/Analysis File

https://docs.google.com/spreadsheets/d/1PiRe8dpyOh8p8i_s3PZZ-XcBH_m2f34m/edit?usp=sharing&ouid=117812218641190502549&rtpof=true&sd=true

File Format

Field Name	WAGE PAY LINE	INCENTIVE PAY	STAFF INC (ALLOWANCE)	BENEFIT PAYLINE
EmployeeCode	Payroll ID	Payroll ID	Payroll ID	Payroll ID
PayCode	Paid Activity -> Pay Code (SSSGENERAL)	Incentive -> Pay Code (EXTRA, A2, A5)		Hardcoded = WRKD
Quantity	Hours Worked	Hardcoded = 1	Hours for Allowance	Hardcoded = 1
RateCode	Paid Activity -> Job Code	Blank		Blank
CostCentreCode	Paid Activity -> Business Structure	Paid Activity -> Business Structure		BLANK
Date	Activity Date	Activity Date		Activity Date
RateAmount	Blank	Incentive Amount in Dollars		Blank
Factor	Blank	Blank		Blank
TotalAmount	Blank	Blank		Blank
Recalculate	Blank	Blank		Blank
ReasonCode	Blank	Blank		Blank
JobCode	Blank	Blank		Blank
Reduce Quantity	Blank	Blank		Blank
Leave date end	Blank	Blank		Blank