LETTERCODE – Benefit Letter Code

System
Benefits (BN)
Prefix
LTC
Primary key
COMPANY, LETTER-CODE, EMPLOYEE, DEPENDENT, PARTICIPNT, DATE
Fields
10
Updated by
5 programs
Referenced by
1 program

LETTERCODE is the Benefit Letter Code table in Lawson Benefits (prefix LTC). It is indexed by COMPANY, LETTER-CODE, EMPLOYEE, DEPENDENT, PARTICIPNT, DATE (LTCSET1). It is related 1:1 to BNCOMPANY, PRSYSTEM, EMDEPEND, EMPLOYEE and PARTICIPNT and 1:M to LETTERTEXT. It is updated by BN00.1, BN05.1, BN285, BN70.1 and BN85.1 and referenced by BN171. The table has 10 fields, 1 index and 6 documented relations.

About LETTERCODE

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

Fields (10)

Column = COBOL field name without the LTC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#LTC-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN05.1, BN85.1
#LTC-LETTER-CODE PK
LETTER_CODE		Alpha 2Contains the user-defined code that represents a letter.BN05.1, BN85.1
#LTC-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.BN85.1
#LTC-DEPENDENT PK
DEPENDENT		Numeric 4Contains the dependent to which the letter is to be sent.BN85.1
#LTC-PARTICIPNT PK
PARTICIPNT		Numeric 9Contains COBRA participant numbers. The number correlates all information about the COBRA participant.BN85.1
#LTC-DATE PK
DATE		Numeric 8 (yyyymmdd)Contains the date of the letter. This field defaults to the system date.BN85.1
#LTC-PRINT-STATUS
PRINT_STATUS		Alpha 1Indicates 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.BN285, BN85.1
#LTC-SALUTATION
SALUTATION		Alpha 40Contains the salutation or greeting of the letter.BN85.1
#LTC-SIGNATURE
SIGNATURE		Alpha 40 Occurs 2 Times ×2Contains the first line of the letter's closing.BN85.1
#LTC-LAST-LTR-SEQ
LAST_LTR_SEQ		Numeric 4Contains the sequence number of the last letter created.BN05.1, BN85.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LTCSET1
  1. COMPANY
  2. LETTER-CODE
  3. EMPLOYEE
  4. DEPENDENT
  5. PARTICIPNT
  6. DATE
PrimaryBN00.1, BN00.2, BN00.3, BN05.1, BN171, BN285, BN70.1, BN85.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BNCOMPANYPRSYSTEMEMDEPENDEMPLOYEEPARTICIPNTLETTERTEXTLETTERCODE

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequired
LTC-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
LTC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DependentEMDEPENDRequiredWhen LTC-DEPENDENT != Zeroes
LTC-COMPANY→EMD-COMPANY
LTC-EMPLOYEE→EMD-EMPLOYEE
LTC-DEPENDENT→EMD-SEQ-NBR
EmployeeEMPLOYEERequiredWhen LTC-EMPLOYEE != Zeroes
LTC-COMPANY→EMP-COMPANY
LTC-EMPLOYEE→EMP-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen LTC-PARTICIPNT != Zeroes
LTC-COMPANY→PAR-COMPANY
LTC-PARTICIPNT→PAR-PARTICIPNT

One to many (1) — child tables

RelationTableRulesConditionField map
Letter TextLETTERTEXTDelete 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

Programs

Updated by (5)

Referenced by (1)