Payment History Extract - SCO Production Format File Description

This file is a payment history extract file. It is created by selecting the SCO PROD (Production) format from the payment history extract screen. Selecting this format will result in a payment history file which includes the same fields as the business month payment history tape (DESCENT. Format), but which contains packed fields. Note: Data in this file format can only be downloaded. It can not be used to generate ad hoc reports in CIRS.

File Name: PD.CSUCFOC.RPTUSER.SCOPROD.userid

Record Length: 3409

Organization: One record per payment transaction.

Segment 1, Segment Occurs 1 time, Segment Size = 484

Start Position	Description	Length	Format
1	Social Security Number	9	X(9)
10	Pay Period Date (YYMM)	4	9(4)
14	Pay Period Type	1	X
15	Position Sequence Number	2	9(2)
17	Agency Code	3	X(3)
20	Reporting Unit	3	X(3)
23	Class Code	4	X(4)
27	Serial Number	3	X(3)
30	Cycle Date (YYMMDD)	6	X(6)
36	Warrant Number	8	X(8)
36	Accounts Receivable Number	5	X(5)
44	Clearance Type	1	X
45	Transaction Code	3	X(3)
52	Earnings ID #1	4	X(4)
56	Earnings ID #2	4	X(4)
60	Earnings ID #3	4	X(4)
64	Collective Bargaining ID	3	X(3)
69	Name, First Int.	1	X
70	Name, Middle Int.	1	X
71	Name, Last	21	X(21)
92	Issue Date (CCYYMMDD)	8	X(8)
100	Original Issue Date (CCYYMMDD)	8	X(8)
108	Transaction Code	3	X(3)
111	PSD File Number	9	X(9)
120	Register Warrant Indicator	1	X
121	Class Type	1	X
122	Payment Type	1	X
123	Payment Type Suffix	1	X
124	Adjustment Code	1	X
125	Accounts Receivable Code	1	X
126	Roll Code	1	X
127	Range Code	2	X(2)
129	FLSA	4	X(4)
133	Salary Type	1	X
134	Gross Type	1	X
135	Shift Differential	1	X
136	Over Time Code	1	X
137	Time Base Numerator	3	X(3)
140	Time Base Denominator	3	X(3)

143	Days Paid	2	P2
143	Units Paid	4	P4.2
145	Hours Paid	2	P3.2
148	Days Docked	2	P2
150	Hours Docked	2	P2.2
152	Federal Tax Gross, Employee	4	P4.2
156	Federal Tax Withheld, Employee	4	P4.2
160	State Code #1	2	X(2)
162	State Tax Gross, Employee	4	P4.2
166	State Tax Withheld, Employee	4	P4.2
170	State Code #2	2	X(2)
172	State Tax Gross, Employee 2	4	P4.2
176	State Tax Withheld, Employee 2	4	P4.2
180	Social Security Tax Gross, Employee	4	P4.2
184	Social Security Withheld, Employee	4	P4.2
188	Medicare Tax Gross, Employee	4	P4.2
192	Medicate Tax Withheld, Employee	4	P4.2
196	Gross Pay	4	P4.2
200	Retirement System ID	2	X(2)
213	Fiscal Year End (CCYY)	4	X(4)
217	Special Pay	1	X
218	Record Type	1	X
219	Summarized Warrant	1	X
220	Reported Redeposit	1	X
221	Locked In Premium Indicator	1	X
222	Account Receivable Type	1	X
223	Lump Sum Pay Period (CCYYMM)	6	X(6)
231	Actual Rate	4	P4.2
235	Salary Rate	4	P4.2
239	Salary Full	4	P4.2
243	Married Federal	1	X
244	Tax Exemptions Federal	2	9(2)
250	Married State	1	X
251	Tax Exemptions State	2	9(2)
253	Itemized Allowances State	2	9(2)
259	Social Security Tax Gross, Employer	4	P4.2
263	Social Security Withheld, Employer	4	P4.2
267	Medicare Tax Gross, Employer	4	P4.2
271	Medicate Tax Withheld, Employer	4	P4.2
275	Retirement Rate	3	P3.5
278	Gross Subject Retirement	4	P4.2
282	Retirement Withheld	4	P4.2
286	Retirement State Share Amount	4	P4.2
290	Retirement EPMC Amount	4	P4.2
294	IDL Offset	4	P4.2
298	Net Pay	4	P4.2
302	Clearance Number	5	X(5)
307	Budget Function	3	X(3)
310	Original Suspense Date (CCYYMMDD)	8	X(8)
318	Filler	104	X(104)

Segment 2, Segment Occurs 36 times, Segment Size = 83

Note: The fields below Deduction Type are dependent on Deduction Type.

They are included in the segment size of 83.

Start Position	Description	Length	Format
1	Deduction ID	6	X(6)
1	Deduction Code	3	X(3)
4	Organization Code	3	X(3)
7	Restriction Code	1	X
8	Deduction Amount	4	P4.2
12	Deduction Pay Period (CCYYMM)	6	X(6)
18	Deduction Pay Period Type	1	X
19	Deduction Tax Gross Indicator	1	X
32	Deduction Type	2	X(2)

Deduction Type = AR (Accounts Receivable)

Start Position	Description	Length	Format
34	Accounts Receivable Number	5	X(5)
39	Payment Type	1	X
40	Taxable Gross	4	P4.2

Deduction Type = BL (Basic Life)

Start Position	Description	Length	Format
34	State Share Amount	3	P3.2
37	Agency Code	3	X(3)
40	Reporting Unit	3	X(3)
43	Collective Bargaining ID	3	X(3)
46	Collective Bargaining Authority	1	X
34	Effective Date (CCYYMMDD)	8	X(8)
42	Termination Date (CCYYMMDD)	8	X(8)
50	Original Amount	4	P4.2
54	Original Amount Owed To Agency	4	P4.2
58	Agency Amount Applied	4	P4.2
62	Tax Dependents	2	P2
64	Maximum Amount	4	P4.2
68	Support Exemption Amount	4	P4.2
72	Support Amount Per Month	4	P4.2
76	Tax Standard Deduction Amount Indicator	1	X

Deduction Type = GI (Government Life Insurance)

Start
Position

Description

Length

Format

Prefix

X(2)

Policy Number

X(8)

Deduction Type = HB, HD, HV, FA, FB, FC, FD, FH

Start Position	Description	Length	Format
34	State Share Amount	3	P3.2
37	Administration Cost	3	P3.2
40	Party Rate Code	1	X
41	Health Benefits Plan	1	X
42	Agency Code	3	X(3)
45	Reporting Unit	3	X(3)

Deduction Type = MD, ZM (Mandatory Arrears Medicare)

Start Position	Description	Length	Format
34	Issue Century	2	X(2)
36	Issue Year	2	X(2)
38	Fiscal Century	2	X(2)
40	Fiscal Year	2	X(2)
42	Quarter Code	1	X
43	Agency Code	3	X(3)
45	Reporting Unit	3	X(3)
49	Employee Medicate Tax Gross	4	P4.2
53	Employer Medicare Tax Gross	4	P4.2
57	Employer Medicare Tax Withheld	4	P4.2
34	Salary Type	1	X
37	Salary Rate	4	P4.2
39	Gross Subject to Retirement	4	P4.2
43	State Share Amount	4	P4.2
47	Retirement Rate	3	P3.5
50	Retirement System ID	2	X(2)
52	Agency Code	3	X(3)
55	Reporting Unit	3	X(3)
58	Payment Type	1	X
59	Adjustment Code	1	X
60	Employer Paid Member Contribution Amt.	4	P4.2
64	Collective Bargaining ID	3	X(3)
67	Collective Bargaining Authority	1	X

Deduction Type = SS, ZS (Mandatory Arrears Social Security)

Start Position	Description	Format	Length
34	Issue Century	2	X(2)
36	Issue Year	2	X(2)
38	Fiscal Century	2	X(2)
40	Fiscal Year	2	X(2)
42	Quarter Code	1	X
43	Agency Code	3	X(3)
45	Reporting Unit	3	X(3)
49	Employee Social Security Tax Gross	4	P4.2
53	Employer Social Security Tax Gross	4	P4.2
57	Employer Social Security Withheld	4	P4.2

Deduction Type = ZF, ZT (Mandatory Federal/State Tax)

Start Position	Description	Format	Length
34	Issue Century	2	X(2)
36	Issue Year	2	X(2)
38	Tax Gross	4	P4.2

Format X - Alphanumeric

Format 9 - Number

Format S - Sign (+ or -)

Format V - Implied Decimal Point