search cancel

Table Equivalents In Clarity and DWH Databases

book

Article ID: 252780

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

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

 

 

Environment

Release : 16.0.3

Resolution

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

PRTIMEPERIOD / DWH_TME_PERIOD
PRTIMESHEET / DWH_TME_SHEET
PRTIMEENTRY / DWH_TME_ENTRY
CMN_SEC_USERS / DWH_RES_RESOURCES
INV_INVESTMENTS / DWH_INV_INVESTMENT
PRTEAM / DWH_INV_TEAM
PRASSIGNMENT / DWH_INV_ASSIGNMENT