Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAELIGIBLE


                            TAELIGIBLE FILE

Eligibility Rules define when accruals and/or allotments become eligible for
use.

REFERENCED BY

HR04.4    HR04.5    HR04.6    LP02.1    LP08.1    LP140
LP201     LP203

UPDATED BY

LP03.3    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TEG-COMPANY            Numeric 4                                 LP03.3
Element: Company Hr

TEG-ELIGIBLE-RULE      Alpha 10                                  LP03.3
Element: Ta Rule

TEG-DESCRIPTION        Alpha 30  (Lower Case)                    LP03.3
Element: Ta Description

TEG-ELIG-DT-CD         Numeric 2                                 LP03.3
Element: Ta Date Code  01 = Hire Date
                       02 = Adjusted Hire Date
                       03 = Anniversary Date
                       04 = Seniority Date
                       05 = First Day Worked
                       06 = Birthdate
                       11 = Benefit Date 1
                       12 = Benefit Date 2
                       13 = Benefit Date 3
                       14 = Benefit Date 4
                       15 = Benefit Date 5
                       31 = Plan Entry Date
                       32 = Service Begin Date
                       33 = Accrual From Date
                       34 = Accrual Start Date
                       35 = Allotment Begin Date

TEG-ELIG-USER-DT       Alpha 2                                   LP03.3
Element: Ta User Key

TEG-WAIT-START         Numeric 2                                 LP03.3
Element: Ta Date Code  01 = Hire Date
                       02 = Adjusted Hire Date
                       03 = Plan Entry Date
                       04 = Service Begin Date
                       05 = Accrual From Date
                       06 = Accrual Start Date
                       07 = Allotment Begin Date
                       08 = Eligibility Requirement Date

TEG-WAIT-PERIOD        Numeric 5                                 LP03.3
Element: Ta Wait Per

TEG-WAIT-UNIT          Numeric 2                                 LP03.3
Element: Ta Unit       01 = Hours
                       02 = Days
                       03 = Weeks
                       04 = Semi months
                       05 = Months

TEG-WAIT-SRV-CLS       Alpha 3                                   LP03.3
Element: Ta Service Cls

TEG-HOURS-TYPE         Numeric 2                                 LP03.3
Element: Ta Type       Contains the units of measure for the
                       summarized totals.
                       01 = Plan
                       02 = Plan; employee group
                       03 = Plan; emp grp; position
                       04 = All hours

TEG-ELIG-DT-FLAG       Numeric 1                                 LP03.3
Element: Ta Date Flag  1 = Earliest date met
                       2 = Latest date met

TEG-NEAREST-POINT      Numeric 1                                 LP03.3
Element: Ta Point Code 1 = After requirements are met
                       2 = Before requirements are met

TEG-ELIG-POINT         Numeric 4  (mmdd) Occurs 13 Times         LP03.3
Element: Ta Point

TEG-PAY-CYCLE-ADJ      Numeric 1                                 LP03.3
Element: Ta Cycle Adj  0 = No
                       1 = Yes

TEG-ELIG-OCCUR         Numeric 2                                 LP03.3
Element: Ta Occur      01 = Weekly
                       02 = Biweekly
                       03 = Semimonthly
                       04 = Four weekly
                       05 = Monthly
                       06 = Bimonthy
                       07 = Quarterly
                       08 = Four monthly
                       09 = Semiannually
                       10 = Annually
                       99 = As accrued
                       00 = None

TEG-DATE-STAMP         Numeric 8  (yyyymmdd)                     LP03.3
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

TEG-TIME-STAMP         Numeric 6  (hhmmss)                       LP03.3
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

TEG-USER-ID            Alpha 10  (Lower Case)                    LP03.3
Element: User

                         TAELIGIBLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TEGSET1   COMPANY                                                HR00.1  HR01.1
          ELIGIBLE-RULE                                          HR04.4  HR04.5
                                                                 HR04.6  LP02.1
                                                                 LP03.3  LP08.1
                                                                 LP140   LP201
                                                                 LP203

                         TAELIGIBLE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TEG-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Elig User Dt   HRUSERFLDS   Required
                            When (TEG-ELIG-USER-DT != Spaces )

                            TEG-ELIG-USER-DT    -> HRU-FIELD-KEY

Wait Srv Cls   TASERVCLSS   Required
                            When (TEG-WAIT-SRV-CLS != Spaces )

                            TEG-COMPANY         -> TSL-COMPANY
                            TEG-WAIT-SRV-CLS    -> TSL-SERVICE-CLASS