FIN_ASST_NOTE

Description:

This table contains information about notes added to financial assistance tracker records.

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	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
3	ENTRY_PERSON_USER_ID	VARCHAR	No
	Note Entry Person
4	ENTRY_PERSON_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	ENTRY_DATE	DATETIME	No
	The date on which this note was created.
6	ACCT_NOTE_INSTANT_DTTM	DATETIME (Local)	No
	The instant in which this note was created.
7	ACCT_NOTE_SUMMARY	VARCHAR	No
	A brief summary of the content of this note to aid in note identification.
8	SYSTEM_GEN_YN	VARCHAR	No
	Denotes whether a financial assistance note was generated automatically by the system. May contain organization-specific values: No Category Entries: Yes
9	FIN_ASST_CASE_ID	NUMERIC	No
	This item stores the internal ID of the financial assistance case record this note is linked to.