TMEMPLVDTL FILE
UK Employee Leave Plan Detail
This is an employee leave plan file containing transactions of employee
attendance history.
REFERENCED BY
UK260
UPDATED BY
BN150 PR128 PR131 PR132 PR134 PR136
PR137 PR140 PR150 PR195 PR199 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1
PR37.1 PR45.1 PR530 PR80.1 PR82.1 PR85.1
UK102 UK330 UK120 UK300 UK60.1 UK70.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TED-COMPANY Numeric 4 UK120 UK60.1
Company The company number represents an
established company and is entered on
all function codes.
TED-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.
TED-PLAN-NAME Alpha 10 UK120 UK60.1
From Plan Name This field contains the plan name.
TED-TR-DATE Numeric 8 (yyyymmdd) UK120 UK60.1
Time Record Date Contains the time record date.
TED-TIME-SEQ Numeric 12 UK120 UK60.1
Sequence Number
TED-ATTEND-CODE Alpha 2 UK120 UK60.1
Attendance Code Contains the time record attendance UK70.1
code.
TED-PCD-SEQ-NBR Numeric 4 UK120 UK60.1
Pcd Seq Nbr Contains the pay code associated with UK70.1
attendance.
TED-HOURS Signed 7.2 UK120 UK60.1
Hours Contains the hours. UK70.1
TMEMPLVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TEDSET1 COMPANY BN150 PR128
EMPLOYEE PR131 PR132
TIME-SEQ PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
...
TEDSET2 COMPANY UK120 UK260
PLAN-NAME UK300 UK60.1
EMPLOYEE UK60.2
TR-DATE*
TIME-SEQ
TEDSET3 COMPANY UK120
EMPLOYEE
PLAN-NAME
TR-DATE
TIME-SEQ
TMEMPLVDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attend Code ATTENDCODE Required
TED-COMPANY -> ATC-COMPANY
TED-ATTEND-CODE -> ATC-ATTEND-CODE
Company PRSYSTEM Required
TED-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
TED-COMPANY -> EMP-COMPANY
TED-EMPLOYEE -> EMP-EMPLOYEE
Prpaycode PRPAYCODE Required
TED-COMPANY -> PCD-COMPANY
TED-PCD-SEQ-NBR -> PCD-SEQ-NBR
Tmempleave TMEMPLEAVE Required
TED-COMPANY -> TEL-COMPANY
TED-EMPLOYEE -> TEL-EMPLOYEE
TED-PLAN-NAME -> TEL-PLAN-NAME
Tmleave TMLEAVE Required
TED-COMPANY -> TLV-COMPANY
TED-PLAN-NAME -> TLV-PLAN-NAME
Tmtime TMTIME Required
TED-COMPANY -> TMT-COMPANY
TED-EMPLOYEE -> TMT-EMPLOYEE
TED-TIME-SEQ -> TMT-TIME-SEQ
|