EMPFULL Master File

This Master File is used in the examples throughout this manual. For instructions about creating this Master File, see the sample session in Creating File Descriptions With AUTOIDMS:

  $$$ CREATED BY AUTOIDMS ON 12/13/12 AT 14.32.16 BY USERID
  $$$ SSCHEMA=EMPSS01
  FILE=EMPFULL,SUFFIX=IDMSR,$
  SEGNAME=S0410_01,SEGTYPE=S,$
    FIELD=DEPT_ID                      ,ALIAS=F0410_1    ,A4    ,A4   ,$
    FIELD=DEPT_NAME                    ,ALIAS=F0410_2    ,A45   ,A45  ,$
    FIELD=DEPT_HEAD_ID                 ,ALIAS=F0410_3    ,A4    ,A4   ,$
    FIELD=FIL 0003                     ,ALIAS=F0410_4    ,A3    ,A3   ,$
    FIELD=S0410_01_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=S0415_02,SEGTYPE=S,PARENT=S0410_01,$
    FIELD=EMP_ID                       ,ALIAS=F0415_1    ,A4    ,A4   ,$
    GROUP=EMP_NAME                     ,ALIAS=F0415_2    ,A25   ,A25  ,$
    FIELD=EMP_FIRST_NAME               ,ALIAS=F0415_3    ,A10   ,A10  ,$
    FIELD=EMP_LAST_NAME                ,ALIAS=F0415_4    ,A15   ,A15  ,$
    GROUP=EMP_ADDRESS                  ,ALIAS=F0415_5    ,A46   ,A46  ,$
    FIELD=EMP_STREET                   ,ALIAS=F0415_6    ,A20   ,A20  ,$
    FIELD=EMP_CITY                     ,ALIAS=F0415_7    ,A15   ,A15  ,$
    FIELD=EMP_STATE                    ,ALIAS=F0415_8    ,A2    ,A2   ,$
    GROUP=EMP_ZIP                      ,ALIAS=F0415_9    ,A9    ,A9   ,$
    FIELD=EMP_ZIP_FIRST_FIVE           ,ALIAS=F0415_10   ,A5    ,A5   ,$
    FIELD=EMP_ZIP_LAST_FOUR            ,ALIAS=F0415_11   ,A4    ,A4   ,$
    FIELD=EMP_PHONE                    ,ALIAS=F0415_12   ,A10   ,A10  ,$
    FIELD=STATUS                       ,ALIAS=F0415_13   ,A2    ,A2   ,$
    FIELD=SS_NUMBER                    ,ALIAS=F0415_19   ,A9    ,A9   ,$
    GROUP=START_DATE                   ,ALIAS=F0415_20   ,A8    ,A8   ,$
    FIELD=START_YEAR                   ,ALIAS=F0415_21   ,A4    ,A4   ,$
    FIELD=START_MONTH                  ,ALIAS=F0415_22   ,A2    ,A2   ,$
    FIELD=START_DAY                    ,ALIAS=F0415_23   ,A2    ,A2   ,$
    GROUP=TERMINATION_DATE             ,ALIAS=F0415_24   ,A8    ,A8   ,$
    FIELD=TERMINATION_YEAR             ,ALIAS=F0415_25   ,A4    ,A4   ,$
    FIELD=TERMINATION_MONTH            ,ALIAS=F0415_26   ,A2    ,A2   ,$
    FIELD=TERMINATION_DAY              ,ALIAS=F0415_27   ,A2    ,A2   ,$
    GROUP=BIRTH_DATE                   ,ALIAS=F0415_28   ,A8    ,A8   ,$
    FIELD=BIRTH_YEAR                   ,ALIAS=F0415_29   ,A4    ,A4   ,$
    FIELD=BIRTH_MONTH                  ,ALIAS=F0415_30   ,A2    ,A2   ,$
    FIELD=BIRTH_DAY                    ,ALIAS=F0415_31   ,A2    ,A2   ,$
    FIELD=S0415_02_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=S0400_03,SEGTYPE=S,PARENT=S0415_02,$
    GROUP=SELECTION_DATE               ,ALIAS=F0400_1    ,A8    ,A8   ,$
    FIELD=SELECTION_YEAR               ,ALIAS=F0400_2    ,A4    ,A4   ,$
    FIELD=SELECTION_MONTH              ,ALIAS=F0400_3    ,A2    ,A2   ,$
    FIELD=SELECTION_DAY                ,ALIAS=F0400_4    ,A2    ,A2   ,$
    GROUP=TERMINATION_DATE             ,ALIAS=F0400_5    ,A8    ,A8   ,$
    FIELD=TERMINATION_YEAR             ,ALIAS=F0400_6    ,A4    ,A4   ,$
    FIELD=TERMINATION_MONTH            ,ALIAS=F0400_7    ,A2    ,A2   ,$
    FIELD=TERMINATION_DAY              ,ALIAS=F0400_8    ,A2    ,A2   ,$
    FIELD=TYPE                         ,ALIAS=F0400_9    ,A1    ,A1   ,$
    FIELD=INS_PLAN_CODE                ,ALIAS=F0400_13   ,A3    ,A3   ,$
    FIELD=S0400_03_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=S0420_04,SEGTYPE=S,PARENT=S0415_02,$
    GROUP=START_DATE                   ,ALIAS=F0420_1    ,A8    ,A8   ,$
    FIELD=START_YEAR                   ,ALIAS=F0420_2    ,A4    ,A4   ,$
    FIELD=START_MONTH                  ,ALIAS=F0420_3    ,A2    ,A2   ,$
    FIELD=START_DAY                    ,ALIAS=F0420_4    ,A2    ,A2   ,$
    GROUP=FINISH_DATE                  ,ALIAS=F0420_5    ,A8    ,A8   ,$
    FIELD=FINISH_YEAR                  ,ALIAS=F0420_6    ,A4    ,A4   ,$
    FIELD=FINISH_MONTH                 ,ALIAS=F0420_7    ,A2    ,A2   ,$
    FIELD=FINISH_DAY                   ,ALIAS=F0420_8    ,A2    ,A2   ,$
    FIELD=SALARY_GRADE                 ,ALIAS=F0420_9    ,A2    ,A2   ,$
    FIELD=SALARY_AMOUNT                ,ALIAS=F0420_10   ,P11.2 ,P5   ,$
    FIELD=BONUS_PERCENT                ,ALIAS=F0420_11   ,P5.3  ,P2   ,$
    FIELD=COMMISSION_PERCENT           ,ALIAS=F0420_12   ,P5.3  ,P2   ,$
    FIELD=OVERTIME_RATE                ,ALIAS=F0420_13   ,P5.2  ,P2   ,$
    FIELD=FIL 0003                     ,ALIAS=F0420_14   ,A3    ,A3   ,$
    FIELD=S0420_04_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=S0425_05,SEGTYPE=S,PARENT=S0415_02,$
    FIELD=SKILL_LEVEL                  ,ALIAS=F0425_1    ,A2    ,A2   ,$
    GROUP=EXPERTISE_DATE               ,ALIAS=F0425_6    ,A8    ,A8   ,$
    FIELD=EXPERTISE_YEAR               ,ALIAS=F0425_7    ,A4    ,A4   ,$
    FIELD=EXPERTISE_MONTH              ,ALIAS=F0425_8    ,A2    ,A2   ,$
    FIELD=EXPERTISE_DAY                ,ALIAS=F0425_9    ,A2    ,A2   ,$
    FIELD=FIL 0002                     ,ALIAS=F0425_10   ,A2    ,A2   ,$
    FIELD=S0425_05_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=S0460_06,SEGTYPE=S,PARENT=S0415_02,$
    FIELD=STRUCTURE_CODE               ,ALIAS=F0460_1    ,A2    ,A2   ,$
    GROUP=STRUCTURE_DATE               ,ALIAS=F0460_4    ,A8    ,A8   ,$
    FIELD=STRUCTURE_YEAR               ,ALIAS=F0460_5    ,A4    ,A4   ,$
    FIELD=STRUCTURE_MONTH              ,ALIAS=F0460_6    ,A2    ,A2   ,$
    FIELD=STRUCTURE_DAY                ,ALIAS=F0460_7    ,A2    ,A2   ,$
    FIELD=FIL 0002                     ,ALIAS=F0460_8    ,A2    ,A2   ,$
    FIELD=S0460_06_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=S0450_07,SEGTYPE=U,PARENT=S0415_02,$
    FIELD=OFFICE_CODE                  ,ALIAS=F0450_1    ,A3    ,A3   ,$
    GROUP=OFFICE_ADDRESS               ,ALIAS=F0450_2    ,A46   ,A46  ,$
    FIELD=OFFICE_STREET                ,ALIAS=F0450_3    ,A20   ,A20  ,$
    FIELD=OFFICE_CITY                  ,ALIAS=F0450_4    ,A15   ,A15  ,$
    FIELD=OFFICE_STATE                 ,ALIAS=F0450_5    ,A2    ,A2   ,$
    GROUP=OFFICE_ZIP                   ,ALIAS=F0450_6    ,A9    ,A9   ,$
    FIELD=OFFICE_ZIP_FIRST_FIVE        ,ALIAS=F0450_7    ,A5    ,A5   ,$
    FIELD=OFFICE_ZIP_LAST_FOUR         ,ALIAS=F0450_8    ,A4    ,A4   ,$
    FIELD=S07_OCC01                    ,ALIAS=           ,A21   ,A21  ,$
    FIELD=OFFICE_AREA_CODE             ,ALIAS=F0450_10   ,A3    ,A3   ,$
    FIELD=SPEED_DIAL                   ,ALIAS=F0450_11   ,A3    ,A3   ,$
    FIELD=S0450_07_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=OCC07_01,SEGTYPE=S,PARENT=S0450_07,
          OCCURS=0003,POSITION=S07_OCC01,$
    FIELD=OFFICE_PHONE                 ,ALIAS=F0450_9    ,A7    ,A7   ,$
    FIELD=OCC07_01                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=S0405_08,SEGTYPE=S,PARENT=S0400_03,$
    GROUP=CLAIM_DATE                   ,ALIAS=F0405_1    ,A8    ,A8   ,$
    FIELD=CLAIM_YEAR                   ,ALIAS=F0405_2    ,A4    ,A4   ,$
    FIELD=CLAIM_MONTH                  ,ALIAS=F0405_3    ,A2    ,A2   ,$
    FIELD=CLAIM_DAY                    ,ALIAS=F0405_4    ,A2    ,A2   ,$
    GROUP=PATIENT_NAME                 ,ALIAS=F0405_5    ,A25   ,A25  ,$
    FIELD=PATIENT_FIRST_NAME           ,ALIAS=F0405_6    ,A10   ,A10  ,$
    FIELD=PATIENT_LAST_NAME            ,ALIAS=F0405_7    ,A15   ,A15  ,$
    GROUP=PATIENT_BIRTH_DATE           ,ALIAS=F0405_8    ,A8    ,A8   ,$
    FIELD=PATIENT_BIRTH_YEAR           ,ALIAS=F0405_9    ,A4    ,A4   ,$
    FIELD=PATIENT_BIRTH_MONTH          ,ALIAS=F0405_10   ,A2    ,A2   ,$
    FIELD=PATIENT_BIRTH_DAY            ,ALIAS=F0405_11   ,A2    ,A2   ,$
    FIELD=PATIENT_SEX                  ,ALIAS=F0405_12   ,A1    ,A1   ,$
    FIELD=RELATION_TO_EMPLOYEE         ,ALIAS=F0405_13   ,A10   ,A10  ,$
    GROUP=DENTIST_NAME                 ,ALIAS=F0405_14   ,A25   ,A25  ,$
    FIELD=DENTIST_FIRST_NAME           ,ALIAS=F0405_15   ,A10   ,A10  ,$
    FIELD=DENTIST_LAST_NAME            ,ALIAS=F0405_16   ,A15   ,A15  ,$
    GROUP=DENTIST_ADDRESS              ,ALIAS=F0405_17   ,A46   ,A46  ,$
    FIELD=DENTIST_STREET               ,ALIAS=F0405_18   ,A20   ,A20  ,$
    FIELD=DENTIST_CITY                 ,ALIAS=F0405_19   ,A15   ,A15  ,$
    FIELD=DENTIST_STATE                ,ALIAS=F0405_20   ,A2    ,A2   ,$
    GROUP=DENTIST_ZIP                  ,ALIAS=F0405_21   ,A9    ,A9   ,$
    FIELD=DENTIST_ZIP_FIRST_FIVE       ,ALIAS=F0405_22   ,A5    ,A5   ,$
    FIELD=DENTIST_ZIP_LAST_FOUR        ,ALIAS=F0405_23   ,A4    ,A4   ,$
    FIELD=DENTIST_LICENSE_NUMBER       ,ALIAS=F0405_24   ,A6    ,A6   ,$
    FIELD=NUMBER_OF_PROCEDURES         ,ALIAS=F0405_25   ,I2    ,I2   ,$
    FIELD=FIL 0001                     ,ALIAS=F0405_26   ,A1    ,A1   ,$
    FIELD=DENTIST_CHARGES              ,ALIAS=F0405_27   ,A256  ,A256 ,$
    FIELD=AUTOPAD08001                 ,ALIAS=           ,A256  ,A256 ,$
    FIELD=AUTOPAD08002                 ,ALIAS=           ,A256  ,A256 ,$
    FIELD=AUTOPAD08003                 ,ALIAS=           ,A32   ,A32  ,$
    FIELD=S0405_08_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=OCC08_01,SEGTYPE=S,PARENT=S0405_08,
          OCCURS=F0405_25,POSITION=F0405_27,$
    FIELD=TOOTH_NUMBER                 ,ALIAS=F0405_28   ,A2    ,A2   ,$
    GROUP=SERVICE_DATE                 ,ALIAS=F0405_29   ,A8    ,A8   ,$
    FIELD=SERVICE_YEAR                 ,ALIAS=F0405_30   ,A4    ,A4   ,$
    FIELD=SERVICE_MONTH                ,ALIAS=F0405_31   ,A2    ,A2   ,$
    FIELD=SERVICE_DAY                  ,ALIAS=F0405_32   ,A2    ,A2   ,$
    FIELD=PROCEDURE_CODE               ,ALIAS=F0405_33   ,A4    ,A4   ,$
    FIELD=DESCRIPTION_OF_SERVICE       ,ALIAS=F0405_34   ,A60   ,A60  ,$
    FIELD=FEE                          ,ALIAS=F0405_35   ,P11.2 ,P5   ,$
    FIELD=FIL 0001                     ,ALIAS=F0405_36   ,A1    ,A1   ,$
    FIELD=OCC08_01                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=S0430_09,SEGTYPE=S,PARENT=S0400_03,$
    GROUP=CLAIM_DATE                   ,ALIAS=F0430_1    ,A8    ,A8   ,$
    FIELD=CLAIM_YEAR                   ,ALIAS=F0430_2    ,A4    ,A4   ,$
    FIELD=CLAIM_MONTH                  ,ALIAS=F0430_3    ,A2    ,A2   ,$
    FIELD=CLAIM_DAY                    ,ALIAS=F0430_4    ,A2    ,A2   ,$
    GROUP=PATIENT_NAME                 ,ALIAS=F0430_5    ,A25   ,A25  ,$
    FIELD=PATIENT_FIRST_NAME           ,ALIAS=F0430_6    ,A10   ,A10  ,$
    FIELD=PATIENT_LAST_NAME            ,ALIAS=F0430_7    ,A15   ,A15  ,$
    GROUP=PATIENT_BIRTH_DATE           ,ALIAS=F0430_8    ,A8    ,A8   ,$
    FIELD=PATIENT_BIRTH_YEAR           ,ALIAS=F0430_9    ,A4    ,A4   ,$
    FIELD=PATIENT_BIRTH_MONTH          ,ALIAS=F0430_10   ,A2    ,A2   ,$
    FIELD=PATIENT_BIRTH_DAY            ,ALIAS=F0430_11   ,A2    ,A2   ,$
    FIELD=PATIENT_SEX                  ,ALIAS=F0430_12   ,A1    ,A1   ,$
    FIELD=RELATION_TO_EMPLOYEE         ,ALIAS=F0430_13   ,A10   ,A10  ,$
    FIELD=HOSPITAL_NAME                ,ALIAS=F0430_14   ,A25   ,A25  ,$
    GROUP=HOSP_ADDRESS                 ,ALIAS=F0430_15   ,A46   ,A46  ,$
    FIELD=HOSP_STREET                  ,ALIAS=F0430_16   ,A20   ,A20  ,$
    FIELD=HOSP_CITY                    ,ALIAS=F0430_17   ,A15   ,A15  ,$
    FIELD=HOSP_STATE                   ,ALIAS=F0430_18   ,A2    ,A2   ,$
    GROUP=HOSP_ZIP                     ,ALIAS=F0430_19   ,A9    ,A9   ,$
    FIELD=HOSP_ZIP_FIRST_FIVE          ,ALIAS=F0430_20   ,A5    ,A5   ,$
    FIELD=HOSP_ZIP_LAST_FOUR           ,ALIAS=F0430_21   ,A4    ,A4   ,$
    GROUP=ADMIT_DATE                   ,ALIAS=F0430_22   ,A8    ,A8   ,$
    FIELD=ADMIT_YEAR                   ,ALIAS=F0430_23   ,A4    ,A4   ,$
    FIELD=ADMIT_MONTH                  ,ALIAS=F0430_24   ,A2    ,A2   ,$
    FIELD=ADMIT_DAY                    ,ALIAS=F0430_25   ,A2    ,A2   ,$
    GROUP=DISCHARGE_DATE               ,ALIAS=F0430_26   ,A8    ,A8   ,$
    FIELD=DISCHARGE_YEAR               ,ALIAS=F0430_27   ,A4    ,A4   ,$
    FIELD=DISCHARGE_MONTH              ,ALIAS=F0430_28   ,A2    ,A2   ,$
    FIELD=DISCHARGE_DAY                ,ALIAS=F0430_29   ,A2    ,A2   ,$
    FIELD=S09_OCC01                    ,ALIAS=           ,A120  ,A120 ,$
    GROUP=HOSPITAL_CHARGES             ,ALIAS=F0430_31   ,A72   ,A41  ,$
    GROUP=ROOM_AND_BOARD               ,ALIAS=F0430_32   ,A48   ,A26  ,$
    GROUP=WARD                         ,ALIAS=F0430_33   ,A24   ,A13  ,$
    FIELD=WARD_DAYS                    ,ALIAS=F0430_34   ,P6    ,P3   ,$
    FIELD=WARD_RATE                    ,ALIAS=F0430_35   ,P11.2 ,P5   ,$
    FIELD=WARD_TOTAL                   ,ALIAS=F0430_36   ,P11.2 ,P5   ,$
    GROUP=SEMI_PRIVATE                 ,ALIAS=F0430_37   ,A24   ,A13  ,$
    FIELD=SEMI_DAYS                    ,ALIAS=F0430_38   ,P6    ,P3   ,$
    FIELD=SEMI_RATE                    ,ALIAS=F0430_39   ,P11.2 ,P5   ,$
    FIELD=SEMI_TOTAL                   ,ALIAS=F0430_40   ,P11.2 ,P5   ,$
    GROUP=OTHER_CHARGES                ,ALIAS=F0430_41   ,A24   ,A15  ,$
    FIELD=DELIVERY_COST                ,ALIAS=F0430_42   ,P11.2 ,P5   ,$
    FIELD=ANESTHESIA_COST              ,ALIAS=F0430_43   ,P11.2 ,P5   ,$
    FIELD=LAB_COST                     ,ALIAS=F0430_44   ,P11.2 ,P5   ,$
    FIELD=S0430_09_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=OCC09_01,SEGTYPE=S,PARENT=S0430_09,
          OCCURS=0002,POSITION=S09_OCC01,$
    FIELD=DIAGNOSIS                    ,ALIAS=F0430_30   ,A60   ,A60  ,$
    FIELD=OCC09_01                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=S0445_10,SEGTYPE=S,PARENT=S0400_03,$
    GROUP=CLAIM_DATE                   ,ALIAS=F0445_1    ,A8    ,A8   ,$
    FIELD=CLAIM_YEAR                   ,ALIAS=F0445_2    ,A4    ,A4   ,$
    FIELD=CLAIM_MONTH                  ,ALIAS=F0445_3    ,A2    ,A2   ,$
    FIELD=CLAIM_DAY                    ,ALIAS=F0445_4    ,A2    ,A2   ,$
    GROUP=PATIENT_NAME                 ,ALIAS=F0445_5    ,A25   ,A25  ,$
    FIELD=PATIENT_FIRST_NAME           ,ALIAS=F0445_6    ,A10   ,A10  ,$
    FIELD=PATIENT_LAST_NAME            ,ALIAS=F0445_7    ,A15   ,A15  ,$
    GROUP=PATIENT_BIRTH_DATE           ,ALIAS=F0445_8    ,A8    ,A8   ,$
    FIELD=PATIENT_BIRTH_YEAR           ,ALIAS=F0445_9    ,A4    ,A4   ,$
    FIELD=PATIENT_BIRTH_MONTH          ,ALIAS=F0445_10   ,A2    ,A2   ,$
    FIELD=PATIENT_BIRTH_DAY            ,ALIAS=F0445_11   ,A2    ,A2   ,$
    FIELD=PATIENT_SEX                  ,ALIAS=F0445_12   ,A1    ,A1   ,$
    FIELD=RELATION_TO_EMPLOYEE         ,ALIAS=F0445_13   ,A10   ,A10  ,$
    GROUP=PHYSICIAN_NAME               ,ALIAS=F0445_14   ,A25   ,A25  ,$
    FIELD=PHYSICIAN_FIRST_NAME         ,ALIAS=F0445_15   ,A10   ,A10  ,$
    FIELD=PHYSICIAN_LAST_NAME          ,ALIAS=F0445_16   ,A15   ,A15  ,$
    GROUP=PHYSICIAN_ADDRESS            ,ALIAS=F0445_17   ,A46   ,A46  ,$
    FIELD=PHYSICIAN_STREET             ,ALIAS=F0445_18   ,A20   ,A20  ,$
    FIELD=PHYSICIAN_CITY               ,ALIAS=F0445_19   ,A15   ,A15  ,$
    FIELD=PHYSICIAN_STATE              ,ALIAS=F0445_20   ,A2    ,A2   ,$
    GROUP=PHYSICIAN_ZIP                ,ALIAS=F0445_21   ,A9    ,A9   ,$
    FIELD=PHYSICIAN_ZIP_FIRST_FIVE     ,ALIAS=F0445_22   ,A5    ,A5   ,$
    FIELD=PHYSICIAN_ZIP_LAST_FOUR      ,ALIAS=F0445_23   ,A4    ,A4   ,$
    FIELD=PHYSICIAN_ID                 ,ALIAS=F0445_24   ,A6    ,A6   ,$
    FIELD=S10_OCC01                    ,ALIAS=           ,A120  ,A120 ,$
    FIELD=NUMBER_OF_PROCEDURES         ,ALIAS=F0445_26   ,I2    ,I2   ,$
    FIELD=FIL 0001                     ,ALIAS=F0445_27   ,A1    ,A1   ,$
    FIELD=PHYSICIAN_CHARGES            ,ALIAS=F0445_28   ,A256  ,A256 ,$
    FIELD=AUTOPAD10001                 ,ALIAS=           ,A256  ,A256 ,$
    FIELD=AUTOPAD10002                 ,ALIAS=           ,A256  ,A256 ,$
    FIELD=AUTOPAD10003                 ,ALIAS=           ,A32   ,A32  ,$
    FIELD=S0445_10_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=OCC10_01,SEGTYPE=S,PARENT=S0445_10,
          OCCURS=0002,POSITION=S10_OCC01,$
    FIELD=DIAGNOSIS                    ,ALIAS=F0445_25   ,A60   ,A60  ,$
    FIELD=OCC10_01                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=OCC10_02,SEGTYPE=S,PARENT=S0445_10,
          OCCURS=F0445_26,POSITION=F0445_28,$
    GROUP=SERVICE_DATE                 ,ALIAS=F0445_29   ,A8    ,A8   ,$
    FIELD=SERVICE_YEAR                 ,ALIAS=F0445_30   ,A4    ,A4   ,$
    FIELD=SERVICE_MONTH                ,ALIAS=F0445_31   ,A2    ,A2   ,$
    FIELD=SERVICE_DAY                  ,ALIAS=F0445_32   ,A2    ,A2   ,$
    FIELD=PROCEDURE_CODE               ,ALIAS=F0445_33   ,A4    ,A4   ,$
    FIELD=DESCRIPTION_OF_SERVICE       ,ALIAS=F0445_34   ,A60   ,A60  ,$
    FIELD=FEE                          ,ALIAS=F0445_35   ,P11.2 ,P5   ,$
    FIELD=FIL 0003                     ,ALIAS=F0445_36   ,A3    ,A3   ,$
    FIELD=OCC10_02                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=S0440_11,SEGTYPE=U,PARENT=S0420_04,$
    FIELD=JOB_ID                       ,ALIAS=F0440_1    ,A4    ,A4   ,$
    FIELD=TITLE                        ,ALIAS=F0440_2    ,A20   ,A20  ,$
    GROUP=DESCRIPTION                  ,ALIAS=F0440_3    ,A120  ,A120 ,$
    FIELD=S11_OCC01                    ,ALIAS=           ,A120  ,A120 ,$
    GROUP=REQUIREMENTS                 ,ALIAS=F0440_5    ,A120  ,A120 ,$
    FIELD=S11_OCC02                    ,ALIAS=           ,A120  ,A120 ,$
    FIELD=MINIMUM_SALARY               ,ALIAS=F0440_7    ,P10.2 ,Z8   ,$
    FIELD=MAXIMUM_SALARY               ,ALIAS=F0440_8    ,P10.2 ,Z8   ,$
    FIELD=S11_OCC03                    ,ALIAS=           ,A8    ,A8   ,$
    FIELD=NUMBER_OF_POSITIONS          ,ALIAS=F0440_10   ,A3    ,A3   ,$
    FIELD=NUMBER_OPEN                  ,ALIAS=F0440_11   ,A3    ,A3   ,$
    FIELD=FIL 0002                     ,ALIAS=F0440_12   ,A2    ,A2   ,$
    FIELD=S0440_11_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=OCC11_01,SEGTYPE=S,PARENT=S0440_11,
          OCCURS=0002,POSITION=S11_OCC01,$
    FIELD=DESCRIPTION_LINE             ,ALIAS=F0440_4    ,A60   ,A60  ,$
    FIELD=OCC11_01                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=OCC11_02,SEGTYPE=S,PARENT=S0440_11,
          OCCURS=0002,POSITION=S11_OCC02,$
    FIELD=REQUIREMENT_LINE             ,ALIAS=F0440_6    ,A60   ,A60  ,$
    FIELD=OCC11_02                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=OCC11_03,SEGTYPE=S,PARENT=S0440_11,
          OCCURS=0004,POSITION=S11_OCC03,$
    FIELD=SALARY_GRADES                ,ALIAS=F0440_9    ,A2    ,A2   ,$
    FIELD=OCC11_03                     ,ALIAS=ORDER      ,I9    ,I4   ,$
  SEGNAME=S0455_12,SEGTYPE=U,PARENT=S0425_05,$
    FIELD=SKILL_ID                     ,ALIAS=F0455_1    ,A4    ,A4   ,$
    FIELD=SKILL_NAME                   ,ALIAS=F0455_2    ,A12   ,A12  ,$
    FIELD=SKILL_DESCRIPTION            ,ALIAS=F0455_3    ,A60   ,A60  ,$
    FIELD=S0455_12_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
  SEGNAME=S0415_13,SEGTYPE=U,PARENT=S0460_06,$
    FIELD=EMP_ID                       ,ALIAS=F0415_1A   ,A4    ,A4   ,$
    GROUP=EMP_NAME                     ,ALIAS=F0415_2A   ,A25   ,A25  ,$
    FIELD=EMP_FIRST_NAME               ,ALIAS=F0415_3A   ,A10   ,A10  ,$
    FIELD=EMP_LAST_NAME                ,ALIAS=F0415_4A   ,A15   ,A15  ,$
    GROUP=EMP_ADDRESS                  ,ALIAS=F0415_5A   ,A46   ,A46  ,$
    FIELD=EMP_STREET                   ,ALIAS=F0415_6A   ,A20   ,A20  ,$
    FIELD=EMP_CITY                     ,ALIAS=F0415_7A   ,A15   ,A15  ,$
    FIELD=EMP_STATE                    ,ALIAS=F0415_8A   ,A2    ,A2   ,$
    GROUP=EMP_ZIP                      ,ALIAS=F0415_9A   ,A9    ,A9   ,$
    FIELD=EMP_ZIP_FIRST_FIVE           ,ALIAS=F0415_10A  ,A5    ,A5   ,$
    FIELD=EMP_ZIP_LAST_FOUR            ,ALIAS=F0415_11A  ,A4    ,A4   ,$
    FIELD=EMP_PHONE                    ,ALIAS=F0415_12A  ,A10   ,A10  ,$
    FIELD=STATUS                       ,ALIAS=F0415_13A  ,A2    ,A2   ,$
    FIELD=SS_NUMBER                    ,ALIAS=F0415_19A  ,A9    ,A9   ,$
    GROUP=START_DATE                   ,ALIAS=F0415_20A  ,A8    ,A8   ,$
    FIELD=START_YEAR                   ,ALIAS=F0415_21A  ,A4    ,A4   ,$
    FIELD=START_MONTH                  ,ALIAS=F0415_22A  ,A2    ,A2   ,$
    FIELD=START_DAY                    ,ALIAS=F0415_23A  ,A2    ,A2   ,$
    GROUP=TERMINATION_DATE             ,ALIAS=F0415_24A  ,A8    ,A8   ,$
    FIELD=TERMINATION_YEAR             ,ALIAS=F0415_25A  ,A4    ,A4   ,$
    FIELD=TERMINATION_MONTH            ,ALIAS=F0415_26A  ,A2    ,A2   ,$
    FIELD=TERMINATION_DAY              ,ALIAS=F0415_27A  ,A2    ,A2   ,$
    GROUP=BIRTH_DATE                   ,ALIAS=F0415_28A  ,A8    ,A8   ,$
    FIELD=BIRTH_YEAR                   ,ALIAS=F0415_29A  ,A4    ,A4   ,$
    FIELD=BIRTH_MONTH                  ,ALIAS=F0415_30A  ,A2    ,A2   ,$
    FIELD=BIRTH_DAY                    ,ALIAS=F0415_31A  ,A2    ,A2   ,$
    FIELD=S0415_13_KEY                 ,ALIAS=DBKEY      ,I10   ,I4   ,$
   $DUPLICATE=BIRTH_DATE                      ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=BIRTH_DATE                      ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=BIRTH_DAY                       ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=BIRTH_DAY                       ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=BIRTH_MONTH                     ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=BIRTH_MONTH                     ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=BIRTH_YEAR                      ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=BIRTH_YEAR                      ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=CLAIM_DATE                      ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=CLAIM_DATE                      ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=CLAIM_DATE                      ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=CLAIM_DAY                       ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=CLAIM_DAY                       ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=CLAIM_DAY                       ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=CLAIM_MONTH                     ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=CLAIM_MONTH                     ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=CLAIM_MONTH                     ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=CLAIM_YEAR                      ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=CLAIM_YEAR                      ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=CLAIM_YEAR                      ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=DESCRIPTION_OF_SERVICE          ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=DESCRIPTION_OF_SERVICE          ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=DIAGNOSIS                       ,COUNT= 2,SEGNAME=S0430_09
   $DUPLICATE=DIAGNOSIS                       ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=EMP_ADDRESS                     ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_ADDRESS                     ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_CITY                        ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_CITY                        ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_FIRST_NAME                  ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_FIRST_NAME                  ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_ID                          ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_ID                          ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_LAST_NAME                   ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_LAST_NAME                   ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_NAME                        ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_NAME                        ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_PHONE                       ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_PHONE                       ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_STATE                       ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_STATE                       ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_STREET                      ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_STREET                      ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_ZIP                         ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_ZIP                         ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_ZIP_FIRST_FIVE              ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_ZIP_FIRST_FIVE              ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=EMP_ZIP_LAST_FOUR               ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=EMP_ZIP_LAST_FOUR               ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=FEE                             ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=FEE                             ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=FIL 0001                        ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=FIL 0001                        ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=FIL 0001                        ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=FIL 0002                        ,COUNT= 3,SEGNAME=S0425_05
   $DUPLICATE=FIL 0002                        ,COUNT= 3,SEGNAME=S0460_06
   $DUPLICATE=FIL 0002                        ,COUNT= 3,SEGNAME=S0440_11
   $DUPLICATE=FIL 0003                        ,COUNT= 3,SEGNAME=S0410_01
   $DUPLICATE=FIL 0003                        ,COUNT= 3,SEGNAME=S0420_04
   $DUPLICATE=FIL 0003                        ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=NUMBER_OF_PROCEDURES            ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=NUMBER_OF_PROCEDURES            ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_BIRTH_DATE              ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_BIRTH_DATE              ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_BIRTH_DATE              ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_BIRTH_DAY               ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_BIRTH_DAY               ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_BIRTH_DAY               ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_BIRTH_MONTH             ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_BIRTH_MONTH             ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_BIRTH_MONTH             ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_BIRTH_YEAR              ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_BIRTH_YEAR              ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_BIRTH_YEAR              ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_FIRST_NAME              ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_FIRST_NAME              ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_FIRST_NAME              ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_LAST_NAME               ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_LAST_NAME               ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_LAST_NAME               ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_NAME                    ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_NAME                    ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_NAME                    ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PATIENT_SEX                     ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=PATIENT_SEX                     ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=PATIENT_SEX                     ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=PROCEDURE_CODE                  ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=PROCEDURE_CODE                  ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=RELATION_TO_EMPLOYEE            ,COUNT= 3,SEGNAME=S0405_08
   $DUPLICATE=RELATION_TO_EMPLOYEE            ,COUNT= 3,SEGNAME=S0430_09
   $DUPLICATE=RELATION_TO_EMPLOYEE            ,COUNT= 3,SEGNAME=S0445_10
   $DUPLICATE=SERVICE_DATE                    ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=SERVICE_DATE                    ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=SERVICE_DAY                     ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=SERVICE_DAY                     ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=SERVICE_MONTH                   ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=SERVICE_MONTH                   ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=SERVICE_YEAR                    ,COUNT= 2,SEGNAME=S0405_08
   $DUPLICATE=SERVICE_YEAR                    ,COUNT= 2,SEGNAME=S0445_10
   $DUPLICATE=SS_NUMBER                       ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=SS_NUMBER                       ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=START_DATE                      ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=START_DATE                      ,COUNT= 3,SEGNAME=S0420_04
   $DUPLICATE=START_DATE                      ,COUNT= 3,SEGNAME=S0415_13
   $DUPLICATE=START_DAY                       ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=START_DAY                       ,COUNT= 3,SEGNAME=S0420_04
   $DUPLICATE=START_DAY                       ,COUNT= 3,SEGNAME=S0415_13
   $DUPLICATE=START_MONTH                     ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=START_MONTH                     ,COUNT= 3,SEGNAME=S0420_04
   $DUPLICATE=START_MONTH                     ,COUNT= 3,SEGNAME=S0415_13
   $DUPLICATE=START_YEAR                      ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=START_YEAR                      ,COUNT= 3,SEGNAME=S0420_04
   $DUPLICATE=START_YEAR                      ,COUNT= 3,SEGNAME=S0415_13
   $DUPLICATE=STATUS                          ,COUNT= 2,SEGNAME=S0415_02
   $DUPLICATE=STATUS                          ,COUNT= 2,SEGNAME=S0415_13
   $DUPLICATE=TERMINATION_DATE                ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=TERMINATION_DATE                ,COUNT= 3,SEGNAME=S0400_03
   $DUPLICATE=TERMINATION_DATE                ,COUNT= 3,SEGNAME=S0415_13
   $DUPLICATE=TERMINATION_DAY                 ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=TERMINATION_DAY                 ,COUNT= 3,SEGNAME=S0400_03
   $DUPLICATE=TERMINATION_DAY                 ,COUNT= 3,SEGNAME=S0415_13
   $DUPLICATE=TERMINATION_MONTH               ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=TERMINATION_MONTH               ,COUNT= 3,SEGNAME=S0400_03
   $DUPLICATE=TERMINATION_MONTH               ,COUNT= 3,SEGNAME=S0415_13
   $DUPLICATE=TERMINATION_YEAR                ,COUNT= 3,SEGNAME=S0415_02
   $DUPLICATE=TERMINATION_YEAR                ,COUNT= 3,SEGNAME=S0400_03
   $DUPLICATE=TERMINATION_YEAR                ,COUNT= 3,SEGNAME=S0415_13

Information Builders