AN_STAFF
Description:
This table contains information about the providers who have been documented as being responsible on an anesthesia record, including their role and begin and end times.

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 VARCHAR No
The unique ID of the provider who is responsible for the anesthesia record.
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_LOCAL_DTTM DATETIME (Local) No
The local date and time when the provider began responsibility for the record.
6 AN_BEGIN_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the provider began responsibility for the record.
7 AN_END_LOCAL_DTTM DATETIME (Local) No
The local date and time when the provider ended responsibility for the record.
8 AN_END_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the provider ended responsibility for the record.
9 AN_EDIT_USER_ID VARCHAR No
The unique ID of the user who documented the responsible staff information.
10 AN_EDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 AN_EDIT_DTTM DATETIME (UTC) No
The date and time when the entry was modified.
12 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.
13 AN_BEGIN_PAT_DTTM DATETIME (Local) No
Contains the start time of the staff member. The time is in the patient department's time zone.
14 AN_END_PAT_DTTM DATETIME (Local) No
Contains the end time of the staff member. The time is in the patient department's time zone.