Table Equivalents In Clarity and DWH Databases

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

What are the common corresponding Clarity / Data Warehouse DWH tables?

 

 

Environment

Release : All

Resolution

After the Load DWH job completes, the following tables are common table references after the sychnronization of the Clarity and DWH databases:

 

CLARITY DB	DWH DB
RPT_CALENDAR	DWH_CMN_PERIOD
PRTIMEPERIOD	DWH_TME_PERIOD
PRTIMESHEET	DWH_TME_SHEET
PRTIMEENTRY	DWH_TME_ENTRY
CMN_SEC_USERS	DWH_RES_RESOURCES
INV_INVESTMENTS	DWH_INV_INVESTMENT
PRASSIGNMENT	DWH_INV_ASSIGNMENT