Lawson Insight Technical Documentation

                             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
Element: 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
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.

                         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