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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WCCSET1COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE, WC-CLASS, CA-WC-CLASSPrimaryBN66.1, PR140, PR18.1, PR18.2, PR189, PR195, PR218, PR278 +6 more
WCCSET2COMPANY, WC-CLASS, CA-WC-CLASS, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE*KeyChangeHR06.1, HR06.4, HR506, HWCA.1, HWCC.1, LT101, LT111

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
Class HeaderWCCLASSHDRRequiredWCC-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
CompanyPRSYSTEMRequiredWCC-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Policy CodeWCPOLICYRequiredWCC-COMPANY → WCP-COMPANY, WCH-WC-CODE → WCP-WC-CODE
Process LevelPRSYSTEMRequiredWhen WCC-PROCESS-LEVEL != SpacesWCC-COMPANY → PRS-COMPANY, WCC-PROCESS-LEVEL → PRS-PROCESS-LEVEL
Wc StatePRSTATERequiredWhen WCC-WC-STATE != SpacesWCC-WC-STATE → PSA-STATE

Programs

Updated by (2)

Referenced by (19)