Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            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     PR17.1    PR278     PRWC.1

UPDATED BY

PR18.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

WCH-WC-STATE         Alpha 2                                     PR18.1
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
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
Effective 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
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
State Annual Limit   Contains the state annual limit defined
                     for the policy.

WCH-STA-MTH-LIMIT    Signed 11.2                                 PR18.1
State Monthly Limit  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
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-E-MOD            Signed 7.4
E Mod

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

                         WCCLASSHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCHSET1   COMPANY                                                PBWC.1  PR18.1
          WC-STATE                                               PR218
          PROCESS-LEVEL
          EFFECT-DATE

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

WCHSET3   COMPANY                                                PRWC.1
          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-WC-STATE         -> WCC-WC-STATE
                            WCH-PROCESS-LEVEL    -> WCC-PROCESS-LEVEL
                            WCH-EFFECT-DATE      -> WCC-EFFECT-DATE
                                                    WCC-WC-CLASS