Queries

• 5
  Expressions:

  

  Data Items

  

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

• 

  

  Query-Work in Progress

  Data Items

  18

  Case Category	'Active'
  Case Number	[Presentation].[Case].[ID]
  Processing Centre	'="'+[Presentation].[Case].[PROCESSING_CENTRE]+'"'
  Age	[Presentation].[Case].[CMT_AGE]
  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)) + '"'
  PRI	'="'+[Presentation].[Case].[PRI] +'"'
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Classification	[Presentation].[Case].[CLASSIFICATION]
  Language	[Presentation].[Case].[LANG]
  State Name	[Presentation].[State].[NAME]
  Urgent	[Presentation].[Case].[URGENT]
  Assigned To	trim (both ' ',trim (both '·',[Presentation].[Case].[ASSIGNEE_CURR]))
  Group Name	#/* Replaced with Team Name field from Current Team on Case */# CASE(char_length ([Presentation].[VW_STG_CURRENT_TEAM].[Team_Name])-21) WHEN 1 THEN 'Team '+'00'+ substring ([Presentation].[VW_STG_CURRENT_TEAM].[Team_Name],22,char_length ([Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]) ) WHEN 2 THEN 'Team '+'0'+ substring ([Presentation].[VW_STG_CURRENT_TEAM].[Team_Name],22,char_length ([Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]) ) WHEN 3 THEN 'Team '+''+substring ([Presentation].[VW_STG_CURRENT_TEAM].[Team_Name],22,char_length ([Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]) ) ELSE [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] END
  Date Modified	#/* Replaced ACTION_TIMESTAMP_EST with Date Modified date field */# '="' +cast([Presentation].[Case].[DATE_MODIFIED_EST_DATE_TIME],varchar(19)) + '"'
  Risk Level	[Presentation].[Sub Type].[RISK_LEVEL]
  Group	[Presentation].[VW_STG_ACCESS_CONTROL].[NAME]

  • Detail Filters
    4
  • 

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

    [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Triage_Follow-Up', 'Verified')
    
  • 

    #/* Disable This filter since Current Team on Case Already has this filter applied */#
    [Presentation].[Compensation Advisor]
    
  • 

    [Presentation].[VW_STG_HISTORY].[EXPIRED_TIMESTAMP] is null
    
• 

  

  Query-All Unassigned Cases

  Data Items

  18

  Case Category	'Unassigned'
  Case Number	[Presentation].[Case].[ID]
  Processing Centre	'="'+[Presentation].[Case].[PROCESSING_CENTRE]+'"'
  Age	[Presentation].[Case].[CMT_AGE]
  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)) + '"'
  PRI	'="'+ [Presentation].[Case].[PRI] +'"'
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Classification	[Presentation].[Case].[CLASSIFICATION]
  Language	[Presentation].[Case].[LANG]
  State Name	[Presentation].[State].[NAME]
  Urgent	[Presentation].[Case].[URGENT]
  Assigned To	' '
  Group Name	' '
  Date Modified	' '
  Risk Level	' '
  Group	[Presentation].[VW_STG_ACCESS_CONTROL].[NAME]

  • Detail Filters
    2
  • 

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

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

  

  Query-BF Cases To Action

  Data Items

  18

  Case Category	'Unassigned'
  Case Number	[Presentation].[Case].[ID]
  Processing Centre	'="'+ [Presentation].[Case].[PROCESSING_CENTRE] +'"'
  Age	[Presentation].[Case].[CMT_AGE]
  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)) + '"'
  PRI	'="'+ [Presentation].[Case].[PRI]+'"'
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Classification	[Presentation].[Case].[CLASSIFICATION]
  Language	[Presentation].[Case].[LANG]
  State Name	[Presentation].[State].[NAME]
  Urgent	[Presentation].[Case].[URGENT]
  Assigned To	' '
  Group Name	' '
  Date Modified	' '
  Risk Level	' '
  Group	[Presentation].[VW_STG_ACCESS_CONTROL].[NAME]

  • Detail Filters
    3
  • 

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

    #/* Replaced with New BF date field */#
    [Presentation].[Case].[DATE_BF_EST] <= current_date
    
  • 

    [Presentation].[State].[NAME] in ('Bring_Forward')
    
• 

  

  Load Date Query

  Data Items

  1

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

• 

  

  Query-WIP-Unassigned-BF

  

  

  Query-Work in Progress

  

  Query-All Unassigned Cases

  

  Query-BF Cases To Action

  • Projected Data Items
  • Case Category
  • Case Number
  • Processing Centre
  • Age
  • Date Open
  • BF Date
  • PRI
  • Sub Type Name
  • Business Unit
  • Classification
  • Language
  • State Name
  • Urgent
  • Assigned To
  • Group Name
  • Date Modified
  • Risk Level
  • Group

  Data Items

  18

  Case Category	[Union1].[Case Category]
  Case Number	[Union1].[Case Number]
  Processing Centre	[Union1].[Processing Centre]
  Age	[Union1].[Age]
  Date Open	[Union1].[Date Open]
  BF Date	[Union1].[BF Date]
  PRI	[Union1].[PRI]
  Sub Type Name	[Union1].[Sub Type Name]
  Business Unit	[Union1].[Business Unit]
  Classification	[Union1].[Classification]
  Language	[Union1].[Language]
  State Name	[Union1].[State Name]
  Urgent	[Union1].[Urgent]
  Assigned To	[Union1].[Assigned To]
  Team Name	[Union1].[Group Name]
  Date Modified	[Union1].[Date Modified]
  Risk Level	[Union1].[Risk Level]
  Group	[Union1].[Group]

Layouts