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. (The Info Mart database in Cloud deployments is not multi-language.)

Table GO_CampProp_Hist


This table contains the history of Campaign property changes during the campaign processing attempt. Records are inserted into this table when ICON receives information about campaign property changes from OCS. Records in this table are never updated or deleted.

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 X The campaign processing session ID (GUID).

Seq

int X The sequence number of state and property changes in a campaign's history.

DialMode

int The dial mode specified for campaign processing.

PrevDialMode

int The previous dialing mode, if the dialing mode was changed.

PrevDMEnter

datetime The GMT-equivalent date and time when previous dialing mode was detected by OCS (according to timestamp provided by OCS).

PrevDMEnter_ts

int The UTC-equivalent value of the PREVDMENTER field. Milliseconds are truncated.

PrevDMEnter_tcode

int A reference, derived from the value of the PREVDMENTER_TS field, to a record in the G_TIMECODE table.

OptimMode

int Code of optimization mode (overdialrate, waiting time, busy factor).

OptimValue

int The current value of the optimization parameter that OCS uses for this campaign.

PrevOptimMode

int The previous optimization mode that OCS ran with this campaign.

PrevOptimValue

int The previous optimization parameter value that OCS used for this campaign.

PrevOMEnter

datetime The GMT-equivalent date and time when the previous optimization mode was reported by OCS.

PrevOMEnter_ts

int The UTC-equivalent value of the PREVOMENTER field. Milliseconds are truncated.

PrevOMEnter_tcode

int A reference, derived from the value of the PREVOMENTER_TS field, to a record in the G_TIMECODE table.

GeneralN

int The numerical value of the priority parameter that OCS used for general records in this campaign.

PrevGeneralN

int The previous value of the priority parameter that OCS used for General records in this campaign.

GeneralW

int The current weight of the priority parameter value for general records that OCS used for this campaign.

PrevGeneralW

int The previous weight of the priority parameter value for general records that OCS used in this campaign.

CallBackN

int The numerical value of the priority parameter that OCS used for callback records in this campaign.

PrevCallBackN

int The previous value of the priority parameter that OCS used for callback records in this campaign.

CallBackW

int The current weight of the priority parameter value for callback records that OCS used within this campaign.

PrevCallBackW

int The previous weight of the priority parameter value for callback records that OCS used in this campaign.

SchedN

int The current numerical value of the priority parameter that OCS used for scheduled records in this campaign.

PrevSchedN

int The previous value of the priority parameter that OCS used for scheduled records in this campaign.

SchedW

int The current weight of the priority parameter value for scheduled records that OCS used in this campaign.

PrevSchedW

int The previous weight of the priority parameter value for scheduled records that OCS used within this campaign.

PrevPPEnter

datetime The GMT-equivalent date and time when the previous priority parameters were reported by OCS.

PrevPPEnter_ts

int The UTC-equivalent value of the PREVPPENTER field. Milliseconds are truncated.

PrevPPEnter_tcode

int A reference, derived from the value of the PREVPPENTER_TS field, to a record in the G_TIMECODE table.

Added

datetime X The GMT-equivalent date and time when any change of a parameter is 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.

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

   

 

Feedback

Comment on this article:

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