|
Topics: |
The following sections contain:
Note: Some samples are annotated to illustrate specific clauses.
This schema is the physical description of the IDMS/DB EMPSCHM database. It contains the following items:
ADD SCHEMA NAME IS EMPSCHM VERSION IS 1
SCHEMA DESCRIPTION IS 'EMPLOYEE DEMO DATABASE'
COMMENTS 'INSTALLATION: COMMONWEATHER CORPORATION'
. ADD FILE NAME IS EMPDEMO ASSIGN TO EMPDEMO
DEVICE TYPE IS 3380
. ADD FILE NAME IS INSDEMO ASSIGN TO INSDEMO
DEVICE TYPE IS 3380
. ADD FILE NAME IS ORGDEMO ASSIGN TO ORGDEMO
DEVICE TYPE IS 3380
. ADD AREA NAME IS EMP-DEMO-REGION
RANGE IS 75001 THRU 75100
WITHIN FILE EMPDEMO FROM 1 THRU 100
. ADD AREA NAME IS ORG-DEMO-REGION
RANGE IS 75151 THRU 75200
WITHIN FILE ORGDEMO FROM 1 THRU 50
. ADD AREA NAME IS INS-DEMO-REGION
RANGE IS 75101 THRU 75150
WITHIN FILE INSDEMO FROM 1 THRU 50
. ADD RECORD NAME IS COVERAGE
SHARE STRUCTURE OF RECORD COVERAGE VERSION IS 1
RECORD ID IS 0400
LOCATION MODE IS VIA EMP-COVERAGE SET
WITHIN AREA INS-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
. ADD RECORD NAME IS DENTAL-CLAIM
SHARE STRUCTURE OF RECORD DENTAL-CLAIM VERSION IS 1
RECORD ID IS 0405
LOCATION MODE IS VIA COVERAGE-CLAIMS SET
WITHIN AREA INS-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
MINIMUM ROOT LENGTH IS 130 CHARACTERS
MINIMUM FRAGMENT LENGTH IS RECORD LENGTH
. ADD RECORD NAME IS DEPARTMENT
SHARE STRUCTURE OF RECORD DEPARTMENT VERSION IS 1
RECORD ID IS 0410
LOCATION MODE IS CALC USING DEPT-ID-0410
DUPLICATES NOT ALLOWED
WITHIN AREA ORG-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
. ADD RECORD NAME IS EMPLOYEE
SHARE STRUCTURE OF RECORD EMPLOYEE VERSION IS 1
RECORD ID IS 0415
LOCATION MODE IS CALC USING EMP-ID-0415
DUPLICATES NOT ALLOWED
WITHIN AREA EMP-DEMO-REGION
OFFSET 2 PAGES FOR 98 PAGES
. ADD RECORD NAME IS EMPOSITION
SHARE STRUCTURE OF RECORD EMPOSITION VERSION IS 1
RECORD ID IS 0420
LOCATION MODE IS VIA EMP-EMPOSITION SET
WITHIN AREA EMP-DEMO-REGION
OFFSET 2 PAGES FOR 98 PAGES
. ADD RECORD NAME IS EXPERTISE
SHARE STRUCTURE OF RECORD EXPERTISE VERSION IS 1
RECORD ID IS 0425
LOCATION MODE IS VIA EMP-EXPERTISE SET
WITHIN AREA EMP-DEMO-REGION
OFFSET 2 PAGES FOR 98 PAGES
. ADD RECORD NAME IS HOSPITAL-CLAIM
SHARE STRUCTURE OF RECORD HOSPITAL-CLAIM VERSION IS 1
RECORD ID IS 0430
LOCATION MODE IS VIA COVERAGE-CLAIMS SET
WITHIN AREA INS-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
. ADD RECORD NAME IS INSURANCE-PLAN
SHARE STRUCTURE OF RECORD INSURANCE-PLAN VERSION IS 1|
RECORD ID IS 0435
LOCATION MODE IS CALC USING INS-PLAN-CODE-0435
DUPLICATES NOT ALLOWED
WITHIN AREA INS-DEMO-REGION
OFFSET 1 PAGE FOR 1 PAGE
. ADD RECORD NAME IS JOB
SHARE STRUCTURE OF RECORD JOB VERSION IS 1
RECORD ID IS 0440
LOCATION MODE IS CALC USING JOB-ID-0440
DUPLICATES NOT ALLOWED
WITHIN AREA ORG-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
MINIMUM ROOT LENGTH IS CONTROL LENGTH
MINIMUM FRAGMENT LENGTH IS RECORD LENGTH
CALL IDMSCOMP BEFORE STORE
CALL IDMSCOMP BEFORE MODIFY
CALL IDMSDCOM AFTER GET
. ADD RECORD NAME IS NON-HOSP-CLAIM
SHARE STRUCTURE OF RECORD NON-HOSP-CLAIM VERSION IS 1
RECORD ID IS 0445
LOCATION MODE IS VIA COVERAGE-CLAIMS SET
WITHIN AREA INS-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
MINIMUM ROOT LENGTH IS 248 CHARACTERS
MINIMUM FRAGMENT LENGTH IS RECORD LENGTH
. ADD RECORD NAME IS OFFICE
SHARE STRUCTURE OF RECORD OFFICE VERSION IS 1
RECORD ID IS 0450
LOCATION MODE IS CALC USING OFFICE-CODE-0450
DUPLICATES NOT ALLOWED
WITHIN AREA ORG-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
. ADD RECORD NAME IS SKILL
SHARE STRUCTURE OF RECORD SKILL VERSION IS 1
RECORD ID IS 0455
LOCATION MODE IS CALC USING SKILL-ID-0455
DUPLICATES NOT ALLOWED
WITHIN AREA ORG-DEMO-REGION
OFFSET 2 PAGES FOR 48 PAGES
. ADD RECORD NAME IS STRUCTURE
SHARE STRUCTURE OF RECORD STRUCTURE VERSION IS 1
RECORD ID IS 0460
LOCATION MODE IS VIA MANAGES SET
WITHIN AREA EMP-DEMO-REGION
OFFSET 2 PAGES FOR 98 PAGES
. ADD SET NAME IS COVERAGE-CLAIMS
ORDER IS LAST
MODE IS CHAIN LINKED TO PRIOR
OWNER IS COVERAGE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS HOSPITAL-CLAIM
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
MEMBER IS NON-HOSP-CLAIM
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
MEMBER IS DENTAL-CLAIM
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
. ADD SET NAME IS DEPT-EMPLOYEE
ORDER IS SORTED
MODE IS CHAIN LINKED TO PRIOR
OWNER IS DEPARTMENT
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS EMPLOYEE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
OPTIONAL AUTOMATIC
ASCENDING KEY IS ( EMP-LAST-NAME-0415
EMP-FIRST-NAME-0415 )
DUPLICATES LAST
. ADD SET NAME IS EMP-COVERAGE
ORDER IS FIRST
MODE IS CHAIN LINKED TO PRIOR
OWNER IS EMPLOYEE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS COVERAGE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
. ADD SET NAME IS EMP-EMPOSITION
ORDER IS FIRST
MODE IS CHAIN LINKED TO PRIOR
OWNER IS EMPLOYEE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS EMPOSITION
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
. ADD SET NAME IS EMP-EXPERTISE
ORDER IS SORTED
MODE IS CHAIN LINKED TO PRIOR
OWNER IS EMPLOYEE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS EXPERTISE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
DESCENDING KEY IS (SKILL-LEVEL-0425 )
DUPLICATES FIRST
. 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 PAGE FOR 1 PAGE
MEMBER IS EMPLOYEE
INDEX DBKEY POSITION IS AUTO
OPTIONAL AUTOMATIC
ASCENDING KEY IS ( EMP-LAST-NAME-0415
EMP-FIRST-NAME-0415 )
COMPRESSED
DUPLICATES LAST
. ADD SET NAME IS JOB-EMPOSITION
ORDER IS NEXT
MODE IS CHAIN LINKED TO PRIOR
OWNER IS JOB
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS EMPOSITION
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
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 PAGE FOR 1 PAGE
MEMBER IS JOB
INDEX DBKEY POSITION IS AUTO
OPTIONAL AUTOMATIC
ASCENDING KEY IS ( TITLE-0440 )
DUPLICATES NOT ALLOWED
. ADD SET NAME IS MANAGES
ORDER IS NEXT
MODE IS CHAIN LINKED TO PRIOR
OWNER IS EMPLOYEE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS STRUCTURE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
. ADD SET NAME IS OFFICE-EMPLOYEE
ORDER IS SORTED
MODE IS INDEX BLOCK CONTAINS 30 KEYS
OWNER IS OFFICE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS EMPLOYEE
INDEX DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
OPTIONAL AUTOMATIC
ASCENDING KEY IS ( EMP-LAST-NAME-0415
EMP-FIRST-NAME-0415 )
COMPRESSED
DUPLICATES LAST
. ADD SET NAME IS REPORTS-TO
ORDER IS NEXT
MODE IS CHAIN LINKED TO PRIOR
OWNER IS EMPLOYE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS STRUCTURE
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
OPTIONAL MANUAL
. ADD SET NAME IS SKILL-EXPERTISE
ORDER IS SORTED
MODE IS INDEX BLOCK CONTAINS 30 KEYS
OWNER IS SKILL
NEXT DBKEY POSITION IS AUTO
PRIOR DBKEY POSITION IS AUTO
MEMBER IS EXPERTISE
INDEX DBKEY POSITION IS AUTO
LINKED TO OWNER
OWNER DBKEY POSITION IS AUTO
MANDATORY AUTOMATIC
DESCENDING KEY IS ( SKILL-LEVEL-0425 )
DUPLICATES FIRST
. 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 PAGE FOR 1 PAGE
MEMBER IS SKILL
INDEX DBKEY POSITION IS AUTO
OPTIONAL AUTOMATIC
ASCENDING KEY IS ( SKILL-NAME-0455 )
DUPLICATES NOT ALLOWED
.
VALIDATE
.This subschema shows the network view of the schema EMPSCHM:
ADD SUBSCHEMA NAME IS EMPSS01 OF SCHEMA NAME IS EMPSCHM VERSION 1 DMCL NAME IS EMPDMCL OF SCHEMA NAME IS EMPSCHM VERSION 1 COMMENTS 'THIS IS THE COMPLETE VIEW OF EMPSCHM'. ADD AREA NAME IS EMP-DEMO-REGION. ADD AREA NAME IS INS-DEMO-REGION. ADD AREA NAME IS ORG-DEMO-REGION. ADD RECORD NAME IS COVERAGE. ADD RECORD NAME IS DENTAL-CLAIM. ADD RECORD NAME IS DEPARTMENT. ADD RECORD NAME IS EMPLOYEE. ADD RECORD NAME IS EMPOSITION. ADD RECORD NAME IS EXPERTISE. ADD RECORD NAME IS HOSPITAL-CLAIM. ADD RECORD NAME IS INSURANCE-PLAN. ADD RECORD NAME IS JOB. ADD RECORD NAME IS NON-HOSP-CLAIM. ADD RECORD NAME IS OFFICE. ADD RECORD NAME IS SKILL. ADD RECORD NAME IS STRUCTURE. ADD SET COVERAGE-CLAIMS. ADD SET DEPT-EMPLOYEE. ADD SET EMP-COVERAGE. ADD SET EMP-EXPERTISE. ADD SET EMP-NAME-NDX. ADD SET EMP-EMPOSITION. ADD SET JOB-EMPOSITION. ADD SET JOB-TITLE-NDX. ADD SET MANAGES. ADD SET OFFICE-EMPLOYEE. ADD SET REPORTS-TO. ADD SET SKILL-EXPERTISE. ADD SET SKILL-NAME-NDX. GENERATE.
This Master File corresponds to the network subschema EMPSS01:
FILE=EMPFULL,SUFFIX=IDMSR ,$ SEGNAME=DEPT,$ FIELDNAME=DEPT_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$ FIELDNAME=DEPT_NAME ,ALIAS= ,USAGE=A45 ,ACTUAL=A45 ,$ FIELDNAME=DEPT_HEAD ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$ FIELDNAME=DEPT_DBKEY ,ALIAS=DBKEY ,USAGE=I10 ,ACTUAL=I4 ,$
SEGNAME=EMPLOYE,PARENT=DEPT,SEGTYPE=S,$
FIELDNAME=EMP_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
GROUP=EMP_NAME ,ALIAS= ,USAGE=A25 ,ACTUAL=A25 ,$
FIELDNAME=FIRST_NAME,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=LAST_NAME ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=EMP_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELDNAME=EMP_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=EMP_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=EMP_FULL_ZIP ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=EMP_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELDNAME=EMP_ZIP_L ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=EMP_PHONE ,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=STATUS ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
FIELDNAME=SOC_SEC_NUM ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=EMP_STRT_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELDNAME=EMP_TERM_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELDNAME=EMP_BRTH_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELDNAME=EMP_DBKEY ,ALIAS=DBKEY ,USAGE=I10 ,ACTUAL=I4 ,$SEGNAME=OFFICE,PARENT=EMPLOYE,SEGTYPE=U,$
FIELDNAME=OFF_CODE ,ALIAS= ,USAGE=A3 ,ACTUAL=A3 ,$
FIELDNAME=OFF_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELDNAME=OFF_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=OFF_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=OFF_FULL_ZIP ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=OFF_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELDNAME=OFF_ZIP_L ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=O_PHONES ,ALIAS= ,USAGE=A21 ,ACTUAL=A21 ,$
FIELDNAME=OFF_AREA_CDE,ALIAS= ,USAGE=A3 ,ACTUAL=A3 ,$
FIELDNAME=SPEED_DIAL ,ALIAS= ,USAGE=A3 ,ACTUAL=A3 ,$SEGNAME=PHONES,PARENT=OFFICE,SEGTYPE=S,OCCURS=3,POSITION=O_PHONES ,$ FIELDNAME=OFF_PHONE ,ALIAS= ,USAGE=A7 ,ACTUAL=A7 ,$ FIELDNAME=LINE_NO ,ALIAS=ORDER ,USAGE=I4 ,ACTUAL=I4 ,$
SEGNAME=STRUCTUR,PARENT=EMPLOYE,SEGTYPE=S,$ FIELDNAME=STRUCTURE_CD,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$ FIELDNAME=STRUCTURE_DT,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
SEGNAME=SUBORDS,PARENT=STRUCTUR,SEGTYPE=U,$
FIELDNAME=SUB_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
GROUP=SUB_NAME ,ALIAS= ,USAGE=A25 ,ACTUAL=A25 ,$
FIELDNAME=SUB_F_NAME,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=SUB_L_NAME,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=SUB_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELDNAME=SUB_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=SUB_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=SUB_FULL_ZIP ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=SUB_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELDNAME=SUB_ZIP_L ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=SUB_PHONE ,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=SUB_STATUS ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
FIELDNAME=SUB_SSN ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=SUB_STRT_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELDNAME=SUB_TERM_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELDNAME=SUB_BRTH_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$SEGNAME=EMPOSIT,PARENT=EMPLOYE,SEGTYPE=S,$ FIELDNAME=POS_STRT_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$ FIELDNAME=POS_FIN_DTE ,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$ FIELDNAME=SALARY_GRADE,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$ FIELDNAME=SALARY_AMT ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$ FIELDNAME=BONUS_PCT ,ALIAS= ,USAGE=P4 ,ACTUAL=P2 ,$ FIELDNAME=COMMIS_PCT ,ALIAS= ,USAGE=P4 ,ACTUAL=P2 ,$ FIELDNAME=OVERTIME_PCT,ALIAS= ,USAGE=P5.2 ,ACTUAL=P2 ,$
SEGNAME=JOB,PARENT=EMPOSIT,SEGTYPE=U,$
FIELDNAME=JOB_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=TITLE ,ALIAS= ,USAGE=A20 ,ACTUAL=A20,
FIELDTYPE=I,$
DEFINE SHORTTITLE/A10 = EDIT(JTIT,'9999999999$'); ,$
FIELDNAME=JOB_DESC ,ALIAS= ,USAGE=A120 ,ACTUAL=A120 ,$
FIELDNAME=REQUIREMENTS,ALIAS= ,USAGE=A120 ,ACTUAL=A120 ,$
FIELDNAME=MIN_SALARY ,ALIAS= ,USAGE=P12.2,ACTUAL=Z8 ,$
FIELDNAME=MAX_SALARY ,ALIAS= ,USAGE=P12.2,ACTUAL=Z8 ,$
FIELDNAME=SAL_GRADE_1 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$
FIELDNAME=SAL_GRADE_2 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$
FIELDNAME=SAL_GRADE_3 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$
FIELDNAME=SAL_GRADE_4 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$
FIELDNAME=POSITION_NUM,ALIAS= ,USAGE=P4 ,ACTUAL=Z3 ,$
FIELDNAME=NUM_OPEN ,ALIAS= ,USAGE=P4 ,ACTUAL=Z3 ,$SEGNAME=EXPERTSE,PARENT=EMPLOYE,SEGTYPE=S,$ FIELDNAME=SKILL_LEVEL ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$ FIELDNAME=EXPERT_DTE ,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
SEGNAME=SKILL,PARENT=EXPERTSE,SEGTYPE=U,$ FIELDNAME=SKILL_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$ FIELDNAME=SKILL_NAME ,ALIAS= ,USAGE=A12 ,ACTUAL=A12, FIELDTYPE=I,$ FIELDNAME=SKILL_DESC ,ALIAS= ,USAGE=A60 ,ACTUAL=A60 ,$
SEGNAME=COVERAGE,PARENT=EMPLOYE,SEGTYPE=S,$ FIELDNAME=COV_SEL_DT ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$ FIELDNAME=COV_TERM_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$ FIELDNAME=COVER_TYPE ,ALIAS= ,USAGE=A1 ,ACTUAL=A1 ,$ FIELDNAME=COV_CODE ,ALIAS= ,USAGE=A3 ,ACTUAL=A3 ,$
SEGNAME=HOSPITAL,PARENT=COVERAGE,SEGTYPE=S,$
FIELDNAME=H_CLAIM_DTE ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=H_FIRST_NAME,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=H_LAST_NAME ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=H_BIRTH_DTE ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=H_SEX ,ALIAS= ,USAGE=A1 ,ACTUAL=A1 ,$
FIELDNAME=H_RELATED_BY,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=HOSP_NAME ,ALIAS= ,USAGE=A25 ,ACTUAL=A25 ,$
FIELDNAME=HOSP_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELDNAME=HOSP_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=HOSP_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=HOSP_FUL_ZIP ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=HOSP_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELDNAME=HOSP_ZIP_L,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=ADMITTED ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=DISCHARGED ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=H_DIAGNOSIS1,ALIAS= ,USAGE=A60 ,ACTUAL=A60 ,$
FIELDNAME=H_DIAGNOSIS2,ALIAS= ,USAGE=A60 ,ACTUAL=A60 ,$
FIELDNAME=WARD_DAYS ,ALIAS= ,USAGE=P5 ,ACTUAL=P3 ,$
FIELDNAME=WARD_RATE ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELDNAME=WARD_TOTAL ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELDNAME=SEMI_DAYS ,ALIAS= ,USAGE=P5 ,ACTUAL=P3 ,$
FIELDNAME=SEMI_RATE ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELDNAME=SEMI_TOTAL ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELDNAME=DELIVERY_TOT,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELDNAME=ANESTHES_TOT,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELDNAME=LAB_TOT ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELDNAME= ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=CLAIM_MONTH ,ALIAS=CMO ,USAGE=I2 ,ACTUAL=Z2 ,$SEGNAME=NON_HOSP,SEGTYPE=S,PARENT=COVERAGE,$
FIELDNAME=N_CLAIM_DTE ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=N_FIRST_NAME,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=N_LAST_NAME ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=N_BIRTH_DTE ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=N_SEX ,ALIAS= ,USAGE=A1 ,ACTUAL=A1 ,$
FIELDNAME=N_RELATED_BY,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=PHYS_FNAME ,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=PHYS_LNAME ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=PHYS_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELDNAME=PHYS_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=PHYS_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=PHYS_FUL_ZIP ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=PHYS_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELDNAME=PHYS_ZIP_L,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=PHYS_ID ,ALIAS= ,USAGE=P6 ,ACTUAL=Z6 ,$
FIELDNAME=P_DIAGNOSIS1,ALIAS= ,USAGE=A60 ,ACTUAL=A60 ,$
FIELDNAME=P_DIAGNOSIS2,ALIAS= ,USAGE=A60 ,ACTUAL=A60 ,$
FIELDNAME=P_NO_OF_PROC,ALIAS= ,USAGE=I2 ,ACTUAL=I2 ,$
FIELDNAME= ,ALIAS= ,USAGE=A1 ,ACTUAL=A1 ,$SEGNAME=PHYSCHRG,SEGTYPE=S,PARENT=NON_HOSP,OCCURS=P_NO_OF_PROC ,$ FIELDNAME=P_SERVICE_DT,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$ FIELDNAME=PHYS_PROC_CD,ALIAS= ,USAGE=P4 ,ACTUAL=Z4 ,$ FIELDNAME=P_SERV_DESC ,ALIAS= ,USAGE=A60 ,ACTUAL=A60 ,$ FIELDNAME=PHYS_FEE ,ALIAS= ,USAGE=P11.2,ACTUAL=P5 ,$ FIELDNAME= ,ALIAS= ,USAGE=A1 ,ACTUAL=A1 ,$ FIELDNAME=PHYS_CHRG_NO,ALIAS=ORDER ,USAGE=I4 ,ACTUAL=I4 ,$
SEGNAME=DENTAL,SEGTYPE=S,PARENT=COVERAGE,$
FIELDNAME=D_CLAIM_DTE ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=D_FIRST_NAME,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=D_LAST_NAME ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=D_BIRTH_DTE ,ALIAS= ,USAGE=I6YMD,ACTUAL=Z6 ,$
FIELDNAME=D_SEX ,ALIAS= ,USAGE=A1 ,ACTUAL=A1 ,$
FIELDNAME=D_RELATED_BY,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=DENT_FNAME ,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=DENT_LNAME ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=DENT_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELDNAME=DENT_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=DENT_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=DENT_FUL_ZIP ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=DENT_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELDNAME=DENT_ZIP_L,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=DENT_LICENSE,ALIAS= ,USAGE=P6 ,ACTUAL=Z6 ,$
FIELDNAME=D_NO_OF_PROC,ALIAS= ,USAGE=I2 ,ACTUAL=I2 ,$
FIELDNAME= ,ALIAS= ,USAGE=A3 ,ACTUAL=A3 ,$SEGNAME=DENTCHRG,SEGTYPE=S,PARENT=DENTAL,OCCURS=D_NO_OF_PROC,$ FIELDNAME=TOOTH_NUM ,ALIAS= ,USAGE=P2 ,ACTUAL=Z2 ,$ FIELDNAME=D_SERVICE_DT,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$ FIELDNAME=DENT_PROC_CD,ALIAS= ,USAGE=P4 ,ACTUAL=Z4 ,$ FIELDNAME=D_SERV_DESC ,ALIAS= ,USAGE=A60 ,ACTUAL=A60 ,$ FIELDNAME=DENT_FEE ,ALIAS= ,USAGE=P11.2,ACTUAL=P5 ,$ FIELDNAME= ,ALIAS= ,USAGE=A3 ,ACTUAL=A3 ,$ FIELDNAME=DENT_CHRG_NO,ALIAS=ORDER ,USAGE=I9 ,ACTUAL=I4 ,$
SEGNAME=INSURNCE,PARENT=COVERAGE,SEGTYPE=U,$
FIELDNAME=INS_PLAN_CDE,ALIAS= ,USAGE=A3 ,ACTUAL=A3 ,$
FIELDNAME=INS_CO_NAME ,ALIAS= ,USAGE=A45 ,ACTUAL=A45 ,$
FIELDNAME=INS_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELDNAME=INS_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELDNAME=INS_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=INS_FULL_ZIP ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELDNAME=INS_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELDNAME=INS_ZIP_L ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELDNAME=INS_PHONE ,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELDNAME=INS_GROUP_NO,ALIAS= ,USAGE=A6 ,ACTUAL=A6 ,$
FIELDNAME=DEDUCT ,ALIAS= ,USAGE=P12.2,ACTUAL=P5 ,$
FIELDNAME=MAX_LIFE_CST,ALIAS= ,USAGE=P12.2,ACTUAL=P5 ,$
FIELDNAME=FAMILY_COST ,ALIAS= ,USAGE=P12.2,ACTUAL=P5 ,$
FIELDNAME=DEPENDNT_CST,ALIAS= ,USAGE=P12.2,ACTUAL=P5 ,$This Access File is associated with the network subschema EMPSS01 and corresponds to its Master File:
SSCHEMA=EMPSS01,RELEASE=15,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_CDE,CLCDUP=N,ACCESS=CLC,KEYFLD=COV_CODE,$
This subschema shows the LRF view of the schema EMPSCHM. It contains the following items:
ADD SUBSCHEMA NAME IS EMPSS02
OF SCHEMA NAME IS EMPSCHM VERSION 1
USAGE IS LR
DMCL NAME IS EMPDMCL
OF SCHEMA NAME IS EMPSCHM VERSION 1
COMMENTS 'THIS IS THE COMPLETE VIEW OF EMPSCHM'.
ADD AREA NAME IS EMP-DEMO-REGION.
ADD AREA NAME IS ORG-DEMO-REGION.
ADD RECORD NAME IS DEPARTMENT.
ADD RECORD NAME IS EMPLOYEE.
ADD RECORD NAME IS EMPOSITION.
ADD RECORD NAME IS JOB.
ADD SET DEPT-EMPLOYEE.
ADD SET EMP-NAME-NDX.
ADD SET EMP-EMPOSITION.
ADD SET JOB-EMPOSITION.
ADD SET JOB-TITLE-NDX.ADD
LOGICAL RECORD NAME IS DEPT-EMP-POS
ELEMENTS ARE DEPARTMENT
EMPLOYEE
EMPOSITION.ADD
PATH-GROUP NAME IS OBTAIN DEPT-EMP-POS
SELECT FOR FIELDNAME-EQ DEPT-ID-0410
OBTAIN DEPARTMENT
WHERE CALCKEY EQ DEPT-ID-0410 OF REQUEST
IF DEPT-EMPLOYEE IS NOT EMPTY
OBTAIN EACH EMPLOYEE WITHIN DEPT-EMPLOYEE
IF EMP-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN EMP-EMPOSITION SELECT FOR FIELDNAME-EQ EMP-ID-0415
OBTAIN EMPLOYEE
WHERE CALCKEY EQ EMP-ID-0415 OF REQUEST
IF DEPT-EMPLOYEE MEMBER
OBTAIN OWNER WITHIN DEPT-EMPLOYEE
IF EMP-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN EMP-EMPOSITION SELECT FOR ELEMENT DEPARTMENT
OBTAIN EACH DEPARTMENT WITHIN ORG-DEMO-REGION
IF DEPT-EMPLOYEE IS NOT EMPTY
OBTAIN EACH EMPLOYEE WITHIN DEPT-EMPLOYEE
IF EMP-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN EMP-EMPOSITION SELECT FOR ELEMENT EMPLOYEE
OBTAIN EACH EMPLOYEE WITHIN EMP-DEMO-REGION
IF DEPT-EMPLOYEE MEMBER
OBTAIN OWNER WITHIN DEPT-EMPLOYEE
IF EMP-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN EMP-EMPOSITION SELECT FOR ELEMENT EMPOSITION
OBTAIN EACH EMPOSITION WITHIN EMP-DEMO-REGION
OBTAIN OWNER WITHIN EMP-EMPOSITION
IF DEPT-EMPLOYEE MEMBER
OBTAIN OWNER WITHIN DEPT-EMPLOYEE SELECT
OBTAIN EACH DEPARTMENT WITHIN ORG-DEMO-REGION
IF DEPT-EMPLOYEE IS NOT EMPTY
OBTAIN EACH EMPLOYEE WITHIN DEPT-EMPLOYEE
IF EMP-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN EMP-EMPOSITION.ADD
LOGICAL RECORD NAME IS JOB-EMPOSITION
ELEMENTS ARE JOB
EMPOSITION.ADD
PATH-GROUP NAME IS OBTAIN JOB-EMPOSITION
SELECT FOR FIELDNAME-EQ JOB-ID-0440
OBTAIN JOB
WHERE CALCKEY EQ JOB-ID-0440 OF REQUEST
IF JOB-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN JOB-EMPOSITION SELECT USING INDEX JOB-TITLE-NDX
FOR FIELDNAME TITLE-0440
OBTAIN EACH JOB USING INDEX
IF JOB-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN JOB-EMPOSITION SELECT FOR FIELDNAME START-DATE-0420
OBTAIN EACH EMPOSITION WITHIN EMP-DEMO-REGION
IF JOB-EMPOSITION MEMBER
OBTAIN OWNER WITHIN JOB-EMPOSITION SELECT FOR ELEMENT JOB
OBTAIN EACH JOB WITHIN ORG-DEMO-REGION
IF JOB-EMPOSITION IS NOT EMPTY
OBTAIN EACH EMPOSITION WITHIN JOB-EMPOSITION SELECT FOR ELEMENT EMPOSITION
OBTAIN EACH EMPOSITION WITHIN EMP-DEMO-REGION
IF JOB-EMPOSITION MEMBER
OBTAIN OWNER WITHIN JOB-EMPOSITION SELECT
OBTAIN EACH JOB WITHIN ORG-DEMO-REGION
ON 0307 CLEAR RETURN LR-NOT-FOUND
ON 0000 NEXT
IF JOB-EMPOSITION IS NOT EMPTY
ON 0000 ITERATE
ON 1601 NEXT
OBTAIN EACH EMPOSITION WITHIN JOB-EMPOSITION
ON 0000 NEXT
ON 0307 ITERATE.
GENERATE.FILE=EMPDATA,SUFFIX=IDMSR,$
SEGNAME=DEPTEMPO,$
FIELD=DEPT_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELD=DEPT_NAME ,ALIAS= ,USAGE=A45 ,ACTUAL=A45 ,$
FIELD=DEPT_HEAD ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELD= ,ALIAS=FILL.END,USAGE=A3 ,ACTUAL=A3 ,$
FIELD=EMP_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
GROUP=EMP_NAME ,ALIAS= ,USAGE=A25 ,ACTUAL=A25 ,$
FIELD=FIRST_NAME,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELD=LAST_NAME ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELD=EMP_STREET ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$
FIELD=EMP_CITY ,ALIAS= ,USAGE=A15 ,ACTUAL=A15 ,$
FIELD=EMP_STATE ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
GROUP=EMP_FULL_ZIP,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELD=EMP_ZIP ,ALIAS= ,USAGE=A5 ,ACTUAL=A5 ,$
FIELD=EMP_ZIP_L ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$
FIELD=EMP_PHONE ,ALIAS= ,USAGE=A10 ,ACTUAL=A10 ,$
FIELD=STATUS ,ALIAS= ,USAGE=A2 ,ACTUAL=A2 ,$
FIELD=SOC_SEC_NUM ,ALIAS= ,USAGE=A9 ,ACTUAL=A9 ,$
FIELD=EMP_STRT_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELD=EMP_TERM_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELD=EMP_BRTH_DTE,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELD= ,ALIAS=FILL.END,USAGE=A6 ,ACTUAL=A6 ,$
FIELD=POS_STRT_DT1,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELD=POS_FIN_DT1 ,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$
FIELD=SALARY_GRAD1,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$
FIELD=SALARY_AMT1 ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$
FIELD=BONUS_PCT1 ,ALIAS= ,USAGE=P4 ,ACTUAL=P2 ,$
FIELD=COMMIS_PCT1 ,ALIAS= ,USAGE=P4 ,ACTUAL=P2 ,$
FIELD=OVERTIM_PCT1,ALIAS= ,USAGE=P5.2 ,ACTUAL=P2 ,$SEGNAME=JOBPOS,PARENT=DEPTEMPO,SEGTYPE=U,$ FIELD=JOB_ID ,ALIAS= ,USAGE=A4 ,ACTUAL=A4 ,$ FIELD=TITLE ,ALIAS= ,USAGE=A20 ,ACTUAL=A20 ,$ FIELD=JOB_DESC ,ALIAS= ,USAGE=A120 ,ACTUAL=A120 ,$ FIELD=REQUIREMENTS,ALIAS= ,USAGE=A120 ,ACTUAL=A120 ,$ FIELD=MIN_SALARY ,ALIAS= ,USAGE=P12.2,ACTUAL=Z8 ,$ FIELD=MAX_SALARY ,ALIAS= ,USAGE=P12.2,ACTUAL=Z8 ,$ FIELD=SAL_GRADE_1 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$ FIELD=SAL_GRADE_2 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$ FIELD=SAL_GRADE_3 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$ FIELD=SAL_GRADE_4 ,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$ FIELD=POSITION_NUM,ALIAS= ,USAGE=P4 ,ACTUAL=Z3 ,$ FIELD=NUM_OPEN ,ALIAS= ,USAGE=P4 ,ACTUAL=Z3 ,$ FIELD= ,ALIAS=FILL.END,USAGE=A2 ,ACTUAL=A2 ,$ FIELD=POS_STRT_DT2,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$ FIELD=POS_FIN_DT2 ,ALIAS= ,USAGE=A6YMD,ACTUAL=A6 ,$ FIELD=SALARY_GRAD2,ALIAS= ,USAGE=P4 ,ACTUAL=Z2 ,$ FIELD=SALARY_AMT2 ,ALIAS= ,USAGE=P10.2,ACTUAL=P5 ,$ FIELD=BONUS_PCT2 ,ALIAS= ,USAGE=P4 ,ACTUAL=P2 ,$ FIELD=COMMIS_PCT2 ,ALIAS= ,USAGE=P4 ,ACTUAL=P2 ,$ FIELD=OVERTIM_PCT2,ALIAS= ,USAGE=P5.2 ,ACTUAL=P2 ,$
This Access File is associated with LRF subschema EMPSS02, and corresponds to its Master File.
SSCHEMA=EMPSS02,RELEASE=15,MODE=LR,TRACE=PARMS,READY=ALL,$ SEGNAM=DEPTEMPO,RECORD=DEPT-EMP-POS,AREA=EMP-DEMO-REGION,LR=Y,$ SEGNAM=JOBPOS,RECORD=JOB-EMPOSITION,AREA=ORG-DEMO-REGION,LR=Y, ACCESS=LR,KEYFLD=POS_STRT_DT1,IXFLD=POS_STRT_DT2,$
The following is an example of a NULL SELECT clause that creates a partial record by returning a user-defined record code. The adapter does not support this user-defined code or any status code other than LR-FOUND or LR-NOT-FOUND.
SELECT
OBTAIN EACH JOB WITHIN ORG-DEMO-REGION
IF JOB-EMPOSITION IS NOT EMPTY
ON 0000 RETURN NO-POS-FOR-JOB
OBTAIN EACH EMPOSITION WITHIN JOB-EMPOSITION.The following is a section of a subschema that contains SPF indexes. Comparable Integrated Indexes are found in the LRF subschema EMPSS02 listed as EMP-NAME-NDX, JOB-TITLE-NDX, and SKILL-NAME-NDX.
ADD SET NAME IS IX-EMP-LNAME
ORDER IS SORTED
MODE IS CHAIN
OWNER IS IXOWNER
NEXT DBKEY POSITION IS AUTO
MEMBER IS EMPLOYEE
NEXT DBKEY POSITION IS AUTO
OPTIONAL MANUAL
ASCENDING KEY IS ( EMP-LAST-NAME-0415)
DUPLICATES LAST
.ADD SET NAME IS IX-TITLE
ORDER IS SORTED
MODE IS CHAIN
OWNER IS IXOWNER
NEXT DBKEY POSITION IS AUTO
MEMBER IS JOB
NEXT DBKEY POSITION IS AUTO
OPTIONAL MANUAL
DESCENDING KEY IS ( TITLE-0440 )
DUPLICATES NOT ALLOWED
.ADD SET NAME IS IX-SKILL-NAME
ORDER IS SORTED
MODE IS CHAIN
OWNER IS IXOWNER
NEXT DBKEY POSITION IS AUTO
MEMBER IS SKILL
NEXT DBKEY POSITION IS AUTO
OPTIONAL MANUAL
ASCENDING KEY IS ( SKILL-NAME-0455 )
DUPLICATES NOT ALLOWED
.| WebFOCUS | |
|
Feedback |