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	bigserial	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	integer				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	integer				The DBID of the configured OCS application that reported activity related to this metric.
RecordHandle	integer				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	integer		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	integer		X		The OCS-provided value for the corresponding statistic type.
Seq	integer				The sequence number of the metric for the same object.
USeq	integer				Reserved
Added	timestamp		X		The GMT-equivalent date and time when the value of the metric was reported by OCS.
Added_ts	integer				The UTC-equivalent value of the ADDED field. Milliseconds are truncated.
Added_tcode	integer				A reference, derived from the value of the ADDED_TS field, to a record in the G_TIMECODE table.
GSYS_DOMAIN	integer				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 DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
GSYS_PARTITION	integer				Key used for partitioning.
GSYS_SYS_ID	integer				System ID. Reserved for future use.
GSYS_SEQ	bigint				Insert Sequence. Not unique.
GSYS_USEQ	bigint				Update Sequence. Not unique.
GSYS_TS	timestamp				Reserved
GSYS_TC	integer				Reserved
GSYS_EXT_VCH1	varchar(255)				Reserved
GSYS_EXT_VCH2	varchar(255)				Reserved
GSYS_EXT_INT1	integer				Reserved
GSYS_EXT_INT2	integer				Reserved