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

BN66.1    PR140     PR189     PR195     PR218     PR278
PR288     PR418     PR80.1    PR89.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 Hr

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 Lev HrContains 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: Effect Date   Contains the date the rates in the
                       table become effective.

WCC-WC-CLASS           Alpha 4                                   PR18.1
Element: Wc Class      Contains the workers' compensation
                       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: Exp Rate      Contains 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 Ind     Contains 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
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


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                                                BN66.1  PR140
          COUNTRY-CODE                                           PR18.1  PR18.2
          WC-STATE                                               PR189   PR195
          PROCESS-LEVEL                                          PR218   PR278
          EFFECT-DATE                                            PR288   PR418
          WC-CLASS                                               PR80.1  PR89.1
          CA-WC-CLASS

WCCSET2   COMPANY       KeyChange                                HR06.1  HR06.4
          WC-CLASS                                               HR506   HWCA.1
          CA-WC-CLASS                                            HWCC.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