Payline Upload Template.xlsx

	A	B	C	D	F
1	Here are the instructions for the information that needs to be filled out on the template. The columns that need to be filled in are highlighted in green.			Updated 05/25/22	was Payline_Adjustments_Earnings_template
2	Column	Column Name	Values	Notes
3	A	Paysheet Update Source	OT - for Other Sources
4	B	Creation Date	MM/DD/YYYY Format
5	C	Company	Company – Three digit district number - Text format
6	D	Pay Group	Pay Group – 3 character ##M, ##P or ##E; Found on Job Data record for employee and position Also listed in query below*
7	E	Pay Period End Date	MM/DD/YYYY Last day of month data is being paid in
8	F	Off Cycle ?	N for Off-Cycle Y for On-Cycle
9	G	Earnings Begin Date	MM/DD/YYYY format
10	H	Earnings End Date	Earnings End Date – Must be the same month as the Earns Begin Date (Earns Begin and End cannot cross multiple months)
11	I	Empl ID	###### - 6 digits
12	J	Empl Record	Empl Record – Empl Record associated with the position
13	K	Sequence Number	Default should be 0. If multiple lines for same Empl Id and same Empl Record, increment 1 for each additional line.
14	L	Paysheet Transaction Type	E - for Earnings
15	M	Transaction Status	A
16	N	Earnings Code	Earnings Code - Valid 3 digit Earning Code; See
17	O	Other Hours	Round to two decimals if used
18	P	Hourly Rate	Round to 2 decimals if used, 6 is also okay if needed	Have guys guys used 6 decimal places?
19	Q	OK to Pay	Y for "Yes"
20	R	Amount	Amount - Amount to be paid; Round to two decimals if used; Negatives are entered with a "minus" front of number
21
22
23	Please Note:
24	Do NOT alter the format of any cells on the Data Input worksheet or tab. Doing so will cause the Excel-to-CI to fail or produce unpredictable results.
25
26	If you are populating the Data Input worksheet or tab from another source document you MUST use the Paste Values option, otherwise the Paste operation will corrupt the cells' predefined format causing the Excel-to-CI to fail or produce unpredictable results.
27
28	Query for Data Input	M_HR_EE_VALIDATION_DIST_PROMPT*
29	Query for Data Validation (after upload)	M_PY_PAYSHEET_DEDN_AUDIT
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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
90
91
92
93
94
95
96
97
98
99
100