HSP_ACCT_OPERATIVE

Description:

This table contains operative component 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 hospital account containing related operative information.
2	LINE	INTEGER	No
	The line number in the results of a query. Each operative information set will have its own line number.
3	OPER_COMP_C_NAME	VARCHAR	No
	Operative component note type associated with hospital account. i.e. 1-dictated 2-progress note May contain organization-specific values: Yes
4	OPER_PHYSICIAN_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.
5	OPER_DT	DATETIME	No
	Date of operation associated with hospital account.
6	CRIT_MET_C_NAME	VARCHAR	No
	This column stores whether the criteria of the operation associated with the hospital account were met: 1-yes, 2-no, or 3-N/A. May contain organization-specific values: No Category Entries: Yes No N/A