fctcalls

Fact table delivering detailed insight on calls.

Table 1. fctcalls table
Column Description Example
TenantID

int

This field is for future use only, and is currently set to 0.

 
TenantName

varchar

This field is for future use only, and is currently set to blank.

 
CallerDeviceID

varchar

Displays the MAC address of the calling device. For telephone calls, this may be the name or extension of the caller.

ddd01fbf328c
CallerDeviceType

varchar

Displays the device type.

Android
CallerDeviceVersion

varchar

Displays the device version.

Android VCS
CallerId

varchar

Displays the internal Vocera Voice Server caller user id. If the caller is a telephone or extension, this displays the calling number.

u-jsmith
CallerName

varchar

Displays the caller name specified in the Vocera Voice Server. For a telephone, this displays the calling number.

JSmith
CallerDisplayName

varchar

Displays the caller display name in "Lastname, Firstname" format. For a telephone, this displays the calling number.

Smith, John
CallerUserSite

varchar

Displays the user home site of the caller.

MyCallerSite
CallType

varchar

Displays the call type (for example: Unicast, Multicast).

Unicast
CallToType

varchar

Displays the entity that the call is going to (for example: Address Book, Broadcast, Buddy, Group, Telephone, User).

Address Book
CallId

bigint

Displays the call id.

85390967418
PartyNumber

int

When calling to a group, this field displays the order in which members of the group are called. The first member called will have a party number of 1, the second will be 2, and so on.

1
LastParty

tinyint

Indicates whether this group member being called is the last party involved in a group call. Set to 1 if the user is last party involved. For others, it will be set to 0. If CallToType is Broadcast this will be set to 0 for all users. If CallToType is User, it will be 1.

0
ReceiverDeviceId

varchar

The MAC address of the receiver. In telephone calls, this can be the name or extension number.

0009ef345661
ReceiverDeviceType

varchar

Displays the device type for the receiver.

Badge
ReceiverDeviceVersion

varchar

Displays the device version for the receiver.

B3000N
ReceiverId

varchar

Displays the receiver userid.

u-jsmith
ReceiverName

varchar

Displays the receiver user name specified in the Vocera Voice Server.

JSmith
ReceiverDisplayName

varchar

Displays the display name for the receiver in the format "Lastname, Firstname".

Smith, John
ReceiverUserSite

varchar

Displays the user home site for the receiver.

MyReceiverSite
ReceiverGroupId

varchar

Displays the internal group id for the receiver. This field is used in group calls and multicasts only.

g-engineering
ReceiverGroupName

varchar

Displays the group name for the receiver. This field is used in group calls and multicasts only.

Engineering
CallDurationSS

int

Displays the call duration in seconds.

92
TalkingDurationSS

int

Displays the talking duration in seconds, or null if there was no talking in the call.

89
DialingDuration

int

Displays the dialing duration. This field is currently not used in any dashboards.

 
InitiatedAcceptedDuration

int

Displays the initiation accepted duration in seconds.

2
InitiatedAt

timestamp

Displays the date and time on which the call was initiated.

2017-11-17 17:12:53
StartedAt

timestamp

Displays the date and time at which the server interrupted the user.

2017-11-17 17:12:54
ReachedAt

timestamp

Displays the date and time at which the receiver was reached. This is normally the time in the InitiatedAt field plus the number of seconds specified in the InitiatedAcceptedDuration field.

2017-11-17 17:14:53
UnavailableAt

timestamp

If the caller is unavailable or has rejected the call, the date and time at which the receiver was unavailable. If the caller is available, this field is null.

2017-11-17 17:14:53
UnavailableReason

varchar

Displays the reason for unavailability. Examples: Call rejected, Not online. If the receiver is available, this field is set to Available.

Not online
AcceptedAt

timestamp

The date and time at which the call was accepted. If the receiver was not available, this field is null.

2017-11-17 17:14:53
AbortedAt

timestamp

If the call was aborted by the caller, the date and time at which this happened. If the call was not aborted, this field is null.

2017-11-17 17:14:53
AbortReason

varchar

Displays the reason why the call was aborted.

Canceled
FinishedAt

timestamp

The date and time at which the call was finished.

2017-11-17 17:14:53
BatchId

int

This field is for future use only, and is currently set to 0.

 
RowCreatedTS

timestamp

The date and time when this table row was created.

2017-12-06 00:16:35
RowUpdatedTS

timestamp

The date and time when this table row was updated, or null if it has not been updated.

2017-12-06 00:16:35
Priority

varchar

Specifies the call priority (for example: normal, urgent).

normal
TotalOnHoldCount

int

Displays the number of times that the call was put on hold.

1
TotalOnHoldDuration

int

Displays the total amount of on hold time in seconds.

13
CallerDeviceSite

varchar

Displays the site of the caller device.

MyDeviceSite
CallerDeviceSerialNo

varchar

Displays the serial number of the caller device.

K5EB16313222
ReceiverDeviceSite

varchar

Displays the site of the receiver device.

MyReceiverSite
ReceiverDeviceSerialNo

varchar

Displays the serial number of the receiver device.

H4AA15300EF4
DisconnectedAt

timestamp

The date and time that the receiver disconnected the call or broadcast.

2017-12-06 00:16:35
CallerSite

varchar

Displays the site where the caller placed the call or broadcast.

MyCallerSite
CallerAccessPoint

varchar

Displays the caller access point.

707db95e2461
CallerLocation

varchar

Displays the caller location.

Operations
CallerDepartments

varchar

Displays a comma-separated list of caller department ids. Set to Unknown if the caller is not part of any department.

g-operations
ReceiverSite

varchar

Displays the site where the receiver received the call.

MyReceiverSite
ReceiverAccessPoint

varchar

Displays the receiver access point.

707db9767761
ReceiverLocation

varchar

Displays the receiver location.

Engineering
ReceiverDepartments

varchar

Displays a comma-separated list of receiver department ids. Set to Unknown if the receiver is not part of any department.

g-tech_support
ReceiverGroupDepartments

varchar

For group calls and broadcasts, displays a comma-separated list of receiver group departments, or Unknown if there are no departments. For other calls, this is null.

g-tech_support