AN_STAFF_AUDIT
Description:
This table contains the audit trail data for the anesthesia responsible staff activity. It contains a list of all the edits made to the information.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique identifier for the Episode.
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 AN_PROV_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.
4 AN_PROV_TYPE_C_NAME VARCHAR No
The anesthesia staff type category number for the provider's responsible role.
May contain organization-specific values: Yes
5 AN_BEGIN_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the provider began responsibility for the record.
6 AN_END_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the provider ended responsibility for the record.
7 AN_EDIT_USER_ID VARCHAR No
The unique ID of the user who documented the responsible staff information.
8 AN_EDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 AN_EDIT_DTTM DATETIME (UTC) No
The date and time when the entry was modified.
10 AN_EDIT_LN INTEGER No
The line number from the anesthesia staff audit trail table that contains the previous information on this staff member's responsibility.
11 AN_DELETED_YN VARCHAR No
Indicates whether the responsible entry this value contains was deleted from the anesthesia staff table.
May contain organization-specific values: No
Category Entries:
No
Yes