LETTERCODE

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
Element: Company Hr
Numeric 4
Contains the company number. The number correlates all information about the company.
BN05.1 BN85.1
LTC-LETTER-CODE
Element: Letter Code
Alpha 2
Contains the user-defined code that represents a letter.
BN05.1 BN85.1
LTC-EMPLOYEE
Element: 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
Element: Dependent
Numeric 4
Contains the dependent to which the letter is to be sent.
BN85.1
LTC-PARTICIPNT
Element: Participnt
Numeric 9
Contains COBRA participant numbers. The number correlates all information about the COBRA participant.
BN85.1
LTC-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the date of the letter. This field defaults to the system date.
BN85.1
LTC-PRINT-STATUS
Element: All Flag
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
Element: Salutation
Alpha 40
Contains the salutation or greeting of the letter.
BN85.1
LTC-SIGNATURE
Element: Signature
Alpha 40 Occurs 2 Times
Contains the first line of the letter's closing.
BN85.1
LTC-LAST-LTR-SEQ
Element: Last Ltr Seq
Numeric 4
Contains the sequence number of the last letter created.
BN05.1 BN85.1


LETTERCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LTCSET1 COMPANY
LETTER-CODE
EMPLOYEE
DEPENDENT
PARTICIPNT
DATE
BN00.1 BN00.2
BN00.3 BN05.1
BN171 BN285
BN70.1 BN85.1


LETTERCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:10:05 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.