Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WCCLASS


                              WCCLASS FILE

                         Work Comp Class Detail

Contains the detail information of workers' compensation plans and stores the
experience rates and limits by effective date.

REFERENCED BY

PBIP.1    PR218     PR278     PR288     PR418     PRWC.1
HR06.1    HR06.4    HR506     HWCA.1    HWCC.1

UPDATED BY

PR18.1    PR18.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WCC-COMPANY            Numeric 4                                 PR18.1  PR18.2
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

WCC-WC-STATE           Alpha 2                                   PR18.1  PR18.2
Element: Wc State      Contains the 2-digit code that
                       identifies the state in which the
                       worker's compensation plan is effective.

WCC-PROCESS-LEVEL      Alpha 5                                   PR18.1  PR18.2
Element: Process Level Contains the process level if the
                       workers' compensation classification is
                       specific to a process level.

WCC-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR18.1  PR18.2
Element: Date          Contains the date the rates in the
                       table become effective.

WCC-WC-CLASS           Alpha 4                                   PR18.1
Workers Comp           Contains the workers' compensation
Classification         class.

WCC-CA-WC-CLASS        Alpha 10                                  PR18.2
Element: Ca Wc Class   Contains the Canadian Workers
                       Compensation classification to be used
                       on the job code.

WCC-DESC               Alpha 30  (Lower Case)                    PR18.1  PR18.2
Element: Description   Contains the workers' compensation
                       classification description.

WCC-EXP-RATE           Signed 7.4                                PR18.1  PR18.2
Element: Experience RatContains the experience rate. The value
                       in this field represents an amount if
                       you enter a value in either the Premium
                       Per Wages or Premium Per Hours field in
                       PR18.1 (Workers' Compensation
                       Classification). If you do not enter a
                       value in either of those fields, the
                       value represents a percent.

WCC-WAGE-LIMIT         Signed 11.2                               PR18.1  PR18.2
Element: Wage Limit    Contains the wage limit amount if
                       defined.

WCC-LIMIT-IND          Alpha 2                                   PR18.1
Element: Limit IndicatoContains the value that indicates if
                       the wage limit amount defined is a
                       monthly or annual limit.
                       MO = Monthly
                       AN = Annual

WCC-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

WCC-CURR-ND            Numeric 1
Account Currency
Code

WCC-E-MOD              Signed 7.4
Element: E Mod

WCC-COUNTRY-CODE       Alpha 2                                   PR18.1  PR18.2
Element: Country Code  Defines which country the record is
                       associated with.

                         WCCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCCSET1   COMPANY                                                PBIP.1  PR18.1
          COUNTRY-CODE                                           PR18.2  PR218
          WC-STATE                                               PR278   PR288
          PROCESS-LEVEL                                          PR418   PRWC.1
          EFFECT-DATE
          WC-CLASS
          CA-WC-CLASS

WCCSET2   COMPANY       KeyChange                                HR06.1  HR06.4
          WC-CLASS                                               HR506   HWCA.1
          CA-WC-CLASS                                            HWCC.1  PBIP.1
          COUNTRY-CODE
          WC-STATE
          PROCESS-LEVEL
          EFFECT-DATE*

                         WCCLASS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Class Header   WCCLASSHDR   Required

                            WCC-COMPANY          -> WCH-COMPANY
                            WCC-COUNTRY-CODE     -> WCH-COUNTRY-CODE
                            WCC-WC-STATE         -> WCH-WC-STATE
                            WCC-PROCESS-LEVEL    -> WCH-PROCESS-LEVEL
                            WCC-EFFECT-DATE      -> WCH-EFFECT-DATE

Company        PRSYSTEM     Required

                            WCC-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Policy Code    WCPOLICY     Required

                            WCC-COMPANY          -> WCP-COMPANY
                            WCH-WC-CODE          -> WCP-WC-CODE

Process Level  PRSYSTEM     Required
                            When WCC-PROCESS-LEVEL != Spaces

                            WCC-COMPANY          -> PRS-COMPANY
                            WCC-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Wc State       PRSTATE      Required
                            When WCC-WC-STATE != Spaces

                            WCC-WC-STATE         -> PSA-STATE