TMLEAVE

REFERENCED BY
PR20.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLV-COMPANY
Element: Company Hr
Numeric 4
TLV-PLAN-NAME
Element: Plan Name
Alpha 10
This field contains the plan name.
TLV-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
TLV-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
TLV-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
TLV-GROUP-NAME
Element: Group Name
Alpha 10
TLV-PROC-GROUP
Element: Proc Grp Hr
Alpha 10
TLV-ENT-FROM-DATE
Element: Ent From Date
Alpha 2

AJ = Adjusted Hire Date
AN = Anniversary Date
HI = Hire Date
SN = Seniority Date
X = Custom Calculation
TLV-ENT-UNITS
Element: Ent Units
Numeric 5
TLV-ENT-UNITS-TYPE
Element: Ent Units Type
Alpha 1

H = Hours
D = Days
W = Weeks
M = Months
S = Semi-Months
TLV-ENT-PAY-CLASS
Element: Ent Pay Class
Alpha 3
TLV-ATTEND-CLASS
Element: Attend Class
Alpha 10
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
Element: Rem Wait Days
Numeric 5
TLV-REM-LIMIT-UNIT
Element: Rem Limit Unit
Numeric 5
TLV-REM-LIMIT-TYPE
Element: Rem Limit Type
Alpha 1

H = Hours
D = Days
W = Weeks
M = Months
Y = Years
TLV-REM-LMT-PD-UNT
Element: Rem Lmt Pd Unt
Numeric 5
TLV-REM-LMT-PD-TYP
Element: Rem Lmt Pd Typ
Alpha 1

H = Hours
D = Days
W = Weeks
M = Months
Y = Years
TLV-REM-LMT-PD-TIM
Element: Rem Lmt Pd Tim
Alpha 1

C = Calendar
R = Rolling
TLV-REM-HOURS-PCD
Element: Rem Hours Pcd
Alpha 4
TLV-REM-TYPE
Element: Rem Type
Alpha 1

H = Hours
D = Days
TLV-PLAN-IND
Element: Plan Ind
Alpha 1

1 = SSP
2 = OSP
3 = SMP
4 = OMP
5 = HOL
6 = SPP
7 = SAP
8 = SPPA
TLV-PLAN-YR-ST-MM
Element: Plan Yr St Mm
Numeric 2
TLV-PLAN-YR-ST-DD
Element: Plan Yr St Dd
Numeric 2
TLV-PL-STRT-RULES
Element: Pl Strt Rules
Alpha 1

1 = zero entlmt if abs spans yrend
2 = dont zero etlmt if spans yrend
X = User Exit
TLV-PLAN-ST-LIMIT
Element: Plan St Limit
Numeric 5
TLV-PL-LIM-TYPE
Element: Pl Lim Type
Alpha 1
TLV-DAY-RATE-S
Element: Day Rate S
Alpha 1

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
Element: Day Rate H
Alpha 1

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
Element: Retire Male
Numeric 2
TLV-RETIRE-FEMALE
Element: Retire Female
Numeric 2
TLV-EXCL-NQ-PCD
Element: Excl Nq Pcd
Alpha 4
TLV-PAY-TYPE
Element: Pay Type
Alpha 1

L = LUMP SUM
W = WEEKLY
N = NORMAL PAY FREQUENCY
M = MONTHLY
2 = BI WEEKLY
4 = FOUR WEEKLY
TLV-PAYMENT-DAY
Element: Payment Day
Alpha 1

1 = SUNDAY
2 = MONDAY
3 = TUESDAY
4 = WEDNESDAY
5 = THURSDAY
6 = FRIDAY
7 = SATURDAY
TLV-RECOVER-PCT
Element: Recover Pct
Signed 7.2
TLV-MPP-START
Element: Mpp Start
Numeric 5
TLV-MPP-END
Element: Mpp End
Numeric 5
TLV-SMP-QW
Element: Smp Qw
Numeric 5


TMLEAVE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TLVSET1 COMPANY
PLAN-NAME
EFFECT-DATE
PR20.4
TLVSET2 COMPANY
ATTEND-CLASS
PLAN-NAME
EFFECT-DATE
KeyChange
TLVSET3 COMPANY
PLAN-IND
EFFECT-DATE
PLAN-NAME


TMLEAVE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Attend Class ATCLASS Required
TLV-COMPANY->ACL-COMPANY
TLV-ATTEND-CLASS->ACL-ATTEND-CLASS
  ACL-ATTEND-CODE
Tmleavedtl TMLEAVEDTL Delete Cascades
TLV-COMPANY->TLD-COMPANY
TLV-PLAN-NAME->TLD-PLAN-NAME
  TLD-REM-UNITS


File created: Thu Jun 09 02:33:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.