- Contents
Interaction Report Assistant User's Guide
11. Voicemails (Tracker)
The Voicemails (Tracker) package is available with the I3_ACCESS_TRACKER license. This package allows you to run reports that are compiled from Tracker data. Voicemails (Tracker) reports show voicemails left for each Tracker Contact and the user for which the voicemail was left.
The records for this package are stored in the following database tables: IntxSegment (ix), Intx_Participant (ixp), Individual (i), IndivAddress (ia).
Voicemails (Tracker) Report Fields |
||
---|---|---|
Friendly name |
Field name/Table |
Description |
Site ID |
ix.siteId |
The identifier of the site a voice mail interaction belongs to |
Voicemail ID |
ix.IntxID |
The unique identifier of a voice mail interaction |
Voicemail DateTime |
ix.StartDateTime |
The originating date and time of the voice mail displayed in local date/time |
Voicemail Date |
Computed Expression |
The originating date of the voice mail |
Voicemail Time |
Computed Expression |
The originating time of the voice mail |
Voicemail Duration |
ia.FldVal |
The duration of the voice mail left by the tracker contact |
Interaction Duration |
ix.Duration |
The whole duration of the interaction |
IC User ID |
i1.ICUserID |
The user identifier of the IC user who received the voice mail |
IC User First Name |
i1.FirstName |
The first name of the IC user who received the voice mail |
IC User Last Name |
i1.LastName |
The last name of the IC user who received the voice mail |
IC User Display Name |
ixp1.DisplayName |
The display name defined for the IC user who received the voice mail |
IC User Street Address |
ia1.StreetAddress |
The street address of the IC user who received the voice mail |
IC User City |
ia1.City |
The city of the IC user who received the voice mail |
IC User State |
ia1.State |
The state of the IC user who received the voice mail |
IC User Zip code |
ia1.zip |
The zip code of the IC user who received the voice mail |
IC User Country |
ia1.Country |
The country of the IC user who received the voice mail |
Contact First Name |
i2.FirstName |
The first name of the tracker contact who left the voice mail |
Contact Last Name |
i2.LastName |
The last name of the tracker contact who left the voice mail |
Contact Display Name |
ixp2.DisplayName |
The display name of the tracker contact who left the voice mail |
Contact Street Address |
ia2.StreetAddress |
The contact street of the tracker contact who left the voice mail |
Contact City |
ia2.City |
The city of the tracker contact who left the voice mail |
Contact State |
ia2.State |
The state of the tracker contact who left the voice mail |
Contact Zip code |
ia2.zip |
The zip code of the tracker contact who left the voice mail |
Contact Country |
ia2.Country |
The country of the tracker contact who left the voice mail |