**PARIS FEDERAL OUTPUT RECORD FORMAT**

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]{.underline}** **[POSITION]{.underline}**
**[LENGTH]{.underline}** **[TYPE]{.underline}**

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

**PARIS FEDERAL OUTPUT RECORD FORMAT**

**[DATA ELEMENT]{.underline}** **[POSITION]{.underline}**
**[LENGTH]{.underline}** **[TYPE]{.underline}**

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]{.underline} (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