-- Call Detail Reporting Guide -- September 2000 -- Page 11 --
5.0 Call Detail Reporting Data Schema
This section contains:
(1)
Data Schema
, indicating the CDR format supported by AltiGen’s AltiWare OE4.0/Call
Center software release, and defining different database elements (e.g. trunking, first/second
party call answering, time stamps etc.).
(2)
How system configuration affects CDR data.
(3)
Example Call Sequences
and the resulting placement of CDR information.
(4)
Glossary of terms
used in the data schema and in reporting
.
CDR Data Schema
Database Element
Definition
Type
Range and data source
Node ID
Unique server node ID
ULONG
1 –100 : Assigned to an AltiServ
System in the AltiAdmin Client
under -
Session ID Number
Unique session ID on the source
Node
ULONG
A unique number, usually 9 digits
or larger, assigned by AltiWare to
a call.
Link Session Node ID
Reserved ULONG
Link Session ID Num
Reserved ULONG
MoreThan2WG
A flag that shows if a call used more
than 2 workgroups during call
handling
UBYTE
1 – more than two parties spoke
with the caller
0 – two or less parties spoke with
the caller. A party is an extension
or tie trunk.
Transfer Trunk Number
The phone number to which a call
was transferred outside the system;
otherwise, it is empty. This field is
used to show “hop-off” calls as well
(IP tie trunks to hop off calls on
remote systems).
UCHAR
(41)
Target extension phone number, or
up to an 11-digit number if the
phone number is an off-net PSTN
phone number type.
Trunks Section
Trunk Direction
Shows whether this call record is for
an inbound or outbound call type
UBYTE
0 – None (logon/off)
2– Incoming
4 – Outgoing
Remote System Trunk ID
Reserved UCHAR
(16)
Trunk Remote Number
1. Trunk destination number for
outgoing call
2. Caller ID (ANI) for incoming
call
3. IP address of far-end system for
both incoming and outgoing call
UCHAR
(41)
Target extension phone number at
the far end, or up to an 11-digit
number if the phone number is an
off-net PSTN phone number type .
Reserved Field
UCHAR
(21)
DNIS Number
DNIS number user dialed. This is the
number the caller dialed.
UCHAR
(41)
The extension number part of the
DNIS number of in incoming call
as determined by the customer and
configured at central office switch.
Trunk Type
Type of trunk
UBYTE
1 – ANALOG
2 – T1
4 – IP
8 – PRI