Understanding the P6 Extended Schema
The P6 Extended Schema is the core database schema for P6 reporting. It allows for:
- Access to views of P6 data tables
- Access to more up-to-date calculated data than is available in the ODS
- Additional control over when data is calculated and stored
Introduced with P6 Release 8.1, the P6 Extended Schema combines the P6 database with additional calculated fields. The tables that make up the P6 Extended Schema are technically views. Views are predefined SQL queries of data from one or more database tables, with security applied. Though they are not tables, views can be called upon like tables in SQL queries when building reports. A database administrator account called PxRptUser serves as the schema owner and has access to all P6 Extended Schema views.
Prior to the introduction of the P6 Extended Schema, calculated fields were only available via the ODS (Operational Data Store), which would typically be updated nightly. By comparison, the P6 Extended Schema can be updated on a near real-time basis.
Last Published Wednesday, December 13, 2023