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	bigserial	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 (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