HSP_ACCT_ABSTS_HX

Description:

Stores the history of changes to the abstract status.

Primary Key

Column Name	Ordinal Position
HSP_ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCT_ID	NUMERIC	No
	The hospital account ID with related abstracting status history information.
2	LINE	INTEGER	No
	The line number in the results of a query. Each coding history will have its own line number.
3	ABSTS_HX_STS_C_NAME	VARCHAR	No
	The abstract status category ID. May contain organization-specific values: Yes Category Entries: Not Started In Progress Waiting Completed Ready To Start On Hold
4	ABSTS_HX_UTC_DTTM	DATETIME (UTC)	No
	This column stores the abstracting status changed instant in Coordinated Universal Time (UTC). Data will not exist in this column for abstracting statuses created before UTC instant tracking was enabled for abstracting history.
5	ABSTS_HX_ASGN_USER_ID	VARCHAR	No
	Item to store abstracting assigned user changes
6	ABSTS_HX_ASGN_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.