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
Forced to paper because the authorized user copy is always sent as a physical copy
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
CRM Text Message
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
EB Appeal Letter
EB Payer Policy
Reg Financial Assistance Letter
Reg Financial Assistance Tracker Note
Reg Financial Assistance Case Note
Prescription Appeal Letter
CCM Concurrent Auth Appeal Letter