LETTERTEXT

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.
UPDATED BY
BN00.1 BN05.1 BN70.1 BN85.1 BN171 BN200
BN285

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.
BN05.1 BN85.1
LTT-LETTER-CODE
Element: Letter Code
Alpha 2
Contains the letter code that represents each letter.
BN05.1 BN85.1
LTT-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee's number. The number correlates all information about the employee.
BN85.1
LTT-DEPENDENT
Element: Dependent
Numeric 4
Contains the dependent number. The number correlates all information about the dependent.
BN85.1
LTT-PARTICIPNT
Element: Participnt
Numeric 9
Contains COBRA participant numbers. The number correlates all information about the COBRA participant.
BN85.1
LTT-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the letter date.
BN85.1
LTT-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the automatically assigned sequence number.
BN05.1 BN85.1
LTT-TEXT
Element: Text
Alpha 70
Contains the text of the letter.
BN05.1 BN85.1


LETTERTEXT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LTTSET1 COMPANY
LETTER-CODE
EMPLOYEE
DEPENDENT
PARTICIPNT
DATE
SEQ-NBR
BN00.1 BN05.1
BN171 BN200
BN285 BN70.1
BN85.1


LETTERTEXT FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Wed Jun 08 20:48:08 2016

Home
Contact Us



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