Data Field Definitions

Data types

The data synthesized and collected in output files is of the following types:

Data Type

Description

etime

Elapsed time. This format is set by the user during output configuration.

long

64-bit integer, from -9223372036854775808 to 9223372036854775807, inclusive

int

32-bit integer, from -2147483648 to 2147483647, inclusive

timestamp

Date and time. This format is set by the user during output configuration.

char

ASCII character string.

long char

ASCII character string that is not limited to a maximum size.

float

Floating-point notation.

boolean

The string "TRUE" or "FALSE"

(Note: For general information on the four data levels, see the Introduction to the Collector.)

Conference data level

The Conference table contains non-participant information relating to the conference as a whole. Field widths are enclosed in parentheses next to the data types.

Field

Description

Data Type

Conference Id (KEY)

A unique conference ID assigned by the ZyrOSS Data Collector. Used as a primary key.

long (12)

Actual Duration

The actual duration time of the conference.

etime (12)

Actual Start Date

The actual start date and time for the conference in Greenwich Mean Time.

timestamp (24)

Billing Code

Touch tone code entered by conference leader for billing purposes. If different codes at participant level, this field is blank, but the Billing Code in the Participant table will be populated.

char (32)

Billing Participant

Name of conference leader who entered Billing Code, if only one did.

char (64)

 Cascade Mode

Conference Cascading Mode

  • None

  • Master

  • Slave

  • Auto

char (8)

 Chair Control

Chairperson control settings

  • Disabled

  • Enabled

char (8)

 Chair Password

The Chairperson password to enter the conference

chair (16)

Conference Entry   Password

The password used to access the conference

char (16)

Conference Name

The conference name harvested from the Polycom MCU.

char (128)

 Conference Type

Type of conference determined by the conference name.

This edit will fail if the conference name is manually modified..

  • Entry Queue - Conf name ends with '(conf id)'

  • Gateway - Conf name ends with '_conf id'

  • On Demand - Conf name begins with 'PNPLCM'

  • Operator - Operator Conf flag set

  • Web Office - Conf name contains an email address format

  • Regular - Conf name does not contain any of the above patterns  

char (12)

 Customer ID

The Customer ID harvested from the Polycom MCU. See Defining MCUs for methods to harvest the Customer ID

char (80)

 Date Collected

The date and time the conference CDR data was collected from the bridge

timestamp (24)

 Date Synthesized

The date and time the conference CDR data was loaded to the embedded database

timestamp (24)

 Dial In Locked

Conference locked to dial in participants. Values are true and false

boolean (6)

 Encryption

Conference encryption setting. Values are true and false

boolean  (6)

End Cause

The reason for the termination of the conference. Possible values:

  • "Conf terminated by operator."

  • "Conf  ended at scheduled end time."

  • "Conf ended automatically when participants disconnected."

  • "Conf terminated by user."

  • "Conf did not start due to scheduled end time elapsing."

  • "Conf could not start due to a problem."

  • "Conf  was ended by MCU reset."

  • "Unknown error."

  • "Unknown:(value)" where the disconnection value returned is not defined.  Ex: Returned value = 43. Disconnection cause = "Unknown:43"

char (64)

 End Cause Code

The numeric conference termination code

int (6)

End Date

The date and time the conference was concluded (Greenwich Mean Time).

timestamp (24)

First Connection Time

The time the first participant connected to the conference

timestamp (24)

GMT Offset

The difference between Greenwich Mean Time and the time zone set on the MCU.

float (9)

Good Cdr Format

If false, indicates that incomplete data was returned by the MCU and some of the values have been extrapolated from what was returned. If true, indicates that the MCU returned a complete description of the conference.

boolean (5)

Last Disconnection Time

The time the past participant disconnected from the conference

timestamp (24)

 Lecture Mode

Lecture Mode setting

  • None

  • Lecture Mode

  • Lecture Show

  • Presentation Mode

char (25)

 Lecturer

The name of the participant selected to be the lecturer

char (80

 Master Name

The name of the participant that acts as a link to the Master Conference

char (80)

Maximum Participants

The maximum number of participants that can connect to the conference, A value of 'Auto' will accommodate the maximum participants that the MCU can connect.

char (10)

Meet Me Per Conference

Meet Me Per Conf setting. Values are true and false.

boolean (6)

MCU Bill Code

A billing code assigned to the conference

char (80)

MCU Conference ID

A Conference ID assigned by either the MCU or the operator. It is unique within a particular MCU.

long (9)

MCU Name

ID for MCU assigned by the user on the "Add/Edit an MCU" page within the ZyrOSS Data Collector.

char (16)

Minimum Participants

Number of undefined parties. The number of participants for which the system reserved resources

int (6)

Number of Audio Participants

The number of audio-only participants in the conference.

int (10)

Number of Participants

The total number of participants in the conference.

int (10)

Number of Video Participants

The number of video participants in the conference.

int (10)

 Numeric ID

A numeric code that uniquely identifies the conference

char (16)

 Operator Remarks

Remarks entered by the operator during the conference

long char

Remarks

Comments entered when the conference is scheduled.

char (300)

Reserved Duration

The time reserved for the conference.

etime (12)

Reserved Start Date

The scheduled start date and time for the conference (Greenwich Mean Time).

timestamp (24)

Restricted Mode

Whether the conference was set to a restricted line rate ("56kbs") or a normal line rate ("64kbs") or "Auto."

char (5)

Total End Point Connection Time

The total of all participants' end point connection time.