Jump to: navigation, search

ICON-Schema-Outbound-Postgre.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

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_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_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_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_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.
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.

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_CampProp_Hist

GO_Campaign REFERENCE_8 SessID

GO_CampaignHistory

GO_Campaign REFERENCE_1 SessID

GO_Chain

GO_Campaign REFERENCE_3 SessID

GO_ChainRec_hist

GO_Chain REFERENCE_4 ChainGUID

GO_Custom_Fields

GO_Chain REFERENCE_10 ID

GO_Custom_Fields

GO_Record REFERENCE_11 RecordHandle

GO_FieldHist

GO_Custom_Fields REFERENCE_9 FieldID

GO_FieldHist

GO_ChainRec_hist REFERENCE_7 ChainGUID; ChainHistSeq

GO_FieldHist

GO_Custom_Fields REFERENCE_8 RecordHandle

GO_FieldHist

GO_Record REFERENCE_6 ChainGUID; RecordHandle

GO_Record

GO_Chain REFERENCE_5 ChainGUID

Feedback

Comment on this article:

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