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.

Field / column	Type	Description & values	Updated by
`TFO-COMPANY` PK COMPANY	Numeric 4	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFO-FORMULA` PK FORMULA	Alpha 10	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFO-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFO-FORMULA-TYPE` FORMULA_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Cycle Amount `02` Hours Amount `03` Ratio `04` Date	LP06.2, LP06.3, LP06.4, LP06.5
`TFO-HOURS-SRV-CLS` HOURS_SRV_CLS	Alpha 3	—	LP06.2
`TFO-HOURS-SRV-TYPE` HOURS_SRV_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Life to date (LTD) `02` Year to date (YTD) `03` Prior year total (PYT)	LP06.3
`TFO-DATE-STAMP` DATE_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-STAMP` TIME_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-ID` USER_ID	Alpha 10 (Lower Case)	—	LP06.2, LP06.3, LP06.4, LP06.5

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TFOSET1`	`COMPANY`, `FORMULA`	Primary		HR00.1, HR01.1, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7 +13 more
`TFOSET2`	`COMPANY`, `FORMULA-TYPE`, `FORMULA`	Subset	Where (FORMULA-TYPE = 1)	LP06.2, LP206
`TFOSET3`	`COMPANY`, `FORMULA-TYPE`, `FORMULA`	Subset	Where (FORMULA-TYPE = 2)	LP06.3, LP206
`TFOSET4`	`COMPANY`, `FORMULA-TYPE`, `FORMULA`	Subset	Where (FORMULA-TYPE = 3)	LP06.4, LP206
`TFOSET5`	`COMPANY`, `FORMULA-TYPE`, `FORMULA`	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		`TFO-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Hours Srv Cls	TASERVCLSS	Required	When (TFO-HOURS-SRV-CLS != Spaces)	`TFO-COMPANY` → `TSL-COMPANY`, `TFO-HOURS-SRV-CLS` → `TSL-SERVICE-CLASS`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Formulax	TAFORMULAX	Delete Cascades		`TFO-COMPANY` → `TFX-COMPANY`, `TFO-FORMULA` → `TFX-FORMULA`, → `TFX-FROM-HOURS`, → `TFX-RATIO-SRV-CLS`, → `TFX-FORMULA-DATE`

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