beautypg.com

Records and data schema, Search results, Hapter – AltiGen MAXCS 7.5 CDR User Manual

Page 51

background image

CDR Manual 47

Re
co
rd
s an

d

Data S

c

hema

C

H A P T E R

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 / Group CDR Search Results: Summary

Window

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: One call may have multiple CDR records logged.

Therefore, the number of records may not match
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” for
explanations of these fields)

This is shown in “Summary (CDR Search and Group CDR Search)”