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.