|
|
TMLEAVE FILE
REFERENCED BY
PR20.4 BN150 PR128 PR130 PR131 PR132
PR134 PR136 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 PR82.1 UK102 TA147 TP135 UK201
UK202
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLV-COMPANY Numeric 4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
TLV-PLAN-NAME Alpha 10
Element: From Plan NameThis 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: Effective Date
TLV-END-DATE Numeric 8 (yyyymmdd)
Element: Ending 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 Contains the processing group (head
process level).The processing group
identifies a group of process levels.
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: 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
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 PR128
ATTEND-CLASS PR130 PR131
PLAN-NAME PR132 PR134
EFFECT-DATE PR136 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
PR82.1 UK102
TA147 TP135
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
|
