WCCLASSOVR

REFERENCED BY
BN150 BN66.1 PR521 EXI2.1 EXI4.1 LP130
LP140 PR128 PR130 PR131 PR132 PR134
PR135 PR136 PR137 PR140 PR189 PR195
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR37.1 PR418 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 PR89.1 UK102 UK560 TA147


UPDATED BY
HR06.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCR-COMPANY
Element: Company Hr		Numeric 4
The company number represents an established company and is entered on all function codes.
HR06.4
WCR-JOB-CODE
Element: Job Code		Alpha 9
Contains the job code of the workers comp class that has multiple values by state/province.
HR06.4
WCR-STATE-PROV
Element: State Prov		Alpha 2
Contains the state/province for workers compensation purposes.
HR06.4
WCR-ST-PROV-CLASS
Element: St Prov Class		Alpha 10 (Lower Case)
Contains the state/province specific WC class used for reporting purposes.
HR06.4
WCR-COUNTRY-CODE
Element: Country Code		Alpha 2
Defines which country the record is associated with.
HR06.4


WCCLASSOVR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCRSET1 COMPANY
COUNTRY-CODE
JOB-CODE
STATE-PROV
...
BN150 BN66.1
HR06.4 PR521
EXI2.1 EXI4.1
LP130 LP140
PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5


WCCLASSOVR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:51:16 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.