|
|
TMLEAVE FILE
UK Leave Plan
This file is a leave plan file that contains eligibility rules, attendance
associated to the plan, and remuneration rules and limits.
REFERENCED BY
PR20.4 UK120 UK220 UK260 UK300 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 contains the description.
TLV-EFFECT-DATE Numeric 8 (yyyymmdd) UK20.1
Effective Date Contains the date this plan is
effective. It is used to start employee
eligibility.
TLV-END-DATE Numeric 8 (yyyymmdd) UK20.1
Ending Date Containd the date this plan ends.
Employees can no longer be eligible for
this plan after this date.
TLV-GROUP-NAME Alpha 10 UK20.1
Group Name Contains the employee group that is
eligible for this plan.
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 Contains the date or starting point from
which other eligibility criteria can be
used to determine if an employee is
eligible for this plan.
AJ = Adjusted Hire Date
AN = Anniversary Date
HI = Hire Date
SN = Seniority Date
X = User Exit
TLV-ENT-UNITS Numeric 5 UK20.1
Ent Units Contains the number of units for
eligibility, length of service.
TLV-ENT-UNITS-TYPE Alpha 1 UK20.1
Ent Units Type Contains the type of units.
H = Hours
D = Days
W = Weeks
M = Months
S = Semi-Months
TLV-ENT-PAY-CLASS Alpha 3 UK20.1
Ent Pay Class Contains the pay class entered to select
specific types of hours to be used in
determining eligibilty.
TLV-ATTEND-CLASS Alpha 10 UK20.1
Attendance Class Contains the attendance class that
defines the range of attendance codes
used for qualifying absenses for this
plan.
TLV-REM-WAIT-DAYS Numeric 5 UK20.1
Rem Wait Days Contains the number of waiting days from
event before remuneration begins.
TLV-REM-LIMIT-UNIT Numeric 5 UK20.1
Rem Limit Unit Contains the number of units for limit.
TLV-REM-LIMIT-TYPE Alpha 1 UK20.1
Rem Limit Type Contains the type of units for the
limit.
H = Paid Hours
D = Paid Days
TLV-REM-LMT-PD-UNT Numeric 5 UK20.1
Rem Lmt Pd Unt Contains the number of units for the
limit period.
TLV-REM-LMT-PD-TYP Alpha 1 UK20.1
Rem Lmt Pd Typ Contains the type of units entered for
the limit period.
W = Weeks
M = Months
TLV-REM-LMT-PD-TIM Alpha 1 UK20.1
Rem Lmt Pd Tim Contains the frame for limit
period=months. Weeks are assumed to be
rolling.
C = Calendar
R = Rolling
TLV-REM-HOURS-PCD Alpha 4 UK20.1
Rem Hours Pcd Contains the pay code used for no pay
situations:
*Required to be hours only
*Employee did not meet waiting period
*Employee has not met eligibility yet
*Employee has met remuneration limits
TLV-REM-TYPE Alpha 1 UK20.1
Rem Type Contains the tyoe of units for leave
remuneration rates.
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
UK300 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
|