WCCLASSOVR – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
WCR
Primary key
COMPANY, COUNTRY-CODE, JOB-CODE, STATE-PROV
Fields
5
Updated by
1 program
Referenced by
46 programs

WCCLASSOVR is a Lawson Payroll table (prefix WCR); no description in the lawson data dictionary. It is indexed by COMPANY, COUNTRY-CODE, JOB-CODE, STATE-PROV (WCRSET1). It is related 1:1 to PRSYSTEM, INSTCTRYCD, JOBCODE and PRPROVINCE. It is updated by HR06.4 and referenced by BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 and 38 more. The table has 5 fields, 1 index and 4 documented relations.

About WCCLASSOVR

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
WCR-COMPANY PK
COMPANY		Numeric 4The company number represents an established company and is entered on all function codes.HR06.4
WCR-JOB-CODE PK
JOB_CODE		Alpha 9Contains the job code of the workers comp class that has multiple values by state/province.HR06.4
WCR-STATE-PROV PK
STATE_PROV		Alpha 2Contains the state/province for workers compensation purposes.HR06.4
WCR-ST-PROV-CLASS
ST_PROV_CLASS		Alpha 10 (Lower Case)Contains the state/province specific WC class used for reporting purposes.HR06.4
WCR-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2Defines which country the record is associated with.HR06.4

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WCRSET1COMPANY, COUNTRY-CODE, JOB-CODE, STATE-PROVPrimaryBN150, BN66.1, HR06.4, PR521, EXI2.1, EXI4.1, LP130, PR128 +22 more (list truncated in source)

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredWCR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (WCR-COUNTRY-CODE != Spaces)WCR-COUNTRY-CODE → INT-COUNTRY-CODE
JobcodeJOBCODERequiredWCR-COMPANY → JBC-COMPANY, WCR-JOB-CODE → JBC-JOB-CODE
State ProvPRPROVINCERequiredWCR-STATE-PROV → PPV-PROVINCE

Programs

Updated by (1)

Referenced by (46)