LETTERTEXT – Benefit Letter Text
- System
- Benefits (BN)
- Prefix
LTT- Primary key
COMPANY,LETTER-CODE,EMPLOYEE,DEPENDENT,PARTICIPNT,DATE,SEQ-NBR- Fields
- 8
- Updated by
- 4 programs
- Referenced by
- 3 programs
LETTERTEXT is the Benefit Letter Text table in Lawson Benefits (prefix LTT). It is indexed by COMPANY, LETTER-CODE, EMPLOYEE, DEPENDENT, PARTICIPNT, DATE, SEQ-NBR (LTTSET1). It is related 1:1 to BNCOMPANY, PRSYSTEM, EMDEPEND, EMPLOYEE, LETTERCODE and PARTICIPNT. It is updated by BN00.1, BN05.1, BN70.1 and BN85.1 and referenced by BN171, BN200 and BN285. The table has 8 fields, 1 index and 6 documented relations.
About LETTERTEXT
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.
Fields (8)
Column = COBOL field name without the LTT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
LTT-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN05.1, BN85.1 |
LTT-LETTER-CODE PKLETTER_CODE | Alpha 2 | Contains the letter code that represents each letter. | BN05.1, BN85.1 |
LTT-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee's number. The number correlates all information about the employee. | BN85.1 |
LTT-DEPENDENT PKDEPENDENT | Numeric 4 | Contains the dependent number. The number correlates all information about the dependent. | BN85.1 |
LTT-PARTICIPNT PKPARTICIPNT | Numeric 9 | Contains COBRA participant numbers. The number correlates all information about the COBRA participant. | BN85.1 |
LTT-DATE PKDATE | Numeric 8 (yyyymmdd) | Contains the letter date. | BN85.1 |
LTT-SEQ-NBR PKSEQ_NBR | Numeric 4 | Contains the automatically assigned sequence number. | BN05.1, BN85.1 |
LTT-TEXTTEXT | Alpha 70 | Contains the text of the letter. | 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 |
|---|---|---|---|---|
LTTSET1 | COMPANY, LETTER-CODE, EMPLOYEE, DEPENDENT, PARTICIPNT, DATE, SEQ-NBR | Primary | BN00.1, BN05.1, BN171, BN200, BN285, BN70.1, BN85.1 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |