TACALC – Absence Plan Rule Calculations

System
Absence Management (LP)
Prefix
TCA
Primary key
COMPANY, CALCULATION
Fields
30
Updated by
4 programs
Referenced by
22 programs

TACALC is the Absence Plan Rule Calculations table in Lawson Absence Management (prefix TCA). It is indexed by COMPANY, CALCULATION (TCASET1). It is related 1:1 to PRSYSTEM, TASERVCLSS and HRUSERFLDS and 1:M to TAPLAN. It is updated by HR00.1, HR01.1, LP07.1 and LP08.1 and referenced by HR04.4, HR04.5, HR04.6, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6 and 14 more. The table has 30 fields, 1 index and 6 documented relations.

About TACALC

No description in the Lawson data dictionary.

Fields (30)

Column = COBOL field name without the TCA- 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
#TCA-COMPANY PK
COMPANY		Numeric 4—LP07.1
#TCA-CALCULATION PK
CALCULATION		Alpha 10—LP07.1
#TCA-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—LP07.1
#TCA-CUSTOM-CALC
CUSTOM_CALC		Numeric 2—
  • 00 No
  • 01 Yes
LP07.1
#TCA-AMOUNT
AMOUNT		Signed 18.6—LP07.1
#TCA-MULT-FACTOR
MULT_FACTOR		Numeric 3—
  • 001 Standard hours per pay period
  • 002 FTE for position
  • 003 Total FTE
  • 004 FTE X Annual Hrs for position
  • 005 Total FTE X Annual Hours
LP07.1
#TCA-MULT-SRV-CLS
MULT_SRV_CLS		Alpha 3—LP07.1
#TCA-MULT-AMOUNT
MULT_AMOUNT		Signed 18.6—LP07.1
#TCA-MULT-USER-NBR
MULT_USER_NBR		Alpha 2—LP07.1
#TCA-DIV-FACTOR
DIV_FACTOR		Numeric 3—
  • 001 Standard hours per pay period
  • 002 FTE for position
  • 003 Total FTE
  • 004 FTE X Annual Hrs for position
  • 005 Total FTE X Annual Hours
LP07.1
#TCA-DIV-SRV-CLS
DIV_SRV_CLS		Alpha 3—LP07.1
#TCA-DIV-AMOUNT
DIV_AMOUNT		Signed 18.6—LP07.1
#TCA-DIV-USER-NBR
DIV_USER_NBR		Alpha 2—LP07.1
#TCA-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.LP07.1
#TCA-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.LP07.1
#TCA-USER-ID
USER_ID		Alpha 10 (Lower Case)—LP07.1
#TCA-MULT-USER-NAME
MULT_USER_NAME		Derived——
#TCA-DIV-USER-NAME
DIV_USER_NAME		Derived——
#TCA-M-SRV-CLS-NM
M_SRV_CLS_NM		Derived——
#TCA-D-SRV-CLS-NM
D_SRV_CLS_NM		Derived——
#TCA-USER-ALPHA-1
USER_ALPHA_1		Alpha 20 (Lower Case)—LP07.1
#TCA-USER-ALPHA-2
USER_ALPHA_2		Alpha 20 (Lower Case)—LP07.1
#TCA-USER-ALPHA-3
USER_ALPHA_3		Alpha 20 (Lower Case)—LP07.1
#TCA-USER-ALPHA-4
USER_ALPHA_4		Alpha 20 (Lower Case)—LP07.1
#TCA-USER-ALPHA-5
USER_ALPHA_5		Alpha 20 (Lower Case)—LP07.1
#TCA-USER-NUM-1
USER_NUM_1		Signed 18.6—LP07.1
#TCA-USER-NUM-2
USER_NUM_2		Signed 18.6—LP07.1
#TCA-USER-NUM-3
USER_NUM_3		Signed 18.6—LP07.1
#TCA-USER-NUM-4
USER_NUM_4		Signed 18.6—LP07.1
#TCA-USER-NUM-5
USER_NUM_5		Signed 18.6—LP07.1

Indexes (1)

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
TCASET1
  1. COMPANY
  2. CALCULATION
PrimaryHR00.1, HR01.1, HR04.4, HR04.5, HR04.6, LP04.2, LP04.3, LP04.4 +18 more

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TCA-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Div Srv ClsTASERVCLSSRequiredWhen (TCA-DIV-SRV-CLS != Spaces)
TCA-COMPANY→TSL-COMPANY
TCA-DIV-SRV-CLS→TSL-SERVICE-CLASS
Div User NbrHRUSERFLDSRequiredWhen (TCA-DIV-USER-NBR != Spaces)
TCA-DIV-USER-NBR→HRU-FIELD-KEY
Mult Srv ClsTASERVCLSSRequiredWhen (TCA-MULT-SRV-CLS != Spaces)
TCA-COMPANY→TSL-COMPANY
TCA-MULT-SRV-CLS→TSL-SERVICE-CLASS
Mult User NbrHRUSERFLDSRequiredWhen (TCA-MULT-USER-NBR != Spaces)
TCA-MULT-USER-NBR→HRU-FIELD-KEY

One to many (1) — child tables

RelationTableRulesConditionField map
Absence PlanTAPLANDelete Cascades
TCA-COMPANY→TAP-COMPANY
—→TAP-PLAN

Programs

Updated by (4)

Referenced by (22)