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 |
BN00.1 | BN05.1 | BN70.1 | BN85.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
LTT-COMPANY Element: Company Hr | Numeric 4 Contains the company number. The number correlates all information about the company. |
|
||
LTT-LETTER-CODE Element: Letter Code | Alpha 2 Contains the letter code that represents each letter. |
|
||
LTT-EMPLOYEE Element: Employee | Numeric 9 Contains the employee's number. The number correlates all information about the employee. |
|
||
LTT-DEPENDENT Element: Dependent | Numeric 4 Contains the dependent number. The number correlates all information about the dependent. |
|
||
LTT-PARTICIPNT Element: Participnt | Numeric 9 Contains COBRA participant numbers. The number correlates all information about the COBRA participant. |
|
||
LTT-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the letter date. |
|
||
LTT-SEQ-NBR Element: Seq Nbr | Numeric 4 Contains the automatically assigned sequence number. |
|
||
LTT-TEXT Element: Text | Alpha 70 Contains the text of the letter. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LTTSET1 |
COMPANY LETTER-CODE EMPLOYEE DEPENDENT PARTICIPNT DATE SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | BNCOMPANY |
Required
| ||||||||||||||||||
Company Name | PRSYSTEM |
Required
| ||||||||||||||||||
Dependent | EMDEPEND |
Required
| ||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||
Letter Code | LETTERCODE |
Required
| ||||||||||||||||||
Participant | PARTICIPNT |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.