Cisco Cisco IP Contact Center Release 4.6.2 Technical References
Table of Contents
Purpose .....................................................................................................................................................1
Audience ....................................................................................................................................................1
Organization ..............................................................................................................................................1
Related Documentation .............................................................................................................................2
Related Documentation..............................................................................................................................2
Product Naming Conventions.....................................................................................................................3
Conventions................................................................................................................................................3
Obtaining Documentation and Submitting a Service Request...................................................................4
Documentation Feedback...........................................................................................................................5
Audience ....................................................................................................................................................1
Organization ..............................................................................................................................................1
Related Documentation .............................................................................................................................2
Related Documentation..............................................................................................................................2
Product Naming Conventions.....................................................................................................................3
Conventions................................................................................................................................................3
Obtaining Documentation and Submitting a Service Request...................................................................4
Documentation Feedback...........................................................................................................................5
The ICM/IPCC Databases..........................................................................................................................7
General Concepts.......................................................................................................................................8
General Concepts.......................................................................................................................................8
Tables, Columns, and Rows..................................................................................................................8
Table Relationships................................................................................................................................8
Key Fields..............................................................................................................................................9
Reserved Fields...................................................................................................................................10
Field Applicability.................................................................................................................................10
Data Types...........................................................................................................................................10
Partitioning...........................................................................................................................................11
Table Relationships................................................................................................................................8
Key Fields..............................................................................................................................................9
Reserved Fields...................................................................................................................................10
Field Applicability.................................................................................................................................10
Data Types...........................................................................................................................................10
Partitioning...........................................................................................................................................11
Admin_Script_Schedule_Map Table....................................................................................................13
Agent Table..........................................................................................................................................15
Agent_Desk_Settings Table ................................................................................................................17
Agent_Distribution Table .....................................................................................................................22
Agent_Event_Detail Table ...................................................................................................................23
Agent_Half_Hour Table .......................................................................................................................24
Agent_Logout Table.............................................................................................................................28
Agent_Real_Time Table ......................................................................................................................29
Agent_Skill_Group_Half_Hour Table ..................................................................................................34
Agent_Skill_Group_Logout Table .......................................................................................................47
Agent_Skill_Group_Real_Time Table..................................................................................................48
Agent_State_Trace Table.....................................................................................................................49
Agent_Targeting_Rule Table................................................................................................................52
Agent_Targeting_Rule_Member Table.................................................................................................54
Agent_Targeting_Rule_Range Table...................................................................................................54
Agent_Team Table...............................................................................................................................55
Agent_Team_Member Table ...............................................................................................................56
Agent_Team_Supervisor Table............................................................................................................57
Announcement Table ..........................................................................................................................57
Application_Event Table ......................................................................................................................58
Application_Gateway Table..................................................................................................................60
Application_Gateway_Connection Table..............................................................................................61
Application_Gateway_Globals Table ...................................................................................................63
Agent Table..........................................................................................................................................15
Agent_Desk_Settings Table ................................................................................................................17
Agent_Distribution Table .....................................................................................................................22
Agent_Event_Detail Table ...................................................................................................................23
Agent_Half_Hour Table .......................................................................................................................24
Agent_Logout Table.............................................................................................................................28
Agent_Real_Time Table ......................................................................................................................29
Agent_Skill_Group_Half_Hour Table ..................................................................................................34
Agent_Skill_Group_Logout Table .......................................................................................................47
Agent_Skill_Group_Real_Time Table..................................................................................................48
Agent_State_Trace Table.....................................................................................................................49
Agent_Targeting_Rule Table................................................................................................................52
Agent_Targeting_Rule_Member Table.................................................................................................54
Agent_Targeting_Rule_Range Table...................................................................................................54
Agent_Team Table...............................................................................................................................55
Agent_Team_Member Table ...............................................................................................................56
Agent_Team_Supervisor Table............................................................................................................57
Announcement Table ..........................................................................................................................57
Application_Event Table ......................................................................................................................58
Application_Gateway Table..................................................................................................................60
Application_Gateway_Connection Table..............................................................................................61
Application_Gateway_Globals Table ...................................................................................................63
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
i