Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LETTERTEXT


                            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
Element: Company Hr    Contains the company number. The number
                       correlates all information about the
                       company.

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

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

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

LTT-PARTICIPNT         Numeric 9                                 BN85.1
Element: Participnt    Contains COBRA participant numbers. The
                       number correlates all information about
                       the COBRA participant.

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

LTT-SEQ-NBR            Numeric 4                                 BN05.1  BN85.1
Element: Seq Nbr       Contains the automatically assigned
                       sequence number.

LTT-TEXT               Alpha 70                                  BN05.1  BN85.1
Element: 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