McDewey

Table 401: Fields in Service_Member Table Keys and NULL Option Data Type Description Name NOT NULL DBSMALLINT The priority level of the specified service for the specified skill group: • 1 = Primary • 2= Secondary Any number of skill entries can be of any priority--not all need to be entered. Priority PK, FK NOT NULL DBINT SkillTargetID of the service. ServiceSkillTargetID PK, FK NOT NULL DBINT SkillTargetID of the skill group that is associated with the service. SkillGroupSkillTargetID Service_Real_Time This table is in the Skill Target category (see Skill Target, on page 635). To see database rules for these tables, see Skill Target Tables, on page 702. When Unified ICM is connected with Unified CCE through a Unified CCE Gateway PG, this value is incremented by any condition on the child that causes the call to terminate while in the queue. Note Local database only. Contains real time information about each service. The system software automatically generates a Service_Real_Time record for each service. Related Table Service, on page 452 (via SkillTargetID) Table 402: Indexes for Service_Real_Time Table index_keys index_description index_name SkillTargetID clustered, unique, primary key located on PRIMARY XPKService_Real_Time Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 474 All Tables Service_Real_Time