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.

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.

Tip
To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

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 (for DB2Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
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
This page was last edited on January 10, 2020, at 15:27.
Comments or questions about this documentation? Contact us for support!