Queries

• 3
  Expressions:

  

  Data Items

  

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

• 

  

  Query1

  Data Items

  16

  Age	[Presentation].[Case].[CMT_AGE]
  State Name	[Presentation].[State].[NAME]
  Date Closed	_add_hours ([Presentation].[Case].[DATE_CLOSED], -4)
  Date Closed-for header	[Presentation].[Case].[DATE_CLOSED]
  PRI	[Presentation].[Case].[PRI]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Pay List	[Presentation].[Case].[PL]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Date Open	_add_hours ( [Presentation].[Case].[DATE_OPEN],-4 )
  Date Open-for header	[Presentation].[Case].[DATE_OPEN]
  Date Assigned	[Presentation].[Case].[DATE_ASSIGNED]
  Work Type Name	[Presentation].[Work Type].[NAME]
  Current date Run	current_date
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  Case Number	[Presentation].[Case].[ID]
  Case Group Type	[Presentation].[Case].[Case Group Type]

  • Detail Filters
    4
  • 

    [PRI] = '025591452'
    
  • 

    [State Name] = 'Closed'
    
  • 

    [Business Unit] = ?para_dept_code?
    
  • 

    if (?Param-Date-Daily? = 0) then
    ([Date Closed] in_range ?para_date_closed?)
    else if (?Param-Date-Daily? = 1) then
    (cast([Date Closed],date) between (_first_of_month(_add_months ( current_date,-1)))and (_last_of_month(_add_months ( current_date,-1))))
    else (0)
    
• 

  

  Query2

  Data Items

  2

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

  • Detail Filters
    1
  • 

    [Department Name] = 'Veterans Affairs Canada / Ministère des Affaires des anciens combattants'
    
• 

  

  Load Last Date Query

  Data Items

  1

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

Layouts