Fields in the ODS

Previous TopicNext TopicContents

The Operational Data Store (ODS) portion of the P6 Reporting Database is a relational database that contains the following information from the P6 EPPM database:

Physical Fields from the P6 EPPM Database

The ODS is a point in time capture of data derived from the P6 EPPM extended schema views. Refer to the OdsFieldMapTable.html file, located in the physical media or download location, for detailed information relating to the fields in the ODS.

Note: For diagrams of the ODS schema, see the ODS_SCHEMA.zip file included in the documentation folder of the Media pack. You need to use Oracle SQL Developer Data Modeler software in order to open this file. For information about downloading this software, see the following website: http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014