| Database Schema Tables / Summary Tables | |
This summary table aggregates daily data from the fctrecresults table: recognized, rejected, and other speech items, and speech, non-speech, and total counts, grouped by user's Vocera Voice Server Site and Department.
| Column | Description | Example | 
|---|---|---|
| Txdate | date The date of the aggregated data.  | 
		2017-10-08 | 
| Site | varchar The Vocera Voice Server user's home site.  | 
		MySiteName | 
| Unit | varchar A comma-separated list of the user's department ids.  | 
		g-engineering,g-office | 
| Recognized | int The number of recognized speech items.  | 
		20 | 
| Rejected | int The number of rejected speech items.  | 
		1 | 
| Others | int The number of speech items that were neither recognized nor rejected.  | 
		0 | 
| speechAttempts | bigint The total number of detected speech attempts.  | 
		21 | 
| NoSpeech | int The number of attempts where no speech was detected.  | 
		1 | 
| TotalAttempts | bigint The total number of attempts. This should be the sum of the speechAttempts and NoSpeech fields.  | 
		22 |