Deployments
UAT_PCR_Deployment
Reports
Report Name: Cases Late by More Than 90 Days
Overview

  • Queries: 6

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 6
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    CasesOver90
    Data Items
    8
    Transaction Type
    [Presentation].[Sub Type].[TRANSACTION_TYPE]
    Case Count
    [Presentation].[Case].[Case Count]
    Aggregate
    count count
    Days Between
    _days_between ([Presentation].[Case].[DATE_RECEIVED_EST],[Presentation].[Case].[DATE_EFFECTIVE_FROM_EST])
    Month
    month([Presentation].[Case].[DATE_RECEIVED_EST])
    Year
    year([Presentation].[Case].[DATE_RECEIVED_EST])
    First Day of Report
    CASE ?DateOption?
    WHEN 1 THEN (#prompt('StartDate','date','current_date')# )
    WHEN 0 THEN (_first_of_month(_add_months(current_date, -12)))
    END
    Last Day of Report
    CASE ?DateOption?
    WHEN 1 THEN (#prompt('EndDate','date','current_date')# )
    WHEN 0 THEN (
    _last_of_month(_add_months(current_date, -1)))
    END
    Month Name
    trim([Presentation].[Date Received Dim].[MonthName])
    • Detail Filters
      6
    • Required
      [Presentation].[Case].[DATE_RECEIVED_EST] between [First Day of Report] and [Last Day of Report]
    • Required
      [Transaction Type] not in ( CAI,)
    • Required
      [Presentation].[Case].[DATE_EFFECTIVE_FROM_EST] is not NULL
    • Required
      [Days Between] > 90
    • Required
      (?Dept_Name? = 'Include All') and (1=1) or ([Presentation].[Case].[DEPARTMENT] = ?Dept_Name?)
    • Required
      [Presentation].[Case].[Created by Category] in ('PAR', 'Worklist','DIP','Liste de travail')
  • Query
    ListCasesOver90
    Data Items
    18
    Transaction Type
    [Presentation].[Sub Type].[TRANSACTION_TYPE]
    Case Count
    [Presentation].[Case].[Case Count]
    Aggregate
    count count
    Days Between
    _days_between ([Presentation].[Case].[DATE_RECEIVED_EST],[Presentation].[Case].[DATE_EFFECTIVE_FROM_EST])
    Month Name
    datename({month},[Presentation].[Case].[DATE_RECEIVED_EST])
    Month
    month([Presentation].[Case].[DATE_RECEIVED_EST])
    Year
    year([Presentation].[Case].[DATE_RECEIVED_EST])
    First Day of Report
    CASE ?DateOption?
    WHEN 1 THEN (#prompt('StartDate','date','current_date')# )
    WHEN 0 THEN (_first_of_month(_add_months(current_date, -12)))
    END
    Last Day of Report
    CASE ?DateOption?
    WHEN 1 THEN (#prompt('EndDate','date','current_date')# )
    WHEN 0 THEN (
    _last_of_month(_add_months(current_date, -1)))
    END
    Department
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Case Number
    [Presentation].[Case].[ID]
    PRI
    [Presentation].[Case].[PRI]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    State Name
    [Presentation].[State].[NAME]
    Pending Reason
    [Presentation].[Case].[PENDING_REASON]
    Created by Category
    [Presentation].[Case].[Created by Category]
    Date Received
    [Presentation].[Case].[DATE_RECEIVED_EST]
    Date Effective From
    [Presentation].[Case].[DATE_EFFECTIVE_FROM_EST]
    • Detail Filters
      6
    • Required
      [Presentation].[Case].[DATE_RECEIVED_EST] between [First Day of Report] and [Last Day of Report]
    • Required
      [Transaction Type] not in ( CAI,)
    • Required
      [Presentation].[Case].[DATE_EFFECTIVE_FROM_EST] is not NULL
    • Required
      [Days Between] >90
    • Required
      (?Dept_Name? = 'Include All') and (1=1) or ([Presentation].[Case].[DEPARTMENT] = ?Dept_Name?)
    • Required
      [Created by Category] in ('PAR', 'Worklist','DIP','Liste de travail')
  • Query
    ReportDates
    Data Items
    2
    First Day of Report
    CASE ?DateOption?
    WHEN 1 THEN (#prompt('StartDate','date','current_date')# )
    WHEN 0 THEN (_first_of_month(_add_months(current_date, -12)))
    END
    Last Day of Report
    CASE ?DateOption?
    WHEN 1 THEN (#prompt('EndDate','date','current_date')# )
    WHEN 0 THEN (
    _last_of_month(_add_months(current_date, -1)))
    END
  • Query
    Dept_Name_Prompt
    Data Items
    2
    Department Name
    [Presentation].[VW_STG_DEPARTMENT].[NAME_1]
    sort
    sort: ascending ascending
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    • Detail Filters
      1
    • Required
      [Business Unit] is not NULL
  • Query
    LastLoadDate
    Data Items
    1
    Last Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
  • Query
    DisplayName
    Data Items
    3
    Dept Name Eng
    trim(substring ([Department Name], 0, (charindex ('/',[Presentation].[VW_STG_DEPARTMENT].[NAME_1]))))
    Department Name
    [Presentation].[VW_STG_DEPARTMENT].[NAME_1]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    • Detail Filters
      3
    • Required
      [Dept Name Eng] is not null
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] is not null
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?Dept_Name?
Layouts