beautypg.com

AltiGen MAXCS 7.0 CDR User Manual

Page 68

background image

Data Schema

64 CDR Manual

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 daytime
savings, in seconds; ex:
Pacific Summer time
25200

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

SessionID

Session ID: a unique
number, usually 9 digits
or larger, assigned by
MAXCS to a call

LONG

SequenceID

A unique number to
identify multiple records
of same call (same
Session ID), beginning
with 0

LONG

TrunkCall

Trunk call or external
call

LONG

1=Internal
2=Trunk Call

Direction

Direction of the call
(incoming or outgoing)

LONG

1=Incoming
2=Outgoing

OriginalPriority

The first priority set by
the system for this call
(1-9)

LONG

Database Element Definition

Type

Specification