Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WCCLASSHDR


                            WCCLASSHDR FILE

                         Work Comp Class Header

This file identifies workers' compensation classes. You can identify classes
by company, work state, or process level. You can add multiple records for the
same workers' compensation class by using different effective dates.

REFERENCED BY

PBWC.1    PR218     PR288     PR418     PR17.1    PR278
PRWC.1

UPDATED BY

PR18.1    PR18.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

WCH-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.

WCH-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR18.1  PR18.2
Element: Date          Contains the effective date of the
                       workers' compensation rate table.

WCH-WC-CODE            Alpha 10                                  PR18.1
Workers Comp Policy    Contains the user-defined code that
Code                   identifies the workers' compensation
                       plan.

WCH-PREM-PER-WAGE      Signed 11.3                               PR18.1  PR18.2
Premium Based on       Contains the amount per wages on which
Wages                  the premium is based.

WCH-PREM-PER-HOUR      Signed 7.2                                PR18.1
Premium Based on       Contains the amount per hour on which
Nbr of Hours           the premium is based.

WCH-STA-ANN-LIMIT      Signed 11.2                               PR18.1  PR18.2
Element: State Annual LContains the state annual limit defined
                       for the policy.

WCH-STA-MTH-LIMIT      Signed 11.2                               PR18.1
Element: State Monthly Contains the state monthly limit
                       defined for the policy. The system
                       checks the limit every calendar month.

WCH-INC-OVT-PREM       Alpha 1                                   PR18.1  PR18.2
Include Overtime       Contains the value that determines if
Premium                the entire overtime pay amount or only
                       the straight time portion of the pay is
                       included in the calculation.
                       Y = Yes
                       N = No

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

WCH-CURR-ND            Numeric 1
Account Currency
Code

WCH-INDUSTRY-CODE      Alpha 10                                  PR18.2
Element: Industry Code This field will store the industry code
                       for the province that is being reported.

WCH-IND-CODE-DESC      Alpha 30  (Lower Case)                    PR18.2
Element: Ind Code Desc Stores the description of the industry
                       code (e.g logging, mining, etc.).

WCH-COUNTRY-CODE       Alpha 2                                   PR18.1  PR18.2
Element: Country Code  Defines which country the record is
                       associated with.
                       "  " = USA
                       CA = Canada
                       US = USA

WCH-E-MOD              Signed 7.4
Element: E Mod

WCH-CA-ACCT-NBR        Alpha 15                                  PR18.2
Element: Ca Acct Nbr   Defines the provincial assigned account
                       number, firm number, registration
                       number, Quebec enterprise number, legal
                       entity, etc. for which this plan is
                       being set up.

WCH-CLIENT-E-MOD       Signed 7.4
Element: Client E Mod

                         WCCLASSHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCHSET1   COMPANY                                                PBWC.1  PR18.1
          COUNTRY-CODE                                           PR18.2  PR218
          WC-STATE                                               PR288   PR418
          PROCESS-LEVEL
          EFFECT-DATE*

WCHSET2   COMPANY       KeyChange                                PR17.1  PR278
          COUNTRY-CODE
          WC-CODE
          CA-ACCT-NBR
          EFFECT-DATE*
          WC-STATE
          PROCESS-LEVEL

WCHSET3   COMPANY                                                PRWC.1
          COUNTRY-CODE
          EFFECT-DATE*
          WC-STATE
          PROCESS-LEVEL

                         WCCLASSHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            WCH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Policy Code    WCPOLICY     Required

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

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

                            WCH-COMPANY          -> PRS-COMPANY
                            WCH-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

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

                            WCH-WC-STATE         -> PSA-STATE

                         WCCLASSHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Classes        WCCLASS      Delete Cascades

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