TMEMPLEAVE

UPDATED BY
UK34.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TEL-COMPANY
Element: Company Hr		Numeric 4
TEL-EMPLOYEE
Element: Employee		Numeric 9
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
Element: Plan Name		Alpha 10
This field contains the plan name.
TEL-PL-ENTRY-DATE
Element: Pl Entry Date		Numeric 8 (yyyymmdd)
TEL-PL-END-DATE
Element: Pl End Date		Numeric 8 (yyyymmdd)
TEL-PREV-ABS-DATE
Element: Prev Abs Date		Numeric 8 (yyyymmdd)
TEL-PREV-ABS-TIME
Element: Prev Abs Time		Signed 7.2
TEL-PREV-ABS-UNITS
Element: Prev Abs Units		Alpha 1
TEL-AVGE-EARNS
Element: Avge Earns		Signed 7.2
TEL-NEXT-CALC-DATE
Element: Next Calc Date		Numeric 8 (yyyymmdd)
UK34.1
TEL-ATTEND-CLASS
Element: Attend Class		Alpha 10
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
EMPLOYEE
PLAN-NAME
PL-ENTRY-DATE
UK34.1
TELSET2 COMPANY
PLAN-NAME
EMPLOYEE
PL-ENTRY-DATE
TELSET3 COMPANY
EMPLOYEE
ATTEND-CLASS
PLAN-NAME
PL-ENTRY-DATE
TELSET4 COMPANY
EMPLOYEE
NEXT-CALC-DATE
ATTEND-CLASS
PLAN-NAME
PL-ENTRY-DATE
KeyChange, Subset
WhereNEXT-CALC-DATE !=Zeroes


TMEMPLEAVE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:51:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.