UCCE Config Queries

ICR_Globals is the table where system default infor is stored, such as default CallType threshold

Agent

SELECT     
Agent.SkillTargetID, 
Agent.PeripheralID,
Agent.PeripheralNumber,
Agent.PersonID, 
Person.FirstName, 
Person.LastName, 
Person.LoginName,
Agent_Team.EnterpriseName AS AgentTeamName

FROM Agent

LEFT JOIN Agent_Team_Member ON Agent.SkillTargetID = Agent_Team_Member.SkillTargetID
LEFT JOIN Agent_Team ON Agent_Team_Member.AgentTeamID = Agent_Team.AgentTeamID
LEFT JOIN Person ON Agent.PersonID = Person.PersonID

ORDER BY FirstName

Call types

SELECT 
  CallTypeID = CT.CallTypeID
 ,CallTypeName = CT.EnterpriseName
 ,Description = CT.Description
 ,SLThreshold = CT.ServiceLevelThreshold
 ,BucketName = isNull(BI.EnterpriseName,'Default')
 ,SL_Type = [ServiceLevelType],
CASE [ServiceLevelType]
When '0' THEN 'Default'
When '1' THEN 'Ignore Abandoned Calls'
When '2' THEN 'Abandoned Calls Have Negative Impact'
When '3' THEN 'Abandoned Calls Have Positive Impact'
ELSE 'Unknown'
END AS SL_Type_Desc

FROM Call_Type CT LEFT JOIN
Bucket_Intervals BI ON CT.BucketIntervalID = BI.BucketIntervalID

WHERE CT.Deleted = 'N'

ORDER By CT.EnterpriseName

Call Type <> Script mapping

SELECT

CallTypeID = [Call_Type_Map].[CallTypeID],
MasterScriptID = [Call_Type_Map].[MasterScriptID],
CallTypeName = [Call_Type].[EnterpriseName],
MasterScriptName = [Master_Script].[EnterpriseName]

FROM 
[ucce_awdb].[dbo].[Call_Type_Map],
[ucce_awdb].[dbo].[Master_Script],
[ucce_awdb].[dbo].[Call_Type]

WHERE 
[Call_Type_Map].[MasterScriptID] = [Master_Script].[MasterScriptID] AND 
[Call_Type_Map].[CallTypeID] = [Call_Type].[CallTypeID]

ORDER BY CallTypeName

Dialed Number <> Calltype Mapping

SELECT        
Dialed_Number_Map.DialedNumberID, 
Dialed_Number.DialedNumberID AS DialedNumberID,
Dialed_Number.EnterpriseName, 
Dialed_Number.RoutingClientID, 
Dialed_Number.DialedNumberString, 
Dialed_Number.Description, 
Call_Type.CallTypeID, 
Call_Type.EnterpriseName AS CalltypeName, 
Call_Type.Description AS CalltypeDesc, 
Routing_Client.RoutingClientID AS RoutingClientID, 
Routing_Client.EnterpriseName AS RoutingClientName

FROM            
Dialed_Number_Map 
INNER JOIN
Dialed_Number ON Dialed_Number_Map.DialedNumberID = Dialed_Number.DialedNumberID 
INNER JOIN
Call_Type ON Dialed_Number_Map.CallTypeID = Call_Type.CallTypeID 
INNER JOIN
Routing_Client ON Dialed_Number.RoutingClientID = Routing_Client.RoutingClientID

ORDER By DialedNumberString

Dialed Number <> Calltype <> Script

SELECT        
DNID = Dialed_Number.DialedNumberID,
DNString = Dialed_Number.DialedNumberString, 
DNName = Dialed_Number.EnterpriseName, 
DNRoutingClientID = Dialed_Number.RoutingClientID, 
DNDesc = ISNULL(Dialed_Number.Description,''), 
RoutingClientID = Routing_Client.RoutingClientID, 
RoutingClientName = Routing_Client.EnterpriseName,
CallTypeID = ISNULL([Call_Type_Map].[CallTypeID],''),
CallTypeName = ISNULL([Call_Type].[EnterpriseName],''),
CallTypeDesc = ISNULL(Call_Type.Description,''), 
MasterScriptID = ISNULL([Call_Type_Map].[MasterScriptID],''),
MasterScriptName = ISNULL([Master_Script].[EnterpriseName],'')

FROM            
Master_Script RIGHT OUTER JOIN Routing_Client 
RIGHT OUTER JOIN Call_Type 
INNER JOIN Dialed_Number_Map ON Call_Type.CallTypeID = Dialed_Number_Map.CallTypeID 
LEFT OUTER JOIN Call_Type_Map ON Call_Type.CallTypeID = Call_Type_Map.CallTypeID 
RIGHT OUTER JOIN Dialed_Number ON Dialed_Number_Map.DialedNumberID = Dialed_Number.DialedNumberID ON Routing_Client.RoutingClientID = Dialed_Number.RoutingClientID ON Master_Script.MasterScriptID = Call_Type_Map.MasterScriptID

ORDER By Dialed_Number.DialedNumberString, Routing_Client.EnterpriseName

Skill Groups / PQ

SELECT 
	[SkillTargetID]
      ,[PrecisionQueueID]
      ,[PeripheralID]
      ,[EnterpriseName]
      ,[PeripheralNumber]
      ,[PeripheralName]
      ,[BaseSkillTargetID]
      ,[SubGroupMaskType]
      ,[Description]
      ,[MRDomainID]
      ,[IPTA]
      ,[DefaultEntry]
      ,[ServiceLevelThreshold]
      ,[ServiceLevelType]
      ,[BucketIntervalID]
      ,[DepartmentID]
  FROM [ucce_awdb].[dbo].[Skill_Group]
  

Reason Codes

SELECT 
       [ReasonCodeID]
      ,[ReasonCode]
      ,[ReasonText]
      ,[Description]
  FROM [ucce_awdb].[dbo].[Reason_Code]
 
This website uses cookies. By using the website, you agree with storing cookies on your computer. Also you acknowledge that you have read and understand our Privacy Policy. If you do not agree leave the website.More information about cookies