Deployments
UAT_PCR_Deployment
Reports
Report Name: POD Summary Backlog & Queue: Operational Report
Overview

  • Queries: 14

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 14
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    POD Backlog
    Join
    Query Reference
    PODS Cases
    Query Reference
    PODS PRI
    • Projected Data Items
    • Measure Category
    • POD_NO
    • Baseline
    • Progress on Baseline
    • Backlog
    • Queue
    • Outstanding Intake - Over SS
    • Outstanding Intake - Within SS
    • POD Start Date
    Data Items
    15
    Measure Category
    [Union1].[Measure Category]
    POD_NO
    [Union1].[POD_NO]
    Baseline
    [Union1].[Baseline]
    Aggregate
    summarize summarize
    label
    A: Baseline
    Progress on Baseline
    [Union1].[Progress on Baseline]
    Aggregate
    summarize summarize
    label
    B: Current #
    Backlog
    [Union1].[Backlog]
    Aggregate
    summarize summarize
    label
    E: Current #
    Queue
    [Union1].[Queue]
    Aggregate
    summarize summarize
    label
    H: Current #
    Outstanding Intake - Over SS
    [Union1].[Outstanding Intake - Over SS]
    Aggregate
    summarize summarize
    label
    Over SS
    Outstanding Intake - Within SS
    [Union1].[Outstanding Intake - Within SS]
    Aggregate
    summarize summarize
    Rollup
    summarize summarize
    label
    Within SS
    Backlog Variant
    [Baseline] - [Backlog]
    Aggregate
    summarize summarize
    label
    F: Variant
    Backlog Reduction
    [Backlog Variant]/[Baseline]
    Aggregate
    summarize summarize
    label
    G: Reduction
    Queue Variant
    [Baseline] - [Queue]
    Aggregate
    summarize summarize
    label
    I: Variant
    Queue Reduction
    [Queue Variant] / [Baseline]
    Aggregate
    summarize summarize
    label
    J: Reduction
    Progress Variant
    [Baseline] - [Progress on Baseline]
    Aggregate
    summarize summarize
    label
    C: Variant
    Progress Reduction
    [Progress Variant] / [Baseline]
    Aggregate
    summarize summarize
    label
    D: Reduction
    POD Start Date
    [Union1].[POD Start Date]
  • Query
    DEPT Backlog
    Join
    Query Reference
    Dept Cases
    Query Reference
    Dept PRI
    • Projected Data Items
    • POD_NO
    • DEPARTMENT CODE
    • Measure Category
    • Baseline
    • Progress on Baseline
    • Backlog
    • Queue
    • Outstanding Intake - Over SS
    • Outstanding Intake - Within SS
    • POD Start Date
    Data Items
    17
    POD_NO
    [Union2].[POD_NO]
    DEPARTMENT CODE
    [Union2].[DEPARTMENT CODE]
    label
    Business Unit
    DEPARTMENT CODE Sort
    if ( [DEPARTMENT CODE] = ?DEPT? ) then ('_' + [DEPARTMENT CODE] ) else ( [DEPARTMENT CODE] )
    label
    Business Unit
    Measure Category
    [Union2].[Measure Category]
    A: Baseline
    [Union2].[Baseline]
    Aggregate
    summarize summarize
    Progress on Baseline
    [Union2].[Progress on Baseline]
    Aggregate
    summarize summarize
    label
    B: Current #
    Backlog
    [Union2].[Backlog]
    Aggregate
    summarize summarize
    label
    E: Current #
    Queue
    [Union2].[Queue]
    Aggregate
    summarize summarize
    label
    H: Current #
    Outstanding Intake - Over SS
    [Union2].[Outstanding Intake - Over SS]
    Aggregate
    summarize summarize
    label
    Over SS
    Outstanding Intake - Within SS
    [Union2].[Outstanding Intake - Within SS]
    Aggregate
    summarize summarize
    label
    Within SS
    Backlog Variant
    [A: Baseline] - [Backlog]
    label
    F: Variant
    Backlog Reduction
    [Backlog Variant]/[A: Baseline]
    label
    G: Reduction
    Queue Variant
    [A: Baseline] - [Queue]
    label
    I: Variant
    Queue Reduction
    [Queue Variant] / [A: Baseline]
    label
    J: Reduction
    Progress Variant
    [A: Baseline] - [Progress on Baseline]
    label
    C: Variant
    Progress Reduction
    [Progress Variant] / [A: Baseline]
    label
    D: Reduction
    POD Start Date
    [Union2].[POD Start Date]
  • Query
    Case Counts PODS
    Data Items
    5
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_CASE_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    • Detail Filters
      2
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11] Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] or
      [Presentation].[Pod 18]
    • Disabled
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
  • Query
    Cases Baseline and Intake PODS
    Data Items
    6
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer)
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    POD Start Date
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    • Detail Filters
      1
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11] Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] Or
      [Presentation].[Pod 18]
  • Query
    PRI Distinct Counts PODS
    Data Items
    5
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_PRI_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    • Detail Filters
      2
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11] Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] Or
      [Presentation].[Pod 18]
    • Disabled
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
  • Query
    PRI Baseline and Intake PODS
    Data Items
    6
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    POD Start Date
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    • Detail Filters
      1
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11] Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] Or
      [Presentation].[Pod 18]
  • Query
    PODS Cases
    Join 
    [Case Counts PODS].[Measure Category] = [Cases Baseline and Intake PODS].[Measure Category] and
[Case Counts PODS].[POD_NO] = [Cases Baseline and Intake PODS].[POD_NO]
    refQuery
    Case Counts PODS
    1:N
    refQuery
    Cases Baseline and Intake PODS
    1:N
    Data Items
    9
    Measure Category
    [Case Counts PODS].[Measure Category]
    POD_NO
    [Case Counts PODS].[POD_NO]
    Baseline
    cast([Case Counts PODS].[Baseline], integer)
    Progress on Baseline
    cast([Cases Baseline and Intake PODS].[Progress on Baseline], integer)
    Backlog
    cast([Case Counts PODS].[Backlog], integer)
    Queue
    cast([Case Counts PODS].[Queue], integer)
    Outstanding Intake - Over SS
    cast([Cases Baseline and Intake PODS].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([Cases Baseline and Intake PODS].[Outstanding Intake - Within SS], integer)
    POD Start Date
    [Cases Baseline and Intake PODS].[POD Start Date]
  • Query
    PODS PRI
    Join 
    [PRI Distinct Counts PODS].[Measure Category] = [PRI Baseline and Intake PODS].[Measure Category] and
[PRI Distinct Counts PODS].[POD_NO] = [PRI Baseline and Intake PODS].[POD_NO]
    refQuery
    PRI Distinct Counts PODS
    1:N
    refQuery
    PRI Baseline and Intake PODS
    1:N
    Data Items
    9
    Measure Category
    [PRI Distinct Counts PODS].[Measure Category]
    POD_NO
    [PRI Distinct Counts PODS].[POD_NO]
    Baseline
    cast([PRI Distinct Counts PODS].[Baseline], integer)
    Progress on Baseline
    cast([PRI Baseline and Intake PODS].[Progress on Baseline], integer)
    Backlog
    cast([PRI Distinct Counts PODS].[Backlog], integer)
    Queue
    cast([PRI Distinct Counts PODS].[Queue], integer)
    Outstanding Intake - Over SS
    cast([PRI Baseline and Intake PODS].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([PRI Baseline and Intake PODS].[Outstanding Intake - Within SS], integer)
    POD Start Date
    [PRI Baseline and Intake PODS].[POD Start Date]
  • Query
    Case Counts DEPT
    Data Items
    6
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    DEPARTMENT CODE
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_CASE_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    • Detail Filters
      2
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11] Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] Or
      [Presentation].[Pod 18]
    • Disabled
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    Cases Baseline and Intake DEPT
    Data Items
    7
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer)
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    POD Start Date
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    • Detail Filters
      2
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11]Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] Or
      [Presentation].[Pod 18]
    • Disabled
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    PRI Distinct Counts DEPT
    Data Items
    6
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_PRI_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    • Detail Filters
      3
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11] Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] Or
      [Presentation].[Pod 18]
    • Disabled
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    • Disabled
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    PRI Baseline and Intake DEPT
    Data Items
    7
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    POD Start Date
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    • Detail Filters
      2
    • Required
      [Presentation].[Pod 0] Or
      [Presentation].[Pod 1] Or
      [Presentation].[Pod 2] Or
      [Presentation].[Pod 3] Or
      [Presentation].[Pod 4] Or
      [Presentation].[Pod 5] Or
      [Presentation].[Pod 6] Or
      [Presentation].[Pod 7] Or
      [Presentation].[Pod 8] Or
      [Presentation].[Pod 9] Or
      [Presentation].[Pod 10] Or
      [Presentation].[Pod 11] Or
      [Presentation].[Pod 12] Or
      [Presentation].[Pod 13] Or
      [Presentation].[Pod 14] Or
      [Presentation].[Pod 15] Or
      [Presentation].[Pod 16] Or
      [Presentation].[Pod 17] Or
      [Presentation].[Pod 18]
    • Disabled
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    Dept Cases
    Join 
    [Case Counts DEPT].[Measure Category] = [Cases Baseline and Intake DEPT].[Measure Category] and
[Case Counts DEPT].[DEPARTMENT CODE] = [Cases Baseline and Intake DEPT].[Business Unit]
    refQuery
    Case Counts DEPT
    1:N
    refQuery
    Cases Baseline and Intake DEPT
    1:N
    Data Items
    10
    POD_NO
    [Case Counts DEPT].[POD_NO]
    DEPARTMENT CODE
    [Case Counts DEPT].[DEPARTMENT CODE]
    Measure Category
    [Case Counts DEPT].[Measure Category]
    Baseline
    cast([Case Counts DEPT].[Baseline], integer)
    Progress on Baseline
    cast([Cases Baseline and Intake DEPT].[Progress on Baseline], integer)
    Backlog
    cast([Case Counts DEPT].[Backlog], integer)
    Queue
    cast([Case Counts DEPT].[Queue], integer)
    Outstanding Intake - Over SS
    cast([Cases Baseline and Intake DEPT].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([Cases Baseline and Intake DEPT].[Outstanding Intake - Within SS], integer)
    POD Start Date
    [Cases Baseline and Intake DEPT].[POD Start Date]
  • Query
    Dept PRI
    Join 
    [PRI Distinct Counts DEPT].[Measure Category] = [PRI Baseline and Intake DEPT].[Measure Category] and
[PRI Distinct Counts DEPT].[Business Unit] = [PRI Baseline and Intake DEPT].[Business Unit]
    refQuery
    PRI Distinct Counts DEPT
    1:N
    refQuery
    PRI Baseline and Intake DEPT
    1:N
    Data Items
    10
    POD_NO
    [PRI Distinct Counts DEPT].[POD_NO]
    Business Unit
    [PRI Distinct Counts DEPT].[Business Unit]
    Measure Category
    [PRI Distinct Counts DEPT].[Measure Category]
    Baseline
    cast([PRI Distinct Counts DEPT].[Baseline], integer)
    Progress on Baseline
    cast([PRI Baseline and Intake DEPT].[Progress on Baseline], integer)
    Backlog
    cast([PRI Distinct Counts DEPT].[Backlog], integer)
    Queue
    cast([PRI Distinct Counts DEPT].[Queue], integer)
    Outstanding Intake - Over SS
    cast([PRI Baseline and Intake DEPT].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([PRI Baseline and Intake DEPT].[Outstanding Intake - Within SS], integer)
    POD Start Date
    [PRI Baseline and Intake DEPT].[POD Start Date]
Layouts