LETTERCODE FILE
Benefit Letter Code
The Benefit Letter Code file contains header information associated with the
Letter Text file for standard and free form letters.
REFERENCED BY
BN171
UPDATED BY
BN00.1 BN05.1 BN285 BN70.1 BN85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LTC-COMPANY Numeric 4 BN05.1 BN85.1
Company Contains the company number. The number
correlates all information about the
company.
LTC-LETTER-CODE Alpha 2 BN05.1 BN85.1
Letter Code Contains the user-defined code that
represents a letter.
LTC-EMPLOYEE Numeric 9 BN85.1
Employee 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.
LTC-DEPENDENT Numeric 4 BN85.1
Dependent Number Contains the dependent to which the
letter is to be sent.
LTC-PARTICIPNT Numeric 9 BN85.1
Participant Number Contains COBRA participant numbers. The
number correlates all information about
the COBRA participant.
LTC-DATE Numeric 8 (yyyymmdd) BN85.1
Date Contains the date of the letter. This
field defaults to the system date.
LTC-PRINT-STATUS Alpha 1 BN285 BN85.1
Print Status 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.
LTC-SALUTATION Alpha 40 BN85.1
Salutation Contains the salutation or greeting of
the letter.
LTC-SIGNATURE Alpha 40 Occurs 2 Times BN85.1
Signature Contains the first line of the letter's
closing.
LTC-LAST-LTR-SEQ Numeric 4 BN05.1 BN85.1
Last Letter Text Contains the sequence number of the
Sequence Nbr last letter created.
LETTERCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LTCSET1 COMPANY BN00.1 BN00.2
LETTER-CODE BN00.3 BN05.1
EMPLOYEE BN171 BN285
DEPENDENT BN70.1 BN85.1
PARTICIPNT
DATE
LETTERCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
LETTERCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
