Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAFORMULA


                             TAFORMULA FILE

                          Time Accrual Formula

Contains the formula used to calculate accrued hours. A formula can be
assigned to one or more plans.

REFERENCED BY

TA170     TA20.2    TA230

UPDATED BY

TA30.1    TA30.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TAF-COMPANY            Numeric 4                                 TA30.1  TA30.2
Element: Company Hr    Contains the number that represents an
                       established company.

TAF-CALC-NAME          Alpha 10                                  TA30.1  TA30.2
Element: Calc Name     Contains the formula calculation name.
                       This field is user-defined.

TAF-FRMLA-TYPE         Alpha 1                                   TA30.1  TA30.2
Element: Frmla Type    Contains the value that identifies the
                       formula type.
                       A = Flat amount
                       R = Ratio per hour

TAF-DESCRIPTION        Alpha 30  (Lower Case)                    TA30.1  TA30.2
Element: Description   Contains the formula description.

TAF-A-PAY-CLASS        Alpha 3                                   TA30.1
Element: A Pay Class   Contains the pay class that represents
                       the hours used in Flat amount formula
                       types. Validated in the Payclass file.

TAF-A-FRM-HRS          Numeric 5 Occurs 24 Times                 TA30.1
Element: A Frm Hrs     Contains the From hours.

TAF-A-TO-HRS           Numeric 5 Occurs 24 Times                 TA30.1
Element: A To Hrs      Contains the To hours.

TAF-A-FLAT-HRS         Signed 9.4 Occurs 24 Times                TA30.1
Element: A Flat Hrs    Contains the flat amount of hours that
                       accrue for hours worked, in the defined
                       pay class, between the defined From and
                       To hours for the cycle.

TAF-A-NUMER-PC         Alpha 3 Occurs 24 Times                   TA30.1
Element: A Numer Pc    Contains the pay class that represents
                       the hours used for the calculation
                       method of accrual.

TAF-A-UA-HRS           Numeric 5 Occurs 24 Times                 TA30.1
Element: A Ua Hrs      Contains the hours associated with the
                       plan's accrual cycle in TA20.2 (Accrual
                       Schedule).

TAF-A-UA-FACTOR        Signed 9.4 Occurs 24 Times                TA30.1
Element: A Ua Factor   Contains the calculation factor. This
                       rate is used to calculate the accrual
                       amount.

TAF-A-UA-HR-DESC       Alpha 30 Occurs 24 Times                  TA30.1
Element: A Ua Hr Desc  Contains the description of the hours
                       used in the calculation method of
                       accrual.

TAF-A-UA-FCT-DESC      Alpha 30 Occurs 24 Times                  TA30.1
Element: A Ua Fct Desc Contains the description of the factor
                       used in the calculation method of
                       accrual.

TAF-R-RATIO            Signed 11.4 Occurs 10 Times               TA30.2
Element: R Ratio       Contains the ratio by which hours
                       worked in the pay class are multiplied
                       to arrive at the accrued hours using the
                       Accrual Ratio Formula.

TAF-R-PAY-CLASS        Alpha 3 Occurs 10 Times                   TA30.2
Element: R Pay Class   Contains the pay class that represents
                       the hours multiplied by the ratio to
                       arrive at the accrued hours using the
                       Accrual Ratio Formula.

TAF-A-FRM-HRS-1        Derived
Element: A Frm Hrs 1

TAF-A-FRM-HRS-2        Derived
Element: A Frm Hrs 2

TAF-A-FRM-HRS-3        Derived
Element: A Frm Hrs 3

TAF-A-FRM-HRS-4        Derived
Element: A Frm Hrs 4

TAF-A-FRM-HRS-5        Derived
Element: A Frm Hrs 5

TAF-A-FRM-HRS-6        Derived
Element: A Frm Hrs 6

TAF-A-FRM-HRS-7        Derived
Element: A Frm Hrs 7

TAF-A-FRM-HRS-8        Derived
Element: A Frm Hrs 8

TAF-A-FRM-HRS-9        Derived
Element: A Frm Hrs 9

TAF-A-FRM-HRS-10       Derived
Element: A Frm Hrs 10

TAF-A-FRM-HRS-11       Derived
Element: A Frm Hrs 11

TAF-A-FRM-HRS-12       Derived
Element: A Frm Hrs 12

TAF-A-FRM-HRS-13       Derived
Element: A Frm Hrs 13

TAF-A-FRM-HRS-14       Derived
Element: A Frm Hrs 14

TAF-A-FRM-HRS-15       Derived
Element: A Frm Hrs 15

TAF-A-FRM-HRS-16       Derived
Element: A Frm Hrs 16

TAF-A-FRM-HRS-17       Derived
Element: A Frm Hrs 17

TAF-A-FRM-HRS-18       Derived
Element: A Frm Hrs 18

TAF-A-FRM-HRS-19       Derived
Element: A Frm Hrs 19

TAF-A-FRM-HRS-20       Derived
Element: A Frm Hrs 20

TAF-A-FRM-HRS-21       Derived
Element: A Frm Hrs 21

TAF-A-FRM-HRS-22       Derived
Element: A Frm Hrs 22

TAF-A-FRM-HRS-23       Derived
Element: A Frm Hrs 23

TAF-A-FRM-HRS-24       Derived
Element: A Frm Hrs 24

TAF-A-TO-HRS-1         Derived
Element: A To Hrs 1

TAF-A-TO-HRS-2         Derived
Element: A To Hrs 2

TAF-A-TO-HRS-3         Derived
Element: A To Hrs 3

TAF-A-TO-HRS-4         Derived
Element: A To Hrs 4

TAF-A-TO-HRS-5         Derived
Element: A To Hrs 5

TAF-A-TO-HRS-6         Derived
Element: A To Hrs 6

TAF-A-TO-HRS-7         Derived
Element: A To Hrs 7

TAF-A-TO-HRS-8         Derived
Element: A To Hrs 8

TAF-A-TO-HRS-9         Derived
Element: A To Hrs 9

TAF-A-TO-HRS-10        Derived
Element: A To Hrs 10

TAF-A-TO-HRS-11        Derived
Element: A To Hrs 11

TAF-A-TO-HRS-12        Derived
Element: A To Hrs 12

TAF-A-TO-HRS-13        Derived
Element: A To Hrs 13

TAF-A-TO-HRS-14        Derived
Element: A To Hrs 14

TAF-A-TO-HRS-15        Derived
Element: A To Hrs 15

TAF-A-TO-HRS-16        Derived
Element: A To Hrs 16

TAF-A-TO-HRS-17        Derived
Element: A To Hrs 17

TAF-A-TO-HRS-18        Derived
Element: A To Hrs 18

TAF-A-TO-HRS-19        Derived
Element: A To Hrs 19

TAF-A-TO-HRS-20        Derived
Element: A To Hrs 20

TAF-A-TO-HRS-21        Derived
Element: A To Hrs 21

TAF-A-TO-HRS-22        Derived
Element: A To Hrs 22

TAF-A-TO-HRS-23        Derived
Element: A To Hrs 23

TAF-A-TO-HRS-24        Derived
Element: A To Hrs 24

TAF-A-FLAT-HRS-1       Derived
Element: A Flat Hrs 1

TAF-A-FLAT-HRS-2       Derived
Element: A Flat Hrs 2

TAF-A-FLAT-HRS-3       Derived
Element: A Flat Hrs 3

TAF-A-FLAT-HRS-4       Derived
Element: A Flat Hrs 4

TAF-A-FLAT-HRS-5       Derived
Element: A Flat Hrs 5

TAF-A-FLAT-HRS-6       Derived
Element: A Flat Hrs 6

TAF-A-FLAT-HRS-7       Derived
Element: A Flat Hrs 7

TAF-A-FLAT-HRS-8       Derived
Element: A Flat Hrs 8

TAF-A-FLAT-HRS-9       Derived
Element: A Flat Hrs 9

TAF-A-FLAT-HRS-10      Derived
Element: A Flat Hrs 10

TAF-A-FLAT-HRS-11      Derived
Element: A Flat Hrs 11

TAF-A-FLAT-HRS-12      Derived
Element: A Flat Hrs 12

TAF-A-FLAT-HRS-13      Derived
Element: A Flat Hrs 13

TAF-A-FLAT-HRS-14      Derived
Element: A Flat Hrs 14

TAF-A-FLAT-HRS-15      Derived
Element: A Flat Hrs 15

TAF-A-FLAT-HRS-16      Derived
Element: A Flat Hrs 16

TAF-A-FLAT-HRS-17      Derived
Element: A Flat Hrs 17

TAF-A-FLAT-HRS-18      Derived
Element: A Flat Hrs 18

TAF-A-FLAT-HRS-19      Derived
Element: A Flat Hrs 19

TAF-A-FLAT-HRS-20      Derived
Element: A Flat Hrs 20

TAF-A-FLAT-HRS-21      Derived
Element: A Flat Hrs 21

TAF-A-FLAT-HRS-22      Derived
Element: A Flat Hrs 22

TAF-A-FLAT-HRS-23      Derived
Element: A Flat Hrs 23

TAF-A-FLAT-HRS-24      Derived
Element: A Flat Hrs 24

                         TAFORMULA FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TAFSET1   COMPANY                                                TA170   TA20.2
          CALC-NAME                                              TA230   TA30.1
                                                                 TA30.2

TAFSET2   COMPANY                                                TA230   TA30.1
          FRMLA-TYPE                                             TA30.2
          CALC-NAME

                         TAFORMULA FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amt Pay Class  PAYCLASS     Required
                            When TAF-FRMLA-TYPE = "A"

                            TAF-COMPANY        -> PCL-COMPANY
                            TAF-A-PAY-CLASS    -> PCL-PAY-CLASS

Company        PRSYSTEM     Required

                            TAF-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Numer Pay Cl   PAYCLASS     Required
                            When TAF-FRMLA-TYPE =  "A"
                            And  TAF-A-NUMER-PC != Spaces

                            TAF-COMPANY        -> PCL-COMPANY
                            TAF-A-NUMER-PC     -> PCL-PAY-CLASS

Ratio Pay Cl   PAYCLASS     Required
                            When TAF-FRMLA-TYPE  =  "R"
                            And  TAF-R-PAY-CLASS != Spaces

                            TAF-COMPANY        -> PCL-COMPANY
                            TAF-R-PAY-CLASS    -> PCL-PAY-CLASS

                         TAFORMULA FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Taeemaster     TAEEMASTER

                            TAF-COMPANY        -> TEM-COMPANY
                                                  TEM-EMPLOYEE
                                                  TEM-PLAN
                                                  TEM-EMPLOYEE-GROUP
                                                  TEM-POSITION