Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

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

TIMESTAMP 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

TIMESTAMP 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

TIMESTAMP 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

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.

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


Index List

Index Name U C

IDX_GO_CAMPAIGN_CID

X

 

 

Feedback

Comment on this article:

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