Deployments
UAT_PCR_Deployment
Reports
Report Name: Weekend Overtime Productivity Report
Overview

  • Queries: 18

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 18
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Query-Assigned
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[ASSIGNEE_CURR]
    Team Name
    replace ([Presentation].[VW_STG_GROUPS].[NAME], 'Compensation-Advisor-', 'Team ')
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[Case].[DATE_ASSIGNED],-5 ), date)
    Action
    '1: Assigned'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Verified
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[VERIFIER]
    Team Name
    'Team Verifiers'
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[Case].[VERIFIED_DATE],-5 ), date)
    Action
    '7: Verified'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Closed
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[ASSIGNEE_CURR]
    Team Name
    replace ([Presentation].[VW_STG_GROUPS].[NAME], 'Compensation-Advisor-', 'Team ')
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Action
    '5: Closed'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Cancelled
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[ASSIGNEE_CURR]
    Team Name
    replace ([Presentation].[VW_STG_GROUPS].[NAME], 'Compensation-Advisor-', 'Team ')
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    Action
    '6: Cancelled'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Sent for Verification
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[ASSIGNEE_CURR]
    Team Name
    replace ([Presentation].[VW_STG_GROUPS].[NAME], 'Compensation-Advisor-', 'Team ')
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[VW_STG_HISTORY Alias].[ACTION_TIMESTAMP],-5 ), date)
    Action
    '2: Sent for Verification'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] in ('Ready_To_Verify')
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] = 'Assigned')
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] in ('Ready_To_Verify')
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] = 'Assigned')
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Returned from Verification
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[ASSIGNEE_CURR]
    Team Name
    replace ([Presentation].[VW_STG_GROUPS].[NAME], 'Compensation-Advisor-', 'Team ')
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[VW_STG_HISTORY Alias].[ACTION_TIMESTAMP],-5 ), date)
    Action
    '3: Returned from Verification'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] = 'Reassigned'
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] in ('Ready_To_Verify'))
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] = 'Reassigned'
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] in ('Ready_To_Verify'))
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Sent to Pending
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[ASSIGNEE_CURR]
    Team Name
    replace ([Presentation].[VW_STG_GROUPS].[NAME], 'Compensation-Advisor-', 'Team ')
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[VW_STG_HISTORY Alias].[ACTION_TIMESTAMP],-5 ), date)
    Action
    '4: Sent to Pending'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] = 'Pending'
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] = 'Assigned')
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] = 'Pending'
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] = 'Assigned')
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Rejected by Verifier
    Data Items
    18
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    cast(_add_hours ([Presentation].[Case].[DATE_OPEN],-5 ), date)
    BF Date
    cast(_add_hours ([Presentation].[Case].[DATE_BF],-5 ), date)
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    Assigned Agent
    [Presentation].[Case].[VERIFIER]
    Team Name
    'Team Verifiers'
    Date Closed
    cast(_add_hours ([Presentation].[Case].[DATE_CLOSED],-5 ), date)
    Date Cancelled
    cast(_add_hours ([Presentation].[Case].[Date Cancelled],-5 ), date)
    EX / Non EX
    [Presentation].[Case].[SUBJECT]
    Date of Action-formatted
    cast(_add_hours ([Presentation].[VW_STG_HISTORY Alias].[ACTION_TIMESTAMP],-5 ), date)
    Action
    '8: Rejected by Verifier'
    Start-Date Monday
    cast(Getdate()-7, date)
    End-Date Sunday
    cast(Getdate()-1, date)
    • Detail Filters
      1
    • Required
      (
      ((?Param-date-prompt? = '1') and
      (([Date of Action-formatted] >= [Start-Date Monday] and [Date of Action-formatted] <= [End-Date Sunday])
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] = 'Reassigned'
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] in ('Ready_To_Verify'))
      and [Presentation].[Compensation Advisor]))
      )
      or
      (
      ((?Param-date-prompt? = '2') and
      (([Date of Action-formatted] >= #prompt('Param-start-date', 'date', 'current_date')# and [Date of Action-formatted] <= #prompt('Param-end-date', 'date', 'current_date')#)
      and ([Presentation].[VW_STG_HISTORY Alias].[NEW_STATE] = 'Reassigned'
      and [Presentation].[VW_STG_HISTORY Alias].[OLD_STATE] in ('Ready_To_Verify'))
      and [Presentation].[Compensation Advisor]))
      )
  • Query
    Query-Date
    Data Items
    2
    Full Date
    cast([Presentation].[Date Opened Dim].[FullDate], date)
    Weekday Weekend or Holiday
    [Presentation].[Date Opened Dim].[WeekdayWeekend]
  • Query
    Query-Assigned-chk
    Join 
    [Query-Assigned].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Assigned
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Assigned].[Case Number]
    Processing Centre
    [Query-Assigned].[Processing Centre]
    Age
    [Query-Assigned].[Age]
    Date Open
    [Query-Assigned].[Date Open]
    BF Date
    [Query-Assigned].[BF Date]
    Work Type Name
    [Query-Assigned].[Work Type Name]
    Sub Type Name
    [Query-Assigned].[Sub Type Name]
    Business Unit
    [Query-Assigned].[Business Unit]
    Classification
    [Query-Assigned].[Classification]
    Assigned Agent
    [Query-Assigned].[Assigned Agent]
    Team Name
    [Query-Assigned].[Team Name]
    Date Closed
    [Query-Assigned].[Date Closed]
    Date Cancelled
    [Query-Assigned].[Date Cancelled]
    EX / Non EX
    [Query-Assigned].[EX / Non EX]
    Date of Action-formatted
    [Query-Assigned].[Date of Action-formatted]
    Action
    [Query-Assigned].[Action]
    Start-Date Monday
    [Query-Assigned].[Start-Date Monday]
    End-Date Sunday
    [Query-Assigned].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-Verified-chk
    Join 
    [Query-Verified].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Verified
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Verified].[Case Number]
    Processing Centre
    [Query-Verified].[Processing Centre]
    Age
    [Query-Verified].[Age]
    Date Open
    [Query-Verified].[Date Open]
    BF Date
    [Query-Verified].[BF Date]
    Work Type Name
    [Query-Verified].[Work Type Name]
    Sub Type Name
    [Query-Verified].[Sub Type Name]
    Business Unit
    [Query-Verified].[Business Unit]
    Classification
    [Query-Verified].[Classification]
    Assigned Agent
    [Query-Verified].[Assigned Agent]
    Team Name
    [Query-Verified].[Team Name]
    Date Closed
    [Query-Verified].[Date Closed]
    Date Cancelled
    [Query-Verified].[Date Cancelled]
    EX / Non EX
    [Query-Verified].[EX / Non EX]
    Date of Action-formatted
    [Query-Verified].[Date of Action-formatted]
    Action
    [Query-Verified].[Action]
    Start-Date Monday
    [Query-Verified].[Start-Date Monday]
    End-Date Sunday
    [Query-Verified].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-Closed-chk
    Join 
    [Query-Closed].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Closed
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Closed].[Case Number]
    Processing Centre
    [Query-Closed].[Processing Centre]
    Age
    [Query-Closed].[Age]
    Date Open
    [Query-Closed].[Date Open]
    BF Date
    [Query-Closed].[BF Date]
    Work Type Name
    [Query-Closed].[Work Type Name]
    Sub Type Name
    [Query-Closed].[Sub Type Name]
    Business Unit
    [Query-Closed].[Business Unit]
    Classification
    [Query-Closed].[Classification]
    Assigned Agent
    [Query-Closed].[Assigned Agent]
    Team Name
    [Query-Closed].[Team Name]
    Date Closed
    [Query-Closed].[Date Closed]
    Date Cancelled
    [Query-Closed].[Date Cancelled]
    EX / Non EX
    [Query-Closed].[EX / Non EX]
    Date of Action-formatted
    [Query-Closed].[Date of Action-formatted]
    Action
    [Query-Closed].[Action]
    Start-Date Monday
    [Query-Closed].[Start-Date Monday]
    End-Date Sunday
    [Query-Closed].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-Cancelled-chk
    Join 
    [Query-Cancelled].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Cancelled
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Cancelled].[Case Number]
    Processing Centre
    [Query-Cancelled].[Processing Centre]
    Age
    [Query-Cancelled].[Age]
    Date Open
    [Query-Cancelled].[Date Open]
    BF Date
    [Query-Cancelled].[BF Date]
    Work Type Name
    [Query-Cancelled].[Work Type Name]
    Sub Type Name
    [Query-Cancelled].[Sub Type Name]
    Business Unit
    [Query-Cancelled].[Business Unit]
    Classification
    [Query-Cancelled].[Classification]
    Assigned Agent
    [Query-Cancelled].[Assigned Agent]
    Team Name
    [Query-Cancelled].[Team Name]
    Date Closed
    [Query-Cancelled].[Date Closed]
    Date Cancelled
    [Query-Cancelled].[Date Cancelled]
    EX / Non EX
    [Query-Cancelled].[EX / Non EX]
    Date of Action-formatted
    [Query-Cancelled].[Date of Action-formatted]
    Action
    [Query-Cancelled].[Action]
    Start-Date Monday
    [Query-Cancelled].[Start-Date Monday]
    End-Date Sunday
    [Query-Cancelled].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-Sent for Verification-chk
    Join 
    [Query-Sent for Verification].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Sent for Verification
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Sent for Verification].[Case Number]
    Processing Centre
    [Query-Sent for Verification].[Processing Centre]
    Age
    [Query-Sent for Verification].[Age]
    Date Open
    [Query-Sent for Verification].[Date Open]
    BF Date
    [Query-Sent for Verification].[BF Date]
    Work Type Name
    [Query-Sent for Verification].[Work Type Name]
    Sub Type Name
    [Query-Sent for Verification].[Sub Type Name]
    Business Unit
    [Query-Sent for Verification].[Business Unit]
    Classification
    [Query-Sent for Verification].[Classification]
    Assigned Agent
    [Query-Sent for Verification].[Assigned Agent]
    Team Name
    [Query-Sent for Verification].[Team Name]
    Date Closed
    [Query-Sent for Verification].[Date Closed]
    Date Cancelled
    [Query-Sent for Verification].[Date Cancelled]
    EX / Non EX
    [Query-Sent for Verification].[EX / Non EX]
    Date of Action-formatted
    [Query-Sent for Verification].[Date of Action-formatted]
    Action
    [Query-Sent for Verification].[Action]
    Start-Date Monday
    [Query-Sent for Verification].[Start-Date Monday]
    End-Date Sunday
    [Query-Sent for Verification].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-Returned from Verification-chk
    Join 
    [Query-Returned from Verification].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Returned from Verification
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Returned from Verification].[Case Number]
    Processing Centre
    [Query-Returned from Verification].[Processing Centre]
    Age
    [Query-Returned from Verification].[Age]
    Date Open
    [Query-Returned from Verification].[Date Open]
    BF Date
    [Query-Returned from Verification].[BF Date]
    Work Type Name
    [Query-Returned from Verification].[Work Type Name]
    Sub Type Name
    [Query-Returned from Verification].[Sub Type Name]
    Business Unit
    [Query-Returned from Verification].[Business Unit]
    Classification
    [Query-Returned from Verification].[Classification]
    Assigned Agent
    [Query-Returned from Verification].[Assigned Agent]
    Team Name
    [Query-Returned from Verification].[Team Name]
    Date Closed
    [Query-Returned from Verification].[Date Closed]
    Date Cancelled
    [Query-Returned from Verification].[Date Cancelled]
    EX / Non EX
    [Query-Returned from Verification].[EX / Non EX]
    Date of Action-formatted
    [Query-Returned from Verification].[Date of Action-formatted]
    Action
    [Query-Returned from Verification].[Action]
    Start-Date Monday
    [Query-Returned from Verification].[Start-Date Monday]
    End-Date Sunday
    [Query-Returned from Verification].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-Sent to Pending-chk
    Join 
    [Query-Sent to Pending].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Sent to Pending
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Sent to Pending].[Case Number]
    Processing Centre
    [Query-Sent to Pending].[Processing Centre]
    Age
    [Query-Sent to Pending].[Age]
    Date Open
    [Query-Sent to Pending].[Date Open]
    BF Date
    [Query-Sent to Pending].[BF Date]
    Work Type Name
    [Query-Sent to Pending].[Work Type Name]
    Sub Type Name
    [Query-Sent to Pending].[Sub Type Name]
    Business Unit
    [Query-Sent to Pending].[Business Unit]
    Classification
    [Query-Sent to Pending].[Classification]
    Assigned Agent
    [Query-Sent to Pending].[Assigned Agent]
    Team Name
    [Query-Sent to Pending].[Team Name]
    Date Closed
    [Query-Sent to Pending].[Date Closed]
    Date Cancelled
    [Query-Sent to Pending].[Date Cancelled]
    EX / Non EX
    [Query-Sent to Pending].[EX / Non EX]
    Date of Action-formatted
    [Query-Sent to Pending].[Date of Action-formatted]
    Action
    [Query-Sent to Pending].[Action]
    Start-Date Monday
    [Query-Sent to Pending].[Start-Date Monday]
    End-Date Sunday
    [Query-Sent to Pending].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-Rejected by Verifier-chk
    Join 
    [Query-Rejected by Verifier].[Date of Action-formatted] = [Query-Date].[Full Date]
    refQuery
    Query-Rejected by Verifier
    1:1
    refQuery
    Query-Date
    1:1
    Data Items
    18
    Case Number
    [Query-Rejected by Verifier].[Case Number]
    Processing Centre
    [Query-Rejected by Verifier].[Processing Centre]
    Age
    [Query-Rejected by Verifier].[Age]
    Date Open
    [Query-Rejected by Verifier].[Date Open]
    BF Date
    [Query-Rejected by Verifier].[BF Date]
    Work Type Name
    [Query-Rejected by Verifier].[Work Type Name]
    Sub Type Name
    [Query-Rejected by Verifier].[Sub Type Name]
    Business Unit
    [Query-Rejected by Verifier].[Business Unit]
    Classification
    [Query-Rejected by Verifier].[Classification]
    Assigned Agent
    [Query-Rejected by Verifier].[Assigned Agent]
    Team Name
    [Query-Rejected by Verifier].[Team Name]
    Date Closed
    [Query-Rejected by Verifier].[Date Closed]
    Date Cancelled
    [Query-Rejected by Verifier].[Date Cancelled]
    EX / Non EX
    [Query-Rejected by Verifier].[EX / Non EX]
    Date of Action-formatted
    [Query-Rejected by Verifier].[Date of Action-formatted]
    Action
    [Query-Rejected by Verifier].[Action]
    Start-Date Monday
    [Query-Rejected by Verifier].[Start-Date Monday]
    End-Date Sunday
    [Query-Rejected by Verifier].[End-Date Sunday]
    • Detail Filters
      1
    • Required
      (((#sq($runLocale)# = 'en') and [Query-Date].[Weekday Weekend or Holiday] in ('Weekend', 'Holiday'))
      or ((#sq($runLocale)# = 'fr') and [Query-Date].[Weekday Weekend or Holiday] in ('Fin de semaine', 'Vacances')))
  • Query
    Query-main
    Join
    Query Reference
    Query-Assigned-chk
    Query Reference
    Query-Verified-chk
    Query Reference
    Query-Closed-chk
    Query Reference
    Query-Cancelled-chk
    Query Reference
    Query-Sent for Verification-chk
    Query Reference
    Query-Returned from Verification-chk
    Query Reference
    Query-Sent to Pending-chk
    Query Reference
    Query-Rejected by Verifier-chk
    • Projected Data Items
    • Case Number
    • Processing Centre
    • Age
    • Date Open
    • BF Date
    • Work Type Name
    • Sub Type Name
    • Business Unit
    • Classification
    • Assigned Agent
    • Team Name
    • Date Closed
    • Date Cancelled
    • EX / Non EX
    • Date of Action-formatted
    • Action
    • Start-Date Monday
    • End-Date Sunday
    Data Items
    23
    Case Number-for detail rpt
    [Union1].[Case Number]
    Case Number
    [Union1].[Case Number]
    Aggregate
    count count
    Rollup
    total total
    Processing Centre
    [Union1].[Processing Centre]
    Age
    [Union1].[Age]
    Date Open
    [Union1].[Date Open]
    BF Date
    [Union1].[BF Date]
    Work Type Name
    [Union1].[Work Type Name]
    Sub Type Name
    [Union1].[Sub Type Name]
    Business Unit
    [Union1].[Business Unit]
    Classification
    [Union1].[Classification]
    Assigned Agent
    [Union1].[Assigned Agent]
    Assigned Agent cnt
    count(distinct([Union1].[Assigned Agent]) for [Date of Action-formatted])
    label
    Number of Unique Agents
    Team Name
    [Union1].[Team Name]
    Date Closed
    [Union1].[Date Closed]
    Date Cancelled
    [Union1].[Date Cancelled]
    EX / Non EX
    [Union1].[EX / Non EX]
    Date of Action-formatted
    [Union1].[Date of Action-formatted]
    Action
    Case
    when (#sq($runLocale)# = 'fr')
    Then
    Case
    when ([Union1].[Action] = '1: Assigned')
    then '1: Attribué'
    when ([Union1].[Action] = '2: Sent for Verification')
    then '2: Envoyé pour vérification'
    when ([Union1].[Action] = '3: Returned from Verification')
    then '3: Renvoyé de la vérification'
    when ([Union1].[Action] = '4: Sent to Pending')
    then '4: Mis en attente'
    when ([Union1].[Action] = '5: Closed')
    then '5: Fermé'
    when ([Union1].[Action] = '6: Cancelled')
    then '6: Annulé'
    when ([Union1].[Action] = '7: Verified')
    then '7: Vérifié'
    when ([Union1].[Action] = '8: Rejected by Verifier')
    then '8: Rejeté par le vérificateur'
    End
    else [Union1].[Action]
    End
    Team-Sort-1
    substring([Team Name],6)
    Team-Sort-2
    case
    when ( [Team-Sort-1] = 'OGD' ) then '200'
    when ( [Team-Sort-1] = 'Verifiers' ) then '300'
    else ([Team-Sort-1])
    end
    Team-Sort-3
    cast([Team-Sort-2],Integer)
    Start-Date Weekend
    minimum([Union1].[Date of Action-formatted]for report)
    End-Date Weekend
    maximum ([Union1].[Date of Action-formatted]for report)
Layouts