Share this page
Vertica for PPM Data Tables
The following table summarizes data tables that were created based on core PPM Center data tables for the Vertica for PPM schema.
| Table | Change |
|---|---|
| DIM_DATE | Added in Vertica for PPM Content Pack 1.0 |
| DIM_ORG_UNITS | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_HIERARCHY_ORG_UNITS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_PERSON | Added in Vertica for PPM Content Pack 1.0 |
| DIM_RESOURCES | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_SKILL_PROFICIENCY | Added in Vertica for PPM Content Pack 1.0 |
| DIM_SKILL | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_RESOURCE_ROLES | Added in Vertica for PPM Content Pack 1.0 |
| DIM_ROLES | Added in Vertica for PPM Content Pack 1.0 |
| DIM_CONTACTS | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_ORG_UNIT_MEMBERS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_RESOURCE_POOLS | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_HIERARCHY_RESOURCE_POOLS | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_RESOURCE_POOLS_RESOURCES | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_RESOURCE_POOL_MANAGERS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_POSITIONS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_PROJECTS | Added in Vertica for PPM Content Pack 1.0 |
| BRIDAGE_PROJECT_MANAGERS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_PROPOSALS | Added in Vertica for PPM Content Pack 1.0 |
| BRIDAGE_PROPOSALS_MANAGERS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_ASSETS | Added in Vertica for PPM Content Pack 1.0 |
| BRIDGE_ASSETS_MANAGERS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_REQUESTS | Added in Vertica for PPM Content Pack 1.0 |
| DIM_TASKS | Added in Vertica for PPM Content Pack 1.0 |
| FACT_RESOURCE_DEMAND | Added in Vertica for PPM Content Pack 1.0 |
| FACT_POSITIONS_REQUESTS | Added in Vertica for PPMContent Pack 1.0 |
| FACT_RESOURCE_ALLOCATION | Added in Vertica for PPMContent Pack 1.0 |
| FACT_RESOURCE_CAPACITY | Added in Vertica for PPMContent Pack 1.0 |
| FACT_RESOURCE_ACTUAL_EFFORT | Added in Vertica for PPMContent Pack 1.0 |
The following tables are generated when the Vertica for PPM content pack is installed.
| Table | Change |
|---|---|
| Metadata tables | |
| CONTENT_PACK | Added in Vertica for PPM Content Pack 1.0 |
| ETL_METADATA | Added in Vertica for PPM Content Pack 1.0 |
| ETL_STREAM | Added in Vertica for PPM Content Pack 1.0 |
| Management tables | |
| DATA_SOURCE_CDC_STAMP | Added in Vertica for PPM Content Pack 1.0 |
| DW_CONFIG | Added in Vertica for PPM Content Pack 1.0 |
| ETL_GENERATED_ARTIFACT | Added in Vertica for PPM Content Pack 1.0 |
| SOURCE_PRODUCT_CONFIG | Added in Vertica for PPM Content Pack 1.0 |
| SOURCE_PRODUCT_CONN_PARAMETERS | Added in Vertica for PPM Content Pack 1.0 |
| TIMEZONE_INFO | Added in Vertica for PPM Content Pack 1.0 |
