This Master File is used in the examples throughout this manual. For instructions about creating this Master File, see the sample session in Chapter 6, Creating File Descriptions With AUTOIDMS:
$$$ CREATED BY AUTOIDMS ON 02/13/01 AT 14.32.16 BY PMSSAE
$$$ 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 |