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 NOVEMBER 28, 2016

Applies to:

PeopleSoft Enterprise EPM Financials Warehouse - Version 9.1 and laterInformation in this document applies to any platform.

Symptoms

Why is there a difference between the table SYSADM.PS_PROJECT and the corresponding table in the OWS?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).

Changes

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms