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 / column | Type | Description & values | Updated by |
|---|---|---|---|
WCH-COMPANY PKCOMPANY | Numeric 4 | — | PR18.1, PR18.2 |
WCH-WC-STATE PKWC_STATE | Alpha 2 | Contains the 2-digit code that identifies the state in which the workers' compensation plan is effective. | PR18.1, PR18.2 |
WCH-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | Contains the process level if the workers' compensation classification is specific to a process level. | PR18.1, PR18.2 |
WCH-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the effective date of the workers' compensation rate table. | PR18.1, PR18.2 |
WCH-WC-CODEWC_CODE | Alpha 10 | Contains the user-defined code that identifies the workers' compensation plan. | PR18.1 |
WCH-PREM-PER-WAGEPREM_PER_WAGE | Signed 11.3 | Contains the amount per wages on which the premium is based. | PR18.1, PR18.2 |
WCH-PREM-PER-HOURPREM_PER_HOUR | Signed 7.2 | Contains the amount per hour on which the premium is based. | PR18.1 |
WCH-STA-ANN-LIMITSTA_ANN_LIMIT | Signed 11.2 | Contains the state annual limit defined for the policy. | PR18.1, PR18.2 |
WCH-STA-MTH-LIMITSTA_MTH_LIMIT | Signed 11.2 | Contains the state monthly limit defined for the policy. The system checks the limit every calendar month. | PR18.1 |
WCH-INC-OVT-PREMINC_OVT_PREM | Alpha 1 | Contains the value that determines if the entire overtime pay amount or only the straight time portion of the pay is included in the calculation.
| PR18.1, PR18.2 |
WCH-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | — |
WCH-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
WCH-INDUSTRY-CODEINDUSTRY_CODE | Alpha 10 | This field will store the industry code for the province that is being reported. | PR18.2 |
WCH-IND-CODE-DESCIND_CODE_DESC | Alpha 30 (Lower Case) | Stores the description of the industry code (e.g logging, mining, etc.). | PR18.2 |
WCH-COUNTRY-CODE PKCOUNTRY_CODE | Alpha 2 | Defines which country the record is associated with. " " = USA
| PR18.1, PR18.2 |
WCH-E-MODE_MOD | Signed 7.4 | — | — |
WCH-CA-ACCT-NBRCA_ACCT_NBR | Alpha 15 | Defines 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-MODCLIENT_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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
WCHSET1 | COMPANY, COUNTRY-CODE, WC-STATE, PROCESS-LEVEL, EFFECT-DATE* | Primary | PR18.1, PR18.2, PR218, PR288, PR418 | |
WCHSET2 | COMPANY, COUNTRY-CODE, WC-CODE, CA-ACCT-NBR, EFFECT-DATE*, WC-STATE, PROCESS-LEVEL | KeyChange | PR17.1, PR278 | |
WCHSET3 | COMPANY, COUNTRY-CODE, EFFECT-DATE*, WC-STATE, PROCESS-LEVEL | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | WCH-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Policy Code | WCPOLICY | Required | WCH-COMPANY → WCP-COMPANY, WCH-WC-CODE → WCP-WC-CODE | |
| Process Level | PRSYSTEM | Required | When WCH-PROCESS-LEVEL != Spaces | WCH-COMPANY → PRS-COMPANY, WCH-PROCESS-LEVEL → PRS-PROCESS-LEVEL |
| Wc State | PRSTATE | Required | When WCH-WC-STATE != Spaces | WCH-WC-STATE → PSA-STATE |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Classes | WCCLASS | Delete Cascades | WCH-COMPANY → WCC-COMPANY, WCH-COUNTRY-CODE → WCC-COUNTRY-CODE, WCH-WC-STATE → WCC-WC-STATE, WCH-PROCESS-LEVEL → WCC-PROCESS-LEVEL, WCH-EFFECT-DATE → WCC-EFFECT-DATE, → WCC-WC-CLASS, → WCC-CA-WC-CLASS |
Programs
Updated by (2)
- PR18.1 United States Workers Compensation Classification
- PR18.2 Canada Workers Compensation Classification
Referenced by (13)
- BN66.1 Estimated Pay Calculation
- PR140 Earnings and Deductions Calculation
- PR17.1 Workers Compensation Policy
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR218 US Workers Compensation Classification Listing
- PR278 United States Workers Compensation Report
- PR288 Canada Workers Compensation Classification Listing
- PR418 Canada Workers Compensation Report
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test