CAVACMSTR – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
CAV
Primary key
COMPANY, PLAN-NAME, TAX-ID-CODE, BEG-EFF-DATE
Fields
14
Updated by
5 programs
Referenced by
1 program

CAVACMSTR is a Lawson Payroll table (prefix CAV); no description in the lawson data dictionary. It is indexed by COMPANY, PLAN-NAME, TAX-ID-CODE, BEG-EFF-DATE (CAVSET1); alternate indexes: CAVSET2. It is related 1:1 to PRSYSTEM, PLANMASTER and PRTAXAUTH and 1:M to EMTAMASTR and TAEEMASTER. It is updated by HR00.1, HR01.1, TA40.1, TA40.2 and TA40.3 and referenced by TA148. The table has 14 fields, 2 indexes and 5 documented relations.

About CAVACMSTR

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the CAV- 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
#CAV-COMPANY PK
COMPANY		Numeric 4—TA40.2, TA40.3
#CAV-PLAN-NAME PK
PLAN_NAME		Alpha 10This field contains the plan name.TA40.2, TA40.3
#CAV-TAX-ID-CODE PK
TAX_ID_CODE		Alpha 10—TA40.2, TA40.3
#CAV-BEG-EFF-DATE PK
BEG_EFF_DATE		Numeric 8 (yyyymmdd)—TA40.2, TA40.3
#CAV-END-EFF-DATE
END_EFF_DATE		Numeric 8 (yyyymmdd)—TA40.2, TA40.3
#CAV-VAC-PERCENT
VAC_PERCENT		Signed 5.2 Occurs 24 Times ×24—TA40.2, TA40.3
#CAV-PAY-CLASS
PAY_CLASS		Alpha 3 Occurs 24 Times ×24—TA40.2, TA40.3
#CAV-PAY-CODE
PAY_CODE		Alpha 4 Occurs 24 Times ×24Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.TA40.2, TA40.3
#CAV-VAC-ENTITLE-HR
VAC_ENTITLE_HR		Numeric 4 Occurs 24 Times ×24—TA40.2, TA40.3
#CAV-BEG-HRS-YRS
BEG_HRS_YRS		Numeric 7 Occurs 24 Times ×24—TA40.2, TA40.3
#CAV-END-HRS-YRS
END_HRS_YRS		Numeric 7 Occurs 24 Times ×24—TA40.2
#CAV-SERV-DT-USED
SERV_DT_USED		Numeric 2—
  • 00 n/a
  • 01 Hire Date
  • 02 Adj Hire Date
TA40.3
#CAV-BEG-HRS-TYPE
BEG_HRS_TYPE		Numeric 2 Occurs 24 Times ×24—
  • 00 n/a
  • 01 Year To Date =
  • 03 Life To Date =
TA40.2
#CAV-END-HRS-TYPE
END_HRS_TYPE		Numeric 2 Occurs 24 Times ×24—
  • 00 n/a
  • 01 Year To Date =
  • 03 Life To Date =
TA40.2

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
CAVSET1
  1. COMPANY
  2. PLAN-NAME
  3. TAX-ID-CODE
  4. BEG-EFF-DATE
PrimaryHR00.1, HR01.1, TA40.1, TA40.2, TA40.3
CAVSET2
  1. COMPANY
  2. PLAN-NAME
  3. TAX-ID-CODE
  4. BEG-EFF-DATE ↓
TA148, TA40.2, TA40.3

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
CAV-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
PlanPLANMASTERRequired
CAV-COMPANY→PLM-COMPANY
CAV-PLAN-NAME→PLM-PLAN-NAME
Tax AuthorityPRTAXAUTHRequired
CAV-TAX-ID-CODE→PRX-TAX-ID-CODE

One to many (2) — child tables

RelationTableRulesConditionField map
EeplanEMTAMASTR
CAV-COMPANY→ETM-COMPANY
CAV-PLAN-NAME→ETM-PLAN-NAME
—→ETM-EMPLOYEE
TaeemasterTAEEMASTER
CAV-COMPANY→TEM-COMPANY
—→TEM-EMPLOYEE
—→TEM-PLAN
—→TEM-EMPLOYEE-GROUP
—→TEM-POSITION

Programs

Updated by (5)

Referenced by (1)