OCCURTYPE FILE

                         COBRA Occurrence Type

The COBRA Occurrence Type file contains information about occurrences.

REFERENCED BY

BN05.1    BN100     BN16.1    BN16.2    BN16.3    BN16.4
BN170     BN171     BN200     BN216     BN270     BN70.1
BN70.2    PA100     PA52.1    PA52.5

UPDATED BY

BN00.1    BN00.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OCC-COMPANY          Numeric 4                                   BN00.3
Company              Contains the company number. The number
                     correlates all information about the
                     company.

OCC-OCCUR-TYPE       Alpha 2                                     BN00.3
Type of First        Contains the user-defined code that
Occurrence           represents an occurrence.

OCC-DESC             Alpha 30  (Lower Case)                      BN00.3  BN16.4
Description          Contains a description of the
                     occurrence.

OCC-MONTHS-EXT       Numeric 2                                   BN00.3
Months Coverage is   Contains the number of months a COBRA
Extended             participant's coverage extends for the
                     occurrence.

OCC-IN-LTR-CODE      Alpha 2                                     BN00.3
Initial Letter Code  Contains the letter code assigned to
                     the occurrence.

                         OCCURTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCCSET1   COMPANY                                                BN00.1  BN00.3
          OCCUR-TYPE                                             BN05.1  BN100
                                                                 BN16.1  BN16.2
                                                                 BN16.3  BN16.4
                                                                 BN170   BN171
                                                                 BN200   BN216
                                                                 BN270   BN70.1
                                                                 BN70.2  PA100
                                                                 PA52.1  PA52.5

                         OCCURTYPE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            OCC-COMPANY        -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            OCC-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Letter Code    LETTERCODE   Required
                            When OCC-IN-LTR-CODE != Spaces

                            OCC-COMPANY        -> LTC-COMPANY
                            OCC-IN-LTR-CODE    -> LTC-LETTER-CODE
                            Zeroes             -> LTC-EMPLOYEE
                            Zeroes             -> LTC-DEPENDENT
                            Zeroes             -> LTC-PARTICIPNT
                            Zeroes             -> LTC-DATE