Deployments
UAT_PCR_Deployment
Reports
Report Name: What was Cancelled
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
    QueryTicket
    Data Items
    18
    DBID
    [Presentation].[Case].[DBID]
    Processing Centre
    '="'+[Presentation].[Case].[PROCESSING_CENTRE] +'"'
    Age
    [Presentation].[Case].[CMT_AGE]
    Open Date
    '="' +cast( _add_hours ( [Presentation].[Case].[DATE_OPEN],-4 ),varchar(19)) +'"'
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type
    [Presentation].[Sub Type].[NAME]
    Department
    [Presentation].[Case].[DEPARTMENT]
    Case Number
    [Presentation].[Case].[ID]
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    Employee Sub-Category
    [Presentation].[Case].[CLASSIFICATION]
    Pay List
    [Presentation].[Case].[PL]
    ASSIGNEE_CURR_ID
    [Presentation].[Case].[ASSIGNEE_CURR_ID]
    Name
    [Presentation].[Case].[NAME]
    Urgent
    [Presentation].[Case].[URGENT]
    BF Date
    _add_hours ( [Presentation].[Case].[DATE_BF],-4 )
    Date of Action
    [Presentation].[VW_STG_HISTORY].[ACTION_TIMESTAMP]
    DateOfAction_Est
    _add_hours ( [Date of Action],-4 )
    Group Name
    [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]
    • Detail Filters
      4
    • Required
      [Presentation].[VW_STG_HISTORY].[ENTITYDEF_ID] = 16777228
    • Required
      [Presentation].[VW_STG_HISTORY].[NEW_STATE] = 'Cancelled'
    • Required
      if ( ?Para_choice? = 0 ) then
      (cast( [DateOfAction_Est],date) in_range ?Para_dateRange? )
      else if ( ?Para_choice? = 1 ) then
      (cast( [DateOfAction_Est] , date)
      between (_add_days (current_date, (_day_of_week (current_date,0 ) )* -1 - 5 )) and (_add_days ( current_date, (_day_of_week (current_date,0 ) )* -1 + 1 )) )
      else if ( ?Para_choice? = 2 ) then
      (cast( [DateOfAction_Est] , date)
      between (_add_days (current_date, (_day_of_week (current_date,0 ) )* -1 - 12 )) and (_add_days ( current_date, (_day_of_week (current_date,0 ) )* -1 - 6 )) )
      else(0)
    • Required
      [Presentation].[Compensation Advisor]
  • Query
    Last Load Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts