Pronexus Application Console Database Environment

The Slaves Table

The Slave table contains information related to each application administered (mastered) by the Pronexus Application Console . There is a one-to-many relationship between the Slaves table and the Calls table.

Name

Type

Description

Slave ID

Long

Unique identifier

Slave Name

String

Name of the slave

Rule Type

Byte

I - DNIS, 2 - ANI, 3 - Fixed Lines, 4 - All, 0 - not configured

Rule Mask

String

Comma delimited parameters of the rule (DNIS values, ANI numbers or line ranges)

The Calls Table

The Calls table contains one record for every call received by the Application Console. Calls handled specifically by the Application Console have the Slave ID field set to -1. ANI and DNIS values are written (if available) regardless of the rule used by the handling slave.

Name

Type

Description

CallID

Long

Unique identifier

SlaveID

Long

Foreign key (Slave table) - the slave that handled the call

Start Time

Date

Date and Time when call started

Duration

Integer

Length of the call in seconds

Channel

Integer

Line carrying the call

ANI

String

Phone number calling in

DNIS

String

Called number identifier

MaxChannel

Integer

Number of channels in use

User 1

String

User defined value

User 2

String

User defined value

User 3

String

User defined value

User 4

String

User defined value

User 5

String

User defined value

The Events Table

Periodically, significant events occur with each application (such as slave starts, slave stops, all lines busy, certain error conditions). As these occur, records are written for display on the Event Log Report. If the event is directly related to the Application Console, the Application field is set to "Master".

Name

Type

Description

Event ID

Long

Unique identifier

Application

String

Slave Application (or "Master") responsible for the event. A Foreign Key to the slave table cannot be used in case a slave name is not registered.

Event Time

Date

Date and Time when call started

Comment

String

Description of event