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     PRWC.1    HR06.1    HWCC.1

UPDATED BY

PR18.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

WCC-WC-STATE         Alpha 2                                     PR18.1
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
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
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-DESC             Alpha 30  (Lower Case)                      PR18.1
Description          Contains the workers' compensation
                     classification description.

WCC-EXP-RATE         Signed 7.4                                  PR18.1
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
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-E-MOD            Signed 7.4
E Mod

                         WCCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCCSET1   COMPANY                                                PBIP.1  PR18.1
          WC-STATE                                               PR218   PR278
          PROCESS-LEVEL                                          PRWC.1
          EFFECT-DATE
          WC-CLASS

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