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.

 

Return to PERAC Home Page | Actuarial Unit