Queries

• 2
  Expressions:

  

  Data Items

  

  Detail Filters
• Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model

• 

  

  Query-Main

  Data Items

  23

  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]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Code	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  State Name	[Presentation].[State].[NAME]
  Employee Sub-Category	[Presentation].[Case].[CLASSIFICATION]
  Language	[Presentation].[Case].[LANG]
  Urgent	[Presentation].[Case].[URGENT]
  Date Received	'="' + cast(_add_hours ([Presentation].[Case].[DATE_RECEIVED],-4 ),varchar(19)) + '"'
  Date Received-for header	[Presentation].[Case].[DATE_RECEIVED]
  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]

  • Detail Filters
    3
  • 

    [Presentation].[Case].[DBID] > 0
    
  • 

    [Presentation].[Case].[VERIFIER] is null
    
  • 

    [Presentation].[State].[NAME] in ('Invalid', 'Open', 'Reassigned')
    
• 

  

  Load Date Query

  Data Items

  1

  Latest Valid Data Load Date	[Presentation].[Data Load Archive].[Latest Valid Data Load Date]

Layouts