Deployments
UAT_PCR_Deployment
Reports
Report Name: Departmental Timeliness Report-Details
Overview

  • Queries: 4

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 4
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    All Transactions1
    • queryHints
    • crossProductAllowed: allow
    Data Items
    18
    Department
    [Presentation].[VW_STG_DEPARTMENT].[NAME_1]
    CODE
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Created By Category
    [Presentation].[Case].[Created by Category]
    TRANSACTION_TYPE
    [Presentation].[Sub Type].[TRANSACTION_TYPE]
    Month
    cast(year( [Presentation].[Case].[DATE_RECEIVED_EST]) ,varchar(4))
    + '-'+
    right('00'+cast(month([Presentation].[Case].[DATE_RECEIVED_EST]),varchar(2)),2)
    Sub Type Code
    [Presentation].[Sub Type].[SUB_TYPE_CODE]
    Date Received
    cast([Presentation].[Case].[DATE_RECEIVED_EST], date)
    Date Open
    cast([Presentation].[Case].[DATE_OPEN_EST], date)
    Case Number
    [Presentation].[Case].[ID]
    Date Effective From
    cast([Presentation].[Case].[DATE_EFFECTIVE_FROM_EST], date)
    On Time
    if ( [Date Received] <= [Date Effective From]) then (1) else (0)
    Aggregate
    total total
    Rollup
    total total
    Case Count
    if ( [Date Received] <= [Date Effective From] ) then ( 1 ) else ( 0 )
    Aggregate
    count count
    Rollup
    total total
    Days of Delay
    _days_between( [Presentation].[Case].[DATE_RECEIVED_EST], [Presentation].[Case].[DATE_EFFECTIVE_FROM_EST] )
    Aggregate
    total total
    Rollup
    average average
    Summary(Case Count)
    [Case Count]
    Aggregate
    calculated calculated
    Rollup
    automatic automatic
    Summary(Days of Delay)
    [Days of Delay]
    Aggregate
    calculated calculated
    Rollup
    automatic automatic
    Summary(On Time Flag)1
    [On Time]
    Aggregate
    calculated calculated
    Rollup
    automatic automatic
    Days per Case
    [Summary(Days of Delay)] / [Summary(Case Count)]
    On Time %
    [Summary(On Time Flag)1] / [Summary(Case Count)]
    • Detail Filters
      7
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] in ('AGR', 'AHS', 'CAP', 'CDC', 'CES', 'CGC', 'COP', 'CSD', 'DFO', 'DND', 'DOE', 'DUS', 'DVA', 'ESO', 'EXT', 'FIN', 'GSS', 'IAN', 'ICA', 'IMC', 'IRB', 'JUS', 'NED', 'NFB', 'NHW', 'NPB', 'PCH', 'PCO', 'PEN', 'PPD', 'PSC', 'PSP', 'PXR', 'RCM', 'RSN', 'RTC', 'SIR', 'SVC', 'TBD')
    • Optional
      [Presentation].[VW_STG_DEPARTMENT].[CODE] in ?Department?
    • Required
      [Presentation].[Case].[DATE_EFFECTIVE_FROM_EST] <=2022-12-31
      and [Presentation].[Case].[DATE_EFFECTIVE_FROM_EST] is not null
    • Required
      [Presentation].[Sub Type].[SUB_TYPE_CODE] not in ('ST-024', 'ST-037', 'ST-041', 'ST-042', 'ST-050', 'ST-071', 'ST-072', 'ST-082', 'ST-083', 'ST-086', 'ST-089', 'ST-092', 'ST-093', 'ST-094', 'ST-095', 'ST-097', 'ST-098', 'ST-100', 'ST-118', 'ST-121', 'ST-122', 'ST-123', 'ST-124', 'ST-125', 'ST-132', 'ST-147', 'ST-149', 'ST-150', 'ST-153', 'ST-154', 'ST-155', 'ST-161', 'ST-162', 'ST-163', 'ST-167', 'ST-169', 'ST-170', 'ST-171', 'ST-182', 'ST-183', 'ST-188', 'ST-189', 'ST-191', 'ST-192', 'ST-193', 'ST-194', 'ST-195', 'ST-196', 'ST-197', 'ST-198', 'ST-199', 'ST-200', 'ST-201', 'ST-209', 'ST-210', 'ST-211', 'ST-212', 'ST-213', 'ST-214', 'ST-215', 'ST-216', 'ST-217', 'ST-222', 'ST-223', 'ST-224', 'ST-225', 'ST-232', 'ST-233', 'ST-234', 'ST-235', 'ST-236', 'ST-240', 'ST-241', 'ST-247', 'ST-262', 'ST-268', 'ST-269', 'ST-273', 'ST-280', 'ST-306', 'ST-504', 'ST-330', 'ST-505', 'ST-508', 'ST-509', 'ST-517', 'ST-518', 'ST-525', 'ST-526', 'ST-527', 'ST-538', 'ST-540', 'ST-611')
    • Optional
      ?Created By? = 'PAR' and [Presentation].[Case].[Created by Category] in ('PAR', 'DIP')
      or
      ?Created By? = 'Worklist' and [Presentation].[Case].[Created by Category] in ('Worklist', 'Liste de travail')
    • Optional
      [Month] = ?Month?
    • Optional
      [Presentation].[Sub Type].[TRANSACTION_TYPE] in ?Transaction Type?
  • Query
    pq_Department
    Data Items
    2
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Department Name
    [Presentation].[VW_STG_DEPARTMENT].[NAME_1]
    sort
    sort: ascending ascending
  • Query
    pq_Transaction_Type
    Data Items
    1
    TRANSACTION_TYPE
    [Presentation].[Sub Type].[TRANSACTION_TYPE]
  • Query
    pq_Created_By
    Data Items
    1
    Created by Category
    [Presentation].[Case].[Created by Category]
    • Detail Filters
      1
    • Required
      [Created by Category] in ('PAR', 'DIP', 'Worklist', 'Liste de travail')
Layouts