Specifications

Records and Data Schema
CDR Manual 75
Records and
Data Schema
StartTime GMT start time of record’s period.
Seconds since 1970/01/01
00:00:00
LONG
EndTime GMT end time of record’s period.
Seconds since 1970/01/01
00:00:00
LONG
GMTOffset Offset to GMT time, includes
daylight savings, in seconds; ex:
Pacific Summer time 22500
LONG
LocalDay 8 digit number representing date
ex: 20040608 = 06/08/2004
LONG Format:
yyyymmdd
DayOfWeek Day of the week LONG 0 = Sunday
1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
WGNum Workgroup Number LONG
NumInWGCall Total inbound WG call during
interval
LONG
NumInCallInQ Total calls in queue during interval LONG
DurInCallQ Total queue duration during time
interval for all WG inbound calls
LONG
NumInAnswered Total WG inbound calls answered
by agents during interval. If a login
agent uses pick call from queue
feature in AltiAgent, this counter is
incremented. If the call is
transferred or parked, this call is
considered out of workgroup.
LONG
DurInTalk Talk duration of incoming calls
(NumInAnswered), starting from
the time an agent answered a call
until the call is disconnected,
transferred or parked
LONG
Database
Element
Definition Type Specification