beautypg.com

Table 4: agentperwgsummary3, Table 5: agentsummary1 – AltiGen MAXCS 7.0 CDR User Manual

Page 64

background image

Data Schema

60 CDR Manual

Table 4: AGENTPERWGSUMMARY3

Database
Element

Definition

Type

Specification

Version

Version of the record

LONG

2 = OE/ACM 5.0A

NodeID

Server ID (System ID)
assigned to a MAXCS system
in MaxAdmin

LONG

value: 1–100

uid

Unique ID to link to
AGENTPERWGSUMMARY1

LONG

DurLogin

The total time agent was
logged in.

LONG

Table 5: AGENTSUMMARY1

Database
Element

Definition

Type

Specification

Version

Version of the record

LONG

2 = OE/ACM 5.0A

NodeID

Server ID (System ID) assigned to
a MAXCS system in MaxAdmin

LONG

value: 1–100

uid

Unique ID to link to
AGENTSUMMARY2,
AGENTSUMMARY3, and
AGENTSUMMARY4

LONG

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 GMT 1970/01/01
00:00:00.

LONG

GMTOffset

Offset to GMT time, includes
daytime savings, in seconds; ex:
Pacific Summer time 25200

LONG

LocalDay

8 digit number representing date
ex: 20040608 = 06/08/2004

LONG

Format:
yyyymmdd