LETTERTEXT FILE

                          Benefit Letter Text

The Benefit Letter Text file contains text of letters created in BN05.1
(Standard Letter) and BN85.1 (Free Form Letter). Letters are identified by
letter code from the Letter Code file. Each free-form letter is assigned to an
employee, a dependent, or a COBRA participant.

REFERENCED BY

BN171     BN200     BN285

UPDATED BY

BN00.1    BN05.1    BN70.1    BN85.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

LTT-COMPANY          Numeric 4                                   BN05.1  BN85.1
Company              Contains the company number. The number
                     correlates all information about the
                     company.

LTT-LETTER-CODE      Alpha 2                                     BN05.1  BN85.1
Letter Code          Contains the letter code that
                     represents each letter.

LTT-EMPLOYEE         Numeric 9                                   BN85.1
Employee             Contains the employee's number. The
                     number correlates all information about
                     the employee.

LTT-DEPENDENT        Numeric 4                                   BN85.1
Dependent Number     Contains the dependent number. The
                     number correlates all information about
                     the dependent.

LTT-PARTICIPNT       Numeric 9                                   BN85.1
Participant Number   Contains COBRA participant numbers. The
                     number correlates all information about
                     the COBRA participant.

LTT-DATE             Numeric 8  (yyyymmdd)                       BN85.1
Date                 Contains the letter date.

LTT-SEQ-NBR          Numeric 4                                   BN05.1  BN85.1
Sequence Number      Contains the automatically assigned
                     sequence number.

LTT-TEXT             Alpha 70                                    BN05.1  BN85.1
Text                 Contains the text of the letter.

                         LETTERTEXT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LTTSET1   COMPANY                                                BN00.1  BN05.1
          LETTER-CODE                                            BN171   BN200
          EMPLOYEE                                               BN285   BN70.1
          DEPENDENT                                              BN85.1
          PARTICIPNT
          DATE
          SEQ-NBR

                         LETTERTEXT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            LTT-COMPANY        -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            LTT-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Dependent      EMDEPEND     Required
                            When LTT-DEPENDENT != Zeroes

                            LTT-COMPANY        -> EMD-COMPANY
                            LTT-EMPLOYEE       -> EMD-EMPLOYEE
                            LTT-DEPENDENT      -> EMD-SEQ-NBR

Employee       EMPLOYEE     Required
                            When LTT-EMPLOYEE != Zeroes

                            LTT-COMPANY        -> EMP-COMPANY
                            LTT-EMPLOYEE       -> EMP-EMPLOYEE

Letter Code    LETTERCODE   Required

                            LTT-COMPANY        -> LTC-COMPANY
                            LTT-LETTER-CODE    -> LTC-LETTER-CODE
                            Zeroes             -> LTC-EMPLOYEE
                            Zeroes             -> LTC-DEPENDENT
                            Zeroes             -> LTC-PARTICIPNT
                            Zeroes             -> LTC-DATE

Participant    PARTICIPNT   Required
                            When LTT-PARTICIPNT != Zeroes

                            LTT-COMPANY        -> PAR-COMPANY
                            LTT-PARTICIPNT     -> PAR-PARTICIPNT