Report Name: CSB Work in Progress (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
    9
    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 Modified
    [Presentation].[Case].[DATE_MODIFIED]
    State Name
    [Presentation].[State].[NAME]
    Date Modified Est
    _add_hours ( [Date Modified], -5 )
    • Detail Filters
      2
    • 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')
    • Required
      [State Name] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Verified', 'Triage_Follow-Up')
  • Query
    Last Valid Date
    Data Items
    1
    Latest Valid Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts