In this section: |
The PAYHIST data source contains the employees' salary history. It consists of one segment, PAYSEG. The SUFFIX attribute indicates that the data file is a fixed-format sequential file.
FILENAME=PAYHIST, SUFFIX=FIX SEGMENT=PAYSEG,$ FIELDNAME=SOC_SEC_NO, ALIAS=SSN, USAGE=A9, ACTUAL=A9, $ FIELDNAME=DATE_OF_IN, ALIAS=INCDATE, USAGE=I6YMTD, ACTUAL=A6, $ FIELDNAME=AMT_OF_INC, ALIAS=RAISE, USAGE=D6.2, ACTUAL=A10,$ FIELDNAME=PCT_INC, ALIAS=, USAGE=D6.2, ACTUAL=A6, $ FIELDNAME=NEW_SAL, ALIAS=CURR_SAL, USAGE=D10.2, ACTUAL=A11,$ FIELDNAME=FILL, ALIAS=, USAGE=A38, ACTUAL=A38,$
SECTION 01 STRUCTURE OF FIX FILE PAYHIST ON 05/15/03 AT 14.51.59 PAYSEG 01 S1 ************** *SOC_SEC_NO ** *DATE_OF_IN ** *AMT_OF_INC ** *PCT_INC ** * ** *************** **************
Information Builders |