LETTER_PRINT_HISTORY
Description:
Table for per claim EOB print data.

Primary Key
Column Name Ordinal Position
CLAIM_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 CLAIM_ID NUMERIC No
The unique identifier (.1 item) for the claim info record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 LETTER_HX_NOTIF_PRINT_TYPE_C_NAME VARCHAR No
The print type of the letter
May contain organization-specific values: No
Category Entries:
BLOB
Rich Text
Plain Text
Electronic
Fax
4 LETTER_HX_DTTM DATETIME (Attached) No
The print instant of the letter
5 LETTER_HX_USER_ID VARCHAR No
The user who printed the letter
6 LETTER_HX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 LETTER_HX_PRINT_JOB_CLASS_C_NAME VARCHAR No
The letter type of the letter
May contain organization-specific values: No
Category Entries:
Premium Billing Invoice
Member PCP Letter
Member Provider Letter
Refund Request Letter
Referral Notification Letter
Claim Notification Letter
Remittance Advice Letter
Explanation Of Benefits Letter
Member Note
Coverage Note
Claim Note
Premium Billing Account Note
Vendor Note
Provider Note
CRM Letter
Appeal & Grievance Letter
Automatic Letter
Member Estimate Letter
Cost Calculator Letter
Periodic EOB
Periodic Summary
8 LETTER_HX_SMARTTEXT_ID VARCHAR No
The SmartText template used to generate the letter
9 LETTER_HX_SMARTTEXT_ID_SMARTTEXT_NAME VARCHAR No
The name of the SmartText record.