Jump to: navigation, search

ICON-Schema-Outbound-MSSQL.png

Outbound Contact Schema

12 tables, containing data relating to Genesys Outbound Contact.

Outbound Contact Schema Diagram

Outbound Contact Data Model Diagram View Large

List of Tables

Table Description
GOX_Chain_Call The records in this table reflect the relationship between voice calls (refer to table G_CALL in the Core Schema of IDB) and Chain processing records (refer to table GO_Chain in this schema).
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
GO_CampaignHistory This table contains the history of Campaign state changes and campaign property changes that occurred during a campaign processing attempt. Records are inserted into this table when the campaign state changes or when ICON receives information about campaign property changes from OCS. Records in this table are never updated or deleted.
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
GO_Chain This table contains current information about chains, as reported by OCS. A record is inserted at the time ICON receives the first notification about Chain processing from OCS. The record is updated when there is a change of state of the chain.
GO_ChainRec_hist This table contains the history of the chain/record processing, as reported by OCS. Changes to the chain state during chain processing result in the creation of a new record in this table. The record is inserted when information about chain state received from OCS. Records are never updated or deleted in this table.
GO_Custom_Fields This table contains information about the content of the custom-defined fields for storage in ICON.
GO_FieldHist This table contains information about the history of the field changes in the records, as reported by OCS, during chain processing.
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.
GO_Record This table contains information about the content of the records as reported by OCS (mandatory fields only). Records are inserted into this table at the time the loading of the record is reported by OCS. Records contain current and last values of the fields. Records are updated when any mandatory field changes.
GO_Secure_Fields This table contains information regarding the content of the custom defined fields that are configured to be stored in ICON. They are configured as protected fields. Records are inserted into this table when the load of the record is reported by OCS. The records contain current and last values of the fields. Records are updated at the time that a field changes.
GO_Sec_FieldHist This table contains information about the history of changes to fields that are configured as protected, as reported by OCS during chain processing.

List of Indexes

Table Index Name U C
GO_Campaign IDX_GO_CAMPAIGN_CID X
GO_Chain IDX_GO_CHAIN_CHID X
GO_Custom_Fields IDX_CUSTOMF_CHID
GO_Custom_Fields IDX_CUSTOMF_FID X
GO_Record IDX_GO_REC_CHID
GO_Record IDX_GO_REC_PHID X
GO_Secure_Fields IDX_SECUREF_CHID
GO_Secure_Fields IDX_SECUREF_PHID X

List of References

Child Table Parent Table CODE F
GO_CampaignHistory GO_Campaign REFERENCE_1 SessID
GO_CampProp_Hist GO_Campaign REFERENCE_8 SessID
GO_Chain GO_Campaign REFERENCE_3 SessID
GO_Custom_Fields GO_Chain REFERENCE_10 ID
GO_Custom_Fields GO_Record REFERENCE_11 RecordHandle
GO_FieldHist GO_ChainRec_hist REFERENCE_7 ChainGUID; ChainHistSeq
GO_FieldHist GO_Custom_Fields REFERENCE_8 RecordHandle
GO_FieldHist GO_Custom_Fields REFERENCE_9 FieldID
GO_FieldHist GO_Record REFERENCE_6 ChainGUID; RecordHandle
GO_Record GO_Chain REFERENCE_5 ChainGUID
This page was last edited on January 10, 2020, at 15:27.
Comments or questions about this documentation? Contact us for support!