Queries

• 2
  Expressions:

  

  Data Items

  

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

• 

  

  qry_main

  Data Items

  10

  Case Number	[Presentation].[Case].[ID]
  Date Open	#/* Replaced with New OPEN date field */# '="' + cast([Presentation].[Case].[DATE_OPEN_EST_DATE_TIME],varchar(19)) + '"'
  BF Date	#/* Replaced with New BF date field */# '="' + cast([Presentation].[Case].[DATE_BF_EST_DATE_TIME],varchar(19)) + '"'
  Work Type Name	[Presentation].[Work Type].[NAME]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Department	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Classification	[Presentation].[Case].[CLASSIFICATION]
  Language	[Presentation].[Case].[LANG]
  Current Date Stamp-1day	(_add_days ( cast(getdate(), date), - 1 ))	label Current Date Stamp
  Group	[Presentation].[VW_STG_ACCESS_CONTROL].[NAME]

  • Detail Filters
    3
  • 

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

    #/* Replaced with New BF, OPEN , ACTION_TIMESTAMP_EST date fields */#
    (([Presentation].[Case].[DATE_BF_EST] is null) and ( [Presentation].[Case].[DATE_OPEN_EST] = [Current Date Stamp-1day]))
    or
    (([Presentation].[VW_STG_HISTORY].[NEW_STATE] = 'Open')
    and
    ([Presentation].[VW_STG_HISTORY].[OLD_STATE] = 'Bring_Forward')
    and
    ([Presentation].[VW_STG_HISTORY].[ACTION_TIMESTAMP_EST] = [Current Date Stamp-1day]))
    
  • 

    [Group] <> 'Restricted'
    
• 

  

  Load Date Query

  Data Items

  1

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

Layouts