TMLEAVE FILE
REFERENCED BY
PR20.4 UK120 UK220 UK260 UK60.1 UK70.1
UPDATED BY
UK20.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLV-COMPANY Numeric 4 UK20.1
Company The company number represents an
established company and is entered on
all function codes.
TLV-PLAN-NAME Alpha 10 UK120 UK20.1
From Plan Name This field contains the plan name.
TLV-DESCRIPTION Alpha 30 (Lower Case) UK120 UK20.1
Description This field displays the description.
TLV-EFFECT-DATE Numeric 8 (yyyymmdd) UK20.1
Effective Date
TLV-END-DATE Numeric 8 (yyyymmdd) UK20.1
Ending Date The ending date in a range of dates.
TLV-GROUP-NAME Alpha 10 UK20.1
Group Name
TLV-PROC-GROUP Alpha 10 UK20.1
Proc Group Contains the processing group (head
process level).The processing group
identifies a group of process levels.
TLV-ENT-FROM-DATE Alpha 2 UK20.1
Ent From Date AJ = Adjusted Hire Date
AN = Anniversary Date
HI = Hire Date
SN = Seniority Date
X = Custom Calculation
TLV-ENT-UNITS Numeric 5 UK20.1
Ent Units
TLV-ENT-UNITS-TYPE Alpha 1 UK20.1
Ent Units Type H = Hours
D = Days
W = Weeks
M = Months
S = Semi-Months
TLV-ENT-PAY-CLASS Alpha 3 UK20.1
Ent Pay Class
TLV-ATTEND-CLASS Alpha 10 UK20.1
Attendance Class A user-defined alphanumeric code that
represents a group of attendance codes
used for reporting and inquiring.
Validated in the ATCLASS file.
TLV-REM-WAIT-DAYS Numeric 5 UK20.1
Rem Wait Days
TLV-REM-LIMIT-UNIT Numeric 5 UK20.1
Rem Limit Unit
TLV-REM-LIMIT-TYPE Alpha 1 UK20.1
Rem Limit Type H = Paid Hours
D = Paid Days
TLV-REM-LMT-PD-UNT Numeric 5 UK20.1
Rem Lmt Pd Unt
TLV-REM-LMT-PD-TYP Alpha 1 UK20.1
Rem Lmt Pd Typ W = Weeks
M = Months
TLV-REM-LMT-PD-TIM Alpha 1 UK20.1
Rem Lmt Pd Tim C = Calendar
R = Rolling
TLV-REM-HOURS-PCD Alpha 4 UK20.1
Rem Hours Pcd
TLV-REM-TYPE Alpha 1 UK20.1
Rem Type H = Hours
D = Days
TMLEAVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TLVSET1 COMPANY PR20.4 UK120
PLAN-NAME UK20.1 UK20.2
UK220 UK260
UK60.1 UK70.1
TLVSET2 COMPANY KeyChange
GROUP-NAME
PROC-GROUP
PLAN-NAME
TMLEAVE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TLV-COMPANY -> PRS-COMPANY (PRSSET1)
Spaces -> PRS-PROCESS-LEVEL
Group Name PERSGROUP Required
TLV-COMPANY -> PRG-COMPANY
TLV-GROUP-NAME -> PRG-GROUP-NAME
Payclass PAYCLASS Required
TLV-COMPANY -> PCL-COMPANY
TLV-ENT-PAY-CLASS -> PCL-PAY-CLASS
Proc Group PRPROCGRP Required
TLV-COMPANY -> PRP-COMPANY
TLV-PROC-GROUP -> PRP-PROC-GROUP
Spaces -> PRP-PROCESS-LEVEL
Prpaycode PRPAYCODE Required
TLV-COMPANY -> PCD-COMPANY
TLV-REM-HOURS-PCD -> PCD-PAY-CODE
Spaces -> PCD-PROCESS-LEVEL
Spaces -> PCD-JOB-CODE
TMLEAVE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attend Class ATCLASS Required
TLV-COMPANY -> ACL-COMPANY
TLV-ATTEND-CLASS -> ACL-ATTEND-CLASS
ACL-ATTEND-CODE
Tmempleave TMEMPLEAVE
TLV-COMPANY -> TEL-COMPANY
TLV-PLAN-NAME -> TEL-PLAN-NAME
TEL-EMPLOYEE
Tmleavedtl TMLEAVEDTL Delete Cascades
TLV-COMPANY -> TLD-COMPANY
TLV-PLAN-NAME -> TLD-PLAN-NAME
TLD-REM-UNITS
|
