FIN_ASST_LETTER
Description:
This table contains information about letters sent as part of financial assistance workflows.

Primary Key
Column Name Ordinal Position
NOTE_ID 1

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier for the note record.
2 LETTER_PRNT_MTHD_C_NAME VARCHAR No
The purpose of this item is to provide additional context for I HNO 39 - Letter Print Instant. This item specifies whether the last print action for this letter was via the server or via the client.
May contain organization-specific values: No
Category Entries:
Printed from server
Printed from client
Created from external system
3 LETTER_PRNT_INSTANT_DTTM DATETIME (Attached) No
Holds the instant the letter was last printed.
4 LETTER_SENT_DT DATETIME No
This item stores the date the letter was sent.
5 ENTRY_PERSON_ID VARCHAR No
Letter printing user's ID.
6 ENTRY_PERSON_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 HB_LET_TEMPLT_ID VARCHAR No
Stores the internal ID of the letter template used.
8 HB_LET_TEMPLT_ID_SMARTTEXT_NAME VARCHAR No
The name of the SmartText record.
9 HB_LTR_EXT_IMG_LINK VARCHAR No
Stores the filename on the BLOB server for the image of the letter.
10 HB_LTR_DVRY_MTD_C_NAME VARCHAR No
This items stores how the letter was delivered, for example, by paper or electronic notification.
May contain organization-specific values: No
Category Entries:
Paper, No Electronic Notification
Paperless, No Electronic Notification
Paper and Electronic Notification
Paperless, Electronic Notification
11 HB_LTR_PAPER_RSN_C_NAME VARCHAR No
Stores the reason the letter was forced to be sent by paper.
May contain organization-specific values: No
Category Entries:
Paperless Billing is disabled for the service area
User specified
Forced to paper because of self-pay follow-up level
Forced to paper because of guarantor rule
Forced to paper because of hospital account rule
Guarantor declined paperless billing
Financial Assistance Program Not Allowed In MyChart
Not self-pay correspondence
Form is not allowed to be displayed in MyChart
Guarantor missing associated patient or MyChart account
Guarantor is not MyChart active
Guarantor is not available in MyChart
No access to billing features in MyChart
MyChart tickler could not be sent
Professional billing letter not marked as Sent
Patient is not active on MyChart
Queued for printing based on estimate rule
Patient is deceased
12 FIN_ASST_CASE_ID NUMERIC No
This item stores the internal ID of the financial assistance case record this note is linked to.
13 FIN_ASST_TRACKER_ID NUMERIC No
Stores the internal ID of the financial assistance program tracker linked to this note.
14 REG_FA_LETTER_TYP_C_NAME VARCHAR No
This item stores the type of letter being sent for a financial assistance case record.
May contain organization-specific values: No
Category Entries:
Approval Letter
Denial Letter
Follow-Up Letter
Request Reminder Letter
Application Letter
Expiration Letter
Re-Application Letter
15 REG_FA_LTR_SRC_C_NAME VARCHAR No
This item stores the source from which a letter has been generated for a financial assistance case record.
May contain organization-specific values: No
Category Entries:
Letters activity
Case Edit activity
Batch job
16 HNO_RECORD_TYPE_C_NAME VARCHAR No
Record type.
May contain organization-specific values: No
Category Entries:
PB Guarantor Note
PB Guarantor Letter
PB Insurance Follow-up Letter
PB Hospital Account Note
PB Visit Account Letter
CRM Letter
CRM Envelope
CRM Email
HB Guarantor Note
HB Hospital Account Note
HB Guarantor Letter
HB Hospital Account Letter
HB Liability Bucket Letter
HB Liability Bucket Note
HB Contractual History Note
EB Guarantor Note
Reg Financial Assistance Letter
Reg Financial Assistance Tracker Note
Reg Financial Assistance Case Note