WCCLASS – Work Comp Class Detail

System
Payroll (PR)
Prefix
WCC
Primary key
COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE, WC-CLASS, CA-WC-CLASS
Fields
14
Updated by
2 programs
Referenced by
19 programs

WCCLASS is the Work Comp Class Detail table in Lawson Payroll (prefix WCC). It is indexed by COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE, WC-CLASS, CA-WC-CLASS (WCCSET1); alternate indexes: WCCSET2. It is related 1:1 to WCCLASSHDR, PRSYSTEM, WCPOLICY and PRSTATE. It is updated by PR18.1 and PR18.2 and referenced by BN66.1, HR06.1, HR06.4, HR506, HWCA.1, HWCC.1, LT101, LT111 and 11 more. The table has 14 fields, 2 indexes and 5 documented relations.

About WCCLASS

Contains the detail information of workers' compensation plans and stores the experience rates and limits by effective date.

Fields (14)

Column = COBOL field name without the WCC- 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
#WCC-COMPANY PK
COMPANY		Numeric 4—PR18.1, PR18.2
#WCC-WC-STATE PK
WC_STATE		Alpha 2Contains the 2-digit code that identifies the state in which the worker's compensation plan is effective.PR18.1, PR18.2
#WCC-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
#WCC-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date the rates in the table become effective.PR18.1, PR18.2
#WCC-WC-CLASS PK
WC_CLASS		Alpha 4Contains the workers' compensation class.PR18.1
#WCC-CA-WC-CLASS PK
CA_WC_CLASS		Alpha 10Contains the Canadian Workers Compensation classification to be used on the job code.PR18.2
#WCC-DESC
DESC		Alpha 30 (Lower Case)Contains the workers' compensation classification description.PR18.1, PR18.2
#WCC-EXP-RATE
EXP_RATE		Signed 7.4Contains the experience rate. The value in this field represents an amount if you enter a value in either the Premium Per Wages or Premium Per Hours field in PR18.1 (Workers' Compensation Classification). If you do not enter a value in either of those fields, the value represents a percent.PR18.1, PR18.2
#WCC-WAGE-LIMIT
WAGE_LIMIT		Signed 11.2Contains the wage limit amount if defined.PR18.1, PR18.2
#WCC-LIMIT-IND
LIMIT_IND		Alpha 2Contains the value that indicates if the wage limit amount defined is a monthly or annual limit.
  • MO Monthly
  • AN Annual
PR18.1
#WCC-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#WCC-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—
#WCC-E-MOD
E_MOD		Signed 7.4——
#WCC-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2Defines which country the record is associated with.PR18.1, PR18.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
WCCSET1
  1. COMPANY
  2. COUNTRY-CODE
  3. WC-STATE
  4. PROCESS-LEVEL
  5. EFFECT-DATE
  6. WC-CLASS
  7. CA-WC-CLASS
PrimaryBN66.1, PR140, PR18.1, PR18.2, PR189, PR195, PR218, PR278 +6 more
WCCSET2
  1. COMPANY
  2. WC-CLASS
  3. CA-WC-CLASS
  4. COUNTRY-CODE
  5. WC-STATE
  6. PROCESS-LEVEL
  7. EFFECT-DATE ↓
KeyChangeHR06.1, HR06.4, HR506, HWCA.1, HWCC.1, LT101, LT111

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
Class HeaderWCCLASSHDRRequired
WCC-COMPANY→WCH-COMPANY
WCC-COUNTRY-CODE→WCH-COUNTRY-CODE
WCC-WC-STATE→WCH-WC-STATE
WCC-PROCESS-LEVEL→WCH-PROCESS-LEVEL
WCC-EFFECT-DATE→WCH-EFFECT-DATE
CompanyPRSYSTEMRequired
WCC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Policy CodeWCPOLICYRequired
WCC-COMPANY→WCP-COMPANY
WCH-WC-CODE→WCP-WC-CODE
Process LevelPRSYSTEMRequiredWhen WCC-PROCESS-LEVEL != Spaces
WCC-COMPANY→PRS-COMPANY
WCC-PROCESS-LEVEL→PRS-PROCESS-LEVEL
Wc StatePRSTATERequiredWhen WCC-WC-STATE != Spaces
WCC-WC-STATE→PSA-STATE

Programs

Updated by (2)

Referenced by (19)