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]
  PROCESSING_CENTRE	if (#sq($runLocale)# = 'en') then ([Presentation].[VW_RPT_Team].[PROCESSING_CENTRE_EN]) else ([Presentation].[VW_RPT_Team].[PROCESSING_CENTRE_FR])	label Processing centre team
  Date Closed-Cancelled	cast(_add_hours([Presentation].[Case].[Date Closed or Date Cancelled], -4), date)
  Name	[Presentation].[VW_RPT_Team].[TEAM_NAME]
  Assigned To	[Presentation].[Case].[ASSIGNEE_CURR]
  Case Number	[Presentation].[Case].[ID]
  PRI	[Presentation].[Case].[PRI]
  State Name	[Presentation].[State].[NAME]
  BF Date	[Presentation].[Case].[DATE_BF]
  Work Type Name	[Presentation].[Work Type].[NAME]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Awaiting Calc selected	[Presentation].[Case].[AWAITING_CALC]
  Date Awaiting Calc Selected-for filter	cast (_add_hours ([Presentation].[Case].[TIME_IN_ASSIGNED], -4), date)
  Awaiting Confirm selected	[Presentation].[Case].[AWAITING_CONFIRM]
  Date Awaiting Confirm Selected-for filter	cast (_add_hours ([Presentation].[Case].[TIME_OUT_ASSIGNED], -4), date)
  Awaiting pay sheet creation selected	[Presentation].[Case].[AWAITING_PAY_SHEET_CREAT]
  Date Awaiting Pay Sheet Creation Selected-for filter	cast (_add_hours ([Presentation].[Case].[TIME_OUT_REASSIGNED], -4), date)
  Awaiting Off Cycle selected	[Presentation].[Case].[AWAITING_OFF_CYCLE]
  Date Awaiting Off Cycle Selected-for filter	cast (_add_hours ([Presentation].[Case].[TIME_IN_REASSIGNED], -4), date)
  Pending Reason	[Presentation].[Case].[PENDING_REASON]
  Date Modified	[Presentation].[Case].[DATE_MODIFIED]
  Current Date Stamp-1day	(_add_days ( cast(getdate(), date), - 1 ))	label Current Date Stamp
  Current Date Stamp-2day	(_add_days ( cast(getdate(), date), - 2 ))

  • Detail Filters
    3
  • 

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

    [Presentation].[VW_STG_PARENT_CHILD_LINKS].[PARENT_FIELDDEF_ID] = 16777321
    
  • 

    Case
    when (?Param-Date-Daily? = 1)
    then (([Date Closed-Cancelled] in_range ?Param-Date-Range?) or
    ([Date Awaiting Calc Selected-for filter] in_range ?Param-Date-Range?) or
    ([Date Awaiting Confirm Selected-for filter] in_range ?Param-Date-Range?) or
    ([Date Awaiting Pay Sheet Creation Selected-for filter] in_range ?Param-Date-Range?) or
    ([Date Awaiting Off Cycle Selected-for filter] in_range ?Param-Date-Range?))
    when (?Param-Date-Daily? = 2)
    then (([Date Closed-Cancelled] = [Current Date Stamp-1day]) or
    ([Date Awaiting Calc Selected-for filter] = [Current Date Stamp-1day]) or
    ([Date Awaiting Confirm Selected-for filter] = [Current Date Stamp-1day]) or
    ([Date Awaiting Pay Sheet Creation Selected-for filter] = [Current Date Stamp-1day]) or
    ([Date Awaiting Off Cycle Selected-for filter] = [Current Date Stamp-1day]))
    when(?Param-Date-Daily? = 3)
    then (([Date Closed-Cancelled] = [Current Date Stamp-2day]) or
    ([Date Awaiting Calc Selected-for filter] = [Current Date Stamp-2day]) or
    ([Date Awaiting Confirm Selected-for filter] = [Current Date Stamp-2day]) or
    ([Date Awaiting Pay Sheet Creation Selected-for filter] = [Current Date Stamp-2day]) or
    ([Date Awaiting Off Cycle Selected-for filter] = [Current Date Stamp-2day]))
    end
    
• 

  

  Load Last Date Query

  Data Items

  1

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

Layouts