Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Table GO_Metrics


This table contains the current and latest values of pre-calculated OCS metrics. Records are inserted at the time ICON receives metric information. The information includes the specified type the first time that the combination of objects is specified. The record is updated each time ICON receives changes to metric data.

Refer to Integration with Outbound Contact in the Interaction Concentrator User's Guide for a description of the pre-calculated metrics that ICON stores for OCS.

Column List

Legend

Column Data Type P M F Description

ID

numeric(16) X X The unique, autonumbered ID of this record. This is the primary key.

SessID

varchar(64) The unique identifier of the Campaign processing attempt. If a campaign has been unloaded and then reloaded, OCS assigns a new SessionGUID. Same as GO_CAMPAIGN.SESSID.

CallingListID

int The DBID of the Calling List object in the Configuration database. This ID cannot be changed during chain processing. Same as GO_CHAIN.CALLINGLISTID.

ChainGUID

varchar(64) The unique identifier of the chain processing attempt, as reported by OCS. This ID cannot to be changed during chain processing. Same as GO_CHAIN.CHAINGUID.

CallAttID

varchar(64) The CallAttemptGUID generated by OCS for the last voice call that OCS tried to produce during the chain processing attempt. Same as GO_CHAIN.LASTCALLATTID.

OCSID

int The DBID of the configured OCS application that reported activity related to this metric.

RecordHandle

int The RecordHandle of the record that OCS used in the last chain processing attempt. Same as GO_CHAIN.RECORDHANDLE.

ResID1

varchar(64) Reserved

ResID2

varchar(64) Reserved

Type

int X The type of metric. One of the following values:
  • 0—GOMetricTypeUndefined–Reserved.
  • 1—GOMetricTotalRecsPerList–Total number of physical records in the calling list database view (that is, the database table + an optional WHERE clause from the dialing filter).
  • 2—GOMetricTotalRecsPerCampGr–Total number of physical records in all database views (see above) whose calling lists are assigned to the campaign participating in the campaign group.
  • 3—GOMetricTotalChainsPerList–Total number of logical chains in the calling list database view (that is, the database table + an optional WHERE clause from the dialing filter). A logical chain is defined as one or more database table records bearing the same Chain ID value.
  • 4—GOMetricTotalChainsPerCampGr–Total number of logical chains in all database views (see above) whose calling lists are assigned to the campaign participating in the campaign group.
  • 5—GOMetricCurrRecsNotProcPerList–Current number of physical records in the calling list database view (that is, the database table + an optional WHERE clause from the dialing filter) which have type GENERAL and status READ.
  • 6—GOMetricCurrRecsNotProcPerCampGr–Current number of physical records in all database views (see above) which have type GENERAL and status READY, whose calling lists are assigned to the campaign participating in the campaign group.
  • 7—GOMetricCurrChainsNotProcPerList–Current number of logical chains in the calling list database view (that is, the database table + an optional WHERE clause from the dialing filter) where at least one record of the chain has type GENERAL and status READY. Logical chain is defined as one or more database table records bearing the same Chain ID value.
  • 8—GOMetricCurrChainsNotProcPerCampGr–Current number of logical chains in all database views (see above) where at least 1 record of the chain has type GENERAL and status READY, and whose calling lists are assigned to the campaign participating in the campaign group.
  • 9—GOMetricCurrUsedPortsPerCampGr–Current number of busy (currently occupied for placing outbound calls) CPD Server ports or Switch call classifier ports.
  • 10—GOMetricCurrUsedEngPortsPerCampGr–Current number of ports used by engaged calls placed by CPD Server. Calculated only for campaign groups activated in ASM dialing modes with CPD Server.
  • 11—GOMetricDetailCallsOverdialed–The metric shows that the given call is considered to be overdialled by Outbound Dialing Engine.
  • 12—GOMetricTimeOutboundCallDialing–Dialing Duration (in msec). Calculated by OCS for each outbound call.
  • 13—GOMetricTimeOutboundCallTransfer–Call Transfer Duration (in msec). Calculated by OCS for each outbound call.
  • 14—GOMetricTimeOutboundCallCPD–Post-connect Call Progress Detection Duration (in msec). Calculated by OCS for each outbound call.


#DICTIONARY TYPE 77

Value

int X The OCS-provided value for the corresponding statistic type.

Seq

int The sequence number of the metric for the same object.

USeq

int Reserved

Added

datetime X The GMT-equivalent date and time when the value of the metric was reported by OCS.

Added_ts

int The UTC-equivalent value of the ADDED field. Milliseconds are truncated.

Added_tcode

int A reference, derived from the value of the ADDED_TS field, to a record in the G_TIMECODE table.

GSYS_DOMAIN

int Contains the data source session ID (DSS_ID) for the session that was active when the data was processed by ICON. For more information, see the description in System Fields.

GSYS_PARTITION

int Key used for partitioning.

GSYS_SYS_ID

int System ID. Reserved for future use.

GSYS_SEQ

bigint Insert Sequence. Not unique.

GSYS_USEQ

bigint Update Sequence. Not unique.

GSYS_TS

datetime Reserved

GSYS_TC

int Reserved

GSYS_EXT_VCH1

varchar(255) Reserved

GSYS_EXT_VCH2

varchar(255) Reserved

GSYS_EXT_INT1

int Reserved

GSYS_EXT_INT2

int Reserved

   

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 31 October 2016, at 16:01.