TMEMPLEAVE FILE
REFERENCED BY
UK220 UK20.1 UK20.2 UK260
UPDATED BY
UK120 UK60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TEL-COMPANY Numeric 4 UK120 UK60.1
Company The company number represents an
established company and is entered on
all function codes.
TEL-EMPLOYEE Numeric 9 UK120 UK60.1
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
TEL-PLAN-NAME Alpha 10 UK120 UK60.1
From Plan Name This field contains the plan name.
TEL-PL-ENTRY-DATE Numeric 8 (yyyymmdd) UK120 UK60.1
Plan Entry Date
TEL-PL-END-DATE Numeric 8 (yyyymmdd) UK120 UK60.1
Plan End Date
TMEMPLEAVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TELSET1 COMPANY UK120 UK220
EMPLOYEE UK60.1
PLAN-NAME
TELSET2 COMPANY UK20.1 UK20.2
PLAN-NAME UK260
EMPLOYEE
TMEMPLEAVE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TEL-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
TEL-COMPANY -> EMP-COMPANY
TEL-EMPLOYEE -> EMP-EMPLOYEE
Tmleave TMLEAVE Required
TEL-COMPANY -> TLV-COMPANY
TEL-PLAN-NAME -> TLV-PLAN-NAME
TMEMPLEAVE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Tmemplvdtl TMEMPLVDTL Delete Cascades
TEL-COMPANY -> TED-COMPANY
TEL-EMPLOYEE -> TED-EMPLOYEE
TED-TIME-SEQ
|
