Deployments
UAT_PCR_Deployment
Reports
Report Name: Work in Progress
Overview

  • Queries: 2

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 2
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Query-Main
    Data Items
    28
    DBID
    [Presentation].[Case].[DBID]
    Case Number
    [Presentation].[Case].[ID]
    Processing Centre
    '="'+[Presentation].[Case].[PROCESSING_CENTRE]+'"'
    Processing Centre-for header
    [Presentation].[Case].[PROCESSING_CENTRE]
    Age
    [Presentation].[Case].[CMT_AGE]
    Date Open
    '="' + cast(_add_hours ( [Presentation].[Case].[DATE_OPEN],-4 ),varchar(19)) + '"'
    Date Open-for header
    [Presentation].[Case].[DATE_OPEN]
    BF Date
    '="' +cast( _add_hours ( [Presentation].[Case].[DATE_BF],-4 ),varchar(19)) + '"'
    BF Date-for header
    [Presentation].[Case].[DATE_BF]
    PRI
    '="'+[Presentation].[Case].[PRI] +'"'
    PRI-for header
    [Presentation].[Case].[PRI]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Code
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Employee Sub-Category
    [Presentation].[Case].[CLASSIFICATION]
    Language
    [Presentation].[Case].[LANG]
    State Name
    [Presentation].[State].[NAME]
    Urgent
    [Presentation].[Case].[URGENT]
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    Group Name
    [Presentation].[VW_STG_GROUPS].[NAME]
    Date of Action
    '="' +cast( _add_hours ([Presentation].[VW_STG_HISTORY].[ACTION_TIMESTAMP],-4 ),varchar(19)) + '"'
    Date of Action-for header
    [Presentation].[VW_STG_HISTORY].[ACTION_TIMESTAMP]
    Risk of Case
    [Presentation].[Case].[Risk of Case]
    Date Received
    '="' + cast(_add_hours ([Presentation].[Case].[DATE_RECEIVED],-4 ),varchar(19)) + '"'
    Date Received-for header
    [Presentation].[Case].[DATE_RECEIVED]
    Date Effective From
    '="' + cast(_add_hours ([Presentation].[Case].[DATE_EFFECTIVE_FROM],-4 ),varchar(19)) + '"'
    Date Effective From-for header
    [Presentation].[Case].[DATE_EFFECTIVE_FROM]
    Date Effective To
    '="' + cast(_add_hours ([Presentation].[Case].[DATE_EFFECTIVE_TO],-4 ),varchar(19)) + '"'
    Date Effective To-for header
    [Presentation].[Case].[DATE_EFFECTIVE_TO]
    • Detail Filters
      5
    • Required
      [Presentation].[Case].[DBID] <> 0
    • Required
      [Presentation].[State].[NAME] in ('Assigned', 'Pending', 'Ready_To_Verify', 'Triage_Follow-Up', 'Verified')
    • Required
      [Presentation].[VW_STG_HISTORY].[ENTITYDEF_ID] = 16777228 and [Presentation].[VW_STG_HISTORY].[EXPIRED_TIMESTAMP] is null
    • Disabled
      [Presentation].[VW_STG_PARENT_CHILD_LINKS].[PARENT_FIELDDEF_ID] = 16777321
    • Required
      [Presentation].[Compensation Advisor]
  • Query
    Load Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts