Jump to: navigation, search

ICON-Schema-Core-Log-MSSQL.png

ICON-Schema-Core-SvcNDict-MSSQL.png

ICON-Schema-Core-LoginSess-MSSQL.png

ICON-Schema-Core-Adata-MSSQL.png

ICON-Schema-Core-CallNParty-MSSQL.png

ICON-Schema-Core-Config3-MSSQL.png

ICON-Schema-Core-Config2-MSSQL.png

ICON-Schema-Core-Config1-MSSQL.png

Core Schema

The Core Schema is the largest and most complex of the Interaction Database (IDB) schemas. Because of the size and varied nature of the tables in the Core schema, this chapter further subdivides its schema into six groupings.

Core Schema Groupings

For diagrams that depict the groupings, see Core Schema Diagrams.

Configuration-Related Tables

Configuration-related tables are the largest grouping of Core Schema tables. These tables store information, mostly derived from the Configuration Server database, that fall into two groups:

  • Object tables, whose names are all prefixed by GC_
  • Object link tables, with table names beginning with GCX_. GCX_ tables store information about the associations between configuration objects, such as the assignments of skills to agents (GCX_SKILL_LEVEL).
[+] Configuration-related tables

Call- and Party-Related Tables

The group of call- and party-related tables provide detailed information about voice or multimedia interactions that are registered by T-Server or Interaction Server and the participants involved in those interactions. This schema group includes tables that contain the historical counterpart of the data in each of the principle tables (denoted by the addition of "_HISTORY" to the table name) and statistical information, which is stored in the G_CALL_STAT and G_PARTY_STAT tables.

[+] Call- and Party-Related Tables

Attached Data–Related Tables

The Attached Data grouping of the Core Schema comprises six tables. G_SECURE_USERDATA_HISTORY stores information about attached data records that must be protected from unauthorized users, whereas the records in G_USERDATA_HISTORY are open. In addition, there are four more tables which store user data. The tables in this group include:

[+] Attached data-related tables

Login- and Session-Related Tables

The group of Login- and Session-related tables of the Core Schema provides detailed information about agent states, login sessions, associations between sessions and endpoints (DNs), reasons, and extensions. The principal tables in this group include:

[+] Login- and session-related tables

Service- and Dictionary-Related Tables

The group of Service- and dictionary-related tables of the Core Schema are predominantly used to describe field values in other tables:

[+] Service- and dictionary-related tables

Log- and System-Related Tables

This grouping of tables of the Core Schema stores information about the success or failure of ICON functions and stored procedures. It also includes two tables that are used only by internal Genesys processes, which you should not alter.

[+] Log- and system-related tables

Changes in a SIP Cluster Environment

Interaction Concentrator 8.1 provides support for a restricted release of SIP Cluster. Information about SIP Cluster that pertains specifically to changes in IDB the data stored in IDB tables and fields is provided in this document. For complete information on Genesys SIP Cluster technology, contact your Genesys representative.

[+] SIP Cluster-Specific Data Changes

Core Schema Diagrams

The following diagrams depict the schema groupings. The tables in each subdivision are shown with a clear background, and the tables to which they join in other subdivisions are shown with shaded backgrounds. Click any diagram to see a larger version.

Configuration Tables - diagram 1 of 3 View Large


Configuration Tables - diagram 2 of 3 View Large


Configuration Tables - diagram 3 of 3 View Large
Call- and Party-Related Tables View Large
Attached Data-Related Tables View Large
Login- and Session-Related Tables View Large
Service- and Dictionary-Related Tables View Large
Log- and System-Related Tables View Large


List of Indexes

Table Index Name U C

GCX_AGENT_PLACE

IDX_AGENT_PLACE

GCX_CAMPGROUP_INFO

IDX_CAMPGROUP_INFO

GCX_CAMPLIST_INFO

IDX_CAMPLIST_INFO

GCX_ENDPOINT_PLACE

IDX_ENDPOINT_PLACE

GCX_FORMAT_FIELD

IDX_FORMAT_FIELD

GCX_GROUP_AGENT

IDX_GROUP_AGENT

GCX_GROUP_ENDPOINT

IDX_GROUP_ENDPOINT

GCX_GROUP_PLACE

IDX_GROUP_PLACE

GCX_GROUP_ROUTEDN

IDX_GROUP_ROUTEDN

GCX_LIST_TREATMENT

IDX_LIST_TREATMENT

GCX_LOGIN_INFO

IDX_LOGIN_INFO

GCX_OBJTABLE_RECORD

IDX_OBJTABLE_RECORD

GCX_SKILL_LEVEL

IDX_SKILL_LEVEL

GCX_SUBCODE

IDX_SUBCODE

GC_ANNEX

IDX_GC_ANNEX

GS_AGENT_STAT

IDX_GS_AGENT_STAT_SID X

GS_AGENT_STAT_WM

IDX_AGENT_STAT_WM_SID X

GX_SESSION_ENDPOINT

IDX_SN_ENDP_AGID X

GX_SESSION_ENDPOINT

IDX_SN_ENDP_LSEP X

G_AGENT_STATE_HISTORY

IDX_G_AGENT_STATE_H_PID_TYPE

G_AGENT_STATE_HISTORY

IDX_G_AGENT_STATE_H_LSID_LSEQ

G_CALL

IDX_G_CALL_PCID

G_CALL

IDX_G_CALL_ROOTIRID

G_CALL

IDX_G_CALL_USEQ

G_CALL

IDX_G_CALL_SEQ

G_CALL

IDX_G_CALL_CID X

G_CALL

IDX_G_CALL_MRGCID

G_CALL_HISTORY

IDX_G_CALL_H_CID X

G_CALL_STAT

IDX_G_CALL_STAT_CID X

G_CALL_USERDATA

IDX_CUSERDATA_CID X

G_CALL_USERDATA_CUST1

IDX_CUDATA_CUST1_CID X

G_CALL_USERDATA_CUST2

IDX_CUDATA_CUST2_CID X

G_CALL_USERDATA_CUST

IDX_CUDATA_CUST_CID X

G_IR

IDX_G_IR_PXID

G_IR

IDX_G_IR_RCID

G_IR

IDX_G_IR_ROOTIRID

G_IR

IDX_G_IR_IRID X

G_IR

IDX_G_IR_USEQ

G_IR

IDX_G_IR_SEQ

G_IR_HISTORY

IDX_G_IR_H_XID

G_IR_HISTORY

IDX_X_H_HIRID_SEQ

G_IS_LINK

IDX_G_ISLINK_USEQ

G_LOGIN_SESSION

IDX_G_LSESS_AGID

G_LOGIN_SESSION

IDX_G_LSESS_LSID X

G_PARTY

IDX_G_PARTY_PPID

G_PARTY

IDX_G_PARTY_PID X

G_PARTY

IDX_G_PARTY_GE_INT_CID X

G_PARTY_HISTORY

IDX_G_PARTY_H_PID

G_PARTY_STAT

IDX_G_PARTY_STAT_PID X

List of References

Child Table Parent Table Code F

GCX_AGENT_PLACE

GC_PLACE AGENT_PLACE_TO_PLACE PlaceID

GCX_AGENT_PLACE

GC_AGENT AGENT_PLACE_TO_AGENT AgentID

GCX_CAMPGROUP_INFO

GC_ENDPOINT FK_CAMGRDN OrigDNID

GCX_CAMPGROUP_INFO

GC_GROUP CAMPGROUP_INFO_TO_GROUP GroupID

GCX_CAMPGROUP_INFO

GC_CAMPAIGN CAMPGROUP_TO_CAMPAIGN CampaignID

GCX_CAMPGROUP_INFO

GC_APPLICATION FK_CAMGRCPD CPDServerID

GCX_CAMPLIST_INFO

GC_CALLING_LIST CAMPLIST_INFO_TO_CALLING_LIST ListID

GCX_CAMPLIST_INFO

GC_CAMPAIGN CAMP_LIST_INFO_TO_CAMPAIGN CampaignID

GCX_ENDPOINT_PLACE

GC_PLACE ENDPOINT_PLACE_TO_PLACE PlaceID

GCX_ENDPOINT_PLACE

GC_ENDPOINT ENDPOINT_PLACE_TO_ENDPOINT EndPointID

GCX_FORMAT_FIELD

GC_FIELD FK_GCX_FLDFMT FieldID

GCX_FORMAT_FIELD

GC_FORMAT FK_GCX_FMTFLD FormatID

GCX_GROUP_AGENT

GC_AGENT GROUP_AGENT_TO_AGENT AgentID

GCX_GROUP_AGENT

GC_GROUP GROUP_AGENT_TO_GROUP GroupID

GCX_GROUP_ENDPOINT

GC_ENDPOINT GROUP_ENDPOINT_TO_ENDPOINT EndPointID

GCX_GROUP_ENDPOINT

GC_GROUP GROUP_ENDPOINT_TO_GROUP GroupID

GCX_GROUP_PLACE

GC_PLACE GROUP_PLACE_TO_PLACE PlaceID

GCX_GROUP_PLACE

GC_GROUP GROUP_PLACE_TO_GROUP GroupID

GCX_GROUP_ROUTEDN

GC_ENDPOINT GROUP_ROUTEDN_TO_ENDPOINT EndPointID

GCX_GROUP_ROUTEDN

GC_GROUP GROUP_ROUTEDN_TO_GROUP GroupID

GCX_LIST_TREATMENT

GC_CALLING_LIST FK_GCX_LSTTRT ListID

GCX_LIST_TREATMENT

GC_TREATMENT FK_GCX_TRTLST TreatmentID

GCX_LOGIN_INFO

GC_LOGIN LOGIN_INFO_TO_LOGIN LoginID

GCX_LOGIN_INFO

GC_AGENT LOGIN_INFO_TO_AGENT AgentID

GCX_OBJTABLE_RECORD

GC_ATTR_VALUE OBJ_TABLE_RECORD_TO_ATTR_VALUE_BY_CUSTSEGMENTID CustSegmentID

GCX_OBJTABLE_RECORD

GC_ATTR_VALUE OBJ_TABLE_RECORD_TO_ATTR_VALUE_BY_SERVICETYPEID ServiceTypeID

GCX_OBJTABLE_RECORD

GC_ATTR_VALUE OBJ_TABLE_RECORD_TO_ATTR_VALUE_BY_MEDIATYPEID MediaTypeID

GCX_OBJTABLE_RECORD

GC_OBJ_TABLE OBJ_TABLE_RECORD_TO_OBJ_TABLE ObjTableID

GCX_SKILL_LEVEL

GC_AGENT SKILL_LEVEL_TO_AGENT AgentID

GCX_SKILL_LEVEL

GC_SKILL SKILL_LEVEL_TO_SKILL SkillID

GCX_SUBCODE

GC_ACTION_CODE SUBCODE_TO_ACTION_CODE CodeID

GC_ACTION_CODE

GC_TENANT ACTION_CODE_TO_TENANT TenantID

GC_AGENT

GC_TENANT AGENT_TO_TENANT TenantID

GC_AGENT

GC_PLACE AGENT_TO_PLACE PlaceID

GC_ATTR_VALUE

GC_TENANT ATTR_VALUE_TO_TENANT TenantID

GC_ATTR_VALUE

GC_BUS_ATTRIBUTE ATTR_VALUE_TO_BUS_ATTRIBUTE AttributeID

GC_BUS_ATTRIBUTE

GC_TENANT BUS_ATTRIBUTE_TO_TENANT TenantID

GC_CALLING_LIST

GC_TABLE_ACCESS FK_LISTLTAB LogTableID

GC_CALLING_LIST

GC_TABLE_ACCESS FK_LISTTAB TableID

GC_CALLING_LIST

GC_TENANT CALLING_LIST_TO_TENANT TenantID

GC_CAMPAIGN

GC_TENANT CAMPAIGN_TO_TENANT TenantID

GC_ENDPOINT

GC_SWITCH ENDPOINT_TO_SWITCH SwitchID

GC_ENDPOINT

GC_TENANT ENDPOINT_TO_TENANT TenantID

GC_FIELD

GC_TENANT FK_FLDTENANT TenantID

GC_FILTER

GC_TENANT FK_FLTTENANT TenantID

GC_FILTER

GC_FORMAT FK_FILTFMT FormatID

GC_FOLDER

GC_TENANT FOLDER_TO_TENANT TenantID

GC_FORMAT

GC_TENANT FK_FMTTENANT TenantID

GC_GROUP

GC_TENANT GROUP_TO_TENANT TenantID

GC_IVR

GC_TENANT IVR_TO_TENANT TenantID

GC_IVRPORT

GC_IVR IVR_PORT_TO_IVR IVRID

GC_IVRPORT

GC_TENANT IVR_PORT_TO_TENANT TenantID

GC_IVRPORT

GC_ENDPOINT IVR_PORT_TO_ENDPOINT EndPointID

GC_LOGIN

GC_SWITCH LOGIN_TO_SWITCH SwitchID

GC_LOGIN

GC_TENANT LOGIN_TO_TENANT TenantID

GC_OBJ_TABLE

GC_TENANT OBJ_TABLE_TO_TENANT TenantID

GC_PLACE

GC_TENANT PLACE_TO_TENANT TenantID

GC_SCRIPT

GC_TENANT SCRIPT_TO_TENANT TenantID

GC_SCRIPT

GC_SCRIPT SCRIPT_TO_SCRIPT n/a

GC_SKILL

GC_TENANT SKILL_TO_TENANT TenantID

GC_SWITCH

GC_TENANT SWITCH_TO_TENANT TenantID

GC_TABLE_ACCESS

GC_FORMAT FK_TABFMT FormatID

GC_TABLE_ACCESS

GC_TENANT FK_TABTENANT TenantID

GC_TIME_ZONE

GC_TENANT TIMEZONE_TO_TENANT TenantID

GC_TREATMENT

GC_TENANT FK_TRTTENANT TenantID

GC_TREATMENT

GC_ENDPOINT FK_TRTDN DestDNID

GC_VOICE_PROMPT

GC_SCRIPT VOICE_PROMPT_TO_SCRIPT ScriptID

GC_VOICE_PROMPT

GC_TENANT VOICE_PROMPT_TO_TENANT TenantID

GC_VOICE_PROMPT

GC_SWITCH VOICE_PROMPT_TO_SWITCH SwitchID

GX_SESSION_ENDPOINT

GC_ENDPOINT SESSION_ENDPOINT_TO_ENDPOINT EndPointID

GX_SESSION_ENDPOINT

G_LOGIN_SESSION SESSION_ENDPOINT_TO_LOGIN_SESSION n/a

GX_SESSION_ENDPOINT

GC_AGENT SESSION_ENDPOINT_TO_AGENT AgentID

G_AGENT_STATE_HISTORY

GC_AGENT AGENT_STATE_HISTORY_TO_AGENT AgentID

G_CALL

G_IR CALL_TO_IR IRID

G_CALL

G_CALL CALL_REFERENCES_PARENT_CALL ParentCallID

G_CALL_HISTORY

G_CALL CALL_HISTORY_REFERENCES_CALL CallID

G_CALL_STAT

G_CALL CALL_STAT_TO_CALL n/a

G_DICTIONARY

G_DICT_TYPE DICTIONARY_TO_DICT__TYPE DTYPE

G_IR

G_CALL IR_TO_CALL RootCallID

G_IR_HISTORY

G_IR IR_HISTORY_TO_IR

G_IS_LINK

G_CALL IS_LINK_REFERENCES_CALL CallID

G_IS_LINK_HISTORY

G_IS_LINK IS_LINK_HISTORY_REFERENCES_IS_LINK LinkID

G_LOGIN_SESSION

GC_LOGIN LOGIN_SESSION_TO_LOGIN LoginID

G_LOGIN_SESSION

GC_PLACE LOGIN_SESSION_TO_PLACE PlaceID

G_LOGIN_SESSION

GC_AGENT LOGIN_SESSION_TO_AGENT AgentID

G_PARTY

G_PARTY PARTY_REFERENCES_PREVIOUS_PARTY n/a

G_PARTY

GC_AGENT PARTY_TO_AGENT AgentID

G_PARTY

G_CALL PARTY_REFERENCES_CALL CallID

G_PARTY

GC_ENDPOINT PARTY_TO_ENDPOINT EndPointID

G_PARTY_HISTORY

GC_ENDPOINT PARTY_HISTORY_TO_ENDPOINT EndpointID

G_PARTY_HISTORY

G_PARTY PARTY_HISTORY_REFERENCES_PARTY PartyID

G_PARTY_STAT

G_PARTY PARTY_STAT_TO_PARTY n/a

G_SECURE_USERDATA_HISTORY

G_PARTY SECURE_USERDATA_TO_PARTY n/a

G_SECURE_USERDATA_HISTORY

G_CALL SECURE_USERDATA_TO_CALL n/a

G_USERDATA_HISTORY

G_PARTY USERDATA_HISTORY_TO_PARTY n/a

G_USERDATA_HISTORY

G_CALL USERDATA_HISTORY_TO_CALL n/a

Feedback

Comment on this article:

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