TMLEAVE

UPDATED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 PR128
PR130 PR131 PR132 PR134 PR135 PR136
PR137 PR189 PR20.4 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 UK102 UK201 UK202
UK560 ZP530 TA147

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
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR37.1
TLVSET3 COMPANY
PLAN-IND
EFFECT-DATE
PLAN-NAME
UK201 UK202


TMLEAVE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TLV-COMPANY->PRS-COMPANY
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
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


File created: Thu Jun 09 11:29:20 2016

Home
Contact Us



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