PBBLWCDTL FILE

                     PB Workers Comp Billing Detail

The Pay to Bill Workers Compensation Billing Detail file

REFERENCED BY

PBWC.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

PBX-PROCESS-LEVEL    Alpha 5
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

PBX-EFFECT-DATE      Numeric 8  (yyyymmdd)
Effective Date       The date the workers comp billing rate
                     is effective.

PBX-WC-STATE         Alpha 2
Wc State             The state where the workers comp policy
                     is used.

PBX-WC-CLASS         Alpha 4
Workers Comp         Contains the workers' compensation
Classification       class.

PBX-BILLING-RATE     Signed 9.4
Billing Rate         The rates used to calculate the workers
                     comp.

PBX-BILLING-MOD      Signed 7.4
Billing Mod          The billing rate used to calculate the
                     amount.

PBX-WAGE-CUT-OFF     Signed 11.2
Wage Cut Off         The maximum workers comp amount that can
                     be billed.

PBX-LIMIT-IND        Alpha 2
Limit Indicator      This field determines if the wage limit
                     is applied monthly or annualy.

                         PBBLWCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBXSET1   COMPANY                                                PBWC.1
          PROCESS-LEVEL
          EFFECT-DATE
          WC-STATE
          WC-CLASS

PBXSET2   COMPANY
          WC-STATE
          PROCESS-LEVEL
          EFFECT-DATE
          WC-CLASS

                         PBBLWCDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pbblwchdr      PBBLWCHDR    Required

                            PBX-COMPANY          -> PBW-COMPANY  (PBWSET1)
                            PBX-PROCESS-LEVEL    -> PBW-PROCESS-LEVEL
                            PBX-EFFECT-DATE      -> PBW-EFFECT-DATE
                            PBX-WC-STATE         -> PBW-WC-STATE