WCCLASSOVR

REFERENCED BY
BN150 BN66.1 PR521 EXI2.1 EXI4.1 LP130
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 ZP530 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 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


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: Thu Jun 09 11:27:35 2016

Home
Contact Us



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