RECORD LAYOUTS FOR ACTIVE AND RETIREE DATA FILES
OCTOBER 1998
ACTIVE RECORD LAYOUT
List for Control File ACTIVE in Library PERACTL on Volume EWING records are fixedlength,
record size is 342 File organization is consecutive
| Field Name |
Start Posn |
Int Fmt |
Int Len |
Ext Len |
Dec Pos |
Occur Count |
Alias Name |
|---|---|---|---|---|---|---|---|
| BOARD NUM | 01 | U | 03 | 03 | 0 | 1 | ACTV-BOARD-NUM |
| SOCSECNO | 04 | C | 09 | 09 | 0 | 1 | ACTV-SS-NUM |
| LASTNAME | 13 | C | 20 | 20 | 0 | 1 | ACTV-NAME-LAST |
| FRSTNAME | 33 | C | 14 | 14 | 0 | 1 | ACTV-NAME-FIRST |
| MIDDNAME | 47 | C | 14 | 14 | 0 | 1 | ACTV-NAME-MIDDLE |
| SUFFIX | 61 | C | 03 | 03 | 0 | 1 | ACTV-NAME-SUFFIX |
| SEX | 64 | C | 01 | 01 | 0 | 1 | ACTV-SEX |
| BIRTHDAY | 65 | U | 08 | 08 | 0 | 1 | ACTV-DOB |
| DATADATE | 73 | U | 08 | 08 | 0 | 1 | ACTV-DATE-OF-DATA |
| JOBGROUP | 81 | C | 01 | 01 | 0 | 1 | ACTV-JOB-GROUP |
| MRTLSTAT | 82 | C | 01 | 01 | 0 | 1 | ACTV-MARITAL-STATUS |
| SPOUSDOB | 83 | U | 08 | 08 | 0 | 1 | ACTV-SPOUSE-DOB |
| NUMCHILD | 91 | C | 02 | 02 | 0 | 1 | ACTV-NUMBER-CHILDREN |
| DEPTMENT | 93 | C | 04 | 04 | 0 | 1 | ACTV-DEPARTMENT |
| EMPLDATE | 97 | U | 08 | 08 | 0 | 1 | ACTV-EMPLOYMENT-DATE |
| ADJEMPLD | 105 | U | 08 | 08 | 0 | 1 | ACTV-ADJ-DATE-OF-EMPLOYMENT |
| ASFBALAN | 113 | U | 09 | 10 | 2 | 1 | ACTV-ASF-BALANCE |
| ASFCONTR | 122 | U | 09 | 10 | 2 | 1 | ACTV-ASF-CONTRIBUTIONS |
| ASFINTRS | 131 | U | 09 | 10 | 2 | 1 | ACTV-ASF-INTEREST |
| YRSALARY | 140 | U | 08 | 08 | 0 | 1 | ACTV-CURRENT-YEAR-SALARY |
| AMTSALRY | 148 | U | 09 | 10 | 2 | 1 | ACTV-CURRENT-SALARY |
| FULLPART | 157 | U | 03 | 03 | 0 | 1 | ACTV-FULL-OR-PART-TIME |
| MKUPBALN | 160 | U | 09 | 10 | 2 | 1 | ACTV-MAKEUP-BALANCE |
| MKUPCURR | 169 | U | 09 | 10 | 2 | 1 | ACTV-MAKEUP-CURR-CONTRIBUTION |
| MKUPINTR | 178 | U | 09 | 10 | 2 | 1 | ACTV-MAKEUP-INTEREST |
| MKUPANPY | 187 | U | 09 | 10 | 2 | 1 | ACTV-MAKEUP-ANNUAL-PAYMENT |
| PREVBRD1 | 196 | U | 03 | 03 | 0 | 1 | ACTV-PREV-BOARD1 |
| PRVSTRT1 | 199 | U | 08 | 08 | 0 | 1 | ACTV-PREV-START1 |
| PREVEND1 | 207 | U | 08 | 08 | 0 | 1 | ACTV-PREV-END1 |
| PREVBRD2 | 215 | U | 03 | 03 | 0 | 1 | ACTV-PREV-BOARD2 |
| PRVSTRT2 | 218 | U | 08 | 08 | 0 | 1 | ACTV-PREV-START2 |
| PREVEND2 | 226 | U | 08 | 08 | 0 | 1 | ACTV-PREV-END2 |
| PREVBRD3 | 234 | U | 03 | 03 | 0 | 1 | ACTV-PREV-BOARD3 |
| PREVSTRT3 | 237 | U | 08 | 08 | 0 | 1 | ACTV-PREV-START3 |
| PREVEND3 | 245 | U | 08 | 08 | 0 | 1 | ACTV-PREV-END3 |
| CREDSERV | 253 | U | 05 | 06 | 3 | 1 | ACTV-CREDITABLE-SERVICE |
| VETCODE | 258 | C | 01 | 01 | 0 | 1 | ACTV-VET-CODE |
| STATUS | 259 | U | 02 | 02 | 0 | 1 | ACTV-STATUS-CODE |
| STATDATE | 261 | U | 08 | 08 | 0 | 1 | ACTV-STATUS-DATE |
| MILTSERV | 269 | U | 05 | 06 | 3 | 1 | ACTV-MILITARY-SERVICE-YEARS |
| CONTRATE | 274 | U | 02 | 03 | 2 | 1 | ACTV-CONTRIBUTORY-BASE-RATE |
| INCRRATE | 276 | U | 01 | 01 | 0 | 1 | ACTV-INCREMENT-RATE |
| XTRACONT | 277 | U | 09 | 10 | 2 | 1 | ACTV-EXTRA-CONTRIBUTIONS |
| XTRACURR | 286 | U | 09 | 10 | 2 | 1 | ACTV-EXTRA-CURRENT-CONTRIBS |
| XTRAINTR | 295 | U | 09 | 10 | 2 | 1 | ACTV-EXTRA-INTEREST |
| XTRARATE | 304 | U | 04 | 05 | 2 | 1 | ACTV-EXTRA-RATE |
| REFUNDS | 308 | U | 09 | 10 | 2 | 1 | ACTV-REFUNDS |
| TOTLCRED | 317 | U | 05 | 06 | 3 | 1 | ACTV-TOTAL-CREDITABLE-SERVICE |
| FILLER | 322 | C | 16 | 16 | 0 | 1 | |
| GOVUNIT | 338 | C | 04 | 04 | 0 | 1 | Governmental Unit Code |
| FILLER | 342 | C | 01 | 01 | 0 | 1 |
RETIREE RECORD LAYOUT
List for Control File RETIREES in Library PERACTL on Volume EWING
Records are fixed-length, record size is 342
File organization is consecutive
| Field Name |
Start Posn |
Int Fmt |
Int Len |
Ext Len |
Dec Pos |
Occur Count |
Alias Name |
|---|---|---|---|---|---|---|---|
| BOARDNUM | 01 | C | 03 | 03 | 0 | 1 | RETR-BOARD-NUM |
| SOCSECNO | 04 | C | 09 | 09 | 0 | 1 | RETR-SS-NUM |
| LASTNAME | 13 | C | 20 | 20 | 0 | 1 | RETR-NAME-LAST |
| FIRSTNAME | 33 | C | 14 | 14 | 0 | 1 | RETR-NAME-FIRST |
| MIDDNAME | 47 | C | 14 | 14 | 0 | 1 | RETR-NAME-MIDDLE |
| SUFFIX | 61 | C | 03 | 03 | 0 | 1 | RETR-NAME-SUFFIX |
| SEX | 64 | C | 01 | 01 | 0 | 1 | RETR-SEX |
| BIRTHDAY | 65 | U | 08 | 08 | 0 | 1 | RETR-DOB |
| DATADATE | 73 | U | 08 | 08 | 0 | 1 | RETR-DATE-OF-DATA |
| RETRDATE | 81 | U | 08 | 08 | 0 | 1 | RETR-RETIRE-DATE |
| OPTIONC | 89 | C | 01 | 01 | 0 | 1 | RETR-OPTION-C-SURV |
| OPTCPOP | 90 | U | 05 | 06 | 4 | 1 | RETR-OPT-C-FACTOR |
| RETRTYPE | 95 | U | 02 | 02 | 0 | 1 | RETR-RETIRE-TYPE |
| RETROPT | 97 | C | 01 | 01 | 0 | 1 | RETR-RETIRE-OPTION |
| JOBGROUP | 98 | C | 01 | 01 | 0 | 1 | RETR-JOB-GROUP |
| AVSALARY | 99 | U | 09 | 10 | 2 | 1 | RETR-FIN-AVG-SALARY |
| ACCUMDED | 108 | U | 09 | 10 | 2 | 1 | RETR-ACCUM-DEDUCTIONS |
| CREDSERV | 117 | U | 05 | 06 | 3 | 1 | RETR-CREDITABLE-SERVICE |
| DEPTMENT | 122 | C | 04 | 04 | 0 | 1 | RETR-DEPARTMENT |
| BENEFSEX | 126 | C | 01 | 01 | 0 | 1 | RETR-BENEF-SEX |
| BENEFDOB | 127 | U | 08 | 08 | 0 | 1 | RETR-BENEF-DOB |
| BENEFREL | 135 | C | 01 | 01 | 0 | 1 | RETR-BENEF-RELAT |
| NODEPCHI | 136 | U | 02 | 02 | 0 | 1 | RETR-DEP-CHILDREN |
| DOBYOUNG | 138 | U | 08 | 08 | 0 | 1 | RETR-DOB-YOUNGEST-DEP |
| VETCODE | 146 | C | 01 | 01 | 0 | 1 | RETR-VET-CODE |
| PAYSTAT | 147 | U | 01 | 01 | 0 | 1 | RETR-PAYMENT-STATUS |
| DOD | 148 | U | 08 | 08 | 0 | 1 | RETR-DATE-OF-DEATH |
| BENEFDOD | 156 | U | 08 | 08 | 0 | 1 | RETR-BENEF-DATE-OF-DEATH |
| ORIGAMNT | 164 | U | 09 | 10 | 2 | 1 | RETR-ORIG-AMOUNT |
| ANNUITY | 173 | U | 09 | 10 | 2 | 1 | RETR-ANNUAL-ANNUITY |
| ORIGPENS | 182 | U | 09 | 10 | 2 | 1 | RETR-ORIG-PENSION |
| ORIGDEPN | 191 | U | 09 | 10 | 2 | 1 | RETR-ORIGINAL-DEPENDENCY |
| ANRESERV | 200 | U | 09 | 10 | 2 | 1 | RETR-ANN-RESERVE |
| FY82COLA | 209 | U | 09 | 10 | 2 | 1 | RETR-PRE-FY82-COLA |
| FY81COLA | 218 | U | 09 | 10 | 2 | 1 | RETR-POST-FY81-COLA |
| CURRPAYB | 227 | U | 09 | 10 | 2 | 1 | RETR-CURR-PAY-AMOUNT |
| YRSLASTB | 236 | U | 05 | 06 | 3 | 1 | RETR-YEARS-LAST-BOARD |
| PREVBRD1 | 241 | U | 03 | 03 | 0 | 1 | RETR-PREV-BOARD1 |
| PREVYRS1 | 244 | U | 05 | 06 | 3 | 1 | RETR-PREV-YEARS1 |
| PREVBRD2 | 249 | U | 03 | 03 | 0 | 1 | RETR-PREV-BOARD2 |
| PREVYRS2 | 252 | U | 05 | 06 | 3 | 1 | RETR-PREV-YEARS2 |
| PREVBRD3 | 257 | U | 03 | 03 | 0 | 1 | RETR-PREV-BOARD3 |
| PREVYRS3 | 260 | U | 05 | 06 | 3 | 1 | RETR-PREV-YEARS3 |
| WRKCMPWK | 265 | U | 07 | 08 | 2 | 1 | RETR-WORKERS-COMP-WEEKLY |
| WKCMPLMP | 272 | U | 11 | 12 | 2 | 1 | RETR-WORKERS-COMP-LUMP |
| POST97COLA | 283 | U | 09 | 10 | 2 | 1 | Post 1997 COLA |
| FILLER | 292 | C | 46 | 46 | 0 | 1 | |
| GOVUNIT | 338 | C | 04 | 04 | 0 | 1 | Governmental Unit Code |
| FILLER | 342 | C | 01 | 01 | 0 | 1 |
KEY TO RECORD LAYOUTS
Field Name Eight character field identifier
Start Position Starting location within the data record
Internal Format P-packed, B-binary, C-character, Z-zoned, U-unsigned
(packed = Computational)
Internal Length Maximum values: P-8, B-4, C-132, Z-15,U-15
External Length only if not calculated from internal length
Alias Name Alternative 26 character field description.