post call survey pcce

[GauravKishore0360]

what is the best way to get agent id in a post call survey application in pcce

[Ramamoorthy Shanmugam]

Hi Gaurav,

We are using a custom gadget with a call studio application for PCS. Or you can try the Default PCS option in PCCE.

Ram.S

[janinegraves · Accepted solution]

This gives you a bunch of information about the agent and skill group based on the RouterCallKey and RouterCallDay:

SELECT

Agent.EnterpriseName AgentName,
Agent.PeripheralNumber AgentPeripheralNumber,
TCD.AgentSkillTargetID AgentSkillID,
TCD.SkillGroupSkillTargetID SkillGroupID,
TCD.InstrumentPortNumber AgentExtension,
TCD.CallTypeID TCD_CT_ID,
Person.LoginName AgentLoginID,
SG.EnterpriseName SGName,
CT.EnterpriseName CallTypeName

FROM L125_hds.dbo.t_Termination_Call_Detail TCD

JOIN L125_awdb.dbo.Agent Agent ON TCD.AgentSkillTargetID = Agent.SkillTargetID
JOIN L125_awdb.dbo.Person Person ON Agent.PersonID = Person.PersonID
JOIN L125_awdb.dbo.Skill_Group SG ON TCD.SkillGroupSkillTargetID = SG.SkillTargetID
JOIN L125_awdb.dbo.Call_Type CT ON TCD.CallTypeID = CT.CallTypeID

WHERE
TCD.RouterCallKeyDay = 1111
AND
TCD.RouterCallKey = 222

[Konstantin Vaksin]

Pass it over variable