Is PRUID from PRTASK table available in DWH?

book

Article ID: 140640

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

I would like to raise a ticket to request assistance finding the PRTASK Table equivalent in DWH. We have configured an attribute utilizing the PRUID field and was wondering if there is a table in DWH that it can be found. I already checked the DWH_INV_TASK and wasn't able to find it there.

Environment

Release : 15.6

Component : CA PPM DATA WAREHOUSE

Resolution

As per current design we do not populate PRUID from PRTASK table in DWH, you will need to change your lookup hidden key to PRID which is task_key on the DWH side.

Alternatively if you are doing this for custom reporting, you could create custom domain that point to PPM schema instead of DWH and pull that data directly from PPM.