HSP_ACCT_EVENTS

Description: |
This table contains hospital account events 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 |
The ID number of a hospital account.
2 | LINE | INTEGER | No |
The line number in the results of a query. Since multiple procedure events can be stored in a hospital account, each event will have a unique line number.
3 | EVENT_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
4 | EVENT_DATE | DATETIME | No |
The procedure event date stored in a hospital account.
5 | EVENT_COMMENT | VARCHAR | No |
A comment associated with a procedure event stored in a hospital account.
6 | ASA_CLASS | INTEGER | No |
An American Society of Anesthesiologists (ASA) class (numeric) associated with a procedure event stored in a hospital account.
7 | ANESTH_TYPE_HA_C_NAME | VARCHAR | No |
The anesthesia type associated with a procedure event stored in a hospital account.
May contain organization-specific values: Yes
Category Entries:
General
Local
Regional
Epidural
None
Spinal
IV Sedation
Topical
Other
8 | ANESTH_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
9 | ICU_HOURS | INTEGER | No |
The number of ICU hours associated with the procedure event.
10 | CCU_HOURS | INTEGER | No |
The number of CCU hours associated with the procedure event.