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.