fctrecresults

Stores speech recognition results.

Table 1. fctrecresults table
Column	Description	Example
TxMillis	`bigint` Gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date	`1507520264332`
TxDateTime	`datetime` Stores the date and time of the event, accurate to the second.	`2017-10-08 20:37:44`
TxDate	`dateL` Stores the date of an event, accurate to the day.	`2017-10-08`
UserType	`varchar` Specifies which type of user uttered the speech. Example values: User, Phone	`User`
UserID	`varchar` Specifies the user ID of the person who uttered the speech. When the UserType value is User, this value is either a User ID specified via the Administration Console or the User Console on the Vocera Voice Server.	`JSmith`
UserSite	`varchar` In a multi-site installation, the UserSite column specifies the Vocera site with which the user is associated.	`VCSLoadSite`
BadgeMACAddr	`varchar` Specifies the badge MAC address.	`bbbb00000040`
APMACAddr	`varchar` Specifies the MAC address of the wireless access point with which the badge was associated when this speech recognition event happened.	`557557557557`
RecStatus	`varchar` Specifies the recognition status of the utterance. Example values: Recognized, Rejected, NoSpeech	`NoSpeech`
Score	`int` Specifies the recognition score for the utterance. Values range from 0 to 100.
Recognized	`varchar` Specifies the speech that was recognized by the Vocera system. Example values: WhereIs Randy Floren, Call Chris Long, Yes, LogOut
Grammar	`varchar` The type of speech grammar. Examples include yesorno, singlename, mainmenu, phonenumber, spelledname, messageaction, and messageresponse.	`yesorno`
DeviceType	`varchar` The type of the device that has initiated contact with the Genie.	`Badge`
IdGenie	`bigint` Identifies a Genie session. A single Genie session may comprise several events. For example, a Genie session for a badge-to-badge call may include the "Vocera" prompt played on the calling party's badge and the "Can you talk to ..." prompt played on the caller's badge.	`6540`
UserUID	`varchar` Specifies the Vocera Voice Server user internal ID.	`u-jsmith`
userDisplayName	`varchar` Specifies the user Display Name of the person who uttered the speech. When the UserType value is User, this value is either a User LastName, FirstName specified via the Administration Console or the User Console on the Vocera Server.	`Smith, John`
UserDepartments	`varchar` Displays a comma-separated list of the internal ids of the user departments. This is Unknown if the user is not part of any department.	`g-operations`
DeviceVersion	`varchar` Displays the user's device version. Example values are B3000N, Android VCS, Apple VCS.	`B3000N`
owningGroupID	`varchar` Displays the ID of the device's owning group.	`g-engineering`
owningGroupName	`varchar` Displays the group name of the device's owning group.	`Engineering`
owningGroupDepartments	`varchar` Specifies the owning group departments.	`g-engineering`
owningGroupSite	`varchar` Specifies the Vocera site with which the owning group is associated.	`MyGroupSite`