This table contains hospital account billing notes from the Hospital Accounts Receivable (HAR) master file.
Primary Key
Column Name
Ordinal Position
HSP_ACCOUNT_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
HSP_ACCOUNT_ID
NUMERIC
No
This column stores the unique identifier for the hospital account.
2
LINE
INTEGER
No
This column stores the line number in the results of a query. As multiple billing notes can be placed on one hospital account, each billing note will have a unique line number.
3
BILLING_NOTE
VARCHAR
No
The text of a billing note associated with the hospital account.