Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LETTERCODE


                            LETTERCODE FILE

                          Benefit Letter Code

The Benefit Letter Code file contains header information associated with the
Letter Text file for standard and free form letters.

REFERENCED BY

BN171

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

LTC-LETTER-CODE        Alpha 2                                   BN05.1  BN85.1
Element: Letter Code   Contains the user-defined code that
                       represents a letter.

LTC-EMPLOYEE           Numeric 9                                 BN85.1
Element: Employee      Contains the employee's number. The
                       number correlates all information about
                       the employee. This field is used when
                       the letter is for an employee,
                       dependent, or retiree.

LTC-DEPENDENT          Numeric 4                                 BN85.1
Element: Dependent NumbContains the dependent to which the
                       letter is to be sent.

LTC-PARTICIPNT         Numeric 9                                 BN85.1
Element: Participant NuContains COBRA participant numbers. The
                       number correlates all information about
                       the COBRA participant.

LTC-DATE               Numeric 8  (yyyymmdd)                     BN85.1
Element: Date          Contains the date of the letter. This
                       field defaults to the system date.

LTC-PRINT-STATUS       Alpha 1                                   BN285   BN85.1
Element: All Flag      Indicates whether the free-form letter
                       has been printed.

                       When you add a free-form letter, this
                       field defaults to Not Printed. When you
                       print this letter, this field changes to
                       Yes.

LTC-SALUTATION         Alpha 40                                  BN85.1
Element: Salutation    Contains the salutation or greeting of
                       the letter.

LTC-SIGNATURE          Alpha 40 Occurs 2 Times                   BN85.1
Element: Signature     Contains the first line of the letter's
                       closing.

LTC-LAST-LTR-SEQ       Numeric 4                                 BN05.1  BN85.1
Last Letter Text       Contains the sequence number of the
Sequence Nbr           last letter created.

                         LETTERCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LTCSET1   COMPANY                                                BN00.1  BN00.2
          LETTER-CODE                                            BN00.3  BN05.1
          EMPLOYEE                                               BN171   BN285
          DEPENDENT                                              BN70.1  BN85.1
          PARTICIPNT
          DATE

                         LETTERCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            LTC-COMPANY        -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            LTC-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Dependent      EMDEPEND     Required
                            When LTC-DEPENDENT != Zeroes

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

Employee       EMPLOYEE     Required
                            When LTC-EMPLOYEE != Zeroes

                            LTC-COMPANY        -> EMP-COMPANY
                            LTC-EMPLOYEE       -> EMP-EMPLOYEE

Participant    PARTICIPNT   Required
                            When LTC-PARTICIPNT != Zeroes

                            LTC-COMPANY        -> PAR-COMPANY
                            LTC-PARTICIPNT     -> PAR-PARTICIPNT

                         LETTERCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Letter Text    LETTERTEXT   Delete Restricted

                            LTC-COMPANY        -> LTT-COMPANY
                            LTC-LETTER-CODE    -> LTT-LETTER-CODE
                            LTC-EMPLOYEE       -> LTT-EMPLOYEE
                            LTC-DEPENDENT      -> LTT-DEPENDENT
                            LTC-PARTICIPNT     -> LTT-PARTICIPNT
                            LTC-DATE           -> LTT-DATE
                                                  LTT-SEQ-NBR