HSP_ACCT_AR_AC_SUM

Description: |
This table contains the archived account summary information 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 archived hospital account.
2 | LINE | INTEGER | No |
The line number in the results of a query. Each account archive summary will have its own line number.
3 | ARCHIVE_ACCT_SUMM | VARCHAR | No |
The archived account summary for the hospital account.