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
Hold Initiated
Hold Ended
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
All SIP Routes Unreachable
Directory Number Not Found
Vendor Operation Error
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
Welcome
EpicCare Link
Background Process
Agent Factory
External To Epic
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 attempting to reach the participant in the call. It can contain keypad characters like * and # in addition to digits.
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.
19 | VOIP_ADDED_REASON_C_NAME | VARCHAR | No |
Reason why participant of the call was added.
May contain organization-specific values: No
Category Entries:
Initial Dial
Transfer
Conference
Unknown