Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TMLEAVE


                              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