TAFORMULAS – No description in the Lawson data dictionary
- System
- Absence Management (LP)
- Prefix
TFO- Primary key
COMPANY,FORMULA- Fields
- 9
- Updated by
- 7 programs
- Referenced by
- 14 programs
TAFORMULAS is a Lawson Absence Management table (prefix TFO); no description in the lawson data dictionary. It is indexed by COMPANY, FORMULA (TFOSET1); alternate indexes: TFOSET2, TFOSET3, TFOSET4 and TFOSET5. It is related 1:1 to PRSYSTEM and TASERVCLSS and 1:M to TAFORMULAX. It is updated by HR00.1, HR01.1, LP06.2, LP06.3, LP06.4, LP06.5 and LP08.1 and referenced by LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 and 6 more. The table has 9 fields, 5 indexes and 3 documented relations.
About TAFORMULAS
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the TFO- 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 |
|---|---|---|---|
#TFO-COMPANY PKCOMPANY | Numeric 4 | — | LP06.2, LP06.3, LP06.4, LP06.5 |
#TFO-FORMULA PKFORMULA | Alpha 10 | — | LP06.2, LP06.3, LP06.4, LP06.5 |
#TFO-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | LP06.2, LP06.3, LP06.4, LP06.5 |
#TFO-FORMULA-TYPE SET2 SET3 SET4 SET5FORMULA_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP06.2, LP06.3, LP06.4, LP06.5 |
#TFO-HOURS-SRV-CLSHOURS_SRV_CLS | Alpha 3 | — | LP06.2 |
#TFO-HOURS-SRV-TYPEHOURS_SRV_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP06.3 |
#TFO-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | This field contains the server date (month, date, and year) of the last change to this record. | LP06.2, LP06.3, LP06.4, LP06.5 |
#TFO-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | LP06.2, LP06.3, LP06.4, LP06.5 |
#TFO-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | LP06.2, LP06.3, LP06.4, LP06.5 |
Indexes (5)
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 |
|---|---|---|---|---|
TFOSET1 |
| Primary | HR00.1, HR01.1, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7 +13 more | |
TFOSET2 |
| Subset | Where (FORMULA-TYPE = 1) | LP06.2, LP206 |
TFOSET3 |
| Subset | Where (FORMULA-TYPE = 2) | LP06.3, LP206 |
TFOSET4 |
| Subset | Where (FORMULA-TYPE = 3) | LP06.4, LP206 |
TFOSET5 |
| Subset | Where (FORMULA-TYPE = 4) | LP06.5, LP206 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
| |||||||
| Hours Srv Cls | TASERVCLSS | Required | When (TFO-HOURS-SRV-CLS != Spaces) |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Formulax | TAFORMULAX | Delete Cascades |
|
Programs
Updated by (7)
- HR00.1 Company
- HR01.1 Process Level
- LP06.2 Cycle Amount Formula
- LP06.3 Hours Amount Formula
- LP06.4 Ratio Formula
- LP06.5 Date Formula
- LP08.1 Service Class
Referenced by (14)
- LP04.2 Cycle Based Accrual Table
- LP04.3 Cycle Based Allotment Table
- LP04.4 Cycle Based Limit Table
- LP04.5 Cycle Based GL Liability Table
- LP04.6 Hours Based Accrual Table
- LP04.7 Hours Based Allotment Table
- LP04.8 Hours Based Limit Table
- LP04.9 Hours Based GL Liability Table
- LP140 Employee Absence Plan Calculation
- LP145 Allotment Adjustment Calculation
- LP198 General Ledger Liability Update
- LP201 Absence Plan Listing
- LP203 Absence Plan Rules Listing
- LP206 Formula Listing