This schema is the physical description of the IDMS EMPSCHM data source. It contains the following annotated items:
000001 DIS SCHEMA EMPSCHM V 100 WITHO ELE. *+ ADD *+ SCHEMA NAME IS EMPSCHM VERSION IS 100 *+ DATE CREATED IS 08/20/97 *+ TIME CREATED IS 15003144 *+ PREPARED BY CSDPJC *+ SCHEMA DESCRIPTION IS 'EMPLOYEE DEMO DATABASE' *+ ASSIGN RECORD IDS FROM 1001 *+ PUBLIC ACCESS IS ALLOWED FOR ALL *+ COMMENTS *+ 'INSTALLATION: COMMONWEATHER CORPORATION' *+ SUBSCHEMA IS EMPSS01 *+ . *+ ADD *+ AREA NAME IS EMP-DEMO-REGION *+ ESTIMATED PAGES ARE 0 *+ . *+ ADD *+ AREA NAME IS ORG-DEMO-REGION *+ ESTIMATED PAGES ARE 0 *+ . *+ ADD *+ AREA NAME IS INS-DEMO-REGION *+ ESTIMATED PAGES ARE 0 *+ .
*+ ADD *+ RECORD NAME IS COVERAGE *+ SHARE STRUCTURE OF RECORD COVERAGE VERSION 100 *+ RECORD ID IS 400 *+ LOCATION MODE IS VIA EMP-COVERAGE SET *+ WITHIN AREA INS-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS COVERGE FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS COVRGE FOR LANGUAGE FORTRAN *+ OWNER OF SET COVERAGE-CLAIMS *+ NEXT DBKEY POSITION IS 4 *+ PRIOR DBKEY POSITION IS 5 *+ MEMBER OF SET EMP-COVERAGE *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ OWNER DBKEY POSITION IS 3 *+ . *+ ADD *+ RECORD NAME IS DENTAL-CLAIM *+ SHARE STRUCTURE OF RECORD DENTAL-CLAIM VERSION 100 *+ RECORD ID IS 405 *+ LOCATION MODE IS VIA COVERAGE-CLAIMS SET *+ MINIMUM ROOT LENGTH IS 132 CHARACTERS *+ MINIMUM FRAGMENT LENGTH IS 932 CHARACTERS *+ WITHIN AREA INS-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS DENTCLM FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS DNTCLM FOR LANGUAGE FORTRAN *+ MEMBER OF SET COVERAGE-CLAIMS *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ . *+ ADD *+ RECORD NAME IS DEPARTMENT *+ SHARE STRUCTURE OF RECORD DEPARTMENT VERSION 100 *+ RECORD ID IS 410 *+ LOCATION MODE IS CALC USING ( DEPT-ID-0410 ) *+ DUPLICATES ARE NOT ALLOWED *+ WITHIN AREA ORG-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS DEPARTMT FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS DEPT FOR LANGUAGE FORTRAN *+ OWNER OF SET DEPT-EMPLOYEE *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ .
*+ ADD *+ RECORD NAME IS EMPLOYEE *+ SHARE STRUCTURE OF RECORD EMPLOYEE VERSION 100 *+ RECORD ID IS 415 *+ LOCATION MODE IS CALC USING ( EMP-ID-0415 ) *+ DUPLICATES ARE NOT ALLOWED *+ WITHIN AREA EMP-DEMO-REGION OFFSET 5 PAGES FOR 95 PAGES *+ RECORD NAME SYNONYM IS EMPLOYE FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS EMPLOY FOR LANGUAGE FORTRAN *+ OWNER OF SET EMP-COVERAGE *+ NEXT DBKEY POSITION IS 7 *+ PRIOR DBKEY POSITION IS 8 *+ OWNER OF SET EMP-EMPOSITION *+ NEXT DBKEY POSITION IS 9 *+ PRIOR DBKEY POSITION IS 10 *+ OWNER OF SET EMP-EXPERTISE *+ NEXT DBKEY POSITION IS 11 *+ PRIOR DBKEY POSITION IS 12 *+ OWNER OF SET MANAGES *+ NEXT DBKEY POSITION IS 13 *+ PRIOR DBKEY POSITION IS 14 *+ OWNER OF SET REPORTS-TO *+ NEXT DBKEY POSITION IS 15 *+ PRIOR DBKEY POSITION IS 16 *+ MEMBER OF SET DEPT-EMPLOYEE *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ OWNER DBKEY POSITION IS 3 *+ MEMBER OF SET EMP-NAME-NDX *+ INDEX DBKEY POSITION IS 4 *+ MEMBER OF SET OFFICE-EMPLOYEE *+ INDEX DBKEY POSITION IS 5 *+ OWNER DBKEY POSITION IS 6 *+ . *+ ADD *+ RECORD NAME IS EMPOSITION *+ SHARE STRUCTURE OF RECORD EMPOSITION VERSION 100 *+ RECORD ID IS 420 *+ LOCATION MODE IS VIA EMP-EMPOSITION SET *+ WITHIN AREA EMP-DEMO-REGION OFFSET 5 PAGES FOR 95 PAGES *+ RECORD NAME SYNONYM IS EMPOSITN FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS EMPOST FOR LANGUAGE FORTRAN *+ MEMBER OF SET EMP-EMPOSITION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ OWNER DBKEY POSITION IS 3 *+ MEMBER OF SET JOB-EMPOSITION *+ NEXT DBKEY POSITION IS 4 *+ PRIOR DBKEY POSITION IS 5 *+ OWNER DBKEY POSITION IS 6 *+ .
*+ ADD *+ RECORD NAME IS EXPERTISE *+ SHARE STRUCTURE OF RECORD EXPERTISE VERSION 100 *+ RECORD ID IS 425 *+ LOCATION MODE IS VIA EMP-EXPERTISE SET *+ WITHIN AREA EMP-DEMO-REGION OFFSET 5 PAGES FOR 95 PAGES *+ RECORD NAME SYNONYM IS EXPRTISE FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS EXPRTS FOR LANGUAGE FORTRAN *+ MEMBER OF SET EMP-EXPERTISE *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ OWNER DBKEY POSITION IS 3 *+ MEMBER OF SET SKILL-EXPERTISE *+ INDEX DBKEY POSITION IS 4 *+ OWNER DBKEY POSITION IS 5 *+ . *+ ADD *+ RECORD NAME IS HOSPITAL-CLAIM *+ SHARE STRUCTURE OF RECORD HOSPITAL-CLAIM VERSION 100 *+ RECORD ID IS 430 *+ LOCATION MODE IS VIA COVERAGE-CLAIMS SET *+ WITHIN AREA INS-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS HOSPCLM FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS HSPCLM FOR LANGUAGE FORTRAN *+ MEMBER OF SET COVERAGE-CLAIMS *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ . *+ ADD *+ RECORD NAME IS INSURANCE-PLAN *+ SHARE STRUCTURE OF RECORD INSURANCE-PLAN VERSION 100 *+ RECORD ID IS 435 *+ LOCATION MODE IS CALC USING ( INS-PLAN-CODE-0435 ) *+ DUPLICATES ARE NOT ALLOWED *+ WITHIN AREA INS-DEMO-REGION OFFSET 1 PAGES FOR 4 PAGES *+ RECORD NAME SYNONYM IS INSPLAN FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS INSPLN FOR LANGUAGE FORTRAN *+ .
*+ ADD *+ RECORD NAME IS JOB *+ SHARE STRUCTURE OF RECORD JOB VERSION 100 *+ RECORD ID IS 440 *+ LOCATION MODE IS CALC USING ( JOB-ID-0440 ) *+ DUPLICATES ARE NOT ALLOWED *+ MINIMUM ROOT LENGTH IS 24 CHARACTERS *+ MINIMUM FRAGMENT LENGTH IS 296 CHARACTERS *+ CALL IDMSCOMP BEFORE STORE *+ CALL IDMSCOMP BEFORE MODIFY *+ CALL IDMSDCOM AFTER GET *+ WITHIN AREA ORG-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS JOBA FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS JOBF FOR LANGUAGE FORTRAN *+ OWNER OF SET JOB-EMPOSITION *+ NEXT DBKEY POSITION IS 2 *+ PRIOR DBKEY POSITION IS 3 *+ MEMBER OF SET JOB-TITLE-NDX *+ INDEX DBKEY POSITION IS 1 *+ . *+ ADD *+ RECORD NAME IS NON-HOSP-CLAIM *+ SHARE STRUCTURE OF RECORD NON-HOSP-CLAIM VERSION 100 *+ RECORD ID IS 445 *+ LOCATION MODE IS VIA COVERAGE-CLAIMS SET *+ MINIMUM ROOT LENGTH IS 248 CHARACTERS *+ MINIMUM FRAGMENT LENGTH IS 1052 CHARACTERS *+ WITHIN AREA INS-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS NONHSPCL FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS NHSPCL FOR LANGUAGE FORTRAN *+ MEMBER OF SET COVERAGE-CLAIMS *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ . *+ ADD *+ RECORD NAME IS OFFICE *+ SHARE STRUCTURE OF RECORD OFFICE VERSION 100 *+ RECORD ID IS 450 *+ LOCATION MODE IS CALC USING ( OFFICE-CODE-0450 ) *+ DUPLICATES ARE NOT ALLOWED *+ WITHIN AREA ORG-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS OFFIC FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS OFFCE FOR LANGUAGE FORTRAN *+ OWNER OF SET OFFICE-EMPLOYEE *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ .
*+ ADD *+ RECORD NAME IS SKILL *+ SHARE STRUCTURE OF RECORD SKILL VERSION 100 *+ RECORD ID IS 455 *+ LOCATION MODE IS CALC USING ( SKILL-ID-0455 ) *+ DUPLICATES ARE NOT ALLOWED *+ WITHIN AREA ORG-DEMO-REGION OFFSET 5 PAGES FOR 45 PAGES *+ RECORD NAME SYNONYM IS SKILLA FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS SKILLF FOR LANGUAGE FORTRAN *+ OWNER OF SET SKILL-EXPERTISE *+ NEXT DBKEY POSITION IS 2 *+ PRIOR DBKEY POSITION IS 3 *+ MEMBER OF SET SKILL-NAME-NDX *+ INDEX DBKEY POSITION IS 1 *+ . *+ ADD *+ RECORD NAME IS STRUCTURE *+ SHARE STRUCTURE OF RECORD STRUCTURE VERSION 100 *+ RECORD ID IS 460 *+ LOCATION MODE IS VIA MANAGES SET *+ WITHIN AREA EMP-DEMO-REGION OFFSET 5 PAGES FOR 95 PAGES *+ RECORD NAME SYNONYM IS STRUCTUR FOR LANGUAGE ASSEMBLER *+ RECORD NAME SYNONYM IS STRUCT FOR LANGUAGE FORTRAN *+ MEMBER OF SET MANAGES *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ OWNER DBKEY POSITION IS 3 *+ MEMBER OF SET REPORTS-TO *+ NEXT DBKEY POSITION IS 4 *+ PRIOR DBKEY POSITION IS 5 *+ OWNER DBKEY POSITION IS 6 *+ .
*+ ADD *+ SET NAME IS COVERAGE-CLAIMS *+ ORDER IS LAST *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS COVERAGE *+ WITHIN AREA INS-DEMO-REGION *+ NEXT DBKEY POSITION IS 4 *+ PRIOR DBKEY POSITION IS 5 *+ MEMBER IS HOSPITAL-CLAIM *+ WITHIN AREA INS-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ MANDATORY AUTOMATIC *+ MEMBER IS NON-HOSP-CLAIM *+ WITHIN AREA INS-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ MANDATORY AUTOMATIC *+ MEMBER IS DENTAL-CLAIM *+ WITHIN AREA INS-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ MANDATORY AUTOMATIC *+ . *+ ADD *+ SET NAME IS DEPT-EMPLOYEE *+ ORDER IS SORTED *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS DEPARTMENT *+ WITHIN AREA ORG-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ MEMBER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 3 *+ OPTIONAL AUTOMATIC *+ KEY IS ( *+ EMP-LAST-NAME-0415 ASCENDING *+ EMP-FIRST-NAME-0415 ASCENDING ) *+ DUPLICATES ARE LAST *+ NATURAL SEQUENCE *+ .
*+ ADD *+ SET NAME IS EMP-COVERAGE *+ ORDER IS FIRST *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 7 *+ PRIOR DBKEY POSITION IS 8 *+ MEMBER IS COVERAGE *+ WITHIN AREA INS-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 3 *+ MANDATORY AUTOMATIC *+ . *+ ADD *+ SET NAME IS EMP-EMPOSITION *+ ORDER IS FIRST *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 9 *+ PRIOR DBKEY POSITION IS 10 *+ MEMBER IS EMPOSITION *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 3 *+ MANDATORY AUTOMATIC *+ .
*+ ADD *+ SET NAME IS EMP-EXPERTISE *+ ORDER IS SORTED *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 11 *+ PRIOR DBKEY POSITION IS 12 *+ MEMBER IS EXPERTISE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 3 *+ MANDATORY AUTOMATIC *+ KEY IS ( *+ SKILL-LEVEL-0425 DESCENDING ) *+ DUPLICATES ARE FIRST *+ NATURAL SEQUENCE *+ .
*+ ADD *+ SET NAME IS EMP-NAME-NDX *+ ORDER IS SORTED *+ MODE IS INDEX BLOCK CONTAINS 40 KEYS *+ OWNER IS SYSTEM *+ WITHIN AREA EMP-DEMO-REGION OFFSET 1 PAGES FOR 4 PAGES *+ MEMBER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ INDEX DBKEY POSITION IS 4 *+ OPTIONAL AUTOMATIC *+ KEY IS ( *+ EMP-LAST-NAME-0415 ASCENDING *+ EMP-FIRST-NAME-0415 ASCENDING ) *+ DUPLICATES ARE LAST *+ NATURAL SEQUENCE *+ COMPRESSED *+ . *+ ADD *+ SET NAME IS JOB-EMPOSITION *+ ORDER IS NEXT *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS JOB *+ WITHIN AREA ORG-DEMO-REGION *+ NEXT DBKEY POSITION IS 2 *+ PRIOR DBKEY POSITION IS 3 *+ MEMBER IS EMPOSITION *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 4 *+ PRIOR DBKEY POSITION IS 5 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 6 *+ OPTIONAL MANUAL *+ .
*+ ADD *+ SET NAME IS JOB-TITLE-NDX *+ ORDER IS SORTED *+ MODE IS INDEX BLOCK CONTAINS 30 KEYS *+ OWNER IS SYSTEM *+ WITHIN AREA ORG-DEMO-REGION OFFSET 1 PAGES FOR 4 PAGES *+ MEMBER IS JOB *+ WITHIN AREA ORG-DEMO-REGION *+ INDEX DBKEY POSITION IS 1 *+ OPTIONAL AUTOMATIC *+ KEY IS ( *+ TITLE-0440 ASCENDING ) *+ DUPLICATES ARE NOT ALLOWED *+ NATURAL SEQUENCE *+ UNCOMPRESSED *+ .
*+ ADD *+ SET NAME IS MANAGES *+ ORDER IS NEXT *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 13 *+ PRIOR DBKEY POSITION IS 14 *+ MEMBER IS STRUCTURE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 3 *+ MANDATORY AUTOMATIC *+ . *+ ADD *+ SET NAME IS OFFICE-EMPLOYEE *+ ORDER IS SORTED *+ MODE IS INDEX BLOCK CONTAINS 30 KEYS *+ OWNER IS OFFICE *+ WITHIN AREA ORG-DEMO-REGION *+ NEXT DBKEY POSITION IS 1 *+ PRIOR DBKEY POSITION IS 2 *+ MEMBER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ INDEX DBKEY POSITION IS 5 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 6 *+ OPTIONAL AUTOMATIC *+ KEY IS ( *+ EMP-LAST-NAME-0415 ASCENDING *+ EMP-FIRST-NAME-0415 ASCENDING ) *+ DUPLICATES ARE LAST *+ NATURAL SEQUENCE *+ COMPRESSED *+ . *+ ADD *+ SET NAME IS REPORTS-TO *+ ORDER IS NEXT *+ MODE IS CHAIN LINKED TO PRIOR *+ OWNER IS EMPLOYEE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 15 *+ PRIOR DBKEY POSITION IS 16 *+ MEMBER IS STRUCTURE *+ WITHIN AREA EMP-DEMO-REGION *+ NEXT DBKEY POSITION IS 4 *+ PRIOR DBKEY POSITION IS 5 *+ LINKED TO OWNER *+ OWNER DBKEY POSITION IS 6 *+ OPTIONAL MANUAL *+ .
*+ ADD
*+ SET NAME IS SKILL-EXPERTISE
*+ ORDER IS SORTED
*+ MODE IS INDEX BLOCK CONTAINS 30 KEYS
*+ OWNER IS SKILL
*+ WITHIN AREA ORG-DEMO-REGION
*+ NEXT DBKEY POSITION IS 2
*+ PRIOR DBKEY POSITION IS 3
*+ MEMBER IS EXPERTISE
*+ WITHIN AREA EMP-DEMO-REGION
*+ INDEX DBKEY POSITION IS 4
*+ LINKED TO OWNER
*+ OWNER DBKEY POSITION IS 5
*+ MANDATORY AUTOMATIC
*+ KEY IS (
*+ SKILL-LEVEL-0425 DESCENDING )
*+ DUPLICATES ARE FIRST
*+ NATURAL SEQUENCE
*+ UNCOMPRESSED
*+ .
*+ ADD
*+ SET NAME IS SKILL-NAME-NDX
*+ ORDER IS SORTED
*+ MODE IS INDEX BLOCK CONTAINS 30 KEYS
*+ OWNER IS SYSTEM
*+ WITHIN AREA ORG-DEMO-REGION OFFSET 1 PAGES FOR 4 PAGES
*+ MEMBER IS SKILL
*+ WITHIN AREA ORG-DEMO-REGION
*+ INDEX DBKEY POSITION IS 1
*+ OPTIONAL AUTOMATIC
*+ KEY IS (
*+ SKILL-NAME-0455 ASCENDING )
*+ DUPLICATES ARE NOT ALLOWED
*+ NATURAL SEQUENCE
*+ UNCOMPRESSED
*+ .
** TRANSACTION SUMMARY **
ENTITY ADD MODIFY REPLACE DELETE DISPLAY
..................... ... ...... ....... ...... .......
SCHEMA 0 0 0 0 1
NO ERRORS OR WARNINGS ISSUED FOR THIS COMPILE| Information Builders |