EMPFULL Access File

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

  $$$ CREATED BY AUTOIDMS ON 12/13/12 AT 14.32.16 BY USERID
  $$$ FILE=EMPFULL,SUFFIX=IDMSR,$
  SSCHEMA=EMPSS01,RELEASE=12.0,MODE=DML,
  DBNAME=EMPDEMO  ,DICTNAME=APPLDICT ,$
  SEGNAM=S0410_01,RECORD=DEPARTMENT,
         AREA=ORG-DEMO-REGION,
  CLCFLD=F0410_1,
         CLCDUP=N,$
  SEGNAM=S0415_02,RECORD=EMPLOYEE,
         AREA=EMP-DEMO-REGION,
         ACCESS=SET,SETNAME=DEPT-EMPLOYEE,
         SETMBR=OA,GETOWN=Y,MULTMBR=N,
  CLCFLD=F0415_1,
         CLCDUP=N,
  KEYFLD=F0415_4/F0415_3,
         SETORD=A,SETDUP=Y,$
  IXSET=EMP-NAME-NDX,IXDUP=Y,IXORD=A,
  IXFLD=F0415_4/F0415_3,$
  SEGNAM=S0400_03,RECORD=COVERAGE,
         AREA=INS-DEMO-REGION,
         ACCESS=SET,SETNAME=EMP-COVERAGE,
         SETMBR=MA,GETOWN=Y,MULTMBR=N,$
  SEGNAM=S0420_04,RECORD=EMPOSITION,
         AREA=EMP-DEMO-REGION,
         ACCESS=SET,SETNAME=EMP-EMPOSITION,
         SETMBR=MA,GETOWN=Y,MULTMBR=N,$
  SEGNAM=S0425_05,RECORD=EXPERTISE,
         AREA=EMP-DEMO-REGION,
         ACCESS=SET,SETNAME=EMP-EXPERTISE,
         SETMBR=MA,GETOWN=Y,MULTMBR=N,
  KEYFLD=F0425_1,
         SETORD=D,SETDUP=Y,$
  SEGNAM=S0460_06,RECORD=STRUCTURE,
         AREA=EMP-DEMO-REGION,
         ACCESS=SET,SETNAME=MANAGES,
         SETMBR=MA,GETOWN=Y,MULTMBR=N,$
  SEGNAM=S0450_07,RECORD=OFFICE,
         AREA=ORG-DEMO-REGION,
         ACCESS=SET,SETNAME=OFFICE-EMPLOYEE,
         SETMBR=OA,GETOWN=Y,MULTMBR=N,
  CLCFLD=F0450_1,
         CLCDUP=N,
  KEYFLD=F0415_4/F0415_3,
         SETORD=A,SETDUP=Y,$
  SEGNAM=S0405_08,RECORD=DENTAL-CLAIM,
         AREA=INS-DEMO-REGION,
         ACCESS=SET,SETNAME=COVERAGE-CLAIMS,
         SETMBR=MA,GETOWN=N,MULTMBR=Y,$
  SEGNAM=S0430_09,RECORD=HOSPITAL-CLAIM,
         AREA=INS-DEMO-REGION,
         ACCESS=SET,SETNAME=COVERAGE-CLAIMS,
         SETMBR=MA,GETOWN=N,MULTMBR=Y,$  SEGNAM=S0445_10,RECORD=NON-HOSP-CLAIM,
         AREA=INS-DEMO-REGION,
         ACCESS=SET,SETNAME=COVERAGE-CLAIMS,
         SETMBR=MA,GETOWN=N,MULTMBR=Y,$
  SEGNAM=S0440_11,RECORD=JOB,
         AREA=ORG-DEMO-REGION,
         ACCESS=SET,SETNAME=JOB-EMPOSITION,
         SETMBR=OM,GETOWN=Y,MULTMBR=N,
  CLCFLD=F0440_1,
         CLCDUP=N,$
  IXSET=JOB-TITLE-NDX,IXDUP=N,IXORD=A,
  IXFLD=F0440_2,$
  SEGNAM=S0455_12,RECORD=SKILL,
         AREA=ORG-DEMO-REGION,
         ACCESS=SET,SETNAME=SKILL-EXPERTISE,
         SETMBR=MA,GETOWN=Y,MULTMBR=N,
  CLCFLD=F0455_1,
         CLCDUP=N,
  KEYFLD=F0425_1,
         SETORD=D,SETDUP=Y,$
  IXSET=SKILL-NAME-NDX,IXDUP=N,IXORD=A,
  IXFLD=F0455_2,$
  SEGNAM=S0415_13,RECORD=EMPLOYEE,
         AREA=EMP-DEMO-REGION,
         ACCESS=SET,SETNAME=REPORTS-TO,
         SETMBR=OM,GETOWN=Y,MULTMBR=N,
  CLCFLD=F0415_1A,
         CLCDUP=N,$
  IXSET=EMP-NAME-NDX,IXDUP=Y,IXORD=A,
  IXFLD=F0415_4A/F0415_3A,$

Information Builders