CODING_CLA_ACTION_HX
Description:
The table contains information about actions taken by users on a query (coding, Clinical Documentation Improvement, or missing doc).

Primary Key
Column Name Ordinal Position
NOTE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier for the note record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 ACTION_USER_ID VARCHAR No
Displays the IDs of all users who have taken action on the query.
4 ACTION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 ACTION_UTC_DTTM DATETIME (UTC) No
This item stores the corresponding time when users take action on the query.
6 ACTION_LOCAL_DTTM DATETIME (Local) No
This item stores the corresponding local time when users take action on the query.
7 CCR_STATUS_AUDIT_C_NAME VARCHAR No
Displays the action taken on the query.
May contain organization-specific values: No
Category Entries:
Query Pending
Query Sent
Response Received
Completed
Deleted
Reassigned
Deactivated
8 ACTION_ACCT_LOC_DTTM DATETIME (Attached) No
The date and time of the user action in the local time zone of the location of the hospital account associated with the query. This is similar to item HNO 41082, which stores the local time zone of the location of the encounter associated with the query. Both items will store identical data except where the time zone of the encounter's location differs from the time zone of the hospital account's location. If the hospital account is combined with an account in another location, this item will be updated to the time zone of the location of the target hospital account.
9 ACTION_END_UTC_DTTM DATETIME (UTC) No
To store the instant when the current action has ended and the next action has started.
10 ACTION_RECIP_USER_ID VARCHAR No
To store the IDs of the users in the recipient list when an action was taken place by either a CDIS/Coder or a provider. In the multiple recipient case, there will be one recipient per line.
11 ACTION_RECIP_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 CCR_USR_ACTION_C_NAME VARCHAR No
To store the action a user takes on a query. A query's status of completed meaning the query has been marked with an outcome of being done.
May contain organization-specific values: No
Category Entries:
Pending
Initial Sent
Response Received
Completed
Deleted
Edited
Deactivated
Replied
13 CCR_USR_SUBACT_C_NAME VARCHAR No
This stores the list of sub-actions that better explains the value in I HNO 41087.
May contain organization-specific values: No
Category Entries:
No
Reassignment