Master File for LRF Sample

This Master File corresponds to LRF subschema EMPSS02:

FILE=EMPDATA,SUFFIX=IDMSR,$
SEGNAME=DEPTEMPO,$
  FIELD=DEPT_ID     ,ALIAS=DID     ,USAGE=A4   ,ACTUAL=A4   ,$
  FIELD=DEPT_NAME   ,ALIAS=DNAME   ,USAGE=A45  ,ACTUAL=A45  ,$
  FIELD=DEPT_HEAD   ,ALIAS=DHEAD   ,USAGE=A4   ,ACTUAL=A4   ,$
  FIELD=            ,ALIAS=FILL.END,USAGE=A3   ,ACTUAL=A3   ,$
  FIELD=EMP_ID      ,ALIAS=EID     ,USAGE=A4   ,ACTUAL=A4   ,$
  GROUP=EMP_NAME        ,ALIAS=ENAME   ,USAGE=A25  ,ACTUAL=A25  ,$
    FIELD=FIRST_NAME,ALIAS=EFN     ,USAGE=A10  ,ACTUAL=A10  ,$
    FIELD=LAST_NAME ,ALIAS=ELN     ,USAGE=A15  ,ACTUAL=A15  ,$
  FIELD=EMP_STREET  ,ALIAS=ESTR    ,USAGE=A20  ,ACTUAL=A20  ,$
  FIELD=EMP_CITY    ,ALIAS=ECI     ,USAGE=A15  ,ACTUAL=A15  ,$
  FIELD=EMP_STATE   ,ALIAS=EST     ,USAGE=A2   ,ACTUAL=A2   ,$
  GROUP=EMP_FULL_ZIP    ,ALIAS=EFZIP   ,USAGE=A9   ,ACTUAL=A9   ,$
    FIELD=EMP_ZIP   ,ALIAS=EZIP    ,USAGE=A5   ,ACTUAL=A5   ,$
    FIELD=EMP_ZIP_L ,ALIAS=EZIPL   ,USAGE=A4   ,ACTUAL=A4   ,$
  FIELD=EMP_PHONE   ,ALIAS=EPHON   ,USAGE=A10  ,ACTUAL=A10  ,$
  FIELD=STATUS      ,ALIAS=ESTAT   ,USAGE=A2   ,ACTUAL=A2   ,$
  FIELD=SOC_SEC_NUM ,ALIAS=SSN     ,USAGE=A9   ,ACTUAL=A9   ,$
  FIELD=EMP_STRT_DTE,ALIAS=ESDTE   ,USAGE=A6YMD,ACTUAL=A6   ,$
  FIELD=EMP_TERM_DTE,ALIAS=ETDTE   ,USAGE=A6YMD,ACTUAL=A6   ,$
  FIELD=EMP_BRTH_DTE,ALIAS=EBDTE   ,USAGE=A6YMD,ACTUAL=A6   ,$
  FIELD=            ,ALIAS=FILL.END,USAGE=A6   ,ACTUAL=A6   ,$
  FIELD=POS_STRT_DT1,ALIAS=PSDTE   ,USAGE=A6YMD,ACTUAL=A6   ,$
  FIELD=POS_FIN_DT1 ,ALIAS=PFDTE   ,USAGE=A6YMD,ACTUAL=A6   ,$
  FIELD=SALARY_GRAD1,ALIAS=SGRADE  ,USAGE=P4   ,ACTUAL=Z2   ,$
  FIELD=SALARY_AMT1 ,ALIAS=SAMOUNT ,USAGE=P10.2,ACTUAL=P5   ,$
  FIELD=BONUS_PCT1  ,ALIAS=BPCT    ,USAGE=P4   ,ACTUAL=P2   ,$
  FIELD=COMMIS_PCT1 ,ALIAS=CPCT    ,USAGE=P4   ,ACTUAL=P2   ,$
  FIELD=OVERTIM_PCT1,ALIAS=ORATE   ,USAGE=P5.2 ,ACTUAL=P2   ,$
SEGNAME=JOBPOS,PARENT=DEPTEMPO,SEGTYPE=U,$
  FIELD=JOB_ID      ,ALIAS=JID     ,USAGE=A4   ,ACTUAL=A4   ,$
  FIELD=TITLE       ,ALIAS=JTIT    ,USAGE=A20  ,ACTUAL=A20  ,$
  FIELD=JOB_DESC    ,ALIAS=JDESC   ,USAGE=A120 ,ACTUAL=A120 ,$
  FIELD=REQUIREMENTS,ALIAS=JREQ    ,USAGE=A120 ,ACTUAL=A120 ,$
  FIELD=MIN_SALARY  ,ALIAS=MINSAL  ,USAGE=P12.2,ACTUAL=Z8   ,$
  FIELD=MAX_SALARY  ,ALIAS=MAXSAL  ,USAGE=P12.2,ACTUAL=Z8   ,$
  FIELD=SAL_GRADE_1 ,ALIAS=GRADE1  ,USAGE=P4   ,ACTUAL=Z2   ,$
  FIELD=SAL_GRADE_2 ,ALIAS=GRADE1  ,USAGE=P4   ,ACTUAL=Z2   ,$
  FIELD=SAL_GRADE_3 ,ALIAS=GRADE1  ,USAGE=P4   ,ACTUAL=Z2   ,$
  FIELD=SAL_GRADE_4 ,ALIAS=GRADE1  ,USAGE=P4   ,ACTUAL=Z2   ,$
  FIELD=POSITION_NUM,ALIAS=NOPOS   ,USAGE=P4   ,ACTUAL=Z3   ,$
  FIELD=NUM_OPEN    ,ALIAS=NOOPEN  ,USAGE=P4   ,ACTUAL=Z3   ,$
  FIELD=            ,ALIAS=FILL.END,USAGE=A2   ,ACTUAL=A2   ,$
  FIELD=POS_STRT_DT2,ALIAS=PSDTE   ,USAGE=A6YMD,ACTUAL=A6   ,$
  FIELD=POS_FIN_DT2 ,ALIAS=PFDTE   ,USAGE=A6YMD,ACTUAL=A6   ,$
  FIELD=SALARY_GRAD2,ALIAS=SGRADE  ,USAGE=P4   ,ACTUAL=Z2   ,$
  FIELD=SALARY_AMT2 ,ALIAS=SAMOUNT ,USAGE=P10.2,ACTUAL=P5   ,$
  FIELD=BONUS_PCT2  ,ALIAS=BPCT    ,USAGE=P4   ,ACTUAL=P2   ,$
  FIELD=COMMIS_PCT2 ,ALIAS=CPCT    ,USAGE=P4   ,ACTUAL=P2   ,$
  FIELD=OVERTIM_PCT2,ALIAS=ORATE   ,USAGE=P5.2 ,ACTUAL=P2   ,$

Information Builders