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.

Field / column	Type	Description & values	Updated by
`LTC-COMPANY` PK COMPANY	Numeric 4	Contains the company number. The number correlates all information about the company.	BN05.1, BN85.1
`LTC-LETTER-CODE` PK LETTER_CODE	Alpha 2	Contains the user-defined code that represents a letter.	BN05.1, BN85.1
`LTC-EMPLOYEE` PK EMPLOYEE	Numeric 9	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.	BN85.1
`LTC-DEPENDENT` PK DEPENDENT	Numeric 4	Contains the dependent to which the letter is to be sent.	BN85.1
`LTC-PARTICIPNT` PK PARTICIPNT	Numeric 9	Contains 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 1	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.	BN285, BN85.1
`LTC-SALUTATION` SALUTATION	Alpha 40	Contains the salutation or greeting of the letter.	BN85.1
`LTC-SIGNATURE` SIGNATURE	Alpha 40 Occurs 2 Times ×2	Contains the first line of the letter's closing.	BN85.1
`LTC-LAST-LTR-SEQ` LAST_LTR_SEQ	Numeric 4	Contains the sequence number of the last letter created.	BN05.1, BN85.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`LTCSET1`	`COMPANY`, `LETTER-CODE`, `EMPLOYEE`, `DEPENDENT`, `PARTICIPNT`, `DATE`	Primary		BN00.1, BN00.2, BN00.3, BN05.1, BN171, BN285, BN70.1, BN85.1

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (5)

BN00.1 Benefits Company
BN05.1 Standard Letter
BN285 Standard Letter Print
BN70.1 COBRA Participant
BN85.1 Free Form Letter

Referenced by (1)

BN171 COBRA Letter Print