This file is a payment history extract file. It is created by selecting the DECENT. format from the payment history extract screen. Selecting this format will result in a file that mirrors the PPSD Data Management business month payment history tape. Note: Data in this file format can only be downloaded. It can not be used to generate ad hoc reports in CIRS.
Segment 1, Segment Occurs = 1 time, Segment Size = 484
|
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, Personnel
|
3
|
X(3)
|
|
48
|
Key Sequence Code
|
2
|
9(2)
|
|
50
|
Suspense Code
|
1
|
X
|
|
51
|
Earnings ID #1
|
4
|
X(4)
|
|
55
|
Earnings ID #2
|
4
|
X(4)
|
|
59
|
Earnings ID #3
|
4
|
X(4)
|
|
63
|
Fiscal Year (CCYY)
|
4
|
9(4)
|
|
67
|
Special Pay
|
1
|
X
|
|
68
|
Record Type
|
1
|
X
|
|
69
|
Summarized Warrant
|
1
|
X
|
|
70
|
Reported Redeposit
|
1
|
X
|
|
71
|
Class Type
|
1
|
X
|
|
72
|
Budget Function Code
|
3
|
X(3)
|
|
75
|
Suspense Date
|
6
|
X(6)
|
|
82
|
Accounts Receivable Dock Time Code
|
1
|
X
|
|
83
|
Collective Bargaining ID
|
3
|
X(3)
|
|
86
|
Collective Bargaining Authority
|
1
|
X
|
|
88
|
Locked-In-Premium Indicator
|
1
|
X
|
|
89
|
Accounts Receivable Type
|
1
|
X
|
|
90
|
Register Warrant Indicator
|
1
|
X
|
|
91
|
Name, First Init
|
1
|
X
|
|
92
|
Name, Middle Init
|
1
|
X
|
|
93
|
Name, Last
|
21
|
X
|
|
114
|
Issue Date (CCYYMMDD)
|
8
|
X(8)
|
|
122
|
Original Issue Date (CCYYMMDD)
|
8
|
X(8)
|
|
130
|
Originating Document Transaction Code
|
3
|
X(3)
|
|
142
|
Payment Type
|
1
|
X
|
|
143
|
Payment Type, Suffix
|
1
|
X
|
|
144
|
Adjustment Code
|
1
|
X
|
|
145
|
Accounts Receivable Code
|
1
|
X
|
|
146
|
Roll Code
|
1
|
X
|
|
147
|
Range Code
|
2
|
X(2)
|
|
149
|
FLSA
|
4
|
X(4)
|
|
153
|
Salary Type
|
1
|
X
|
|
154
|
Salary Rate
|
7
|
S9(5)V99
|
|
161
|
Actual Rate
|
7
|
S9(5)V99
|
|
168
|
Salary Full
|
7
|
S9(5)V99
|
|
175
|
Gross Type
|
1
|
X
|
|
176
|
Time Base Numerator
|
3
|
X(3)
|
|
179
|
Time Base Denominator
|
3
|
X(3)
|
|
182
|
Shift Differential
|
1
|
X
|
|
183
|
Overtime Code
|
1
|
X
|
|
184
|
Days Paid
|
2
|
99
|
|
186
|
Hours Paid
|
5
|
S9(3)V99
|
|
184
|
Units Paid
|
7
|
S9(5)V99
|
|
191
|
Days Docked
|
2
|
S9(2)
|
|
193
|
Hours Docked
|
3
|
S9V99
|
|
196
|
Federal Married Status
|
1
|
X
|
|
197
|
Federal Tax Exemptions
|
2
|
9(2)
|
|
199
|
Federal Tax Gross, Employee
|
7
|
S9(5)V99
|
|
206
|
Federal Tax Withheld, Employee
|
7
|
S9(5)V99
|
|
217
|
State Married Status
|
1
|
X
|
|
218
|
State Tax Exemptions
|
2
|
9(2)
|
|
220
|
State Itemized Allowances
|
2
|
9(2)
|
|
222
|
State Code 1
|
2
|
X(2)
|
|
224
|
State Tax Gross 1
|
7
|
S9(5)V99
|
|
231
|
State Tax Withheld 1
|
7
|
S9(5)V99
|
|
242
|
State Code 2
|
2
|
X(2)
|
|
244
|
State Tax Gross 2
|
7
|
S9(5)V99
|
|
251
|
State Tax Withheld 2
|
7
|
S9(5)V99
|
|
262
|
Employee Social Security Tax Gross
|
7
|
S9(5)V99
|
|
269
|
Employee Social Security Withheld
|
7
|
S9(5)V99
|
|
276
|
Employer Social Security Tax Gross
|
7
|
S9(5)V99
|
|
283
|
Employer Social Security Withheld
|
7
|
S9(5)V99
|
|
290
|
Employee Medicare Tax Gross
|
7
|
S9(5)V99
|
|
297
|
Employee Medicare Withheld
|
7
|
S9(5)V99
|
|
304
|
Employer Medicare Tax Gross
|
7
|
S9(5)V99
|
|
311
|
Employer Medicare Withheld
|
7
|
S9(5)V99
|
|
318
|
Retirement System ID
|
2
|
X(2)
|
|
320
|
Retirement Rate
|
5
|
SV9(5)
|
|
325
|
Gross Subject Retirement
|
7
|
S9(5)V99
|
|
332
|
Retirement Withheld
|
7
|
S9(5)V99
|
|
339
|
Retirement State Share Amount
|
7
|
S9(5)V99
|
|
346
|
Retirement Employer Paid Member Contribution
|
7
|
S9(5)V99
|
|
353
|
Gross
|
7
|
S9(5)V99
|
|
360
|
LC 4800 Gross/Offset Amount
|
7
|
S9(5)V99
|
|
367
|
Net
|
7
|
S9(5)V99
|
|
374
|
Clearance Number
|
5
|
9(5)
|
|
379
|
Key Pay Period
|
1
|
X
|
|
380
|
Lump Sum Pay Period (YYMM)
|
4
|
X(4)
|
|
384
|
Filler
|
97
|
X(97)
|
|
481
|
Deduction Segment Count
|
4
|
S9(4)
|
Segment 2, Segment Occurs = 36 times, Segment Size = 93
|
1
|
Deduction Code
|
3
|
X(3)
|
|
4
|
Organization Code
|
3
|
X(3)
|
|
7
|
Restriction Code
|
1
|
X
|
|
8
|
Deduction Amount
|
7
|
S9(5)V99
|
|
15
|
Deduction Pay Period (CCYYMM)
|
6
|
X(6)
|
|
21
|
Deduction Pay Period Type
|
1
|
X
|
|
22
|
Deduction Tax Gross Indicator
|
1
|
X
|
|
23
|
Filler
|
8
|
X(15)
|
|
31
|
Deduction Type
|
2
|
X(2)
|
Note: The fields below are dependent on Deduction Type. They are included in the segment size of 93.
Deduction Type = AR (Accounts Receivable)
|
33
|
Accounts Receivable Number
|
5
|
X(5)
|
|
38
|
Payment Type
|
1
|
X
|
|
39
|
Taxable Gross
|
7
|
S9(5)V99
|
|
46
|
Filler
|
48
|
X(48)
|
Deduction Type = BL (Basic Life)
|
33
|
State Share Amount
|
5
|
S9(3)V99
|
|
38
|
Agency Code
|
3
|
X(3)
|
|
41
|
Reporting Unit
|
3
|
X(3)
|
|
44
|
Collective Bargaining ID
|
3
|
X(3)
|
|
47
|
Collective Bargaining Authority
|
1
|
X
|
|
48
|
Filler
|
46
|
X(46)
|
Deduction Type = GA (Garnishment)
|
33
|
Effective Date (CCYYMMDD)
|
8
|
X(8)
|
|
41
|
Termination Date (CCYYMMDD)
|
8
|
X(8)
|
|
49
|
Original Amount
|
7
|
S9(5)V99
|
|
56
|
Original Amount Owed To Agency
|
7
|
S9(5)V99
|
|
63
|
Agency Amount Applied
|
7
|
S9(5)V99
|
|
70
|
Tax Standard Deduction Amount Indicator
|
1
|
X
|
|
71
|
Tax Dependents
|
2
|
99
|
|
73
|
Maximum Amount
|
7
|
S9(5)V99
|
|
80
|
Support Exemption Amount
|
7
|
S9(5)V99
|
|
87
|
Support Amount Per Month
|
7
|
S9(5)V99
|
Deduction Type = GI (Government Life Insurance)
|
33
|
Prefix
|
2
|
X(2)
|
|
35
|
Policy Number
|
8
|
X(8)
|
|
43
|
Filler
|
51
|
X(51)
|
Deduction Type = HB, HD, HV, FA, FB, FC, FD, FH
(Health Benefit, Dental Plan, Vision Care, Flexible Benefit Deduction)
|
33
|
State Share Amount
|
5
|
S9(3)V99
|
|
38
|
Administration Cost
|
5
|
S9(3)V99
|
|
43
|
Party Rate Code
|
1
|
X
|
|
44
|
Filler
|
1
|
X
|
|
45
|
Agency Code
|
3
|
X(3)
|
|
48
|
Reporting Unit
|
3
|
X(3)
|
|
51
|
Collective Bargaining ID
|
3
|
X(3)
|
|
54
|
Collective Bargaining Authority
|
1
|
X
|
|
55
|
Filler
|
1
|
X
|
|
56
|
Matching Deduction Code
|
3
|
X(3)
|
|
59
|
Matching Organization Code
|
3
|
X(3)
|
|
62
|
Matching Deduction Indicator
|
1
|
X
|
|
63
|
Filler
|
31
|
X(31)
|
Deduction Type = ZS, ZM, SS, MD
(Mandatory Arrears Social Security and Medicare)
|
33
|
Issue Century
|
2
|
X(2)
|
|
35
|
Issue Year
|
2
|
X(2)
|
|
37
|
Fiscal Century
|
2
|
X(2)
|
|
39
|
Fiscal Year
|
2
|
X(2)
|
|
41
|
Quarter Code
|
1
|
X
|
|
42
|
Agency Code
|
3
|
X(3)
|
|
45
|
Reporting Unit
|
3
|
X(3)
|
|
48
|
Employee Social Security/Medicare Tax Gross
|
7
|
S9(5)V99
|
|
55
|
Employer Social Security/Medicare Tax Gross
|
7
|
S9(5)V99
|
|
62
|
Employer Social Security/Medicare Tax Withheld
|
7
|
S9(5)V99
|
|
69
|
Filler
|
25
|
X(25)
|
Deduction Type = PG (General Service Parking Fee)
|
33
|
Lot Number
|
2
|
X(2)
|
|
34
|
Filler
|
59
|
X(59)
|
Deduction Type = RJ, RP, RT (Retroactive Retirement Adjustment)
|
33
|
Salary Type
|
1
|
X
|
|
34
|
Salary Rate
|
7
|
S9(5)V99
|
|
41
|
Gross Subject to Retirement
|
7
|
S9(5)V99
|
|
48
|
State Share Amount
|
7
|
S9(5)V99
|
|
55
|
Retirement Rate
|
5
|
SV9(5)
|
|
60
|
Retirement System ID
|
2
|
X(2)
|
|
62
|
Agency Code
|
3
|
X(3)
|
|
65
|
Reporting Unit
|
3
|
X(3)
|
|
68
|
Payment Type
|
1
|
X
|
|
69
|
Adjustment Code
|
1
|
X
|
|
70
|
Employer Paid Member Contribution Amount
|
7
|
S9(5)V99
|
|
77
|
Collective Bargaining ID
|
3
|
X(3)
|
|
80
|
Collective Bargaining Authority
|
1
|
X
|
|
81
|
Filler
|
13
|
X(13)
|
Deduction Type = ZF, ZT (Mandatory Federal/State Tax)
|
33
|
Issue Century
|
2
|
X(2)
|
|
35
|
Issue Year
|
2
|
X(2)
|
|
37
|
Tax Gross
|
7
|
S9(5)V99
|
|
44
|
Filler
|
50
|
X(50)
|
Format X - Alphanumeric
Format 9 - Number
Format S - Sign (+ or -)
Last Updated: July 13, 2004