Download Call Detail Reporting Manual

Records and Data Schema
Table 11: WGSUMMARY
Database Element
Definition
Type
Specification
Version
Version of the record
LON
G
2 = OE/ACM
5.0A
NodeID
Server ID (System ID)
assigned to a MAXCS
system in MaxAdmin
LON
G
value: 1–100
StartTime
GMT start time of record’s
period. Seconds since
1970/01/01 00:00:00
LON
G
EndTime
GMT end time of record’s
period. Seconds since
1970/01/01 00:00:00
LON
G
GMTOffset
Offset to GMT time,
includes daylight savings, in
seconds; ex: Pacific
Summer time 22500
LON
G
LocalDay
8 digit number representing
date
ex: 20040608 = 06/08/2004
LON
G
Format:
yyyymmdd
0 = Sunday
1 = Monday
2 = Tuesday
DayOfWeek
Day of the week
LON
G
3 = Weds
4 = Thursday
5 = Friday
6 = Saturday
Workgroup Number
LON
G
NumInWGCall
Total inbound WG call
during interval
LON
G
NumInCallInQ
Total calls in queue during
interval
LON
G
DurInCallQ
Total queue duration during
time interval for all WG
inbound calls
LON
G
Records and
Data Schema
WGNum
CDR Manual 73