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.

Field / column	Type	Description & values	Updated by
`CAV-COMPANY` PK COMPANY	Numeric 4	—	TA40.2, TA40.3
`CAV-PLAN-NAME` PK PLAN_NAME	Alpha 10	This 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 ×24	Contains 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CAVSET1`	`COMPANY`, `PLAN-NAME`, `TAX-ID-CODE`, `BEG-EFF-DATE`	Primary		HR00.1, HR01.1, TA40.1, TA40.2, TA40.3
`CAVSET2`	`COMPANY`, `PLAN-NAME`, `TAX-ID-CODE`, `BEG-EFF-DATE*`			TA148, TA40.2, TA40.3

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`CAV-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Plan	PLANMASTER	Required	`CAV-COMPANY` → `PLM-COMPANY`, `CAV-PLAN-NAME` → `PLM-PLAN-NAME`
Tax Authority	PRTAXAUTH	Required	`CAV-TAX-ID-CODE` → `PRX-TAX-ID-CODE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Eeplan	EMTAMASTR			`CAV-COMPANY` → `ETM-COMPANY`, `CAV-PLAN-NAME` → `ETM-PLAN-NAME`, → `ETM-EMPLOYEE`
Taeemaster	TAEEMASTER			`CAV-COMPANY` → `TEM-COMPANY`, → `TEM-EMPLOYEE`, → `TEM-PLAN`, → `TEM-EMPLOYEE-GROUP`, → `TEM-POSITION`

Programs

Updated by (5)

HR00.1 Company
HR01.1 Process Level
TA40.1 Canada Vacation Plan Master
TA40.2 Canada Vacation Hours Schedule
TA40.3 Canada Vacation Date Schedule

Referenced by (1)

TA148 Canada Vacation Rollover