This file is a payment history extract file. It is created by selecting the PC EDIT format from the payment history extract screen. Selecting this format will result in a file that has selected fields from the on-line payment history file in tab delimited text format. The PC EDIT file includes a header record with an abbreviated column title for each field in the PC EDIT file. This allows the user to download the PC EDIT file and open the tab delimited text file with a spreadsheet program such as EXCEL or LOTUS. The header record provides an easy way for the user to find a payment field without knowing the exact record layout of the PC EDIT file. 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 = 404
-
|
Social Security Number
|
9
|
X(9)
|
|
10
|
Tab
|
1
|
X
|
|
11
|
Pay Period Date (YYMM)
|
4
|
9(4)
|
|
15
|
Tab
|
1
|
X
|
|
16
|
Pay Period Type
|
1
|
X
|
|
17
|
Tab
|
1
|
X
|
|
18
|
Position Sequence Number
|
2
|
9(2)
|
|
20
|
Tab
|
1
|
X
|
|
21
|
Agency Code
|
3
|
X(3)
|
|
24
|
Reporting Unit
|
3
|
X(3)
|
|
27
|
Class Code
|
4
|
X(4)
|
|
31
|
Serial Number
|
3
|
X(3)
|
|
34
|
Tab
|
1
|
X
|
|
35
|
Cycle Date (YYMMDD)
|
6
|
X(6)
|
|
41
|
Tab
|
1
|
X
|
|
42
|
Warrant Number
|
8
|
X(8)
|
|
50
|
Tab
|
1
|
X
|
|
51
|
Clearance Type
|
1
|
X
|
|
52
|
Tab
|
1
|
X
|
|
53
|
Fiscal Year
|
2
|
9(2)
|
|
55
|
Tab
|
1
|
X
|
|
56
|
Special Pay
|
1
|
X
|
|
57
|
Tab
|
1
|
X
|
|
58
|
Record Type
|
1
|
X
|
|
59
|
Tab
|
1
|
X
|
|
60
|
Budget Function Code
|
3
|
X(3)
|
|
63
|
Tab
|
1
|
X
|
|
64
|
Collective Bargaining ID
|
3
|
X(3)
|
|
67
|
Tab
|
1
|
X
|
|
68
|
Accounts Receivable Type
|
1
|
X
|
|
69
|
Tab
|
1
|
X
|
|
70
|
Register Warrant Indicator
|
1
|
X
|
|
71
|
Tab
|
1
|
X
|
|
72
|
Name, First Init
|
1
|
X
|
|
73
|
Name, Middle Init
|
1
|
X
|
|
74
|
Tab
|
1
|
X
|
|
75
|
Name, Last
|
21
|
X(21)
|
|
96
|
Tab
|
1
|
X
|
|
97
|
Issue Date (YYMMDD)
|
6
|
X(6)
|
|
103
|
Tab
|
1
|
X
|
|
104
|
Payment Type
|
1
|
X
|
|
105
|
Tab
|
1
|
X
|
|
106
|
Payment Suffix
|
1
|
X
|
|
107
|
Tab
|
1
|
X
|
|
108
|
Adjustment Code
|
1
|
X
|
|
109
|
Tab
|
1
|
X
|
|
110
|
Accounts Receivable Code
|
1
|
X
|
|
111
|
Tab
|
1
|
X
|
|
112
|
Roll Code
|
1
|
X
|
|
113
|
Tab
|
1
|
X
|
|
114
|
Range Code
|
1
|
X
|
|
115
|
Tab
|
1
|
X
|
|
116
|
FLSA
|
4
|
X(4)
|
|
120
|
Tab
|
1
|
X
|
|
121
|
Salary Type
|
1
|
X
|
|
122
|
Tab
|
1
|
X
|
|
123
|
Salary Rate
|
9
|
S9(5).99
|
|
133
|
Tab
|
1
|
X
|
|
134
|
Actual Salary
|
9
|
S9(5).99
|
|
143
|
Tab
|
1
|
X
|
|
144
|
Salary Full
|
9
|
S9(5).99
|
|
152
|
Tab
|
1
|
X
|
|
153
|
Gross Type
|
1
|
X
|
|
154
|
Tab
|
1
|
X
|
|
155
|
Time Base, Numerator
|
3
|
X(3)
|
|
158
|
Tab
|
1
|
X
|
|
159
|
Time Base, Denominator
|
3
|
X(3)
|
|
162
|
Tab
|
1
|
X
|
|
163
|
Shift Differential
|
1
|
X
|
|
164
|
Tab
|
1
|
X
|
|
165
|
Overtime
|
1
|
X
|
|
166
|
Tab
|
1
|
X
|
|
167
|
Days Paid
|
3
|
S99
|
|
170
|
Tab
|
1
|
X
|
|
171
|
Hours Paid
|
7
|
S999.99
|
|
178
|
Tab
|
1
|
X
|
|
179
|
Units Paid
|
9
|
S9(5).99
|
|
188
|
Tab
|
1
|
X
|
|
189
|
Days Docked
|
3
|
S99
|
|
192
|
Tab
|
1
|
X
|
|
193
|
Hours Docked
|
4
|
S9.99
|
|
198
|
Tab
|
1
|
X
|
|
199
|
Federal Married Status
|
1
|
X
|
|
200
|
Tab
|
1
|
X
|
|
201
|
Federal Tax Exemptions
|
2
|
99
|
|
203
|
Tab
|
1
|
X
|
|
204
|
Federal Tax Gross, Employee
|
9
|
S9(5).99
|
|
213
|
Tab
|
1
|
X
|
|
214
|
Federal Tax Withhold, Employee
|
9
|
S9(5).99
|
|
223
|
Tab
|
1
|
X
|
|
224
|
State Married Status
|
1
|
X
|
|
225
|
Tab
|
1
|
X
|
|
226
|
State Tax Exemptions
|
2
|
99
|
|
228
|
Tab
|
1
|
X
|
|
229
|
State Itemized Allowances
|
2
|
99
|
|
231
|
Tab
|
1
|
X
|
|
232
|
State Tax Gross, Employee 1
|
9
|
S9(5).99
|
|
241
|
Tab
|
1
|
X
|
|
242
|
State Tax Withhold, Employee 1
|
9
|
S9(5).99
|
|
251
|
Tab
|
1
|
X
|
|
252
|
Social Security Tax Gross, Employee
|
9
|
S9(5).99
|
|
261
|
Tab
|
-
|
X
|
|
262
|
Social Security Withhold, Employee
|
9
|
S9(5).99
|
|
271
|
Tab
|
1
|
X
|
|
272
|
Social Security Tax Gross, Employer
|
9
|
S9(5).99
|
|
281
|
Tab
|
1
|
X
|
|
282
|
Social Security Withheld, Employer
|
9
|
S9(5).99
|
|
291
|
Tab
|
1
|
X
|
|
292
|
Medicare Tax Gross, Employee
|
9
|
S9(5).99
|
|
301
|
Tab
|
1
|
X
|
|
302
|
Medicare Withhold, Employee
|
9
|
S9(5).99
|
|
311
|
Tab
|
1
|
X
|
|
312
|
Medicare Tax Gross, Employer
|
9
|
S9(5).99
|
|
321
|
Tab
|
1
|
X
|
|
322
|
Medicare Withhold, Employer
|
9
|
S9(5).99
|
|
331
|
Tab
|
1
|
X
|
|
332
|
Retirement System ID
|
2
|
X(2)
|
|
334
|
Tab
|
1
|
X
|
|
335
|
Retirement Rate
|
7
|
S.9(5)
|
|
342
|
Tab
|
1
|
X
|
|
343
|
Gross Subject Retirement
|
9
|
S9(5).99
|
|
352
|
Tab
|
1
|
X
|
|
353
|
Retirement Withhold
|
9
|
S9(5).99
|
|
362
|
Tab
|
1
|
X
|
|
363
|
Retirement State Share Amount
|
9
|
S9(5).99
|
|
372
|
Tab
|
1
|
X
|
|
373
|
Gross
|
9
|
S9(5).99
|
|
382
|
Tab
|
1
|
X
|
|
383
|
Net
|
9
|
S9(5).99
|
|
392
|
Tab
|
1
|
X
|
|
393
|
Clearance Number
|
5
|
X(5)
|
|
398
|
Tab
|
1
|
X
|
|
399
|
Deduction Count
|
5
|
S9(4)
|
|
404
|
Tab
|
1
|
X
|
Segment 2, Segment Occurs 30 times, Segment Size = 25
|
1
|
Deduction ID
|
6
|
X(6)
|
|
1
|
Deduction Code
|
3
|
X(3)
|
|
4
|
Organization Code
|
3
|
X(3)
|
|
7
|
Tab
|
1
|
X
|
|
8
|
Deduction Amount
|
9
|
S9(5).99
|
|
17
|
Tab
|
1
|
X
|
|
18
|
Deduction Pay Period (YYMM)
|
4
|
X(4)
|
|
22
|
Tab
|
1
|
X
|
|
23
|
Deduction Type
|
2
|
X(2)
|
|
25
|
Tab
|
1
|
X
|
Format X - Alphanumeric
Format 9 - Number
Format S - Sign (+ or -)
Last Updated: July 13, 2004