WCPOLICY – Workers Compensation Policy

System
Payroll (PR)
Prefix
WCP
Primary key
COMPANY, WC-CODE
Fields
8
Updated by
1 program
Referenced by
11 programs

WCPOLICY is the Workers Compensation Policy table in Lawson Payroll (prefix WCP). It is indexed by COMPANY, WC-CODE (WCPSET1). It is related 1:1 to PRSYSTEM. It is updated by PR17.1 and referenced by BN66.1, PR140, PR18.1, PR189, PR195, PR218, PR278, PR80.1 and 3 more. The table has 8 fields, 1 index and 1 documented relation.

About WCPOLICY

The workers' compensation policy file contains information about the policy.

Fields (8)

Column = COBOL field name without the WCP- 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
#WCP-COMPANY PK
COMPANY
Numeric 4—PR17.1
#WCP-WC-CODE PK
WC_CODE
Alpha 10Contains the user-defined workers' compensation policy code.PR17.1
#WCP-DESC
DESC
Alpha 30 (Lower Case)Contains the workers' compensation policy code description.PR17.1
#WCP-BEG-DATE
BEG_DATE
Numeric 8 (yyyymmdd)Contains the effective date of the policy.BN66.1, PR140, PR17.1, PR189, PR195, PR80.1, PR80.4, PR89.1 +1 more
#WCP-END-DATE
END_DATE
Numeric 8 (yyyymmdd)Contains the last date the policy is in effect.PR17.1
#WCP-POLICY-NBR
POLICY_NBR
Alpha 20Contains the policy number.PR17.1
#WCP-INSURANCE-CPY
INSURANCE_CPY
Alpha 30Contains the name of the insurance company who underwrites the workers' compensation policy.PR17.1
#WCP-CONTACT-DESC
CONTACT_DESC
Alpha 30Contains the name of the contact person with the insurance company.PR17.1

Indexes (1)

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
WCPSET1
  1. COMPANY
  2. WC-CODE
PrimaryBN66.1, PR140, PR17.1, PR18.1, PR189, PR195, PR218, PR278 +4 more

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
WCP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (11)