Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TASTRUCTUR


                            TASTRUCTUR FILE

Plan Structure is used to assign a specific set of rules to each Accrual Plan
and Employee Group combination.  This allows different rules to be applied to
different employee goups within the same accrual plan.  The only rule that is
not required is the general ledger rule.

REFERENCED BY

BN15.1    HR11.1    HR511     PA100     PA52.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

TST-PLAN               Alpha 10
Element: Ta Plan

TST-EMPLOYEE-GROUP     Alpha 10
Element: Group Name

TST-BEGIN-DATE         Numeric 8  (yyyymmdd)
Element: Ta Begin Date The begin date for this effort period.

TST-END-DATE           Numeric 8  (yyyymmdd)
Element: Ta End Date   The end date for this effort period.

TST-ACCRUAL-OPTION     Numeric 1
Element: Ta Option     1 = hours accrual
                       2 = earnings accrual
                       3 = hours and earnings accruals

TST-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

TST-SERVICE-RULE       Alpha 10
Element: Ta Rule

TST-ACCRUAL-RULE       Alpha 10
Element: Ta Rule

TST-ELIGIBLE-RULE      Alpha 10
Element: Ta Rule

TST-LIMIT-RULE         Alpha 10
Element: Ta Rule

TST-PAYROLL-RULE       Alpha 10
Element: Ta Rule

TST-GL-RULE            Alpha 10
Element: Ta Rule

TST-ROUND-METH-HRS     Numeric 1
Element: Ta Method     0 = None
                       1 = Normal
                       2 = High
                       3 = Low

TST-ROUND-TO-HRS       Signed 18.6
Element: Ta Round To

TST-ROUND-METH-ERN     Numeric 1
Element: Ta Method     0 = None
                       1 = Normal
                       2 = High
                       3 = Low

TST-ROUND-TO-ERN       Signed 18.6
Element: Ta Round To

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

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

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

                         TASTRUCTUR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TSTSET1   COMPANY                                                BN15.1
          PLAN
          EMPLOYEE-GROUP
          BEGIN-DATE

TSTSET2   COMPANY                                                HR11.1  HR511
          EMPLOYEE-GROUP                                         PA100   PA52.4
          PLAN
          BEGIN-DATE*

                         TASTRUCTUR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TST-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Currency       CUCODES      Not Required

                            TST-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Employee Group PERSGROUP    Required

                            TST-COMPANY           -> PRG-COMPANY
                            TST-EMPLOYEE-GROUP    -> PRG-GROUP-NAME

Limit Rule     TALIMIT      Required

                            TST-COMPANY           -> TLM-COMPANY
                            TST-LIMIT-RULE        -> TLM-LIMIT-RULE

Plan           TAPLAN       Required

                            TST-COMPANY           -> TAP-COMPANY
                            TST-PLAN              -> TAP-PLAN