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.

Field / columnTypeDescription & valuesUpdated by
WCP-COMPANY PK
COMPANY
Numeric 4PR17.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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WCPSET1COMPANY, WC-CODEPrimaryBN66.1, PR140, PR17.1, PR18.1, PR189, PR195, PR218, PR278 +4 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredWCP-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (11)