|
|
TMEMPLEAVE FILE
UPDATED BY
UK34.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TEL-COMPANY Numeric 4
Element: Company Hr
TEL-EMPLOYEE Numeric 9
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
Element: Plan Name This field contains the plan name.
TEL-PL-ENTRY-DATE Numeric 8 (yyyymmdd)
Element: Pl Entry Date
TEL-PL-END-DATE Numeric 8 (yyyymmdd)
Element: Pl 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: Attend Class A 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
EMPLOYEE
PLAN-NAME
PL-ENTRY-DATE
TELSET2 COMPANY
PLAN-NAME
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
|
