Specifications

Call Detail Record Reports
C – 50 ShoreTel, Inc.
Connect Table
The Connect table contains a record for each party in a call. There are many different
types of parties that can be reflected in the table including individual user extensions,
workgroups, workgroup agents, and trunks.
The following flow chart illustrates how new entries are added to the Connect table
each time a party is added to a call within the ShoreTel system.
Figure C-21 New Entries in the Connect Table
Field Name Data Type Description
ID AutoNumber Unique identifier. (4-byte integer, required)
PartyType Number See Party Type enumeration below. (1-byte integer, required)
CallTableID Number Link to Call Table ID Key. (4-byte integer, required)
LineID Number TAPI permanent line ID for this party. (4-byte integer, required)
SwitchID Number Switch ID for this party. A unique ID assigned to the ShoreGear
switch by the configuration database. This information is only
visible in the database and not available through ShoreWare
Director. (4-byte integer, required).
The number is 0 if the party is a workgroup, voice mail, or an
unassigned user (in all these cases, such DNs are not assigned to
a specific switch/port).