TMLEAVE FILE
REFERENCED BY
PR20.4 UK120 UK220 UK260 UK300 UK60.1
UK70.1 AC541 AC542 BN150 PR128 PR130
PR131 PR132 PR134 PR136 PR189 PR29.1
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR45.1
PR529 PR530 PR560 PR80.1 PR82.1 UK102
UK560 TA147 UK201 UK202
UPDATED BY
UK20.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLV-COMPANY Numeric 4 UK20.1
Element: Company The company number represents an
established company and is entered on
all function codes.
TLV-PLAN-NAME Alpha 10 UK120 UK20.1
Element: From Plan NameThis field contains the plan name.
TLV-DESCRIPTION Alpha 30 (Lower Case) UK120 UK20.1
Element: Description This field displays the description.
TLV-EFFECT-DATE Numeric 8 (yyyymmdd) UK20.1
Element: Date
TLV-END-DATE Numeric 8 (yyyymmdd) UK20.1
Element: Date The ending date in a range of dates.
TLV-GROUP-NAME Alpha 10 UK20.1
Element: Group Name
TLV-PROC-GROUP Alpha 10 UK20.1
Element: 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
Element: 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
Element: Ent Units
TLV-ENT-UNITS-TYPE Alpha 1 UK20.1
Element: Ent Units TypeH = Hours
D = Days
W = Weeks
M = Months
S = Semi-Months
TLV-ENT-PAY-CLASS Alpha 3 UK20.1
Element: Ent Pay Class
TLV-ATTEND-CLASS Alpha 10 UK20.1
Element: Attendance ClaA 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
Element: Rem Wait Days
TLV-REM-LIMIT-UNIT Numeric 5 UK20.1
Element: Rem Limit Unit
TLV-REM-LIMIT-TYPE Alpha 1 UK20.1
Element: Rem Limit TypeH = Hours
D = Days
W = Weeks
M = Months
Y = Years
TLV-REM-LMT-PD-UNT Numeric 5 UK20.1
Element: Rem Lmt Pd Unt
TLV-REM-LMT-PD-TYP Alpha 1 UK20.1
Element: Rem Lmt Pd TypH = Hours
D = Days
W = Weeks
M = Months
Y = Years
TLV-REM-LMT-PD-TIM Alpha 1 UK20.1
Element: Rem Lmt Pd TimC = Calendar
R = Rolling
TLV-REM-HOURS-PCD Alpha 4 UK20.1
Element: Rem Hours Pcd
TLV-REM-TYPE Alpha 1 UK20.1
Element: Rem Type H = Hours
D = Days
TLV-PLAN-IND Alpha 1
Element: Plan Ind 1 = SSP
2 = OSP
3 = SMP
4 = OMP
5 = HOL
6 = SPP
7 = SAP
8 = SPPA
TLV-PLAN-YR-ST-MM Numeric 2
Element: Plan Yr St Mm
TLV-PLAN-YR-ST-DD Numeric 2
Element: Plan Yr St Dd
TLV-PL-STRT-RULES Alpha 1
Element: Pl Strt Rules 1 = zero entlmt if abs spans yrend
2 = dont zero etlmt if spans yrend
X = User Exit
TLV-PLAN-ST-LIMIT Numeric 5
Element: Plan St Limit
TLV-PL-LIM-TYPE Alpha 1
Element: Pl Lim Type
TLV-DAY-RATE-S Alpha 1
Element: Day Rate S 1 = ANN SAL /260
2 = ANN SAL /260 *FTE
3 = ANN SAL /365
4 = ANN SAL /365 *FTE
5 = ANN SAL / ANN HOURS
6 = ANN SAL / ANN HOURS * FTE
X = USER DEFINED
TLV-DAY-RATE-H Alpha 1
Element: Day Rate H 1 = PAY RATE*DAY HRS FROM WPT
2 = PAY RATE*DAY HRS FROM WPT*FTE
3 = PAY RATE*ANN HOURS/260
4 = PAY RATE*ANN HOURS/260*FTE
5 = PAY RATE*ANN HOURS/365
6 = PAY RATE*ANN HOURS/365*FTE
X = USER DEFINED
TLV-RETIRE-MALE Numeric 2
Element: Retire Male
TLV-RETIRE-FEMALE Numeric 2
Element: Retire Female
TLV-EXCL-NQ-PCD Alpha 4
Element: Excl Nq Pcd
TLV-PAY-TYPE Alpha 1
Element: Pay Type L = LUMP SUM
W = WEEKLY
N = NORMAL PAY FREQUENCY
M = MONTHLY
2 = BI WEEKLY
4 = FOUR WEEKLY
TLV-PAYMENT-DAY Alpha 1
Element: Payment Day 1 = SUNDAY
2 = MONDAY
3 = TUESDAY
4 = WEDNESDAY
5 = THURSDAY
6 = FRIDAY
7 = SATURDAY
TLV-RECOVER-PCT Signed 7.2
Element: Recover Pct
TLV-MPP-START Numeric 5
Element: Mpp Start
TLV-MPP-END Numeric 5
Element: Mpp End
TLV-SMP-QW Numeric 5
Element: Smp Qw
TMLEAVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TLVSET1 COMPANY PR20.4 UK120
PLAN-NAME UK20.1 UK20.2
EFFECT-DATE UK220 UK260
UK300 UK60.1
UK70.1
TLVSET2 COMPANY KeyChange AC541 AC542
ATTEND-CLASS BN150 PR128
PLAN-NAME PR130 PR131
EFFECT-DATE PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
UK102 UK560
...
TLVSET3 COMPANY UK201 UK202
PLAN-IND
EFFECT-DATE
PLAN-NAME
TLVSET4 COMPANY Subset
PLAN-NAME Where (PLAN-IND = "3" )
EFFECT-DATE
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
Prsystem PRSYSTEM Required
TLV-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
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 Delete Cascades
TLV-COMPANY -> TEL-COMPANY
TLV-PLAN-NAME -> TEL-PLAN-NAME
TEL-EMPLOYEE
TEL-PL-ENTRY-DATE
Tmleavedtl TMLEAVEDTL Delete Cascades
TLV-COMPANY -> TLD-COMPANY
TLV-PLAN-NAME -> TLD-PLAN-NAME
TLD-REM-UNITS
|
