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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: