HSP_ACCT_BILL_NOTE

Description: |
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.