Deployments
UAT_PCR_Deployment
Reports
Report Name: Completed Productivity for Non-backlog cases and Satellite backlog cases - List report
Overview

  • Queries: 3

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 3
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Main Query
    Data Items
    21
    Processing Location
    if ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] )
    Team Name
    If ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] )
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    Case Number
    [Presentation].[Case].[ID]
    PRI
    [Presentation].[Case].[PRI]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    State Name
    [Presentation].[State].[NAME]
    Date Closed or Date Cancelled
    [Presentation].[Case].[Date Closed or Date Cancelled EST]
    BF Date
    [Presentation].[Case].[DATE_BF_EST]
    Date Open
    [Presentation].[Case].[DATE_OPEN_EST]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Backlog Case
    Case
    when [Processing Centre] like '%ORIG-SAT%' or [Processing Centre] like '%SATELLITE%'
    then 'Backlog'
    when (([Processing Centre] not like '%ORIG-SAT%' and [Processing Centre] not like '%SATELLITE%')
    or
    ([Processing Centre] is null))
    then 'Non-backlog'
    End
    Rollup
    total total
    Transaction Type
    [Presentation].[Sub Type].[TRANSACTION_TYPE]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Awaiting Calc
    [Presentation].[Case].[AWAITING_CALC]
    Awaiting Confirm
    [Presentation].[Case].[AWAITING_CONFIRM]
    Pending Reason
    [Presentation].[Case].[PENDING_REASON]
    Auto Process Indicator
    [Presentation].[Case].[Auto Process Indicator]
    Date Modified
    [Presentation].[Case].[DATE_MODIFIED_EST]
    Current Date-1
    _add_days(current_date, -1)
    • Detail Filters
      4
    • Required
      [Presentation].[State].[NAME] in ('Closed', 'Cancelled')
    • Required
      if (?Param-Date-Daily? = 0) then
      (cast([Date Closed or Date Cancelled], date) in_range ?Param-Date-Range?)
      else if (?Param-Date-Daily? = 1) then
      (cast([Date Closed or Date Cancelled], date) = [Current Date-1])
      else (0)
    • Required
      [Processing Location] in ?Param-Processing-Centre?
    • Required
      [Team Name] in ?Param-Team-Name?
  • Query
    Load Last Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
  • Query
    Query-Prompt
    Data Items
    2
    Pay Processing Centre
    if ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] )
    Team Name
    If ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] )
    • Detail Filters
      2
    • Required
      [Pay Processing Centre] is not null
    • Required
      [Team Name] is not null
Layouts