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_Campaign


This table contains current information about a Campaign, as reported by OCS. Records are inserted into this table when the first OCSD event that is related to campaign processing attempts is received from OCS. The record is updated each time that information about changes to Campaign state or Campaign properties are received from OCS.

Refer to Outbound Objects and Models in the Interaction Concentrator User's Guide for a graphic illustrating the Genesys Campaign Finite State Machine.

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) X The unique identifier of the Campaign processing attempt. If a campaign has been unloaded and then reloaded, OCS assigns a new SessionGUID.
CampaignID integer X The DBID of the Campaign configuration object that OCS uses for the Campaign processing attempt.
GroupID integer X The DBID of the Campaign Group configuration object.
State integer X The current state of the campaign according to the Campaign FSM (finite state machine). One of the following values:
  • null—terminated
  • 1—loaded
  • 2—started
  • 3—unloading


#DICTIONARY TYPE 71

OCSID integer X The DBID of the OCS Server application in the Configuration database. The Campaign running on this instance of OCS.
DialMode integer The running mode of the campaign as reported by OCS.
OptimMode integer The optimization mode of the campaign with OCS running.
OptimValue integer The value of the optimization parameter used by OCS in this campaign.
GeneralN integer The numerical value of the priority parameter that OCS uses for general records in this campaign.
GeneralW integer The weight of the priority parameter value for general records that OCS uses in this campaign.
SchedN integer The numerical value of the priority parameter that OCS uses for scheduled records within this campaign.
SchedW integer The weight of the priority parameter value that OCS uses for scheduled records within this campaign.
CallBackN integer The numerical value of the priority parameter that OCS uses for the callback records in this campaign.
CallBackW integer The weight of the priority parameter value for callback records that OCS uses for this campaign.
Created datetime X The GMT-equivalent date and time that the campaign was loaded, as reported by OCS.
Created_ts integer The UTC-equivalent value of the CREATED field. Milliseconds are truncated.
Created_tcode integer A reference, derived from the value of the CREATED_TS field, to a record in the G_TIMECODE table.
Terminated datetime The GMT-equivalent date and time when the campaign was unloaded, as reported by OCS.
Terminated_ts integer The timestamp of when the campaign was terminated. In seconds (milliseconds truncated).
Terminated_tcode integer A reference, derived from the value of the TERMINATED_TS field, to a record in the G_TIMECODE table.
LastChanged datetime X The GMT-equivalent date and time of the last event from OCS, with information about change of campaign state or campaign properties.
LastChanged_ts integer The UTC-equivalent value of the LASTCHANGED field. Milliseconds are truncated.
LastChanged_tcode integer A reference, derived from the value of the LASTCHANGED_TS field, to a record in the G_TIMECODE table.
InternalReason integer The reason the campaign was stopped, if it was stopped at all. This may be due to a failure or ICON may have detected the unavailability of reporting data for this campaign. One of the following values:
  • null—normal–No special system reason specified.
  • 1—disconnect–Termination due to disconnect.
  • 2—internal_error–Reserved for cases of termination due to internal errors.
  • 3—register–Termination due to information in the message after registration in the OCS.


#DICTIONARY TYPE 73

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!