PSHUP Template for EARNINGS.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE
1	PU_SOURCE	CREATION_DT	COMPANY	PAYGROUP	PAY_END_DT	OFF_CYCLE	EARNS_BEGIN_DT	EARNS_END_DT	EMPLID	EMPL_RCD	SEQNO	PU_TXN_TYPE	PU_TXN_STATUS	PAGE_NUM	LINE_NUM	ADDL_NBR	SEPCHK	DEPTID	JOBCODE	POSITION_NBR	ACCT_CD	GL_PAY_TYPE	PU_DISTRIBUTE	ERNCD	ADDL_PAY_SHIFT	ADDL_SEQ	ADDLPAY_REASON	OTH_HRS	HOURLY_RT	OK_TO_PAY	DISABLE_DIR_DEP	STATE	LOCALITY	TAX_PERIODS	TAX_METHOD	DED_TAKEN	DED_SUBSET_ID	DED_TAKEN_GENL	DED_SUBSET_GENL	BUSINESS_UNIT	COMP_RATECD	TAX_CLASS	ONE_TIME_CD	CTX_CLASS	PLAN_TYPE	BENEFIT_PLAN	DEDCD	DED_CLASS	DED_CALC	DED_RATE_PCT	PU_AMT	MANUAL_CHECK	PAYCHECK_NBR	DED_SLSTX_CLASS	EX_DOC_ID	EX_DOC_TYPE	EX_LINE_NBR	CURRENCY_CD	OVERRIDE_ONLY	GROSSUP	VC_PLAN_ID	VC_PAYOUT_PRD_ID	GB_GROUP_ID	APPLID	AWARD_DATE	EIM_KEY	PAYOUT_DT	PU_TXN_MANUAL_CHG	CHECK_DT	OPRID	GARNID	GARN_ONE_TIME_CD	GARN_PRIORITY	GARN_DED_CALC	GARN_DED_PCT	GARN_DED_AMT	CMPNY_FEE_PCT	CMPNY_FEE_AMT	PAYEE_FEE_PCT	PAYEE_FEE_AMT	PY_GARN_EXEMPT	WORK_PSD_CD	RES_PSD_CD
2	OT	5/5/2023	010	E01	5/15/2023	N	4/16/2023	4/30/2023	XXXXXXXXX	X	1	E	A	0	0	0	0	98620			000204043			STP	N	0		50.00	0.000000	Y	N			0																0.000	100.00	N	0	B			0		Y	N								N		CTC_FUNCTIONAL			0	0	0.00	0.00	0.00	0.00	0.00	0.00
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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