Lawson Insight Technical Documentation

                             OCCURTYPE FILE

                         COBRA Occurrence Type

The COBRA Occurrence Type file contains information about occurrences.

REFERENCED BY

BN05.1    BN100     BN101     BN102     BN103     BN105
BN106     BN16.1    BN16.2    BN16.3    BN16.4    BN170
BN171     BN200     BN216     BN270     BN31.1    BN31.2
BN32.1    BN32.2    BN32.3    BN531     BN532     BN70.1
BN70.2    BN71.1    BN72.1    BS32.1    HR13.2    HR13.3
HR13.4    PA100     PA52.1    PA52.5

UPDATED BY

BN00.1    BN00.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OCC-COMPANY            Numeric 4                                 BN00.3
Element: Company Hr    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
Element: 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
Element: Initial LetterContains the letter code assigned to
                       the occurrence.

OCC-EVENT-CODE         Numeric 1                                 BN00.3
Element: Event Code    1 = Termination of Employment
                       2 = Reduction of Work Hours
                       3 = Medicare
                       4 = Death
                       5 = Divorce
                       6 = Separation
                       7 = Ineligible Child
                       8 = Bankruptcy of Retiree

                         OCCURTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCCSET1   COMPANY                                                BN00.1  BN00.3
          OCCUR-TYPE                                             BN05.1  BN100
                                                                 BN101   BN102
                                                                 BN103   BN105
                                                                 BN106   BN16.1
                                                                 BN16.2  BN16.3
                                                                 BN16.4  BN170
                                                                 BN171   BN200
                                                                 BN216   BN270
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN531
                                                                 BN532   BN70.1
                                                                 BN70.2  BN71.1
                                                                 BN72.1  BS32.1
                                                                 ...

                         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