WCCLASSHDR – Work Comp Class Header

System
Payroll (PR)
Prefix
WCH
Primary key
COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE
Fields
18
Updated by
2 programs
Referenced by
13 programs

WCCLASSHDR is the Work Comp Class Header table in Lawson Payroll (prefix WCH). It is indexed by COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE (WCHSET1); alternate indexes: WCHSET2 and WCHSET3. It is related 1:1 to PRSYSTEM, WCPOLICY and PRSTATE and 1:M to WCCLASS. It is updated by PR18.1 and PR18.2 and referenced by BN66.1, PR140, PR17.1, PR189, PR195, PR218, PR278, PR288 and 5 more. The table has 18 fields, 3 indexes and 5 documented relations.

About WCCLASSHDR

This file identifies workers' compensation classes. You can identify classes by company, work state, or process level. You can add multiple records for the same workers' compensation class by using different effective dates.

Fields (18)

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

Field / columnTypeDescription & valuesUpdated by
WCH-COMPANY PK
COMPANY
Numeric 4PR18.1, PR18.2
WCH-WC-STATE PK
WC_STATE
Alpha 2Contains the 2-digit code that identifies the state in which the workers' compensation plan is effective.PR18.1, PR18.2
WCH-PROCESS-LEVEL PK
PROCESS_LEVEL
Alpha 5Contains the process level if the workers' compensation classification is specific to a process level.PR18.1, PR18.2
WCH-EFFECT-DATE PK
EFFECT_DATE
Numeric 8 (yyyymmdd)Contains the effective date of the workers' compensation rate table.PR18.1, PR18.2
WCH-WC-CODE
WC_CODE
Alpha 10Contains the user-defined code that identifies the workers' compensation plan.PR18.1
WCH-PREM-PER-WAGE
PREM_PER_WAGE
Signed 11.3Contains the amount per wages on which the premium is based.PR18.1, PR18.2
WCH-PREM-PER-HOUR
PREM_PER_HOUR
Signed 7.2Contains the amount per hour on which the premium is based.PR18.1
WCH-STA-ANN-LIMIT
STA_ANN_LIMIT
Signed 11.2Contains the state annual limit defined for the policy.PR18.1, PR18.2
WCH-STA-MTH-LIMIT
STA_MTH_LIMIT
Signed 11.2Contains the state monthly limit defined for the policy. The system checks the limit every calendar month.PR18.1
WCH-INC-OVT-PREM
INC_OVT_PREM
Alpha 1Contains the value that determines if the entire overtime pay amount or only the straight time portion of the pay is included in the calculation.
  • Y Yes
  • N No
PR18.1, PR18.2
WCH-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).
WCH-CURR-ND
CURR_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.
WCH-INDUSTRY-CODE
INDUSTRY_CODE
Alpha 10This field will store the industry code for the province that is being reported.PR18.2
WCH-IND-CODE-DESC
IND_CODE_DESC
Alpha 30 (Lower Case)Stores the description of the industry code (e.g logging, mining, etc.).PR18.2
WCH-COUNTRY-CODE PK
COUNTRY_CODE
Alpha 2Defines which country the record is associated with. " " = USA
  • CA Canada
  • US USA
PR18.1, PR18.2
WCH-E-MOD
E_MOD
Signed 7.4
WCH-CA-ACCT-NBR
CA_ACCT_NBR
Alpha 15Defines the provincial assigned account number, firm number, registration number, Quebec enterprise number, legal entity, etc. for which this plan is being set up.PR18.2
WCH-CLIENT-E-MOD
CLIENT_E_MOD
Signed 7.4

Indexes (3)

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

IndexKeysFlagsConditionUsed in
WCHSET1COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE*PrimaryPR18.1, PR18.2, PR218, PR288, PR418
WCHSET2COMPANY, COUNTRY-CODE, WC-CODE, CA-ACCT-NBR, EFFECT-DATE*, WC-STATE, PROCESS-LEVELKeyChangePR17.1, PR278
WCHSET3COMPANY, COUNTRY-CODE, EFFECT-DATE*, WC-STATE, PROCESS-LEVELBN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredWCH-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
Policy CodeWCPOLICYRequiredWCH-COMPANYWCP-COMPANY, WCH-WC-CODEWCP-WC-CODE
Process LevelPRSYSTEMRequiredWhen WCH-PROCESS-LEVEL != SpacesWCH-COMPANYPRS-COMPANY, WCH-PROCESS-LEVELPRS-PROCESS-LEVEL
Wc StatePRSTATERequiredWhen WCH-WC-STATE != SpacesWCH-WC-STATEPSA-STATE

One to many (1) — child tables

RelationTableRulesConditionField map
ClassesWCCLASSDelete CascadesWCH-COMPANYWCC-COMPANY, WCH-COUNTRY-CODEWCC-COUNTRY-CODE, WCH-WC-STATEWCC-WC-STATE, WCH-PROCESS-LEVELWCC-PROCESS-LEVEL, WCH-EFFECT-DATEWCC-EFFECT-DATE, WCC-WC-CLASS, WCC-CA-WC-CLASS

Programs

Updated by (2)

Referenced by (13)