OTPAY_UPDOCS_Template.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
1	One Time Payment									One-Time Payment Detail
2			OTPAY_DOC_HDR	OTPAY_DOC_HDR	OTPAY_DOC_HDR	OTPAY_DOC_HDR	OTPAY_DOC_LINE	OTPAY_DOC_HDR	OTPAY_DOC_HDR	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE	OTPAY_DOC_LINE
3	SPD_DOC_ID	AUTO_NO_FL	DOC_CD	DOC_DEPT_CD	DOC_ID	DOC_UNIT_CD	DOC_LINE_LN_NO	EMPLOYEE_ID	APPOINTMENT_ID	EVNT_TYP_CD	CNTRCT_PAY_AM	EFFECTIVE_DT	SUPPL_TYP_ID	SCHD_LCTN_CD	LABR_DIST_OVRD_FL	LABR_DIST_PROF_CD	POSN_ID	FUND_CD	SFUND_CD	DEPT_CD	UNIT_CD	SUNIT_CD	APPR_CD	OBJ_CD	SOBJ_CD	RSRC_CD	SRSRC_CD	BSA_CD	SBSA_CD	OBSA_CD	SOBSA_CD	DOBJ_CD	DRSRC_CD	LOC_CD	SLOC_CD	ACTV_CD	SACTV_CD	FUNC_CD	SFUNC_CD	RPT_CD	SRPT_CD	TASK_CD	STASK_CD	TASK_ORD_CD	PROG_CD	PHASE_CD	PPC_CD	REF_DOC_CD	REF_DOC_DEPT_CD	REF_DOC_ID	REF_DOC_VERS_NO	REF_DOC_VEND_LN_NO	REF_DOC_COMM_LN_NO	REF_DOC_ACTG_LN_NO
4	*Spreadsheet Doc Id	Auto Numbering	*Code	*Dept	ID	Unit	*One-Time Payment Detail Line No	*Employee ID	Appointment ID	*Pay Type	*Payment Amount	*Event Date	*Supplemental Pay	Schedule Location	*Labor Distribution Override Option	Labor Distribution Profile	Position Number	Fund	Sub Fund	Department	Unit	Sub Unit	Appr Unit	Object	Sub Object	Revenue	Sub Revenue	BSA	Sub BSA	OBSA	Sub OBSA	Dept Object	Dept Revenue	Location	Sub Location	Activity	Sub Activity	Function	Sub Function	Reporting	Sub Reporting	Task	Sub Task	Task Order	Program	Phase	Program Period	Reference Transaction Code	Reference Transaction Dept	Reference Transaction ID	Reference Version	Reference Vendor Line	Reference Commodity Line	Reference Accounting Line
5	1	TRUE	OTPAY	AAEA			1	9980000036		BNS	50	12/01/2025	1		0
6	2	TRUE	OTPAY	AAEA			1	9980000037		BNS	50	12/01/2025	1		3	CONV
7	3	TRUE	OTPAY	AAEA			1	9980000038		BNS	50	12/01/2025	1		4
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