HSP_ACCT_LETTERS

Description:

This table contains hospital billing letters information from the Notes (HNO) master file.

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.
2	LETTER_SENT_DATE	DATETIME	No
	The date the letter was sent.
3	LET_CREATE_USER_ID	VARCHAR	No
	This column stores the unique identifier for the user who created the letter.
4	LET_CREATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the guarantor account that is associated with this letter. This is only populated for letters sent at the guarantor account level.
6	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account that is associated with this letter. This is only populated for letters sent at the hospital account level.
7	BUCKET_ID	NUMERIC	No
	This column stores the unique identifier for the liability bucket that is associated with this letter. This is only populated for letters sent at the liability bucket level.