X 5.4.5

CommonPrmDefaults_USER, fields:
- DefaultNoneValueInt
Common_AgentNameList_DW:
- fields:
  - keyvalue
- parameters:
  - @AgentGroups
Common_BPNameList_DW:
- fields:
  - keyvalue
- parameters:
  - @BPGroups
New common Common_AgentGroups_DW:
- fields:
  - AgentGroupName
  - keyvalue
- parameters:
  - @DWDBName
  - @Current_User
New common Common_AgentsFromGroup_DW:
- fields:
  - AgentName
  - keyvalue
- parameters:
  - @DWDBName
  - @Current_User
  - @AgentGroups
New common Common_BPGroups_DW:
- fields:
  - BPGroupName
  - keyvalue
- parameters:
  - @DWDBName
  - @Current_User
New common Common_BPsFromGroup_DW:
- fields:
  - BPName
  - keyvalue
- parameters:
  - @DWDBName
  - @Current_User
  - @BPGroups
1.01 Detailed Agent Activity Report:
- Parameter: @AgentGroups
1.02 Agent Detailed Alerts Report:
- Parameter: @AgentGroups
1.03 Agent Transferred Interactions Report:
- Parameter: @AgentGroups
1.04 Agent Breaks Report:
- Parameter: @AgentGroups
1.05 Agent Rejected Interactions Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
1.06 Staffing Report:
- Parameter: @BPGroups
2.01 Detailed Agent Interactions Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
2.02 Agent Time Allocation Performance Report:
- Parameter: @AgentGroups
2.03 Agent Scoring Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
2.04 Agent Interaction Summary Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
3.01 Mistreated Interactions Report:
- Parameter: @BPGroups
3.03 Agents Assignments to BP Detailed Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
3.04 Interactions Detail Record Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
3.05 Conversations Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
4.01 Detailed Business Entity Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
4.02 Destination Trace Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
4.03 Interaction Disposition Codes Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
4.10 Inbound Interactions Distribution Report:
- Parameter: @BPGroups
4.11 Interactions Analysis Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
4.13 Disposition Codes Distribution Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
4.14 Demand Interval Distribution Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
5.01 Business Process Agent Performance Report:
- Parameter: @BPGroups
5.02 Business Process Interaction Performance Report:
- Parameter: @BPGroups
5.03 Business Process Callback Performance Report:
- Parameter: @BPGroups
5.04 Business Process Detailed Alerts Report:
- Parameter: @BPGroups
5.05 Queue Interval Summary Report:
- Parameter: @BPGroups
6.02 Campaign Time Frame Specific Statistics Report:
- Parameter: @BPGroups
6.03 Campaign Inspection Report:
- Parameter: @BPGroups
6.04 Completed Callback Interactions Report:
- Parameter: @InitiatedBPGroups
- Parameter: @CompletedBPGroups
7.01 Customer Experience Report:
- Parameter: @BPGroups
7.02 Customer Experience Trends Report:
- Parameter: @BPGroups
7.03 Contact Center Performance Report:
- Parameter: @BPGroups
7.04 Abandoned Interactions Report:
- Parameter: @BPGroups
7.05 Contact Center Performance By Demand Report:
- Parameter: @BPGroups
8.01 Calls Performance by BP and Destinations Report:
- Parameter: @BPGroups
9.01 PCS Detail Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
9.02 PCS Summary Agent Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups
9.03 PCS Summary BP Report:
- Parameter: @AgentGroups
- Parameter: @BPGroups

LOGIC CHANGES:

ETL db changes:
- changes procedures:
  - dbo.Upload_F_AgentLife
  - dbo.Upload_F_Interactions
  - dbo.Upload_F_InteractionSegments
DBA new db procedures:
- dbo.UpdateSubscriptionsAgentGroupChanges
- dbo.UpdateSubscriptionsBPGroupChanges
DBA db procedures changed:
- dbo.UpdateSubscriptionsMissingAgent
- dbo.UpdateSubscriptionsMissingBP
Users new db procedures:
- DW.spRpt_Common_Prm_AgentGroups
- DW.spRpt_Common_Prm_AgentsFromGroup
- DW.spRpt_Common_Prm_BPGroups
- DW.spRpt_Common_Prm_BPsFromGroup
Users db procedures changed:
- DW.spRpt_Common_Prm_AgentNameList.
- DW.spRpt_Common_Prm_BPNameList
- dbo.spRpt_Common_Prm_Defaults_USER
- dbo.spSet_AgentGroup
- dbo.spSet_BPGroup

Page tree

X 5.4.5

1.01 Detailed Agent Activity Report:

1.02 Agent Detailed Alerts Report:

1.03 Agent Transferred Interactions Report:

1.04 Agent Breaks Report:

1.05 Agent Rejected Interactions Report:

1.06 Staffing Report:

2.01 Detailed Agent Interactions Report:

2.02 Agent Time Allocation Performance Report:

2.03 Agent Scoring Report:

2.04 Agent Interaction Summary Report:

3.01 Mistreated Interactions Report:

3.03 Agents Assignments to BP Detailed Report:

3.04 Interactions Detail Record Report:

3.05 Conversations Report:

4.01 Detailed Business Entity Report:

4.02 Destination Trace Report:

4.03 Interaction Disposition Codes Report:

4.10 Inbound Interactions Distribution Report:

4.11 Interactions Analysis Report:

4.13 Disposition Codes Distribution Report:

4.14 Demand Interval Distribution Report:

5.01 Business Process Agent Performance Report:

5.02 Business Process Interaction Performance Report:

5.03 Business Process Callback Performance Report:

5.04 Business Process Detailed Alerts Report:

5.05 Queue Interval Summary Report:

6.02 Campaign Time Frame Specific Statistics Report:

6.03 Campaign Inspection Report:

6.04 Completed Callback Interactions Report:

7.01 Customer Experience Report:

7.02 Customer Experience Trends Report:

7.03 Contact Center Performance Report:

7.04 Abandoned Interactions Report:

7.05 Contact Center Performance By Demand Report:

8.01 Calls Performance by BP and Destinations Report:

9.01 PCS Detail Report:

9.02 PCS Summary Agent Report:

9.03 PCS Summary BP Report: