Lawson Insight Technical Documentation |
|
WCCLASSOVR
WCCLASSOVR FILE
REFERENCED BY
BN150 BN66.1 ET530 ETI2.1 LP130 PR128
PR130 PR131 PR132 PR134 PR136 PR140
PR189 PR195 PR29.1 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR418 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 PR89.1 UK102
UK560 TA147
UPDATED BY
HR06.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCR-COMPANY Numeric 4 HR06.4
Element: Company Hr The company number represents an
established company and is entered on
all function codes.
WCR-JOB-CODE Alpha 9 HR06.4
Element: Job Code Contains the job code of the workers
comp class that has multiple values by
state/province.
WCR-STATE-PROV Alpha 2 HR06.4
Element: State Prov Contains the state/province for workers
compensation purposes.
WCR-ST-PROV-CLASS Alpha 10 (Lower Case) HR06.4
Element: St Prov Class Contains the state/province specific WC
class used for reporting purposes.
WCR-COUNTRY-CODE Alpha 2 HR06.4
Element: Country Code Defines which country the record is
associated with.
WCCLASSOVR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCRSET1 COMPANY BN150 BN66.1
COUNTRY-CODE ET530 ETI2.1
JOB-CODE HR06.4 LP130
STATE-PROV PR128 PR130
PR131 PR132
PR134 PR136
PR140 PR189
PR195 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR418 PR45.1
...
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
|