Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WCCLASSOVR


                            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