This Access File is associated with network subschema EMPSS01 and corresponds to its Master File:
SSCHEMA=EMPSS01,RELEASE=14.0,MODE=DML,TRACE=NO,READY=,$ SEGNAM=DEPT,RECORD=DEPARTMENT,AREA=ORG-DEMO-REGION, CLCFLD=DEPT_ID,CLCDUP=N,$ SEGNAM=EMPLOYE,RECORD=EMPLOYEE,AREA=EMP-DEMO-REGION, CLCFLD=EMP_ID,CLCDUP=N,ACCESS=SET,SETNAME=DEPT-EMPLOYEE, SETMBR=OA,GETOWN=Y,MULTMBR=N,$ SEGNAM=OFFICE,RECORD=OFFICE,AREA=ORG-DEMO-REGION, CLCFLD=OFF_CODE,CLCDUP=N,ACCESS=SET,SETNAME=OFFICE-EMPLOYEE, SETMBR=OA,GETOWN=Y,MULTMBR=N,$ SEGNAM=STRUCTUR,RECORD=STRUCTURE,AREA=EMP-DEMO-REGION, ACCESS=SET,SETNAME=MANAGES,SETMBR=MA,GETOWN=Y,MULTMBR=N,$ SEGNAM=SUBORDS,RECORD=EMPLOYEE,AREA=EMP-DEMO-REGION, CLCFLD=SUB_ID,CLCDUP=N,ACCESS=SET,SETNAME=REPORTS-TO, SETMBR=OM,GETOWN=Y,MULTMBR=N,$ SEGNAM=EMPOSIT,RECORD=EMPOSITION,AREA=EMP-DEMO-REGION, ACCESS=SET,SETNAME=EMP-EMPOSITION,SETMBR=MA,GETOWN=Y,MULTMBR=N,$ SEGNAM=JOB,RECORD=JOB,AREA=ORG-DEMO-REGION, CLCFLD=JOB_ID,CLCDUP=N,ACCESS=SET,SETNAME=JOB-EMPOSITION, SETMBR=OM,GETOWN=Y,MULTMBR=N,SEQFIELD=TITLE,$ SEGNAM=EXPERTSE,RECORD=EXPERTISE,AREA=EMP-DEMO-REGION, ACCESS=SET,SETNAME=EMP-EXPERTISE,KEYFLD=SKILL_LEVEL,SETORD=D, SETDUP=Y,SETMBR=MA,GETOWN=Y,MULTMBR=N,$ SEGNAM=SKILL,RECORD=SKILL,AREA=ORG-DEMO-REGION, CLCFLD=SKILL_ID,CLCDUP=N,ACCESS=SET,SETNAME=SKILL-EXPERTISE, KEYFLD=SKILL_LEVEL,SETORD=D,SETDUP=Y, SETMBR=MA,GETOWN=Y,MULTMBR=N,SEQFIELD=SKILL_NAME,$ SEGNAM=COVERAGE,RECORD=COVERAGE,AREA=INS-DEMO-REGION, ACCESS=SET,SETNAME=EMP-COVERAGE,SETMBR=MA,GETOWN=Y,MULTMBR=N,$ SEGNAM=HOSPITAL,RECORD=HOSPITAL-CLAIM,AREA=INS-DEMO-REGION, ACCESS=SET,SETNAME=COVERAGE-CLAIMS,SETMBR=MA,GETOWN=Y,MULTMBR=Y,$ SEGNAM=NON_HOSP,RECORD=NON-HOSP-CLAIM,AREA=INS-DEMO-REGION, ACCESS=SET,SETNAME=COVERAGE-CLAIMS,SETMBR=MA,GETOWN=Y,MULTMBR=Y,$ SEGNAM=DENTAL,RECORD=DENTAL-CLAIM,AREA=INS-DEMO-REGION, ACCESS=SET,SETNAME=COVERAGE-CLAIMS,SETMBR=MA,GETOWN=Y,MULTMBR=Y,$ IXSET=JOB-TITLE-NDX,IXFLD=TITLE,IXDUP=N,IXORD=A, IXAREA=INS-DEMO-REGION,$ IXSET=SKILL-NAME-NDX,IXFLD=SKILL_NAME,IXDUP=N,IXORD=D, IXAREA=EMP-DEMO-REGION,$ SEGNAM=INSURNCE,RECORD=INSURANCE-PLAN,AREA=INS-DEMO-REGION, CLCFLD=INS_PLAN_CD
E,CLCDUP=N,ACCESS=CLC,KEYFLD=COV_CODE,$
Information Builders |