Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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

PR218     PR278     PR288     PR418     PRWC.1    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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

WCC-WC-STATE         Alpha 2                                     PR18.1  PR18.2
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
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
Effective 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
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
Description          Contains the workers' compensation
                     classification description.

WCC-EXP-RATE         Signed 7.4                                  PR18.1  PR18.2
Experience 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
Wage Limit           Contains the wage limit amount if
                     defined.

WCC-LIMIT-IND        Alpha 2                                     PR18.1
Limit Indicator      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
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

WCC-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

WCC-E-MOD            Signed 7.4
E Mod

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

                         WCCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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