Queries

• 3
  Expressions:

  

  Data Items

  

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

• 

  

  Query1

  Data Items

  16

  State Name	CASE when [Presentation].[State].[NAME] = ('Bring_Forward ') then ('Bring Forward / Rappel') else [Presentation].[State].[NAME] End
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Current date Run	current_date
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  Pay Period Year	[Presentation].[Case].[PAY_PERIOD_YEAR_1]
  Case Number	[Presentation].[Case].[ID]
  Department	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Name	[Presentation].[Case].[NAME]
  PRI	[Presentation].[Case].[PRI]
  Pay Period	[Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PAY_PERIOD_1]
  BF Date	cast(_add_hours ( [Presentation].[Case].[DATE_BF],-4 ),date)
  Pay Period Year1	[Presentation].[Case].[PAY_PERIOD_YEAR_1]
  Work Type Name	[Presentation].[Work Type].[NAME]
  Subtype Code	[Presentation].[Sub Type].[SUB_TYPE_CODE]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Processing Date	cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PROCESSING_DATE],-4 ),date)

  • Detail Filters
    4
  • 

    [State Name] = 'Bring Forward / Rappel'
    
  • 

    [Business Unit] = (?SUB para_dept_code?)
    
  • 

    [Processing Date] in (?SUB_Process_Date?)
    
  • 

    [Business Unit] in (? para_dept_code 2?)
    
• 

  

  Query2

  Data Items

  2

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]

• 

  

  Load Last Date Query

  Data Items

  1

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

Layouts