TAFORMULA – Time Accrual Formula
- System
- Event Management (TA)
- Prefix
TAF- Primary key
COMPANY,CALC-NAME- Fields
- 87
- Updated by
- 2 programs
- Referenced by
- 2 programs
TAFORMULA is the Time Accrual Formula table in Lawson Event Management (prefix TAF). It is indexed by COMPANY, CALC-NAME (TAFSET1); alternate indexes: TAFSET2. It is related 1:1 to PAYCLASS and PRSYSTEM and 1:M to TAEEMASTER. It is updated by TA30.1 and TA30.2 and referenced by TA20.2 and TA230. The table has 87 fields, 2 indexes and 5 documented relations.
About TAFORMULA
Contains the formula used to calculate accrued hours. A formula can be assigned to one or more plans.
Fields (87)
Column = COBOL field name without the TAF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TAF-COMPANY PKCOMPANY | Numeric 4 | Contains the number that represents an established company. | TA30.1, TA30.2 |
#TAF-CALC-NAME PKCALC_NAME | Alpha 10 | Contains the formula calculation name. This field is user-defined. | TA30.1, TA30.2 |
#TAF-FRMLA-TYPE SET2FRMLA_TYPE | Alpha 1 | Contains the value that identifies the formula type.
| TA30.1, TA30.2 |
#TAF-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the formula description. | TA30.1, TA30.2 |
#TAF-A-PAY-CLASSA_PAY_CLASS | Alpha 3 | Contains the pay class that represents the hours used in Flat amount formula types. Validated in the Payclass file. | TA30.1 |
#TAF-A-FRM-HRSA_FRM_HRS | Numeric 5 Occurs 24 Times ×24 | Contains the From hours. | TA30.1 |
#TAF-A-TO-HRSA_TO_HRS | Numeric 5 Occurs 24 Times ×24 | Contains the To hours. | TA30.1 |
#TAF-A-FLAT-HRSA_FLAT_HRS | Signed 9.4 Occurs 24 Times ×24 | 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. | TA30.1 |
#TAF-A-NUMER-PCA_NUMER_PC | Alpha 3 Occurs 24 Times ×24 | Contains the pay class that represents the hours used for the calculation method of accrual. | TA30.1 |
#TAF-A-UA-HRSA_UA_HRS | Numeric 5 Occurs 24 Times ×24 | Contains the hours associated with the plan's accrual cycle in TA20.2 (Accrual Schedule). | TA30.1 |
#TAF-A-UA-FACTORA_UA_FACTOR | Signed 9.4 Occurs 24 Times ×24 | Contains the calculation factor. This rate is used to calculate the accrual amount. | TA30.1 |
#TAF-A-UA-HR-DESCA_UA_HR_DESC | Alpha 30 Occurs 24 Times ×24 | Contains the description of the hours used in the calculation method of accrual. | TA30.1 |
#TAF-A-UA-FCT-DESCA_UA_FCT_DESC | Alpha 30 Occurs 24 Times ×24 | Contains the description of the factor used in the calculation method of accrual. | TA30.1 |
#TAF-R-RATIOR_RATIO | Signed 11.4 Occurs 10 Times ×10 | Contains the ratio by which hours worked in the pay class are multiplied to arrive at the accrued hours using the Accrual Ratio Formula. | TA30.2 |
#TAF-R-PAY-CLASSR_PAY_CLASS | Alpha 3 Occurs 10 Times ×10 | Contains the pay class that represents the hours multiplied by the ratio to arrive at the accrued hours using the Accrual Ratio Formula. | TA30.2 |
#TAF-A-FRM-HRS-1A_FRM_HRS_1 | Derived | — | — |
#TAF-A-FRM-HRS-2A_FRM_HRS_2 | Derived | — | — |
#TAF-A-FRM-HRS-3A_FRM_HRS_3 | Derived | — | — |
#TAF-A-FRM-HRS-4A_FRM_HRS_4 | Derived | — | — |
#TAF-A-FRM-HRS-5A_FRM_HRS_5 | Derived | — | — |
#TAF-A-FRM-HRS-6A_FRM_HRS_6 | Derived | — | — |
#TAF-A-FRM-HRS-7A_FRM_HRS_7 | Derived | — | — |
#TAF-A-FRM-HRS-8A_FRM_HRS_8 | Derived | — | — |
#TAF-A-FRM-HRS-9A_FRM_HRS_9 | Derived | — | — |
#TAF-A-FRM-HRS-10A_FRM_HRS_10 | Derived | — | — |
#TAF-A-FRM-HRS-11A_FRM_HRS_11 | Derived | — | — |
#TAF-A-FRM-HRS-12A_FRM_HRS_12 | Derived | — | — |
#TAF-A-FRM-HRS-13A_FRM_HRS_13 | Derived | — | — |
#TAF-A-FRM-HRS-14A_FRM_HRS_14 | Derived | — | — |
#TAF-A-FRM-HRS-15A_FRM_HRS_15 | Derived | — | — |
#TAF-A-FRM-HRS-16A_FRM_HRS_16 | Derived | — | — |
#TAF-A-FRM-HRS-17A_FRM_HRS_17 | Derived | — | — |
#TAF-A-FRM-HRS-18A_FRM_HRS_18 | Derived | — | — |
#TAF-A-FRM-HRS-19A_FRM_HRS_19 | Derived | — | — |
#TAF-A-FRM-HRS-20A_FRM_HRS_20 | Derived | — | — |
#TAF-A-FRM-HRS-21A_FRM_HRS_21 | Derived | — | — |
#TAF-A-FRM-HRS-22A_FRM_HRS_22 | Derived | — | — |
#TAF-A-FRM-HRS-23A_FRM_HRS_23 | Derived | — | — |
#TAF-A-FRM-HRS-24A_FRM_HRS_24 | Derived | — | — |
#TAF-A-TO-HRS-1A_TO_HRS_1 | Derived | — | — |
#TAF-A-TO-HRS-2A_TO_HRS_2 | Derived | — | — |
#TAF-A-TO-HRS-3A_TO_HRS_3 | Derived | — | — |
#TAF-A-TO-HRS-4A_TO_HRS_4 | Derived | — | — |
#TAF-A-TO-HRS-5A_TO_HRS_5 | Derived | — | — |
#TAF-A-TO-HRS-6A_TO_HRS_6 | Derived | — | — |
#TAF-A-TO-HRS-7A_TO_HRS_7 | Derived | — | — |
#TAF-A-TO-HRS-8A_TO_HRS_8 | Derived | — | — |
#TAF-A-TO-HRS-9A_TO_HRS_9 | Derived | — | — |
#TAF-A-TO-HRS-10A_TO_HRS_10 | Derived | — | — |
#TAF-A-TO-HRS-11A_TO_HRS_11 | Derived | — | — |
#TAF-A-TO-HRS-12A_TO_HRS_12 | Derived | — | — |
#TAF-A-TO-HRS-13A_TO_HRS_13 | Derived | — | — |
#TAF-A-TO-HRS-14A_TO_HRS_14 | Derived | — | — |
#TAF-A-TO-HRS-15A_TO_HRS_15 | Derived | — | — |
#TAF-A-TO-HRS-16A_TO_HRS_16 | Derived | — | — |
#TAF-A-TO-HRS-17A_TO_HRS_17 | Derived | — | — |
#TAF-A-TO-HRS-18A_TO_HRS_18 | Derived | — | — |
#TAF-A-TO-HRS-19A_TO_HRS_19 | Derived | — | — |
#TAF-A-TO-HRS-20A_TO_HRS_20 | Derived | — | — |
#TAF-A-TO-HRS-21A_TO_HRS_21 | Derived | — | — |
#TAF-A-TO-HRS-22A_TO_HRS_22 | Derived | — | — |
#TAF-A-TO-HRS-23A_TO_HRS_23 | Derived | — | — |
#TAF-A-TO-HRS-24A_TO_HRS_24 | Derived | — | — |
#TAF-A-FLAT-HRS-1A_FLAT_HRS_1 | Derived | — | — |
#TAF-A-FLAT-HRS-2A_FLAT_HRS_2 | Derived | — | — |
#TAF-A-FLAT-HRS-3A_FLAT_HRS_3 | Derived | — | — |
#TAF-A-FLAT-HRS-4A_FLAT_HRS_4 | Derived | — | — |
#TAF-A-FLAT-HRS-5A_FLAT_HRS_5 | Derived | — | — |
#TAF-A-FLAT-HRS-6A_FLAT_HRS_6 | Derived | — | — |
#TAF-A-FLAT-HRS-7A_FLAT_HRS_7 | Derived | — | — |
#TAF-A-FLAT-HRS-8A_FLAT_HRS_8 | Derived | — | — |
#TAF-A-FLAT-HRS-9A_FLAT_HRS_9 | Derived | — | — |
#TAF-A-FLAT-HRS-10A_FLAT_HRS_10 | Derived | — | — |
#TAF-A-FLAT-HRS-11A_FLAT_HRS_11 | Derived | — | — |
#TAF-A-FLAT-HRS-12A_FLAT_HRS_12 | Derived | — | — |
#TAF-A-FLAT-HRS-13A_FLAT_HRS_13 | Derived | — | — |
#TAF-A-FLAT-HRS-14A_FLAT_HRS_14 | Derived | — | — |
#TAF-A-FLAT-HRS-15A_FLAT_HRS_15 | Derived | — | — |
#TAF-A-FLAT-HRS-16A_FLAT_HRS_16 | Derived | — | — |
#TAF-A-FLAT-HRS-17A_FLAT_HRS_17 | Derived | — | — |
#TAF-A-FLAT-HRS-18A_FLAT_HRS_18 | Derived | — | — |
#TAF-A-FLAT-HRS-19A_FLAT_HRS_19 | Derived | — | — |
#TAF-A-FLAT-HRS-20A_FLAT_HRS_20 | Derived | — | — |
#TAF-A-FLAT-HRS-21A_FLAT_HRS_21 | Derived | — | — |
#TAF-A-FLAT-HRS-22A_FLAT_HRS_22 | Derived | — | — |
#TAF-A-FLAT-HRS-23A_FLAT_HRS_23 | Derived | — | — |
#TAF-A-FLAT-HRS-24A_FLAT_HRS_24 | Derived | — | — |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TAFSET1 |
| Primary | TA20.2, TA230, TA30.1, TA30.2 | |
TAFSET2 |
| TA230, TA30.1, TA30.2 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Amt Pay Class | PAYCLASS | Required | When TAF-FRMLA-TYPE = "A" |
| ||||||
| Company | PRSYSTEM | Required |
| |||||||
| Numer Pay Cl | PAYCLASS | Required | When TAF-FRMLA-TYPE = "A" And TAF-A-NUMER-PC != Spaces |
| ||||||
| Ratio Pay Cl | PAYCLASS | Required | When TAF-FRMLA-TYPE = "R" And TAF-R-PAY-CLASS != Spaces |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Taeemaster | TAEEMASTER |
|