Deployments
UAT_PCR_Deployment
Reports
Report Name: CSB Sent for Verification (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
    13
    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 of Action
    [Presentation].[VW_STG_HISTORY].[ACTION_TIMESTAMP]
    Old State
    [Presentation].[VW_STG_HISTORY].[OLD_STATE]
    New State
    [Presentation].[VW_STG_HISTORY].[NEW_STATE]
    Date of Action est
    _add_hours ([Date of Action] , -5 )
    Yesterday
    _add_days(current_date, -1)
    Date range display
    if (?Param-Date-Daily? ='1') then
    ([Yesterday])
    else (' ')
    Action
    'Sent to Verify'
    label
    Action / Nom d'action
    • Detail Filters
      4
    • Required
      if (?Param-Date-Daily? = 0) then
      (cast([Date of Action est], date) in_range ?Param_Date of Action?)
      else if (?Param-Date-Daily? = 1) then
      (cast( [Date of Action 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')
    • Required
      [New State] = 'Ready_To_Verify'
    • Required
      [Old State] = 'Assigned'
  • Query
    Last Valid Date
    Data Items
    1
    Latest Valid Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts