Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TALIMIT


                              TALIMIT FILE

Limit Rules define maximums for ongoing balance, annual accrual and carryover
amounts.  Limit Rules also define when accrual totals are reset, and if the
carryover amount is available for a limited period of time (carryover period).
 A plan structure must have an annual reset point or date to determine when
totals are reset, but maximums are optional.  The ongoing balance limit has an
additional option to check maximums by plan category (balance limit type).

REFERENCED BY

HR11.1    HR511     PA100     PA52.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TLM-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.

TLM-LIMIT-RULE         Alpha 10
Element: Ta Rule

TLM-DESCRIPTION        Alpha 30  (Lower Case)
Element: Ta DescriptionThis field displays the description.

TLM-RESET-DT-CD        Numeric 2
Element: Ta Date Code  01 = Hire Date
                       02 = Adjusted Hire Date
                       03 = Plan Entry Date
                       04 = Service Begin Date
                       05 = Accrual From Date
                       06 = Allotment Start Date
                       07 = Allotment Begin Date
                       08 = Eligibility Begin Date

TLM-RESET-POINT        Numeric 4  (mmdd)
Element: Ta Point

TLM-BAL-HRS-TBL        Alpha 10
Element: Ta Table

TLM-BAL-ERN-TBL        Alpha 10
Element: Ta Table

TLM-BAL-LIMIT-TYPE     Numeric 2
Element: Ta Type       01 = Plan
                       02 = Plan employee group
                       03 = Plan; emp grp; position
                       04 = Plan category

TLM-BAL-BYPASS-FLG     Numeric 1
Element: Bypass Flag   0 = No bypass
                       1 = Bypass hours limit
                       2 = Bypass earnings limit
                       3 = Bypass both limits

TLM-ACRLIM-HRS-TBL     Alpha 10
Element: Ta Table

TLM-ACRLIM-ERN-TBL     Alpha 10
Element: Ta Table

TLM-ACR-LIMIT-TYPE     Numeric 2
Element: Ta Type       01 = Plan
                       02 = Plan; employee group
                       03 = Plan; emp group; position
                       04 = Plan category

TLM-CARRY-HRS-TBL      Alpha 10
Element: Ta Table

TLM-CARRY-ERN-TBL      Alpha 10
Element: Ta Table

TLM-CARRY-PERIOD       Numeric 4
Element: Ta Period

TLM-CARRYOVER-UNIT     Numeric 2
Element: Ta Unit       02 = Days
                       03 = Weeks
                       04 = Semi months
                       05 = Months

TLM-RSV-HRS-TBL        Alpha 10
Element: Ta Table

TLM-RSV-ERN-TBL        Alpha 10
Element: Ta Table

TLM-PAYOUT-HRS-TBL     Alpha 10
Element: Ta Table

TLM-PAYOUT-ERN-TBL     Alpha 10
Element: Ta Table

TLM-DON-HRS-TBL        Alpha 10
Element: Ta Table

TLM-DON-ERN-TBL        Alpha 10
Element: Ta Table

TLM-PURCH-HRS-TBL      Alpha 10
Element: Ta Table

TLM-PURCH-ERN-TBL      Alpha 10
Element: Ta Table

TLM-GIFT-HRS-TBL       Alpha 10
Element: Ta Table

TLM-GIFT-ERN-TBL       Alpha 10
Element: Ta Table

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

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

TLM-USER-ID            Alpha 10  (Lower Case)
Element: User          Contains the user ID of the person who
                       last changed this record.

                         TALIMIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TLMSET1   COMPANY                                                HR11.1  HR511
          LIMIT-RULE                                             PA100   PA52.4

                         TALIMIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TLM-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL