Deployments
UAT_PCR_Deployment
Reports
Report Name: CSB Cases Assigned (All Teams)
Overview

  • Queries: 2

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 2
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Main
    Data Items
    11
    Case Number
    [Presentation].[Case].[ID]
    PRI
    [Presentation].[Case].[PRI]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    label
    Agent
    NAME
    [Presentation].[VW_STG_PARENT_CHILD_LINKS_Alias_For_Groups_VW_STG_GROUPS].[NAME]
    Date Assigned
    [Presentation].[Case].[DATE_ASSIGNED]
    Date Assigned est
    _add_hours ( [Date Assigned], -5 )
    Yesterday
    _add_days(current_date, -1)
    Date range display
    if (?Param-Date-Daily? ='1') then
    ([Yesterday] )
    else (' ')
    Action
    'Assigned'
    • Detail Filters
      2
    • Required
      if (?Param-Date-Daily? = 0) then
      (cast([Date Assigned est], date) in_range ?Param_Date_Assigned?)
      else if (?Param-Date-Daily? = 1) then
      ( cast([Date Assigned est], date) = [Yesterday])
      else (0)
    • Required
      [NAME] in ('Compensation-Advisor-19', 'Compensation-Advisor-83', 'Compensation-Advisor-84', 'Compensation-Advisor-85', 'Compensation-Advisor-86', 'Compensation-Advisor-87', 'Compensation-Advisor-88', 'Compensation-Advisor-89', 'Compensation-Advisor-90','Compensation-Advisor-91', 'Compensation-Advisor-92','Compensation-Advisor-93')
  • Query
    Last Valid Date
    Data Items
    1
    Latest Valid Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts