TMLEAVE FILE
REFERENCED BY
PR20.4 BN150 ET530 ETI2.1 LP130 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 PR35.9
PR36.1 PR45.1 PR529 PR530 PR560 PR80.1
PR82.1 UK102 UK560 TA147 UK201 UK202
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLV-COMPANY Numeric 4
Element: Company Hr
TLV-PLAN-NAME Alpha 10
Element: Plan Name This field contains the plan name.
TLV-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
TLV-EFFECT-DATE Numeric 8 (yyyymmdd)
Element: Effect Date
TLV-END-DATE Numeric 8 (yyyymmdd)
Element: End Date The end date for this effort period.
TLV-GROUP-NAME Alpha 10
Element: Group Name
TLV-PROC-GROUP Alpha 10
Element: Proc Grp Hr
TLV-ENT-FROM-DATE Alpha 2
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
Element: Ent Units
TLV-ENT-UNITS-TYPE Alpha 1
Element: Ent Units TypeH = Hours
D = Days
W = Weeks
M = Months
S = Semi-Months
TLV-ENT-PAY-CLASS Alpha 3
Element: Ent Pay Class
TLV-ATTEND-CLASS Alpha 10
Element: Attend 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
Element: Rem Wait Days
TLV-REM-LIMIT-UNIT Numeric 5
Element: Rem Limit Unit
TLV-REM-LIMIT-TYPE Alpha 1
Element: Rem Limit TypeH = Hours
D = Days
W = Weeks
M = Months
Y = Years
TLV-REM-LMT-PD-UNT Numeric 5
Element: Rem Lmt Pd Unt
TLV-REM-LMT-PD-TYP Alpha 1
Element: Rem Lmt Pd TypH = Hours
D = Days
W = Weeks
M = Months
Y = Years
TLV-REM-LMT-PD-TIM Alpha 1
Element: Rem Lmt Pd TimC = Calendar
R = Rolling
TLV-REM-HOURS-PCD Alpha 4
Element: Rem Hours Pcd
TLV-REM-TYPE Alpha 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
PLAN-NAME
EFFECT-DATE
TLVSET2 COMPANY KeyChange BN150 ET530
ATTEND-CLASS ETI2.1 LP130
PLAN-NAME PR128 PR130
EFFECT-DATE 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
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
...
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
|
