VOIP_AUDIT_ACTIONS
Description:
The audited actions for VoIP call logs.

Primary Key
Column Name Ordinal Position
VIDEO_VISIT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 VIDEO_VISIT_ID NUMERIC No
The unique identifier (.1 item) for the video visit 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 VOIP_AUDIT_ACTION_C_NAME VARCHAR No
The single audit action for a VoIP call log.
May contain organization-specific values: No
Category Entries:
Unknown
Connection
Disconnection
Participant Added
Did Not Connect
Call Initiated
Unknown
4 PARTICIPANT_GUID VARCHAR No
This item stores the participant GUIDs of each participant connected to the call.
5 VOIP_USER_ID VARCHAR No
This item stores the EMP ID associated with the participant in the call.
6 VOIP_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 VOIP_ACTION_INST_DTTM DATETIME (UTC) No
The instant of the audit action.
8 DID_NOT_CONN_RSN_C_NAME VARCHAR No
The reason the participant did not connect to the call.
May contain organization-specific values: No
Category Entries:
None
Busy
No Answer
Canceled
No Device Registrations
Emergency Call Misdial
Unknown
9 ADD_BY_PARTICIPANT_GUID VARCHAR No
The participant GUID of the participant that added the participant to the call.
10 VOIP_CLIENT_APP_TARGET_C_NAME VARCHAR No
This item stores the Epic application used to make/receive the call for the participant.
May contain organization-specific values: Yes
Category Entries:
Hyperspace
Canto
Haiku
Rover
Epic Monitor
MyChart Mobile
MyChart Bedside Tablet
MyChart Bedside TV
Limerick
MyChart Bedside Whiteboard
MyChart
EpicCare Link
Home Health
FMK Administration Reconciliation
BCA Web
Video Visit Direct Join Link
Video Visit Direct Join Link - SMS
Video Visit Direct Join Link - Email
11 VOIP_PHONE_NUMBER VARCHAR No
The number that was dialed to reach the participant in the call.
12 AVB_STATUS_C_NAME VARCHAR No
Availability status for VoIP audit actions.
May contain organization-specific values: No
Category Entries:
Available
Busy
Unavailable
Do Not Disturb
Offline
13 IS_USER_FORWARDING_YN VARCHAR No
Call forwarding flag for VoIP audit actions.
May contain organization-specific values: No
Category Entries:
No
Yes
14 ACTION_LOCAL_DTTM DATETIME (Attached) No
The instant of the audit action in local time.
15 CALL_RESULT_C_NAME VARCHAR No
Call result for VoIP audit actions.
May contain organization-specific values: No
Category Entries:
Answered
Declined
Missed
Dropped
16 PARTICIPANT_TYPE_C_NAME VARCHAR No
The type of connection for participant in the call, such as an Epic device or external phone.
May contain organization-specific values: No
Category Entries:
Epic Device
Phone Number
Directory Number
Phone Number over SIP
Unknown
17 RESOLVED_PHONE_NUMBER VARCHAR No
The number that was used to route the call to the participant.
18 RESOLVED_SIP_ADDRESS VARCHAR No
The SIP address that was used to route the call to the participant.