Specifications

CDR Manual 45
Records and
Data Schema
C HAPTER 5
Records and Data Schema
This section contains explanations of the CDR search results records,
including the data schema.
Important!
In order to reduce the storage space of the database, records with all zero
files are not written to the database.
Search Results
This section explains the fields in all the CDR Search results windows.
CDR Search and Group CDR Search Results Windows
Summary Window
Shown in “Summary (CDR Search and Group CDR Search)” on page 18
Field Definition
ID Number assigned by CDR Search to this record
Time/Extension/
Workgroup/
Trunk/Date
Start time for this record, if sorting by Time; Extension for this
record, if sorting by Extension; Workgroup for this record, if
sorting by Workgroup; Trunk for this record, if sorting by
Trunk; Date for this record, if sorting by Date.
Total Records Total CDR records of the type searched for.
Note: Please note that one call may have multiple CDR
records logged. Therefore, the number of records may
not match with the number of calls in WG Statistics
screens.
Total Duration Sum of duration of the calls in the records, where duration lasts
from Start Time to End Time (see “Record Window for “Call
Info”” on page 47 for explanations of these fields)