TAFORMULAX – No description in the Lawson data dictionary

System: Absence Management (LP)
Prefix: TFX
Primary key: COMPANY, FORMULA, FROM-HOURS, RATIO-SRV-CLS, FORMULA-DATE
Fields: 12
Updated by: 11 programs
Referenced by: 3 programs

TAFORMULAX is a Lawson Absence Management table (prefix TFX); no description in the lawson data dictionary. It is indexed by COMPANY, FORMULA, FROM-HOURS, RATIO-SRV-CLS, FORMULA-DATE (TFXSET1); alternate indexes: TFXSET2. It is related 1:1 to TACALC, PRSYSTEM, TAFORMULAS and TASERVCLSS. It is updated by HR00.1, HR01.1, LP06.2, LP06.3, LP06.4, LP06.5, LP07.1, LP08.1 and 3 more and referenced by LP201, LP203 and LP206. The table has 12 fields, 2 indexes and 5 documented relations.

About TAFORMULAX

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the TFX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TFX-COMPANY` PK COMPANY	Numeric 4	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFX-FORMULA` PK FORMULA	Alpha 10	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFX-FROM-HOURS` PK FROM_HOURS	Numeric 16	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFX-RATIO-SRV-CLS` PK RATIO_SRV_CLS	Alpha 3	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFX-FORMULA-DATE` PK FORMULA_DATE	Numeric 8 (yyyymmdd)	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFX-DATE-DESC` DATE_DESC	Alpha 30 (Lower Case)	—	LP06.5
`TFX-MULT-SRV-CLS` MULT_SRV_CLS	Alpha 3	—	LP06.2, LP06.3
`TFX-FORMULA-AMT` FORMULA_AMT	Signed 18.6	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFX-CALCULATION` CALCULATION	Alpha 10	—	LP06.2, LP06.3, LP06.4, LP06.5
`TFX-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
`TFX-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
`TFX-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP06.2, LP06.3, LP06.4, LP06.5

Indexes (2)

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
`TFXSET1`	`COMPANY`, `FORMULA`, `FROM-HOURS`, `RATIO-SRV-CLS`, `FORMULA-DATE`	Primary		HR00.1, HR01.1, LP06.2, LP06.3, LP06.4, LP06.5, LP07.1, LP08.1 +6 more
`TFXSET2`	`COMPANY`, `FORMULA`, `FROM-HOURS*`, `RATIO-SRV-CLS`, `FORMULA-DATE`			LP140, LP145, LP198

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Calculation	TACALC	Required	When (TFX-CALCULATION != Spaces)	`TFX-COMPANY` → `TCA-COMPANY`, `TFX-CALCULATION` → `TCA-CALCULATION`
Company	PRSYSTEM	Required		`TFX-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Formulas	TAFORMULAS	Required		`TFX-COMPANY` → `TFO-COMPANY`, `TFX-FORMULA` → `TFO-FORMULA`
Mult Srv Cls	TASERVCLSS	Required	When (TFX-MULT-SRV-CLS != Spaces)	`TFX-COMPANY` → `TSL-COMPANY`, `TFX-MULT-SRV-CLS` → `TSL-SERVICE-CLASS`
Ratio Srv Cls	TASERVCLSS	Required	When (TFX-RATIO-SRV-CLS != Spaces)	`TFX-COMPANY` → `TSL-COMPANY`, `TFX-RATIO-SRV-CLS` → `TSL-SERVICE-CLASS`

Programs

Updated by (11)

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
LP07.1 Calculation
LP08.1 Service Class
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP198 General Ledger Liability Update

Referenced by (3)

LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing
LP206 Formula Listing