Previous Topic: Drop Table ExampleNext Topic: Debugging a CA Culprit Report


The Personnel File Description

The Commonweather Corporation personnel file, which is used in examples in this manual, is described fully in the figure below:

The Commonweather Corporation Personnel File Description

RECORD SIZE    200 bytes
BLOCK SIZE     400 bytes
RECORD FORMAT  FIXED (F)
FILE TYPE      SEQUENTIAL (PS)


Data Field    Start Position   Length (bytes)   Data Type

EMPLOYEE-ID        1                 4          Zoned decimal
EMPLOYEE-NAME      5                25          Alphanumeric
FIRST-NAME         5                10          Alphanumeric
LAST-NAME         15                15          Alphanumeric
STREET            30                20          Alphanumeric
CITY              50                15          Alphanumeric
STATE             65                 2          Alphanumeric
ZIP-CODE          67                 5          Alphanumeric
PHONE             72                10          Zoned decimal
STATUS            82                 2          Alphanumeric
SS-NUMBER         84                 9          Zoned decimal
START-MONTH       93                 2          Zoned decimal
START-DAY         95                 2          Zoned decimal
START YEAR        97                 2          Zoned decimal
TERMINATION-MONTH 99                 2          Zoned decimal
TERMINATION-DAY  101                 2          Zoned decimal
TERMINATION-YEAR 103                 2          Zoned decimal
BIRTH-MONTH      105                 2          Zoned decimal
BIRTH-DAY        107                 2          Zoned decimal
BIRTH-YEAR       109                 2          Zoned decimal
DEPT-ID          111                 4          Zoned decimal
DEPT-NAME        115                45          Alphanumeric
SALARY-AMOUNT    160                 5          Packed Decimal
JOB-ID           167                 4          Zoned decimal
TITLE            171                20          Alphanumeric