Why is there a difference between the table SYSADM.PS_PROJECT and the corresponding table in the OWS?
(Doc ID 1588753.1)
Last updated on MARCH 09, 2020
Applies to:PeopleSoft Enterprise EPM Financials Warehouse - Version 9.1 and later
Information in this document applies to any platform.
There are columns that exist in one but not the other. While some of these are obviously columns related to EPM (i.e. BATCH_SID, DATA_ORIGIN, etc) others seem to be operational
columns that exist in PS and not in the warehouse (i.e. PC_HEALTH, PC_HEALTH_CALC, PC_HEALTH_DTTM).
documentation clearly states:
'The structure of the OWS target tables match the structure of the source transaction tables with the addition of a source system identification column (SRC_SYS_ID), which enables you to track the origin of your data'. - PeopleSoft 9.1: EPM Fundamentals, June 2013, pg. 35
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document