Cardrona 1.0

Overview

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

Custom Fields

Field Name	Source
PayCode	Paid Activity
RateCode	Paid Activity
CostCenterCode	Paid Activity

Payroll Export Requirements

Payroll Requirements/Analysis File

https://docs.google.com/spreadsheets/d/1Ylk-5ioKwLBX_NUxVG8xL6cKW0kXX-BL/edit?usp=sharing&ouid=117812218641190502549&rtpof=true&sd=true

Benefit Days - To allow the payroll system to track benefit days worked an extra line is required in the payroll file for each instructor for each day worked with the paycode = WRKD and the quantity = 1 (no time minimum)

Allowances - the allowance is an additional allowance paycode on an activity that creates a line in the payroll file with the allowance paycode and the hours worked. This paycode then drives a hourly commission rate that is set up in the payroll system (Ex A1 adds $1 an hour, A2 adds $2 an hour in their payroll system)

Holiday - They would like a different paycode to be sent on the holiday to flag time and a half to be paid in the payroll system. There is only one holiday day in the ski season. If this is not possible suggested workarounds are:

WORKAROUNDS

1. Set up a second set of products with the holiday paycode

2. Intercept the pay file and manually replace the paycode (they are concerned about security)

3. Override the paycode in the payroll system

Leading Zeroes - Leading Zeroes on pay codes must persist 001

Commissions - total daily commission amount for an instructor should be sent in a line with Paycode = EXTRA, Quantity = 1 and the commission amount in dollars in the RateAmount = $commission

Header - Do not include a header in the payroll file Pay Period - the extract should include the data for the previous 2 weeks

File Format

Field Name	source / flaik field
EmployeeCode	Payroll ID
PayCode	Add a field on paid activity for resort to enter this
Quantity	Hours Worked if it is an hourly paycode 1 - if it is the benefit day paycode WRKD 1 - if it is a commission type paycode
RateCode	Add a field on paid activity for resort to enter this
CostCentreCode	Add a field on paid activity for resort to enter this
Date	Activity Date
RateAmount	Total Commission in Dollars
Factor	Blank
TotalAmount	Blank
Recalculate	Blank
ReasonCode	Blank
JobCode	Blank
Reduce Quantity	Blank
Leave date end	Blank

Allowance Code

Allowance Code	Description	Factor	Unit Rate
1	Ordinary Time	1	0
006B	PH Hours Worked @T1.5	1.5	0
A1	Allowance $1	1	1
A2	Allowance $2	1	2
A20	Allowance 20c	1	0.2
A3	Allowance $3	1	3
A3.4	Allowance $3.40	1	3.4
A35	Allowance $35	1	35
A40	Allowance $40	1	40
A5	Allowance 50c	1	0.5
EXTRA	Extras	1	0