HSP_ACCT_NOTES

Description:

This table contains hospital account notes information from the Notes (HNO) master file. The table includes information about guarantor, patient, hospital account, and hospital liability bucket the note is associated with.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	This column stores the unique identifier for the note record associated with a hospital account.
2	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account for which the account note was entered.
3	NOTE_ENTRY_USER_ID	VARCHAR	No
	This column stores the unique identifier for the user who entered an account note associated with the hospital account.
4	NOTE_ENTRY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	NOTE_ENTRY_DT_TIME	DATETIME (Local)	No
	The date and time an account note was entered for a hospital account.
6	BUCKET_ID	NUMERIC	No
	Hospital Liability Bucket linked to this note
7	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 EB Payer Rationale Reg Financial Assistance Letter Reg Financial Assistance Tracker Note Reg Financial Assistance Case Note Prescription Appeal Letter CCM Concurrent Auth Denial Comment CCM Concurrent Auth Appeal Letter
8	HAR_NOTE_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the guarantor associated with the hospital account. It is only populated for hospital account-level notes.