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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TFXSET1
  1. COMPANY
  2. FORMULA
  3. FROM-HOURS
  4. RATIO-SRV-CLS
  5. FORMULA-DATE
PrimaryHR00.1, HR01.1, LP06.2, LP06.3, LP06.4, LP06.5, LP07.1, LP08.1 +6 more
TFXSET2
  1. COMPANY
  2. FORMULA
  3. FROM-HOURS ↓
  4. RATIO-SRV-CLS
  5. FORMULA-DATE
LP140, LP145, LP198

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
TACALCPRSYSTEMTAFORMULASTASERVCLSSTAFORMULAX

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CalculationTACALCRequiredWhen (TFX-CALCULATION != Spaces)
TFX-COMPANY→TCA-COMPANY
TFX-CALCULATION→TCA-CALCULATION
CompanyPRSYSTEMRequired
TFX-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
FormulasTAFORMULASRequired
TFX-COMPANY→TFO-COMPANY
TFX-FORMULA→TFO-FORMULA
Mult Srv ClsTASERVCLSSRequiredWhen (TFX-MULT-SRV-CLS != Spaces)
TFX-COMPANY→TSL-COMPANY
TFX-MULT-SRV-CLS→TSL-SERVICE-CLASS
Ratio Srv ClsTASERVCLSSRequiredWhen (TFX-RATIO-SRV-CLS != Spaces)
TFX-COMPANY→TSL-COMPANY
TFX-RATIO-SRV-CLS→TSL-SERVICE-CLASS

Programs

Updated by (11)

Referenced by (3)