|
|
LETTERTEXT FILE
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
UPDATED BY
BN00.1 BN05.1 BN70.1 BN85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LTT-COMPANY Numeric 4 BN05.1 BN85.1
Element: Company Hr Contains the company number. The number
correlates all information about the
company.
LTT-LETTER-CODE Alpha 2 BN05.1 BN85.1
Element: Letter Code Contains the letter code that
represents each letter.
LTT-EMPLOYEE Numeric 9 BN85.1
Element: Employee Contains the employee's number. The
number correlates all information about
the employee.
LTT-DEPENDENT Numeric 4 BN85.1
Element: Dependent NumbContains the dependent number. The
number correlates all information about
the dependent.
LTT-PARTICIPNT Numeric 9 BN85.1
Element: Participant NuContains COBRA participant numbers. The
number correlates all information about
the COBRA participant.
LTT-DATE Numeric 8 (yyyymmdd) BN85.1
Element: Date Contains the letter date.
LTT-SEQ-NBR Numeric 4 BN05.1 BN85.1
Element: Sequence NumbeContains the automatically assigned
sequence number.
LTT-TEXT Alpha 70 BN05.1 BN85.1
Element: Text Contains the text of the letter.
LETTERTEXT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LTTSET1 COMPANY BN00.1 BN05.1
LETTER-CODE BN171 BN200
EMPLOYEE BN285 BN70.1
DEPENDENT BN85.1
PARTICIPNT
DATE
SEQ-NBR
LETTERTEXT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
