Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TACALC


                              TACALC FILE

REFERENCED BY

HR04.4    HR04.5    HR04.6    LP04.2    LP04.3    LP04.4
LP04.5    LP04.6    LP04.7    LP04.8    LP04.9    LP06.2
LP06.3    LP06.4    LP06.5    LP08.1    LP140     LP145
LP198     LP201     LP203     LP206     LP207

UPDATED BY

LP07.1    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TCA-COMPANY            Numeric 4                                 LP07.1
Element: Company Hr

TCA-CALCULATION        Alpha 10                                  LP07.1
Element: Ta Calculation

TCA-DESCRIPTION        Alpha 30  (Lower Case)                    LP07.1
Element: Ta Description

TCA-CUSTOM-CALC        Numeric 2                                 LP07.1
Element: Ta Custom Calc00 = No
                       01 = Yes

TCA-AMOUNT             Signed 18.6                               LP07.1
Element: Ta Amount

TCA-MULT-FACTOR        Numeric 3                                 LP07.1
Element: Ta Factor     001 = Standard hours per pay period
                       002 = FTE for position
                       003 = Total FTE
                       004 = FTE X Annual Hrs for position
                       005 = Total FTE X Annual Hours

TCA-MULT-SRV-CLS       Alpha 3                                   LP07.1
Element: Ta Service Cls

TCA-MULT-AMOUNT        Signed 18.6                               LP07.1
Element: Ta Amount

TCA-MULT-USER-NBR      Alpha 2                                   LP07.1
Element: Ta User Key

TCA-DIV-FACTOR         Numeric 3                                 LP07.1
Element: Ta Factor     001 = Standard hours per pay period
                       002 = FTE for position
                       003 = Total FTE
                       004 = FTE X Annual Hrs for position
                       005 = Total FTE X Annual Hours

TCA-DIV-SRV-CLS        Alpha 3                                   LP07.1
Element: Ta Service Cls

TCA-DIV-AMOUNT         Signed 18.6                               LP07.1
Element: Ta Amount

TCA-DIV-USER-NBR       Alpha 2                                   LP07.1
Element: Ta User Key

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

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

TCA-USER-ID            Alpha 10  (Lower Case)                    LP07.1
Element: User

TCA-MULT-USER-NAME     Derived
Element: Mult User Name

TCA-DIV-USER-NAME      Derived
Element: Div User Name

TCA-M-SRV-CLS-NM       Derived
Element: M Srv Cls Nm

TCA-D-SRV-CLS-NM       Derived
Element: D Srv Cls Nm

TCA-USER-ALPHA-1       Alpha 20  (Lower Case)                    LP07.1
Element: Ta User Alpha

TCA-USER-ALPHA-2       Alpha 20  (Lower Case)                    LP07.1
Element: Ta User Alpha

TCA-USER-ALPHA-3       Alpha 20  (Lower Case)                    LP07.1
Element: Ta User Alpha

TCA-USER-ALPHA-4       Alpha 20  (Lower Case)                    LP07.1
Element: Ta User Alpha

TCA-USER-ALPHA-5       Alpha 20  (Lower Case)                    LP07.1
Element: Ta User Alpha

TCA-USER-NUM-1         Signed 18.6                               LP07.1
Element: Ta Amount

TCA-USER-NUM-2         Signed 18.6                               LP07.1
Element: Ta Amount

TCA-USER-NUM-3         Signed 18.6                               LP07.1
Element: Ta Amount

TCA-USER-NUM-4         Signed 18.6                               LP07.1
Element: Ta Amount

TCA-USER-NUM-5         Signed 18.6                               LP07.1
Element: Ta Amount

                         TACALC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TCASET1   COMPANY                                                HR00.1  HR01.1
          CALCULATION                                            HR04.4  HR04.5
                                                                 HR04.6  LP04.2
                                                                 LP04.3  LP04.4
                                                                 LP04.5  LP04.6
                                                                 LP04.7  LP04.8
                                                                 LP04.9  LP06.2
                                                                 LP06.3  LP06.4
                                                                 LP06.5  LP07.1
                                                                 LP08.1  LP140
                                                                 LP145   LP198
                                                                 LP201   LP203
                                                                 LP206   LP207

                         TACALC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TCA-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Div Srv Cls    TASERVCLSS   Required
                            When (TCA-DIV-SRV-CLS != Spaces )

                            TCA-COMPANY          -> TSL-COMPANY
                            TCA-DIV-SRV-CLS      -> TSL-SERVICE-CLASS

Div User Nbr   HRUSERFLDS   Required
                            When (TCA-DIV-USER-NBR != Spaces )

                            TCA-DIV-USER-NBR     -> HRU-FIELD-KEY

Mult Srv Cls   TASERVCLSS   Required
                            When (TCA-MULT-SRV-CLS != Spaces )

                            TCA-COMPANY          -> TSL-COMPANY
                            TCA-MULT-SRV-CLS     -> TSL-SERVICE-CLASS

Mult User Nbr  HRUSERFLDS   Required
                            When (TCA-MULT-USER-NBR != Spaces )

                            TCA-MULT-USER-NBR    -> HRU-FIELD-KEY

                         TACALC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Absence Plan   TAPLAN       Delete Cascades

                            TCA-COMPANY          -> TAP-COMPANY
                                                    TAP-PLAN