WCCLASSOVR FILE
REFERENCED BY
PR418 PRWC.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCR-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
WCR-JOB-CODE Alpha 9
Job Code Contains the job code of the workers
comp class that has multiple values by
state/province.
WCR-STATE-PROV Alpha 2
State or Province Contains the state/province for workers
compensation purposes.
WCR-ST-PROV-CLASS Alpha 10 (Lower Case)
St Prov Class Contains the state/province specific WC
class used for reporting purposes.
WCR-COUNTRY-CODE Alpha 2
Country Code Defines which country the record is
associated with.
WCCLASSOVR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCRSET1 COMPANY PR418 PRWC.1
COUNTRY-CODE
JOB-CODE
STATE-PROV
WCCLASSOVR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
WCR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (WCR-COUNTRY-CODE != Spaces )
WCR-COUNTRY-CODE -> INT-COUNTRY-CODE
Jobcode JOBCODE Required
WCR-COMPANY -> JBC-COMPANY
WCR-JOB-CODE -> JBC-JOB-CODE
State Prov PRPROVINCE Required
WCR-STATE-PROV -> PPV-PROVINCE
|
