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.