Deployments
UAT_PCR_Deployment
Reports
Report Name: Closed or 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
    Query-Main
    Data Items
    27
    DBID
    [Presentation].[Case].[DBID]
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    '="'+[Presentation].[Case].[PROCESSING_CENTRE]+'"'
    Processing Centre-for header
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    '="' + cast(_add_hours ( [Presentation].[Case].[DATE_OPEN],-4 ),varchar(19)) + '"'
    Date Open-for header
    [Presentation].[Case].[DATE_OPEN]
    BF Date
    '="' + cast(_add_hours ( [Presentation].[Case].[DATE_BF],-4 ),varchar(19)) + '"'
    BF Date-for header
    [Presentation].[Case].[DATE_BF]
    PRI
    '="'+ [Presentation].[Case].[PRI]+'"'
    PRI-for header
    [Presentation].[Case].[PRI]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Code
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Employee Sub-Category
    [Presentation].[Case].[CLASSIFICATION]
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    Urgent
    [Presentation].[Case].[URGENT]
    Name
    [Presentation].[Case].[NAME]
    Group Name
    [Presentation].[VW_STG_GROUPS].[NAME]
    Date Effective From
    '="' + cast(_add_hours ( [Presentation].[Case].[DATE_EFFECTIVE_FROM],-4 ),varchar(19)) + '"'
    Date Effective From-for header
    [Presentation].[Case].[DATE_EFFECTIVE_FROM]
    Date Effective To
    '="' + cast(_add_hours ( [Presentation].[Case].[DATE_EFFECTIVE_TO],-4 ),varchar(19)) + '"'
    Date Effective To-for header
    [Presentation].[Case].[DATE_EFFECTIVE_TO]
    ACTION_TIMESTAMP
    cast([Date of Action(-4hrs)],date)
    Date of Action(-4hrs)
    (_add_hours ([Presentation].[VW_STG_HISTORY].[ACTION_TIMESTAMP], -4))
    Current Date Stamp-1day
    (_add_days ( cast(getdate(), date), - 1 ))
    label
    Current Date Stamp-1
    Current Date Stamp-2day
    (_add_days ( cast(getdate(), date), - 2 ))
    label
    Current Date Stamp-2
    • Detail Filters
      5
    • Required
      [Presentation].[Case].[DBID] <> 0
    • Required
      ([Presentation].[VW_STG_HISTORY].[ENTITYDEF_ID] = 16777228)
      and
      ([Presentation].[VW_STG_HISTORY].[NEW_STATE] in ('Cancelled', 'Closed'))
    • Required
      Case
      when (?Param-Date-Daily? = 0)
      then ([ACTION_TIMESTAMP] in_range ?Param-Date-Range?)
      when (?Param-Date-Daily? = 1)
      then ([ACTION_TIMESTAMP] = [Current Date Stamp-1day])
      when (?Param-Date-Daily? = 2)
      then ([ACTION_TIMESTAMP] = [Current Date Stamp-2day])
      end
    • Disabled
      [Presentation].[VW_STG_PARENT_CHILD_LINKS].[PARENT_FIELDDEF_ID] = 16777321
    • Required
      [Presentation].[Compensation Advisor]
  • Query
    Load Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts