Cardrona Payroll Export 2.0.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1			*** DO NOT INCLUDE HEADER IN PAYROLL FILE ***
2			Payroll System
3			Export File	Timekeeping Report ONLY
4			Frequency	Bi-Weekly
5			File Format	.csv
6			File Naming Req	be nice to have the ‘Date file generated, business unit, system’. i.e 29042022CardronaFlaik
7			File Transfer	SFTP
8
9			Field Name	WAGE LINE	INCENTIVE LINE	BASE INCENTIVE LINE	BENEFIT LINE	source / flaik field Eport 1.0	source / flaik field Eport 2.0
10			EmployeeCode	3902	3902	1234	3902	Payroll ID	Payroll ID
11			PayCode	312	EXTRA	A2	WRKD	IF INCENTIVE THEN Paycode = EXTRA ELSE Paycode = Paid Activity.Paycode	IF INCENTIVE THEN Paycode = Incentive -> Paycode ELSE Paycode = Paid Activity -> Paycode	Paycode Incentive = EXTRA or A2 etc Paycode Paid Activity = WRKD
12			Quantity	4.75	1	2	1	IF INCENTIVE OR BENEFIT LINE THEN Quatity = 1 ELSE Quantity = # of Hours of Paid Activity	IF INCENTIVE OR BENEFIT LINE THEN Quatity = 1 ELSE Quantity = # of Hours of Paid Activity
13			RateCode		0			Pulled from Paid Activity -> Ratecode	Pull from Paid Activity -> Job Code Field	P
14			CostCentreCode	141151000	141151000	4061042205		Add a field on paid activity for resort to enter this	Pull from Paid Activity -> Business Structure	Business Structure
15			Date	20220221	20220221	20220502	20220221	Activity Date	Activity Date
16			RateAmount		20			Total Commission in Dollars	Total Incentives in Dollars (Excluding Hourly/Base Inentives)
17			Factor					Blank	Blank
18			TotalAmount					Blank	Blank
19			Recalculate					Blank	Blank
20			ReasonCode					Blank	Blank
21			JobCode					Blank	Blank
22			Reduce Quantity					Blank	Blank
23			Leave date end					Blank	Blank
24
25
26		LRS NOTES	Current Functionality
27		Backend auto generated	BENEFIT LINES - Auto Generated by flaik	These are paylines 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 (no time minimum)
28		Currently Using Allowances, we will transition to using Base Incentives on the Instructor ( for A1 add a $1 base Incentive to all Instructors and assign to eligible Paid activities)	ALLOWANCE LINES -> Change to use Base Incentives where Allowace Code is set up In Incentive -> Paycode	The allowance is an additional payline that is created by a paid activity. The allowance is attached to the paid Activity. It is an hourly incentive that has a specific paycode attached (A1 = $1 hour, A2 = $2 an hour) to specify the hourly dollar amout and the Quantity = Number of hours of the Paid activity. The allowance wattached to the Paid activity 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) and adds the hourly amount to the instructor pay in flaik						LRS APR 21 - where is the Allowance Paycode coming from? the paycodes on Allowances are blank?
29		Not Applicable	Holiday (NOT DONE)	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
30		Not currently working with New Fields	Leading Zeroes	Leading Zeroes on pay codes must persist 001
31			INCENTIVE LINES	total daily incentive amount for an instructor should be sent in a line with Paycode = EXTRA Quantity = 1 RateAmount = Incentive Amount in Dollars
32			Header	Do not include a header in the payroll file
33
34		NEW REQUIREMENTS May 30
35		Hourly Lesson Incentives	Enahancment Deployed								Cardrona 3.0
36		Exlcude first Participant from Headcount	- there is an issue with suggested workaround
37
38
39	#		Details						Comments
40	1	Group lesson (am/pm)	$3 additional person when more than two in a group						Code for all tasks which are group lessons		remove the 1st person exclusion == flaik native
41	2	Under 5's Privates	$14 for returning						Coded that they get an extra $14 if the task is Private U5 Ski or Private U5 SB		align with regular private incentive			maybe add a flat rate 'bonus' for wiping noses
42	3	Under 5's Groups	$5 / additional child when more than 2 in a group						Hard coded to task id for U5's Group AM and U5's Group PM		is this really a product you want to offer? canabiises your private					see above replicate gorup lessons
43	4	1 hour private	Assigned - $8 per additional person per lesson. Request - $16 per additional person per lesson						Coded for tasks specified as a private		move to per person OR per hour
44	5	1.5 hour private	Assigned - $10 per additional person per lesson. Request - $20 per additional person per lesson						Coded for tasks specified as a private		OR - flat rate
45	6	2 hour private	Assigned - $12 per additional person per lesson. Request - $24 per additional person per lesson						Coded for tasks specified as a private		ideally - just don't charge for Additional people and use that to drive higher Assigned / Request
46	7	3 hour private	Assigned - $16 per additional person per lesson. Request - $32 per additional person per lesson						Coded for tasks specified as a private
47	8	6 hour private	Assigned - $25 per additional person per lesson. Request - $50 per additional person per lesson						Coded for tasks specified as a private
48	9	Adaptive/telemark lesson	Assigned rate plus $4 an hour extra for assigned lessons						Any class with the discipline outlined as adaptive or telemark will get $4 extra an hour		roll into regular provate scheme
49	10	Adaptive Request Private	Assigned rate plus $14 an hour extra for request lessons booked at adapative rate)						Coded for tasks specified as Private U5 Ski and Private U5 SB		make same as regualr Privarte BUT add extra hourly incentive
50	11	Closed Day Pay	2 hours mountain rate excluding allowances
51	NEW REQUIREMENTS JUL 31
52		CPS Performance Private WST Performance Private	1. Pay a flat rate lesson incentive of $271.52 2. Add the Base Incentive (SSS $3 Equipment Allowance) A3
53		Syndicate Private	1. Pay a flat rate lesson incentive of $126 2. Add the Base Incentive (SSS $3 Equipment Allowance) A3 3. NEW Headcount Incentive (Flat Rate, not hourly) Guest 1 - $0 Guest 2 - $100 Guest 3 - $100 Guest 4 - $100
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89			Field Name	EmployeeCode	PayCode	Quantity	RateCode	CostCentreCode	Date	RateAmount	Factor	TotalAmount	Recalculate	ReasonCode	JobCode	Reduce Quantity	Leave date end
90			WAGE LINE	3902	312	4.75		141151000	20220221
91			INCENTIVE LINE	3902	EXTRA	1	0	141151000	20220221	20
92			BASE INCENTIVE LINE	1234	A2	2		4061042205	20220502
93			BENEFIT LINE	3902	WRKD	1			20220221
94			source / flaik field Eport 1.0	Payroll ID	IF INCENTIVE THEN Paycode = EXTRA ELSE Paycode = Paid Activity.Paycode	IF INCENTIVE OR BENEFIT LINE THEN Quatity = 1 ELSE Quantity = # of Hours of Paid Activity	Pulled from Paid Activity -> Ratecode	Add a field on paid activity for resort to enter this	Activity Date	Total Commission in Dollars	Blank	Blank	Blank	Blank	Blank	Blank	Blank
95			source / flaik field Eport 2.0	Payroll ID	IF INCENTIVE THEN Paycode = Incentive -> Paycode ELSE Paycode = Paid Activity -> Paycode	IF INCENTIVE OR BENEFIT LINE THEN Quatity = 1 ELSE Quantity = # of Hours of Paid Activity	Pull from Paid Activity -> Job Code Field	Pull from Paid Activity -> Business Structure	Activity Date	Total Incentives in Dollars (Excluding Hourly/Base Inentives)	Blank	Blank	Blank	Blank	Blank	Blank	Blank
96
97
98
99
100