|
|
TMEMPLEAVE FILE
REFERENCED BY
UK220 UK20.1 UK20.2 UK260
UPDATED BY
UK34.1 UK120 UK60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TEL-COMPANY Numeric 4 UK120 UK60.1
Element: Company The company number represents an
established company and is entered on
all function codes.
TEL-EMPLOYEE Numeric 9 UK120 UK60.1
Element: 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
Element: From Plan NameThis field contains the plan name.
TEL-PL-ENTRY-DATE Numeric 8 (yyyymmdd) UK120 UK60.1
Element: Plan Entry Date
TEL-PL-END-DATE Numeric 8 (yyyymmdd) UK120 UK60.1
Element: Plan End Date
TEL-PREV-ABS-DATE Numeric 8 (yyyymmdd)
Element: Prev Abs Date
TEL-PREV-ABS-TIME Signed 7.2
Element: Prev Abs Time
TEL-PREV-ABS-UNITS Alpha 1
Element: Prev Abs Units
TEL-AVGE-EARNS Signed 7.2
Element: Avge Earns
TEL-NEXT-CALC-DATE Numeric 8 (yyyymmdd) UK34.1
Element: Next Calc Date
TEL-ATTEND-CLASS Alpha 10
Element: Attendance ClaA user-defined alphanumeric code that
represents a group of attendance codes
used for reporting and inquiring.
Validated in the ATCLASS file.
TMEMPLEAVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TELSET1 COMPANY UK34.1 UK120
EMPLOYEE UK220 UK60.1
PLAN-NAME
PL-ENTRY-DATE
TELSET2 COMPANY UK20.1 UK20.2
PLAN-NAME UK260
EMPLOYEE
PL-ENTRY-DATE
TELSET3 COMPANY
EMPLOYEE
ATTEND-CLASS
PLAN-NAME
PL-ENTRY-DATE
TELSET4 COMPANY KeyChange, Subset
EMPLOYEE Where NEXT-CALC-DATE != Zeroes
NEXT-CALC-DATE
ATTEND-CLASS
PLAN-NAME
PL-ENTRY-DATE
TMEMPLEAVE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TEL-COMPANY -> PRS-COMPANY (PRSSET1)
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
TEL-PL-ENTRY-DATE -> TLV-EFFECT-DATE
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
TEL-PLAN-NAME -> TED-PLAN-NAME
TED-TR-DATE
TED-ATTEND-CODE
|
