WCCLASSOVR FILE
REFERENCED BY
PR418     PRWC.1
UPDATED BY
HR06.4
FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY
WCR-COMPANY            Numeric 4                                 HR06.4
Element: Company       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 or ProviContains 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                                                HR06.4  PR418
          COUNTRY-CODE                                           PRWC.1
          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
 |