PARIS Federal Output Record Format (Effective in August 2007)
Click here to download the Word format (26.0 KB)
STARTING Aug 2007
********************************************************************
** PARIS.FEDERAL(OUTPUT)
** THIS IS THE FORMAT FOR THE OUTPUT OF THE COMBINED FEDERAL FILES.
** STATE DATA IS FIRST THEN THE DMDC DATA.
** RECORD TYPE = CD DOD CIVILIAN
** RECORD TYPE = CO OPM CIVILIAN
** RECORD TYPE = CR OPM CIVIL SERVICE RETIREMENT
** RECORD TYPE = MA MILITARY ACTIVE DUTY
** RECORD TYPE = MR MILITARY RETIRED PAY
** RECORD TYPE = MV MILITARY RESERVES
** RECORD TYPE = NF NON-APPROPRIATED FUNDS
*********************************************************************
| DATA ELEMENT | POSITION | LENGTH | TYPE |
|---|---|---|---|
| SSN | 001-009 | 9 | character |
| STATE DATA (SEE LAYOUT BELOW) | 010-129 | 120 | character |
| RECORD TYPE | 130-131 | 2 | character |
| FILE DATE | 132-137 | 6 | character |
| DATE OF BIRTH | 138-145 | 8 | numeric |
| LAST NAME | 146-171 | 26 | character |
| FIRST NAME | 172-186 | 15 | character |
| MIDDLE NAME | 187-201 | 15 | character |
| SUFFIX NAME | 202-205 | 4 | character |
| SEX | 206-206 | 1 | character |
| GROSSPAY | 207-215 | 9.2 | numeric |
| UNIT ID CODE (UIC) | 216-223 | 8 | character |
| AGENCY | 224-227 | 4 | character |
| PAY PLAN | 228-229 | 2 | character |
| PAY GRADE | 230-233 | 4 | character |
| PAY STEP | 234-235 | 2 | numeric |
| BASIC SALARY | 236-244 | 9.2 | numeric |
| STATE RESIDENCE | 245-246 | 2 | character |
| FEDERAL TAXABLE WAGES | 247-255 | 9 | numeric |
| FEDERAL TAX WITHHELD | 256-264 | 9 | numeric |
| STATE TAXABLE WAGES | 265-273 | 9 | numeric |
| STATE TAX WITHHELD | 274-282 | 9 | numeric |
| EMPLOYEE STATUS CODE | 283-322 | 40 | character |
| PAYROLL OFFICE NUMBER | 323-362 | 40 | character |
| PERSONNEL OFFICE ID | 363-366 | 4 | character |
| PAY BASIC CODE | 367-368 | 2 | character |
| PAY PERIOD END DATE (YYYYMMDD) | 369-376 | 8 | numeric |
| DISBURSING DATE (YYYYMMDD) | 377-384 | 8 | numeric |
| PAY STATUS (P=ACTIVE N=INACTIVE) | 385-385 | 1 | character |
| CATAGORY CD | 386-386 | 1 | character |
| TOTAL BASE PAY ALL DRILLS | 387-395 | 9 | numeric |
| MARITAL STATUS CODE | 396-396 | 1 | character |
| DEPENDENTS QUANTITY | 397-398 | 2 | numeric |
| OFF DUTY MILITARY CODE | 399-399 | 1 | character |
| WELFARE TO WORK HIRE CODE | 400-400 | 1 | character |
| CITY | 401-413 | 13 | character |
| STATE | 414-415 | 2 | character |
| ZIP | 416-424 | 9 | character |
| ADDRESS LINE 1 | 425-451 | 27 | character |
| ADDRESS LINE 2 | 452-478 | 27 | character |
| ADDRESS LINE 3 | 479-500 | 22 | character |
| ADDRESS LINE 4 | 501-522 | 22 | character |
| ADDRESS LINE 5 | 523-544 | 22 | character |
| ADDRESS LINE 6 | 545-566 | 22 | character |
| MAILING ADDRESS EFFECTIVE CALENDAR DATE | 567-572 | 6 | numeric |
| CLAIM NUMBER | 573-581 | 9 | character |
| RETIRED PAY ENTITLMT EFFECTIVE DATE | 582-589 | 8 | numeric |
| COMMENT1 | 590-728 | 139 | character |
| COMMENT2 | 729-955 | 227 | character |
| COMMENT3 | 956-1091 | 136 | character |
| COMMENT4 | 1092-1318 | 227 | character |
|
|||
| STATE DATA (1-129) | |||
| SSN | 01-09 |
9 |
|
| LAST NAME | 10-24 |
15 |
|
| FIRST NAME | 25-39 |
15 |
|
| DATE OF BIRTH | 40-47 |
8 |
|
| FILLER/BLANK | 48-48 |
1 |
|
| FILE DATE | 49-54 |
6 |
|
| STATE NAME | 55-56 |
2 |
|
| OPTIONAL | 57-116 |
60 |
|
| LOCATION CODE | 117-119 |
3 |
|
| CASE NUMBER | 120-129 |
10 |
|