2 Oracle Product Lifecycle Analytics Data Model

This chapter includes information on the types of tables and columns in the Oracle Product Lifecycle Analytics schema, and the naming conventions used.

Naming Conventions for Multi-Dimensional Schema Tables

Oracle Product Lifecycle Analytics Multi-Dimensional Schema (MDS) table names follow a three-part naming convention - PREFIX_NAME_SUFFIX.

Standard Table Prefixes

The prefix indicates the part of the Oracle Product Lifecycle Analytics Multi-Dimensional Schema to which a table belongs.

Table 2-1 Standard table prefixes

Prefix	Description
DOC_	Dimension tables conforming across Fact tables in the Item Subject Area.
ITEM_	Dimension tables conforming across Fact tables in the Item Subject Area.
MDS_	Temporary tables in the MDS.
MFR_PART	Dimension or bridge tables conforming across fact tables in the Manufacturer Part Subject Area.
PC_	Fact tables or conforming dimension tables within the Product Collaboration (PC) module.
PC_ECO_	Fact or Conforming dimension tables within the ECO Subject Area in the PC module. Other subject areas: DEV, ECR,MCO, and SS.
PLM_	Common Tables for all Modules
PLM_LANG_	Tables that store localization data.
PPM_	Fact tables or conforming dimension tables within the Product Portfolio Management (PPM) module.
PQM_	Fact tables or conforming dimension tables within the Product Quality Management (PQM) module.
PQM_PR_	Fact or Conforming dimension tables within the PR Subject Area in PQM module. Other subject areas: NCR, CAPA and AUDIT.
USRDEF_	User-defined dimension tables or Bridge tables.
ETL_	ETL Control Tables
W_LOCALIZED_	For Localization Data
W_DAY	For Calendar Data

Standard Table Suffixes

The suffix indicates the type of the table in the Oracle Product Lifecycle Analytics Multi-Dimensional Schema.

Table 2-2 Standard Table Suffixes

Suffix	Description
_B	Bridge tables that resolve multi-list attribute data.
_CTL	Control tables.
_D	Dimension table with extended columns.
_DATA	Data Table that holds details of the Workflow and Sign-off.
_F	Fact table.
_TEMP or _TMP	These are reserved temporary tables used by the ETL process, internally. Note Do not alter or delete these tables.

Standard Column Prefixes

Table 2-3 Standard Column Prefixes

Prefix	Value
USRDEF_	User defined columns in Fact or Dimension tables.
PPM_	Dimension FKs for conforming dimensions within PPM module.
PPM_ACTIVITY_	Conforming dimension FKs within Activities and Gates in PPM module.
PF_	Dimension FKs in PPM Portfolio columns.
PRG_	Dimension FKs in PPM Program columns.
PRJ_	Dimension FKs in PPM Project columns.
PH_	Dimension FKs in PPM Phase columns.
GATE_	Dimension FKs in PPM Gate columns.
PQM_	Dimension FKs for conforming dimensions within PQM module.
PQM_PR_	Conforming dimension FKs within PR subject area in PQM module. Other subject areas : NCR, CAPA, AUDIT.
PC_	Dimension FKs for conforming dimensions within PC module.
PC_ECO_	Conforming dimension FKs within ECO subject area in PC module. Other subject areas : DEV, ECR,MCO, SS.
MFR_PART_	Conforming dimension FKs within Manufacturer Part Subject Area.

Standard Column Suffixes

Table 2-4 Standard Column Suffixes

Suffix	Value
_ID or _WID	Primary Key or Foreign Key (FK) that maps to Dimension tables. For a column with a Dynamic List whose values are not stored in List Entry table, you can consider this column as a 'Normal' FK to an Agile table.
_TIME_ID	Date columns that store date values in Julian format - FK to Time Dimension.
_FLAG or _FLG	This column contains a numeric value to represent Boolean Value; 1 indicates 'True' or 'Yes' and 0 indicates 'False' or 'No'.
_NAME	Name of dimension member or object name.
_DAYS	Aggregated cycle time in days.
_PCT	Stores Percentage value in number.

Table Types in Oracle Product Lifecycle Analytics Schema

Oracle Product Lifecycle Analytics Multi-Dimensional Schema (MDS) table names follow a three-part naming convention - PREFIX_NAME_SUFFIX.

ETL Control Entities
Fact Tables
Dimension Tables
Bridge Tables
Data Tables
Materialized Views

ETL Control Entities

Table 2-5 ETL Control Entities

EntityName	Description
BI_DATA_DICTIONARY	Stores Mapping information about MDS tables including all fact table source and target mapping details. In addition, it contains information about the DATA tables.
BRIDGE_CTL	Reserved Table. ETL uses this mapping information to populate data into bridge tables.
ETL_PARAMETER	Stores variables that control the ETL process.
ETL_RUN_INFO	Stores information about ETL runs.
MDS_LISTDIM_CTL	List Dimension data population control table.
ETL_VERSION	Stores source version, OS version, Data base version, source name, etc.

Fact Tables

The following are the Fact tables in this release of Oracle Product Lifecycle Analytic MDS.

Table 2-6 Fact tables

Entity	Description
ITEM_ECRSS_F	Fact table that stores relationship between items, ECR and SS.
ITEM_F	Item Fact Table. This is the core fact table for Item which has Volume, Age and Item Risk related measures.
MFR_PART_F	Manufacturer Part Fact Table. This is the core fact table for Agile PLM Manufacturer Part which has Volume and Risk related measures.
PC_DEV_F	DEV Core Fact Table. Stores Volume, Aging and Cycle time related measures of DEV.
PC_ECO_F	ECO Fact Table. This is the core fact table for ECO which has Volume, Aging and Cycle time related measures.
PC_ECO_CUM_%_F	ECO Cumulative Fact table. Stores fiscal data at week, month, quarter, and year levels.
PC_ECR_F	ECR Core Fact Table. Stores Volume, Aging and Cycle time related measures of ECR.
PC_MCO_F	MCO Core Fact Table. Stores core facts of MCO, viz., Volume, Aging and Cycle time related measures.
PC_SS_F	Stop Ship Core Fact Table. Used for Agile PLM Stop Ship information, viz., Volume, Aging and Cycle time related measures.
PLM_PRJ_METRICS_F	Fact table that stores project metrics data such as 3 year NPV for Agile PLM for process source
PLM_SPEC_F	Specifications Fact Table. A Specification is the grain. The types of specifications are trade, formulation, ingredient, packaging material, printed packaging, menu item, product and nutrient profile. Each instance of these types is a row in the fact table.
PLM_SPEC_WKFLW_F	Specification Workflow Fact Table. A step on the specification object is the grain. For example, if a specification has 4 steps, this table will have 4 rows.
PPM_ACTIVITY_DEL_F	Activity Deliverable Fact table.
PPM_ACTIVITY_F	Activity Fact Table. Stores detailed data to support Detailed Activity Analysis.
PPM_BASELINE_F	Fact tables that stores project baseline and current projects data.
PPM_PHASE_GATE_F	Phase Gate Fact Table. A gate is the grain. Stores data that has the relationship between a phase and a gate. The grain of the table is Gate of type DG1-DG6 and the start gates. The measures are analyzed with not just the gate dimensions but also with project, phase, program and portfolio dimensions the gate belongs to. The source input for the table is the activity table. The phase derivation is based on the configuration and business rules. Only user-defined measures from the gate are propagated to the phase gate fact table and it is a services activity to bring in the facts into the model. This table does not contain any private templates.
PPM_PHASE_GATE_SIGNOFF_F	Phase gate fact table. The grain is the gate and each of the signoff.
PPM_PORTFOLIO_F	Portfolio fact table Stores the portfolio summary data to support the analysis of the portfolio measures which is derived from the PLM reference number.
PPM_PRD_DEMAND_F	Product Demand Fact Table.
PPM_PRD_INV_QTY_F	Product Inventory Quantities Fact Table.
PPM_PRD_INV_VALUE_F	Product Inventory Values Fact Table.
PPM_PRD_REVENUE_F	Product Revenues Fact Table.
PPM_PRD_UNIT_REC_F	Product Units Received Fact Table.
PPM_PRD_UNIT_SHIP_F	Product Units Shipped Fact Table.
PPM_PRJ_COST_F	Project Costs Fact Table. Stores detailed data to support Project Cost Analysis.
PPM_PRJ_DET_SIGNOFF_F	Project Detail Signoff Fact Table. An activity or a gate with signoffs on each of them is the grain.
PPM_PRJ_DET_WKFLW_F	Project Details Workflow Fact Table. An activity or gate with workflow and steps is the grain.
PPM_PRJ_FORE_REV_F	Project Forecast Revenue Fact Table. Stores detailed data to support Project Forecast Revenue Analysis.
PPM_PRJ_SUM_F	Project Summary Fact Table. The grain is a project, a phase and a gate. Project summary is the summary of all projects which are derived as per the configuration business rules.
PPM_PROGRAM_F	Program Fact Table. Stores program summary which is the analysis of the program measures derived from the PLM reference number.
PPM_SNAPSHOT_F	Snapshot Fact Table. This table takes data from the project summary table. The frequency of the load is configurable. Project dimension in this subject area is the list of all the current projects.
PQM_AUDIT_F	Audit Fact Table. This core fact table is used for Audit which has Volume, Aging and Cycle time related measures.
PQM_CAPA_F	CAPA Fact Table. This is the core fact table for CAPA which has Volume, Aging and Cycle time related measures.
PQM_NCR_F	NDR Fact Table. This is the core Fact table for NCR which has Volume, Aging and Cycle time related measures.
PQM_PR_F	PR Fact Table. This is the core Fact table for PR which has Volume, Aging and Cycle time related measures.

Dimension Tables

The Dimensions in the MDS have multiple levels of attributes or a Hierarchy. This section describes the method in which the hierarchical attributes in the MDS database are stored and lists the various cascaded dimension entities.

Consider the following Hierarchy of Attributes specific to the 'Location' Dimension.

Level 0 - Continent
Level 1 - Region
Level 2 - Country
Level 3 - States
Level 4 - Cities

All these attributes are stored in the database table with unique identification.

Example

Table 2-7 Dimension table example

ID	Name	Level0	Level1	Level2	Level3	Level4
3	Continent	123	-124	-125	-126	-127
23 4	Continent\|\|Region	123	234	-235	-236	-237
34 5	Continent\|\|Region\|\|Country	123	234	345	-346	-347
45 6	Continent\|\|Region\|\|Country\|\|States	123	234	345	456	-457
56 7	Continent\|\|Region\|\|Country\|\|States\|\|Cities	123	234	345	456	567

All cascaded attributes do not have the same number of levels. The non-existent levels are identified by negative-valued identifiers. The following table displays the level names corresponding to each level:

Table 2-8 Level names corresponding to each level

ID	Level0 _ Name	Level1 _ Name	Level2 _ Name	Level3 _ Name	Level4 _ Name
123	Continent	UNDEFINED	UNDEFINED	UNDEFINED	UNDEFINED
234	Continent	Region	UNDEFINED	UNDEFINED	UNDEFINED
345	Continent	Region	Country	UNDEFINED	UNDEFINED
456	Continent	Region	Country	States	UNDEFINED
567	Continent	Region	Country	States	Cities

The level name corresponding to the negative-valued identifiers is UNDEFINED.

Dimension Entities

The following table lists all the dimension entities of the Oracle Product Lifecycle Analytics MDS.

Table 2-9 Dimension entities

Entity	Description
CLASS_INFO_D	Class Info Dimension table. Stores the List of Classes Information.
CUSTOMER_D	Customers Dimension Table. This table is conforming across the PLM. Out of the box, this table is mapped to Customer Object in Agile PLM.
DOC_CATEGORY_D	Document Category Dimension Table. This table is conforming across the fact tables in Item Subject Area. Out of the box, this table is mapped to the List configured to Category attribute of Item Class of Agile PLM.
DOC_CONF_MGMT_1_D	Document Configuration Management Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_CONF_MGMT_2_D	Document Configuration Management Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_CONF_MGMT_3_D	Document Configuration Management Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_ERP_1_D	Document ERP Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_ERP_2_D	Document ERP Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_ERP_3_D	Document ERP Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_MANUF_1_D	Document Manufacturer Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_MANUF_2_D	Document Manufacturer Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_MANUF_3_D	Document Manufacturer Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_PROD_ENG_1_D	Document Product Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_PROD_ENG_2_D	Document Product Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_PROD_ENG_3_D	Document Product Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_TYPE_D	Document Type Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is mapped to the List data from Types or Subclass attribute of the Documents class of Agile PLM.
EVENT_TYPE_D	Event Type Dimension table. This table stores the List of Event Types.
FLAG_D	Common Flag Dimension Table. Stores the flags in the fact tables such as cancel flag, released flag, etc.
INT_ORGANIZATION_D	Internal Organization Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_ASSEMBLY_RATING_D	Item Assembly Rating Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_CATEGORY_D	Item Category Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is mapped to the List data from the Category attribute of the Parts class of Agile PLM.
ITEM_COMMODITY_1_D	Item Commodity Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMMODITY_2_D	Item Commodity Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMMODITY_3_D	Item Commodity Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMMODITY_D	Item Commodity for Affected Items Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is mapped to List data from Commodity attribute of Parts class of Agile PLM.
ITEM_COMPLIANCE_1_D	Item Compliance Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMPLIANCE_2_D	Item Compliance Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMPLIANCE_3_D	Item Compliance Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMPLIANCY_D	Item Compliancy Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is mapped to List data from Overall Compliance attribute of Parts class of Agile PLM.
ITEM_COMPONENT_ENGINEER _D	Item Component Engineer Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMP_ENG_1_D	Item Component Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMP_ENG_2_D	Item Component Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COMP_ENG_3_D	Item Component Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_COST_RATING_D	Item Cost Rating Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_CUST_SUPP_1_D	Item Customer Support Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_CUST_SUPP_2_D	Item Customer Support Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_CUST_SUPP_3_D	Item Customer Support Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_D	Items Dimension Table. This Dimension Table is Conforming across PLM. Out of the box, this table is mapped to Parts Object in Agile PLM.
ITEM_ERP_1_D	Item ERP Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_ERP_2_D	Item ERP Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_ERP_3_D	Item ERP Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_FAILURE_MODE_D	Failure Modes for Affected Items Dimension Table. This table is conforming across all PQM and PC Subject Areas. Out of the box, this table is mapped to List data from Failure Mode attribute of the Parts class of Agile PLM.
ITEM_LIFECYCLE_RATING_D	Item Life Cycle Rating Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_LIFECYCLE_STATE_D	Life Cycle States for Affected Items Dimension Table. This table is conforming across all PQM and PC Subject Areas. Out of the box, this table is mapped to List data from Life Cycle State attribute of Parts class of Agile PLM.
ITEM_MFR_PART_PREFER_STA TUS_D	Item Manufacturer Part Preferred Status Dimension Table. This table is conforming across the fact tables in the Item AML Subject Area. Out of the box, this table is mapped to List data from the Manufacturer Part Preferred Status attribute of Manufacturer Part Class 'where used' tab of Agile PLM.
ITEM_PART_FAMILY_D	Part Families for Affected Items Dimension Table. This table is conforming across all PQM and PC Subject Areas. Out of the box, this table is mapped to List data from Part Family attribute of Parts class.
ITEM_PERFORMANCE_RATING _D	Item Performance Rating Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_PRODUCTLINE_D	Item Productline Dimension Table. Product Lines for Affected Items and is conforming across all PQM Subject Areas. Out of the box, this table is mapped to List data from Product Line attribute of Parts and Documents class.
ITEM_PROD_ENG_1_D	Item Product Engineering Dimension Table. This table is conforming across fact tables in Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_PROD_ENG_2_D	Item Product Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_PROD_ENG_3_D	Item Product Engineering Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_RELIABILITY_RATING_D	Item Reliability Rating Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
ITEM_REV_D	Item Revision Dimension table. Stores the list of Item Revisions.
ITEM_SIZE_D	Sizes for Affected Items Dimension Table. This table is conforming across all PQM Subject Areas. Out of the box, this table is mapped to List data from Size attribute of Parts class of Agile PLM.
ITEM_TLA_D	Item TLAs Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is mapped to List data from TLA attribute of the Parts class of Agile PLM.
ITEM_TYPE_D	Item Type or Subclass Dimension Table. This table is conforming across the fact tables in the Item Subject Area. Out of the box, this table is mapped to type or subclass attribute of Part Class of Agile PLM.
MANUFACTURER_D	Manufacturers Dimension Table. This table is conforming across PLM. Out of the box, this table is mapped to List of the Manufacturers of the Manufacturer Class of Agile PLM.
MFR_COMPLIANCE_D	Manufacturer Compliance Dimension Table. This table is conforming across fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to compliance attribute of Manufacturer Class of Agile PLM.
MFR_COUNTRY_D	Manufacturer Countries Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from the Manufacturer Country attribute of Manufacturer class.
MFR_LIFECYCLE_PHASE_D	Manufacturer Lifecycle Phases Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from Lifecycle Phases attribute of Manufacturer class.
MFR_LOCATION_D	Manufacturer Locations Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from the Manufacturer Location attribute of Manufacturer class.
MFR_PART_ASSEMBLY_RATE_ D	Manufacturer Part Assembly Rating Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMMODITY_1_D	Manufacturer Part Commodity Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMMODITY_2_D	Manufacturer Part Commodity Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMMODITY_3_D	Manufacturer Part Commodity Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMPLIANCE_1_D	Manufacturer Part Compliance Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMPLIANCE_2_D	Manufacturer Part Compliance Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMPLIANCE_3_D	Manufacturer Part Compliance Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMPLIANCE_D	Manufacturer Part Compliance Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from Compliance attribute of Manufacturer Parts class.
MFR_PART_COMP_ENG_1_D	Manufacturer Part Component Engineering Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMP_ENG_2_D	Manufacturer Part Component Engineering Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMP_ENG_3_D	Manufacturer Part Component Engineering Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COMP_ENG_D	Manufacturer Part Component Engineer Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_COST_RATE_D	Manufacturer Part Cost Rate Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_LIFECYCLE_PHASE _D	Manufacturer Part Lifecycle Phases Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from the Manufacturer Part Lifecycle Phases attribute of Manufacturer Part class.
MFR_PART_LIFECYCLE_RATE_ D	Manufacturer Part Lifecycle Rating Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_PARTFAMILY_D	Manufacturer Part Families Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from Manufacturer Part Family attribute of Manufacturer Part class.
MFR_PART_PERF_RATE_D	Manufacturer Part Performance Rating Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_RELIABILITY_RATE _D	Manufacturer Part Reliability Rating Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_PART_TYPE_D	Manufacturer Part Types Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from Types attribute of the Manufacturer Parts class.
MFR_QMS_STANDARD_D	Manufacturer QMS Standards Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_REGION_D	Manufacturer Region Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_SIZE_D	Manufacturer Size Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
MFR_STATE_D	Manufacturer States Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from Manufacturer States attribute of Manufacturer class of Agile PLM.
MFR_TYPE_D	Manufacturer Types Dimension Table. This table is conforming across the fact tables in Manufacturer Part Subject Area. Out of the box, this table is mapped to List data from Manufacturer Types attribute of the Manufacturers class of Agile PLM.
PC_CUSTOMER_D	Stores the customer data for the activities.
PC_DEV_CATEGORY_D	DEV Category Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is mapped to the List configured to Category attribute of DEV Class of Agile PLM.
PC_DEV_FIELD_D	DEV Fields Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_FINISHEDGOODS_D	DEV Finished Goods Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_FUNCTION_D	DEV Functions Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_IDEA_TYPE_D	DEV Idea Types Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_MFRLOCIMPACT_D	DEV Manufacturing Locations Impacted Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_ONORDER_D	DEV On Orders Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_PRGTASK_D	DEV Program Task Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_PRIORITY_D	DEV Priority Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_PROGRAM_D	DEV Programs Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_REASON_CODE_D	DEV Reason Codes Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is mapped to the List configured to Reason Codes attribute of the DEV Class.
PC_DEV_REGTYPE_D	DEV Regulation Type Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_REQ_PART_TYPE_D	DEV Requested Part Types Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_SALESREGIMPACT_D	DEV Sales Regions Impacted Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_SEVFINIMPACT_D	DEV Severity of Financial Impact Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_STOCK_D	DEV Stocks Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_TYPE_D	DEV Types Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is mapped to List data from Types or Subclass attribute of the DEV class of Agile PLM.
PC_DEV_WIP_D	DEV WIPs Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_DEV_WORKFLOW_D	DEV Workflow Dimension Table. This table is conforming across the fact tables in DEV Subject Area. Out of the box, this table is contains all the workflows assigned to DEV and the states within each of the workflow.
PC_ECO_CATEGORY_D	ECO Category Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is mapped to the List configured to Category attribute of ECO Class of Agile PLM.
PC_ECO_FIELD_D	ECO Fields Dimension Table. This table is conforming across the fact tables in ECO Item Subject Area. Out of the box, this table is mapped to the List configured to Fields attribute of the ECO Class on the Affected Item tab of Agile PLM.
PC_ECO_FINISHEDGOODS_D	ECO Finished Goods Dimension Table. This table is conforming across the fact tables in ECO Item Subject Area. Out of the box, this table is mapped to the List configured to Finished Goods attribute of the ECO Class on the Affected Item tab of Agile PLM.
PC_ECO_FUNCTION_D	ECO Functions Dimension Table. This table is conforming across the fact tables in ECO Item Subject Area. Out of the box, this table is mapped to the List configured to Functions attribute of the ECO Class on the Affected Item tab of Agile PLM.
PC_ECO_MFRLOCIMPACT_D	ECO Manufacturing locations impacted Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECO_ONORDER_D	ECO On Orders Dimension Table. This table is conforming across the fact tables in ECO Item Subject Area. Out of the box, this table is mapped to the List configured to On Orders attribute of the ECO Class on the Affected Item tab of Agile PLM.
PC_ECO_PRGTASK_D	ECO Program Task Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECO_PRIORITY_D	ECO Priority Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECO_PROGRAM_D	ECO Programs Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECO_REASON_CODE_D	ECO Reason Codes Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is mapped to the List configured to Reason Codes attribute of the ECO Class of Agile PLM.
PC_ECO_REGTYPE_D	ECO Regulation Type Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECO_SALESREGIMPACT_D	ECO Sales Regions Impacted Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECO_SEVFINIMPACT_D	ECO Severity of Financial Impact Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECO_STOCK_D	ECO Stocks Dimension Table. This table is conforming across the fact tables in ECO Item Subject Area. Out of the box, this table is mapped to the List configured to Stocks attribute of the ECO Class on the Affected Item tab of Agile PLM.
PC_ECO_TYPE_D	ECO Types Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is mapped to List data from Types or Subclass attribute of the ECO class of Agile PLM.
PC_ECO_WIP_D	ECO Work in Progress Dimension Table. This table is conforming across the fact tables in ECO Item Subject Area. Out of the box, this table is mapped to the List configured to WIPs attribute of the ECO Class of Agile PLM.
PC_ECO_WORKFLOW_D	ECO Workflow Dimension Table. This table is conforming across the fact tables in ECO Subject Area. Out of the box, this table is contains all the workflows assigned to ECO and the states within each of the workflow.
PC_ECR_CATEGORY_D	ECR Category Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is mapped to the List configured to Category attribute of ECR Class of Agile PLM.
PC_ECR_FIELD_D	ECR Fields Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_FINISHEDGOODS_D	ECR Finished Goods Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_FUNCTION_D	ECR Functions Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_IDEA_TYPE_D	ECR Idea Types Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_MFRLOCIMPACT_D	ECR Manufacturing Locations Impacted Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_ONORDER_D	ECR On Orders Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_PRGTASK_D	ECR Program Task Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_PRIORITY_D	ECR Priority Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_PROGRAM_D	ECR Programs Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_REASON_CODE_D	ECR Reason Codes Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is mapped to the List configured to Reason Codes attribute of the ECR Class.
PC_ECR_REGTYPE_D	ECR Regulation Type Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_REQ_PART_TYPE_D	ECR Requested Part Types Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_SALESREGIMPACT_D	ECR Sales Regions Impacted Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_SEVFINIMPACT_D	ECR Severity of Financial Impact Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_STOCK_D	ECR Stocks Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_TYPE_D	ECR Types Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is mapped to List data from Types or Subclass attribute of the ECR class of Agile PLM.
PC_ECR_WIP_D	ECR WIPs Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_ECR_WORKFLOW_D	ECR Workflow Dimension Table. This table is conforming across the fact tables in ECR Subject Area. Out of the box, this table is contains all the workflows assigned to ECR and the states within each of the workflow.
PC_LOCATION_D	PC Locations Dimension Table. This Dimension Table is Conforming across PLM. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_CATEGORY_D	Manufacturer Change Order Category Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is mapped to the List configured to Category attribute of MCO Class of Agile PLM.
PC_MCO_FIELD_D	MCO Fields Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_FINISHEDGOODS_D	MCO Finished Goods Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_FUNCTION_D	MCO Functions Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_MFRLOCIMPACT_D	MCO Manufacturing Locations Impacted Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_ONORDER_D	MCO On Orders Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_PRGTASK_D	MCO Program Task Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_PRIORITY_D	MCO Priority Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_PROGRAM_D	MCO Programs Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_REASON_CODE_D	MCO Reason Codes Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is mapped to the List configured to Reason Codes attribute of the MCO Class.
PC_MCO_REGTYPE_D	MCO Regulation Type Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_SALESREGIMPACT_D	MCO Sales Regions Impacted Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_SEVFINIMPACT_D	MCO Severity of Financial Impact Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_STOCK_D	MCO Stocks Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_TYPE_D	MCO Types Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is mapped to List data from Types or Subclass attribute of the MCO class..
PC_MCO_WIP_D	MCO WIPs Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_MCO_WORKFLOW_D	MCO Workflow Dimension Table. This table is conforming across the fact tables in MCO Subject Area. Out of the box, this table is contains all the workflows assigned to MCO and the states within each of the workflow.
PC_PRODUCTLINE_D	Productlines Dimension Table. This is a conforming Dimension Table across Change Orders (ECO), Change Requests (ECR), Manufacturing Changes (MCO) and Stop Ships. Out of the box, this table is mapped to Product Line attribute on the change objects of Agile PLM.
PC_SS_CATEGORY_D	Stop Ship Category Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is mapped to the List configured to Category attribute of SS Class of Agile PLM.
PC_SS_FIELD_D	Stop Ship Fields Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_FINISHEDGOODS_D	Stop Ship Finished Goods Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_FUNCTION_D	Stop Ship Functions Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_MFRLOCIMPACT_D	Stop Ship Manufacturing locations impacted Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_ONORDER_D	Stop Ship On Orders Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_PRGTASK_D	Stop Ship Program Task Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_PRIORITY_D	Stop Ship Priority Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_PROGRAM_D	Stop Ship Program Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_REASON_CODE_D	Stop Ship Reason Codes Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is mapped to the List configured to Reason Codes attribute of the SS Class of Agile PLM.
PC_SS_REGTYPE_D	Stop Ship Regulation Type Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_SALESREGIMPACT_D	Stop Ship Sales Regions Impacted Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_SEVFINIMPACT_D	Stop Ship Severity of Financial Impact Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_STOCK_D	Stop Ship Stocks Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_TYPE_D	Stop Ship Types Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is mapped to List data from Types or Subclass attribute of the SS class of Agile PLM.
PC_SS_WIP_D	Stop Ship WIPs Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PC_SS_WORKFLOW_D	Stop Ship Workflow Dimension Table. This table is conforming across the fact tables in SS Subject Area. Out of the box, this table is contains all the workflows assigned to SS and the states within each of the workflow of Agile PLM.
PC_SUPPLIER_D	Stores the Supplier data.
PLM_BASIS_D	Basis Dimension Table.
PLM_BRAND_D	Project Brands Dimension Table. A Project Brand is the grain.
PLM_CATEGORY_D	Categories Dimension Table.
PLM_CHANNEL_D	Project Channel Dimension Table. This contains the master list of all the channels of a project.
PLM_DEMOGRAPH_D	Project Demograph Dimension Table. This contains the master list of all the demographs of a project.
PLM_FSCLYR_D	Fiscal Year Dimension Table.
PLM_FUNC_AREA_D	Functional Area Dimension Table. Stores all the functional areas in the source system.
PLM_GLOBAL_CAT_D	Project Global Categories Dimension Table. This contains the master list of all the global categories of a project.
PLM_ISP_TITLE_D	Project ISP Title Dimension Table. This contains the master list of all the ISP Title of a project.
PLM_LEAD_CNTRY_D	Project Lead Countries Dimension. Stores the master list of all the lead countries of a project.
PLM_METRIC_PHASE_D	Metric Phase Dimension Table.
PLM_PRJ_TYPE_D	Project Types Dimension Table. This is a hierarchy. This table stores the master list of all the project types of a project.
PLM_PRJ_VISIBILITY_D	Project Visibility Dimension table.
PLM_SPEC_BUS_UNIT_D	Business Unit Specifications Dimension Table.
PLM_SPEC_CLASSIFY_D	Classification Specifications Dimension Table. Stores Ingredient, product and Nutrient Profile specifications. A Classification is the grain.
PLM_SPEC_CNTRY_ORIGIN_D	Country of Origin and Specifications Dimension Table. Contains trade and ingredient specifications.
PLM_SPEC_D	Specifications Dimension Table.
PLM_SPEC_LANG_D	Language Specifications Dimension Table. Stores language attributes for printed packaging.
PLM_SPEC_MAT_TYPE_D	Material types Dimension Table. Stores ingredient specifications. A Material Type is the grain.
PLM_SPEC_MENU_CLASS_D	Menu item class dimension table. A Menu Item Class is the grain.
PLM_SPEC_SHIP_COND_D	Shipping Conditions Dimension Table. Stores product shipping conditions.
PLM_SPEC_SHIP_REQ_D	Shipping Requirements Dimension Table. Stores ingredient shipping requirements.
PLM_SPEC_SPCL_ATTR_D	Specification Special Attributes Dimension Table.
PLM_SPEC_STEP_D	Specification Step Dimension Table. A Specification and its Step is the grain.
PLM_SPEC_STOR_REQ_D	Specification Storage Requirements Dimension Table.
PLM_SPEC_SUB_RECT_D	Substitute Restrictions Dimension Table. Used for formulation.
PLM_SPEC_SYS_EQUIVALENT_ D	Specification System Equivalent Dimension Table. The system equivalent is the grain.
PLM_SPEC_TAXONOMY_D	Specification Taxonomy Dimension Table. Stores the category, subcategory and group hierarchy. Level columns are used for the hierarchy purpose.
PLM_SPEC_TYPE_D	Specification Types Dimension Table.
PLM_STRAT_BRIEF_D	Project Strategic Brief Dimension Table.
PPM_ACTIVITY_D	Activity Dimension table. The grain is the activity, which includes projects, phases, gates and activities. Stores resolved dimension attributes data for activities and can be conformed across all PPM Fact tables. This table will not contain any private templates. Initiated flag determines whether an activity/gate/phase is initiated or not.
PPM_ACTIVITY_WKFLW_D	Activity Workflow Dimension Table. The grain is activity, workflow and workflow step.
PPM_BASELINE_D	Project Baseline Dimension Table. The grain is the project baseline. Stores the resolved dimension attributes data for the Baseline (Project) activities.
PPM_BUS_UNIT_D	Project Business Unit Dimension Table. Contains the master list of all the business units for a project.
PPM_CATEGORY10_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY11_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY12_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY13_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY14_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY15_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY16_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY17_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY18_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY19_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY20_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY21_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY22_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY23_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY24_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY7_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY8_D	Category Dimension Table. Stores category list data for activities.
PPM_CATEGORY9_D	Category Dimension Table. Stores category list data for activities.
PPM_CUSTOMER_D	Customer Dimension Table. Stores customer data for activities.
PPM_DELIVERABLE_D	Deliverable Dimension table. A Deliverable is the grain.
PPM_DEL_TAG_D	Deliverable Tags Dimension table
PPM_DIVISION_D	Division Dimension Table. Stores the division data for the activities.
PPM_FUNC_AREA_D	Functional Area Dimension Table. Stores functional area data for activities. A Functional Area is the grain.
PPM_GATE_D	Gate Dimension Table. Stores the resolved dimension attributes data for gates. A Gate is the grain. This table does not contain any private templates. Initiated flag determines whether a gate is initiated or not.
PPM_LAUNCH_YEAR_D	Launch Year Dimension Table. Stores the launch year data for activities.
PPM_LOCATION_D	Location Dimension Table. Stores location data for activities.
PPM_PHASE_D	Phase Dimension Table. Stores the resolved dimension attributes data for Phase activities. It does not contain any private templates. A Phase is the grain. Initiated flag will determine whether a phase is initiated or not.
PPM_PHASE_WORKFLOW_D	Phase Workflow Dimension Table. Stores resolved dimension attributes data for phase workflows.
PPM_PORTFOLIO_D	Portfolio Dimension Table. Stores resolved dimension attributes data for Portfolio activities.
PPM_PRODUCT_LINE_D	Product Line Dimension Table. Stores resolved dimension attributes data for product line data.
PPM_PROGRAM_D	Program Dimension Table. Stores resolved dimension attributes data for Program activities.
PPM_PROJECT_D	Project Dimension Table. Stores resolved dimension attributes data for Project activities. Does not contain any private templates.
PPM_PROJECT_TYPE_D	Project Type Dimension Table.
PPM_PROJECT_WORKFLOW_D	Project Workflow Dimension Table. Stores resolved dimension attributes data for project workflows.
PPM_REGION_D	Region Dimension Table.
PPM_ROOT_PROGRAM_D	Root Programs Table. Stores resolved dimension attributes data for root level programs.
PQM_AUDIT_CATEGORY_D	Audit Category Dimension Table. This Dimension table is conforming across Fact tables in Audit Subject Area. Out of the box, this table is mapped to the List configured to Category attribute of Audit Class of Agile PLM.
PQM_AUDIT_DEPARTMENT_D	Department Audited Dimension Table. This Dimension table is conforming across Fact tables in Audit Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_DOC_AUDITED_D	Document Audited Dimension Table. This Dimension table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_EXTRNL_AGENCY _D	Audit External Agencies Dimension Table. This Dimension table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_FINDING_TYPE_D	Audit Finding Types Dimension Table. This table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_FORM_D	Audit Form Dimension table. This table is conforming across Fact tables in Audit Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_LOCATION_D	Audit Locations Dimension Table. This table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_MANUAL_SECTIO N_D	Audit Manual Section Dimension Table. This table is conforming across Fact tables in Audit Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_PRD_AUDITED_D	Product Audited Dimension Table. This table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_PRG_D	Audit Programs Dimension Table. This table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_PRIORITY_D	Audit Priorities Dimension Table. This table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_PROCESS_AUDITE D_D	Audit Process Dimension Table. This table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_RESULT_D	Audit Results Dimension Table. This table is conforming across Fact tables in CAPA and Audit Subject Areas. Out of the box, this table is mapped to the List configured to Audit Result of Agile PLM.
PQM_AUDIT_STANDARD_D	Audit Standards Dimension Table. This table is conforming across Fact tables in Audit Subject Areas. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_AUDIT_TYPE_D	Audit Type Dimension Table. This table is conforming across Fact tables in Audit Subject Area. Out of the box, the table is mapped to the Agile PLM type or subclass attribute of Audit Class.
PQM_AUDIT_WORKFLOW_D	Audit Workflow Dimension Table. This table is conforming across Fact tables in Audit Subject Area. Out of the box, this table contains all the Agile PLM workflows assigned to Audit and the states within each of the workflow.
PQM_CAPA_BUSINESS_RISK_D	Corrective and Preventive Actions (CAPA) Business Risks Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_CATEGORY_D	CAPA Category Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, the table is mapped to the Agile PLM List configured to Category attribute of CAPA Class.
PQM_CAPA_CORRECTIVE_ACTI ON_D	CAPA Corrective Action Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_FUNCTION_D	CAPA Functions Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_LOCATION_D	CAPA Locations Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_PRBL_SOL_METHO D_D	CAPA Problem Solving Methods Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_PREVENTIVE_ACTI ON_D	CAPA Preventive Action Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_PRIORITY_D	CAPA Priorities Dimension table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_QMS_SECTION_D	CAPA QMS Sections Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_QMS_STANDARD_ D	CAPA QMS Standards Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_REG_RISK_D	CAPA Regulatory Risks Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_ROOT_CAUSE_D	CAPA Root Cause Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_TEAM_D	CAPA Teams Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_CAPA_TYPE_D	CAPA Types or Subclasses Dimension table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, this table is mapped to the Agile PLM type or subclass attribute of CAPA Class.
PQM_CAPA_WORKFLOW_D	CAPA Workflow Dimension Table. This table is conforming across Fact tables in CAPA Subject Area. Out of the box, the table contains all the Agile PLM workflows assigned to CAPA and the states within each of the workflow.
PQM_LOCATION_D	Location Dimension table. This table is conforming across PQM. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_CATEGORY_D	Non Conformance Report Category Dimension Table. This table is conforming across fact tables in NCR Subject Area. Out of the box, this table is mapped to the Agile PLM list configured to Category attribute of NCR Class.
PQM_NCR_CAUSE_D	NCR Cause Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_DOC_D	NCR Documents Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_FUNC_AREA_D	NCR Functional Areas Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_INSPECTION_TYPE_ D	NCR Inspection Types Dimension table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_MTRL_REVIEW_D	NCR Material Reviews Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_PRG_TASK_D	NCR Program Tasks Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_PRIORITY_D	NCR Priority Dimension table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_PROBLEM_TYPE_D	NCR Problem Type Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_PROGRAM_RELEAS E_D	NCR Program Release Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_QMS_D	NCR QMS Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_QMS_SECTION_D	NCR Quality Management System Section Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_REASON_CODE_D	NCR Reason Codes Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_RESOLUTION_D	NCR Resolution Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_RPT_FAILURE_TYPE _D	NCR Reported Failure Type Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_SEVERITY_D	NCR Severity Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is mapped to the Agile PLM List configured to Severity attribute of NCR Class.
PQM_NCR_SOURCE_D	NCR Sources Dimension table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_SUSP_FAILURE_TY PE_D	NCR Suspected Failure Type Dimension table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_NCR_TYPE_D	NCR Types Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, the table is mapped to the Agile PLM List configured to Types or subclass attribute of NCR Class.
PQM_NCR_WORKFLOW_D	NCR Workflow Dimension Table. This table is conforming across Fact tables in NCR Subject Area. Out of the box, the table contains all the Agile PLM workflows assigned to NCR and the states within each of the workflow.
PQM_PRODUCTLINE_D	Product Lines Dimension Table. This table is conforming across fact tables in PQM Subject Area. Out of the box, the table mapped to the Agile PLM List configured to Product Line attribute in Product Quality object such as Complaints, NCRs, Audits and CAPAs.
PQM_PR_CALLER_TYPE_D	PR Caller Types Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_CATEGORY_D	Problem Reports Category Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, the table is mapped to the Agile PLM List configured to Category attribute of PR Class.
PQM_PR_CONTACT_MODE_D	PR Contact Modes Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_DOC_D	PR Documents Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_FUNC_AREA_D	PR Function Areas Dimension Table. This table is conforming across fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_ITEM_FAILURE_TYPE _D	PR Item Failure Types Dimension Table. This table is conforming across Fact tables in PR Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_ITEM_FAIL_CAUSE_1_ D	Item Failure Cause Dimension Table. This table is conforming across fact tables in PR Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_ITEM_FAIL_CAUSE_2_ D	Item Failure Cause Dimension Table. This table is conforming across fact tables in PR Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_ITEM_FAIL_CAUSE_3_ D	Item Failure Cause Dimension Table. This table is conforming across fact tables in PR Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_ITEM_FAIL_MFR_PAR T_D	PR Item Failed Manufacturer Parts Dimension Table. This table is conforming across Fact tables in PR Item Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_ITEM_RPT_FAILURE_ D	PR Item Reported for Failures Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_ITEM_TLA_D	PR Item TLAs Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_PRBL_REPD_D	PR Problem Reproduced Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_PRG_D	PR Programs Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_PRG_TASK_D	PR Program Tasks Dimension Table. This table is conforming across fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_PRIORITY_D	PR Priority Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_PROBLEM_TYPE_D	PR Problem Type Dimension Table. This table is conforming across fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_QMS_D	PR QMS Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_REASON_CODE_D	PR Reason Codes Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_REG_RPT_TYPE_D	PR Regulatory Report Types Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_RESOLUTION_D	PR Dispositions Dimension Table. This table is conforming across fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_RPT_FAILURE_TYPE_ D	PR Reported Failure Type Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_SALES_REGION_D	PR Sales Regions Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_SEVERITY_D	PR Severity Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, the table is mapped to the Agile PLM List configured to Severity attribute of PR Class.
PQM_PR_SUSP_FAILURE_TYPE _D	PR Suspected Failure Type Dimension Table. This table is conforming across Fact tables in PR Subject Area. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
PQM_PR_TYPE_D	PR Types or Subclasses Dimension Table. This table is conforming across fact tables in PR Subject Area. Out of the box, the table is mapped to the Agile PLM List configured to Types or Subclasses attribute of PR Class.
PQM_PR_WORKFLOW_D	PR Workflow Dimension Table. This table is conforming across fact tables in PR Subject Area. Out of the box, the table contains all the Agile PLM workflows assigned to PR and the states within each of the workflow.
REVISION_CHANGE_TYPE_D	Revision Change Types for Item Dimension Table. This table is conforming across Fact tables in Item Subject Area. Out of the box, the table is mapped to the Agile PLM List configured to Revision Change Type attribute of Parts Class.
SITE_D	Sites Dimension Table. This table is conforming across PLM. Out of the box, the table is mapped to the Agile PLM Site Object in Agile PLM.
SUPPLIER_D	Suppliers Dimension Table. This table is conforming across PLM. Out of the box, the table is mapped to the Supplier Object in Agile PLM.
USER_D	Users Dimension Table. This table is conforming across PLM. Out of the box, the table is mapped to User Object in Agile PLM.
USER_SIGNOFF_TYPE_D	User Signoff Types Dimension Table. This table is conforming across PLM. Out of the box, the table is mapped to the Signoff User Types in Agile PLM.
W_DAY_D	Day Dimension Table. Stores time information for report calculations.

Bridge Tables

Table 2-10 Bridge tables

Entity	Description
DOC_CONF_MGMT_3_B	Configuration Management Bridge table. Maintains data between DOC_CONF_MGMT_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated only when the Agile PLM attributes are mapped using BI Configurator.
DOC_ERP_3_B	Document ERP Bridge table. Maintains data between DOC_ERP_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data.The table is populated only when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
DOC_MANUF_3_B	Document Manufacturer Bridge table. Maintains data between DOC_MANUF_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
DOC_PROD_ENG_3_B	Document Product Engineering Bridge table. Maintains data between DOC_PROD_ENG_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The data is populated when Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using the BI Configurator.
ITEM_COMMODITY_3_B	Item Commodity Bridge table. Maintains data between ITEM_COMMODITY_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
ITEM_COMPLIANCE_3_B	Bridge Table. Maintains data between ITEM_COMPLIANCE_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. data is populated when Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
ITEM_COMP_ENG_3_B	Bridge Table. Maintains data between ITEM_COMP_ENG_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The data is populated when Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
ITEM_CUST_SUPP_3_B	Item Customer Support Bridge table. Maintains data between ITEM_CUST_SUPP_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The data is populated when Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
ITEM_ERP_3_B	Bridge Table. Maintains data between ITEM_ERP_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is mapped to the corresponding column in fact table using BI Configurator.
ITEM_PRODUCTLINE_B	Item Productline Bridge table. Maintains data between Item and Productline to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
ITEM_PROD_ENG_3_B	Bridge Table. Maintains data between ITEM_PROD_ENG_3_D table and Item fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
ITEM_SUPPLIER_B	Item Supplier Bridge table. Maintains data between Item fact and Supplier dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
MFR_PART_COMMODITY_3_B	Manufacturer Part Commodity Bridge Table. Maintains data between MFR_PART_COMMODITY_3_D table and Mfr Part fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
MFR_PART_COMPLIANCE_3_B	Manufacturer Part Compliance Bridge table. Maintains data between MFR_PART_COMPLIANCE_3_D table and Mfr Part fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
MFR_PART_COMP_ENG_3_B	Manufacturer Part Component Engineering Bridge table. Maintains data between MFR_PART_COMP_ENG_3_D table and Mfr Part fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
MFR_PART_SUPPLIER_B	Manufacturer Part Supplier Bridge table. Maintains data between Manufacturer Part fact and Supplier Dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
MFR_QMS_STANDARD_B	Manufacturer QMS Standards Bridge Table. Maintains data between MFR_QMS_STANDARD_D table and Manufacturer Part fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
MFR_REGION_B	Manufacturer Region Bridge Table. Maintains data between MFR_REGION_D table and Mfr Part fact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_CUSTOMER_B	DEV Customer Bridge Table. Maintains data between DEV fact and Customer dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_ITEM_PRODUCTLINE_ B	DEV Item Productline Bridge Table. Maintains data between DEV fact and Item Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_MANUF_OWNER_B	DEV Manufacturer Owner Bridge Table. Maintains data between DEV fact and Manufacturer Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_MFRLOCIMPACT_B	DEV Manufacturer Locations Impacted Bridge Table. Maintains data between DEV fact and Manufacturer Location Impact dimension Impact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_PRGTASK_B	DEV Program Task Bridge Table. Maintains data between DEV fact and Program Task dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_PRODUCTLINE_B	DEV Productline Bridge Table. Maintains data between DEV fact and Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_PROGRAM_B	DEV Programs Bridge Table. Maintains data between DEV fact and Program dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_QUALITY_OWNER_B	DEV Quality Owner Bridge Table. Maintains data between DEV fact and Quality Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_SALESREGIMPACT_B	DEV Sales Region Impacted Bridge Table. Maintains data between DEV fact and Sales Region Impact dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_SC_OWNER_B	DEV SC Owner Bridge Table. Maintains data between DEV fact and SC Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_SIGNOFF_B	DEV Signoff Bridge Table. Maintains data between DEV and Signoff to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_DEV_SUPPLIER_B	DEV Supplier Bridge Table. Maintains data between DEV and Supplier to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_CUSTOMER_B	ECO Customer Bridge Table. Maintains data between ECO fact and Customer dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_ITEM_PRODUCTLINE_ B	ECO Item Productline Bridge Table. Maintains data between ECO fact and Item Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_MANUF_OWNER_B	ECO Manufacturer Owner Bridge Table. Maintains data between ECO fact and Manufacturer Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_MFRLOCIMPACT_B	ECO Manufacturing Location Impact Bridge Table. Maintains data between ECO fact and Manufacturer Location Impact dimension Impact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_PRGTASK_B	ECO Bridge Table. Maintains data between ECO fact and Program Task dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_PRODUCTLINE_B	ECO Productline Bridge Table. Maintains data between ECO fact and Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_PROGRAM_B	ECO Program Bridge Table. Maintains data between ECO fact and Program dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_QUALITY_OWNER_B	ECO Quality Owner Bridge Table. Maintains data between ECO fact and Quality Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_SALESREGIMPACT_B	ECO Sales Region Impact Bridge Table. Maintains data between ECO fact and Sales Region Impact dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_SC_OWNER_B	ECO SC Owner Bridge Table. Maintains data between ECO fact and SC Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_SIGNOFF_B	ECO Signoff Bridge Table. Maintains data between ECO and Signoff to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECO_SUPPLIER_B	ECO Supplier Bridge Table. Maintains data between ECO and Supplier to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_CUSTOMER_B	ECR Customer Bridge Table. Maintains data between ECR fact and Customer dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_ITEM_PRODUCTLINE_ B	ECR Item Productline Bridge Table. Maintains data between ECR fact and Item Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_MANUF_OWNER_B	ECR Manufacturer Owner Bridge Table. Maintains data between ECR fact and Manufacturer Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_MFRLOCIMPACT_B	ECR Manufacturer Locations Impacted Bridge Table. Maintains data between ECR fact and Manufacturer Location Impact dimension Impact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_PRGTASK_B	ECR Program Task Bridge Table. Maintains data between ECR fact and Program Task dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_PRODUCTLINE_B	ECR Productline Bridge Table. Maintains data between ECR fact and Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_PROGRAM_B	ECR Programs Bridge Table. Maintains data between ECR fact and Program dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_QUALITY_OWNER_B	ECR Quality Owner Bridge Table. Maintains data between ECR fact and Quality Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_SALESREGIMPACT_B	ECR Sales Region Impacted Bridge Table. Maintains data between ECR fact and Sales Region Impact dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_SC_OWNER_B	ECR SC Owner Bridge Table. Maintains data between ECR fact and SC Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_SIGNOFF_B	ECR Signoff Bridge Table. Maintains data between ECR and Signoff to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_ECR_SUPPLIER_B	ECR Supplier Bridge Table. Maintains data between ECR and Supplier to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_CUSTOMER_B	MCE Customer Bridge Table. Maintains data between MCO fact and Customer dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_ITEM_PRODUCTLINE_ B	MCO Item Productline Bridge Table. Maintains data between MCO fact and Item Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_MANUF_OWNER_B	MCO Manufacturer Owner Bridge Table. Maintains data between MCO fact and Manufacturer Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_MFRLOCIMPACT_B	MCO Manufacturer Locations Impacted Bridge Table. Maintains data between MCO fact and Manufacturer Location Impact dimension Impact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_PRGTASK_B	MCO Program Task Bridge Table. Maintains data between MCO fact and Program Task dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_PRODUCTLINE_B	MCO Productline Bridge Table. Maintains data between MCO fact and Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_PROGRAM_B	MCO Programs Bridge Table. Maintains data between MCO fact and Program dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_QUALITY_OWNER_B	MCO Quality Owner Bridge Table. Maintains data between MCO fact and Quality Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_SALESREGIMPACT_B	MCO Sales Regions Impacted Bridge Table. Maintains data between MCO fact and Sales Region Impact dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_SC_OWNER_B	MCO SC Owner Bridge Table. Maintains data between MCO fact and SC Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_SIGNOFF_B	MCO Signoff Bridge Table. Maintains data between MCO and Signoff to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_MCO_SUPPLIER_B	MCO Supplier Bridge Table. Maintains data between MCO and Supplier to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_CUSTOMER_B	Stop Ship Customer Bridge Table. Maintains data between SS fact and Customer dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_ITEM_PRODUCTLINE_B	Stop Ship Item Productline Bridge Table. Maintains data between SS fact and Item Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_MANUF_OWNER_B	Stop Ship Manufacturer Owner Bridge Table. Maintains data between SS fact and Manufacturer Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_MFRLOCIMPACT_B	Stop Ship Manufacturing Locations Impacted Bridge Table. Maintains data between SS fact and Manufacturer Location Impact dimension Impact to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_PRGTASK_B	Stop Ship Bridge Table. Maintains data between SS fact and Program Task dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_PRODUCTLINE_B	Stop Ship Productline Bridge Table. Maintains data between SS fact and Productline dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_PROGRAM_B	Stop Ship Program Bridge Table. Maintains data between SS fact and Program dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_QUALITY_OWNER_B	Stop Ship Quality Owner Bridge Table. Maintains data between SS fact and Quality Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_SALESREGIMPACT_B	Stop Ship Sales Regions Impacted Bridge Table. Maintains data between SS fact and Sales Region Impact dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_SC_OWNER_B	Stop Ship SC Owner Bridge Table. Maintains data between SS fact and SC Owner dimension to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_SIGNOFF_B	Stop Ship Signoff Bridge Table. Maintains data between SS and Signoff to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PC_SS_SUPPLIER_B	Stop Ship Supplier Bridge Table. Maintains data between SS and Supplier to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when the Agile PLM Multilist type attribute is mapped to the corresponding column in the fact table using BI Configurator.
PLM_ACTIVITY_OWNER_B	Activities Owner Bridge Table. Maintains many to many relationships between activities, activity owners and the functional areas of the activity owners of Agile PLM.
PLM_ACTIVITY_TPL_OWNER_B	Activities Template Owner Bridge Table. Maintains many to many relationships between activities and template owners of Agile PLM.
PLM_ACT_STEP_NOTIFIER_B	Activities Step Notifier Bridge Table. Maintains many to many relationships between step notifiers, activity workflows, activities and functional areas of Agile PLM.
PLM_ACT_STEP_OWNER_B	Activities Step Owner Bridge Table. Maintains many to many relationships between activities, activity workflows, step owners and functional areas of Agile PLM.
PLM_ACT_STEP_SIGNATORY_B	Activities Step Signatory Bridge Table. Maintains many to many relationships between step signatories, activity workflows, activities and functional areas of Agile PLM.
PLM_GATE_SIGNATORY_B	Gate Signatory Bridge Table. Maintains many to many relationships between gates, signatories and functional areas.
PLM_PHASE_FUNC_AREA_B	Functional Areas and Phases Bridge Table. Maintains many to many relationships between functional areas and phases.
PLM_PHASE_GATE_KEEPER_B	Phases and Gate Keepers Bridge Table. Maintains many to many relationships between phases and gate keepers.
PLM_PHASE_REVIEWER_B	Phases and Reviewers Bridge Table. Maintains many to many relationships between phases and reviewers.
PLM_PHASE_TEAM_LEADER_B	Phases and Team Leaders Bridge Table. Maintains many to many relationships between phases and team leaders.
PLM_PHASE_TEAM_MEM_B	Phases and Team Members Bridge Table. Maintains many to many relationships between phases and team members.
PLM_PRJ_BRAND_B	Projects and Brands Bridge Table. Maintains many to many relationships between projects and brands.
PLM_PRJ_BUS_UNIT_B	Projects and Business Units Bridge Table. Maintains many to many relationships between projects and business units.
PLM_PRJ_CHANNEL_B	Projects and Channels Bridge Table. Maintains many to many relationships between projects and channels.
PLM_PRJ_DEMOGRAPH_B	Projects and Demographics Bridge Table. Maintains many to many relationships between projects and demographics.
PLM_PRJ_FUNC_AREA_B	Projects and Functional Areas Bridge Table. Maintains many to many relationships between projects and functional areas.
PLM_PRJ_GATE_KEEPER_B	Projects and Gate Keepers Bridge Table. Maintains many to many relationships between projects and gate keepers.
PLM_PRJ_GLOBAL_CAT_B	Projects and Global Categories Bridge Table. Maintains many to many relationships between projects and global categories.
PLM_PRJ_ISP_B	Projects and ISP Bridge Table. Maintains many to many relationships between projects and ISP titles.
PLM_PRJ_LEAD_CNTRY_B	Project Lead Countries Bridge Table. Maintains many to many relationships between projects and lead countries.
PLM_PRJ_REVIEWER_B	Project Reviewers Bridge table. Maintains many to many relationships between projects and reviewers.
PLM_PRJ_STRAT_BRIEF_B	Project Strategic Briefs Bridge Table. Maintains many to many relationships between projects and strategic briefs.
PLM_PRJ_TEAM_LEADER_B	Project Team leaders Bridge Table. Maintains many to many relationships between projects and team leaders.
PLM_PRJ_TEAM_MEM_B	Project Team Members Bridge Table. Maintains many to many relationships between projects and team members.
PLM_PRJ_TRADE_SPEC_B	Project Trade Specifications Bridge Table. Maintains many to many relationships between project trade specifications and the projects.
PLM_PRJ_TYPE_B	Project Types Bridge Table. Maintains many to many relationships between projects, project templates and the project types.
PLM_PRJ_VISIBILITY_B	Project Visibility Bridge Table. Maintains many to many relationships between the project visibilities and the projects.
PLM_SPEC_BUS_UNIT_B	Business Units and Specifications Bridge Table. Maintains many to many relationships between specifications and business units.
PLM_SPEC_CLASSIFY_B	Classifications and Specifications Bridge Table. Maintains many to many relationships between specifications and the classifications.
PLM_SPEC_CNTRY_ORIGIN_B	Country of Origin and Specifications Bridge Table. Maintains many to many relationships between the countries of origin and specifications.
PLM_SPEC_LANG_B	Language and Specifications Bridge Table. Maintains many to many relationships between printed packaging and the printed packaging languages.
PLM_SPEC_MAT_TYPE_B	Material Type and Specifications Bridge Table. Maintains many to many relationships between the ingredient specifications and material types.
PLM_SPEC_MENU_CLASS_B	Menu Classes and Specifications Bridge Table. Maintains many to many relationships between the menu item classes and menu items.
PLM_SPEC_SHIP_COND_B	Shipping Conditions Bridge Table. Maintains many to many relationships between products and shipping conditions.
PLM_SPEC_SHIP_REQ_B	Specifications and Shipping Requirements Bridge Table. Maintains many to many relationships between ingredient shipping requirements and the specifications.
PLM_SPEC_SPCL_ATTR_B	Specifications and Special Attributes Bridge Table. Maintains many to many relationships between specifications and special attributes.
PLM_SPEC_STEP_OWNER_B	Specification Steps and Owners. Bridge Table. Maintains many to many relationships between specification steps and owners.
PLM_SPEC_STOR_REQ_B	Specifications and Storage Requirements Bridge Table. Maintains many to many relationships between specifications and storage requirements.
PLM_SPEC_SUB_RECT_B	Specification and Substitute Restrictions Bridge Table. Maintain many to many relationships between specifications and substitute restrictions.
PLM_SPEC_SYS_EQUIVALENT_ B	Specification System Equivalent Bridge Table. Maintains many to many relationships between system equivalents and specifications.
PPM_ACTIVITY_PLM_REFEREN CE_B	Activity Reference Bridge Table. Maintains many to many relationships between PPM references and activities.
PPM_ACT_DEPACT_B	Bridge table maintains many to many relationships for dependant activities.
PPM_ACT_PROGRAMS_B	Activities and Programs Bridge Table. Maintains many to many relationships between program data and activities.
PPM_CATEGORY10_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY11_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY12_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY13_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY14_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY15_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY16_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY17_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY18_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY19_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY20_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY21_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY22_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY23_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY24_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY7_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY8_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CATEGORY9_B	Category Bridge Table. Maintains many to many relationships between category data and activities.
PPM_CUSTOMER_B	Customer Bridge Table. Maintains many to many relationships between customer data and activities.
PPM_DEL_TAG_B	Deliverable Tags Bridge Table. Maintains many to many relationships between deliverables and deliverable tags.
PPM_DIVISION_B	Division Bridge Table. Maintains many to many relationships between division data and activities.
PPM_FUNC_AREA_B	Functional Area Bridge Table. Maintains many to many relationships between activities and functional areas.
PPM_INT_ORGANIZATION_B	Internal Organization Bridge Table. Maintains many to many relationships between internal organization data and activities.
PPM_ITEM_B	Item Bridge Table. Maintains many to many relationships between item data and activities.
PPM_LAUNCH_YEAR_B	Launch Year Bridge Table. Maintains many to many relationships between launch year data and activities.
PPM_LOCATION_B	Location Bridge Table. Maintains many to many relationships between location data and activities.
PPM_PRODUCT_LINE_B	Product Line Bridge Table. Maintains many to many relationships between product line Multilist data and projects.
PPM_PROJECT_PORTFOLIO_B	Project Portfolio Bridge Table. Maintains many to many relationships between projects and portfolios.
PPM_PROJECT_PROGRAM_B	Project Program Bridge Table. Maintains many to many relationships between projects and programs.
PPM_PROJECT_TYPE_B	Project Type Bridge Table. Maintains many to many relationships between project types and activities.
PPM_REGION_B	Region Bridge Table. Maintains many to many relationships between regions data and activities.
PQM_AUDIT_CUSTOMER_B	Audit Customer Bridge Table. Maintains data between Audit and Customer to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. Data is populated when Agile PLM Multilist type attribute is configured to the corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_DOC_AUDITED_B	Audit and Document Audited Bridge Table. Maintains data between Audit and Document Audited to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. Data is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_FINDING_TYPE_B	Audit Finding Type Bridge Table. Maintains data between Audit and Finding Type to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. Data is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_ITEM_PRODUCTLI NE_B	Audit Item Productline Bridge Table. Maintains data between Audit Item Fact table and Item Productline Dimension table to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. Data is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_PRD_AUDITED_B	Audit and Product Audited Bridge Table. Maintains data between Audit and Audited Product to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_PRG_B	Audit Program Bridge Table. Maintains data between Audit and Audited Program to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to the corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_PROCESS_AUDITE D_B	Audit and Process Audited Bridge Table. Maintains data between Audit and Audited Process to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_PRODUCTLINE_B	Audit Productline Bridge Table. Maintains data between Audit and Productline to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_AUDIT_SUPPLIER_B	Audit and Supplier Bridge Table. Maintains data between Audit and Supplier to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_CUSTOMER_B	CAPA Customer Bridge Table. Maintains data between CAPA and Customer to resolve many to many relasionships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_FUNCTION_B	CAPA Function Bridge Table. Maintains data between CAPA and Function to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_ITEM_PRODUCTLI NE_B	CAPA Item Productline Bridge Table. Maintains data between CAPA Item fact table and Item Productline dimension table to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_PRODUCTLINE_B	CAPA Productline Bridge Table. Maintains data between CAPA and Productline to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_QMS_SECTION_B	CAPA QMS Section Bridge Table. Maintains data between CAPA and QMS Section to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_QMS_STANDARD_ B	CAPA QMS Standards Bridge Table. Maintains data between CAPA and QMS Standard to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_SUPPLIER_B	CAPA Supplier Bridge Table. Maintains data between CAPA and Supplier to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_CAPA_TEAM_B	CAPA Team Bridge Table. Maintains data between CAPA and team to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_NCR_CUSTOMER_B	NCR Customer Bridge Table. Maintains data between NCR and Customer to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_NCR_DOC_B	NCR Documents Bridge Table. Maintains data between NCR and Documents to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_NCR_FUNC_AREA_B	NCR Functional Area Bridge Table. Maintains data between NCR and Functional Area to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_NCR_ITEM_PRODUCTLIN E_B	NDR Item Productline Bridge Table. Maintains data between NCR Item fact table and Item Productline dimension table to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in fact table using BI Configurator.
PQM_NCR_PRG_TASK_B	NCR Program Tasks Bridge Table. Maintains data between NCR and Program Task to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_NCR_PRODUCTLINE_B	NCR Productline Bridge Table. Maitnains data between NCR and Productline to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_NCR_QMS_B	NCR QMS Bridge Table. Maintains data between NCR and QMS to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_NCR_SUPPLIER_B	NCR Supplier Bridge Table. Maintains data between NCR and Supplier to resolve Many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_CUSTOMER_B	PR Customer Bridge Table. Maintains data between PR and Customer to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_DESIGN_OWNER_B	PR Design Owner Bridge Table. Maintains data between PR and Design Owner to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_DOC_B	PR Documents Bridge Table. Maintains data between PR and Document to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_FUNC_AREA_B	PR Functional Area Bridge Table. Maintains data between PR and Functional Area to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_ITEM_FAILURE_TYPE _B	PR Item Failure Type Bridge Table. Maintains data between PR and Failure Type to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_ITEM_FAIL_CAUSE_1_ B	PR Item Failure Cause Bridge Table. Maintains data between PR and Item Fail Cause 1 to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. This table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_ITEM_FAIL_CAUSE_2_ B	PR Item Failure Cause Bridge Table. Maintains data between PR and Item Fail Cause 2 to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. This table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_ITEM_FAIL_CAUSE_3_ B	PR Item Failure Cause Bridge Table. Maintains data between PR and Item Fail Cause 3 to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. This table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_ITEM_PRODUCTLINE_ B	PR Item Productline Bridge Table. Maintains data between PR Item Fact table and Item Productline dimension table to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_PRG_TASK_B	PR Program Tasks Bridge Table. Maintains data between PR and Program Task to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_PRODUCTLINE_B	PR Productline Bridge Table. Maintains data between PR and Productline to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_QMS_B	PR QMS Bridge Table. Maintains data between PR and QMS to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
PQM_PR_SUPPLIER_B	PR Supplier Bridge Table. Maintains data between PR and Supplier to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.
USER_PRODUCTLINE_B	Productline Bridge Table. Maintains many to many relationships between product lines and users.
USER_USER_GROUP_B	User Group Bridge Table. Maintains data between User and User Group to resolve many to many relationships. Out of the box, this table is not populated with Agile PLM data. The table is populated when Agile PLM Multilist type attribute is configured to corresponding column in the Fact table using BI Configurator.

Data Tables

Data tables store the data for Affected Items only.

Table 2-11 Data tables

Entity	Description
ITEM_MFR_PART_DATA	Item and Manufacturer Part Data Table. This is a Temporary table, Reserved for ETL process, and is used for configuring flex attributes between Item and Manufacturer Part relationship.
PC_DEV_ITEM_DATA	DEV Item Data Table. This Temporary table, reserved for ETL process, is used for configuring Agile PLM flex attributes between Item and Change Requests (DEV) relationship.
PC_DEV_SIGNOFF_DATA	DEV Signoff Data Table. This Temporary table, reserved for ETL process, is used for processing Change Requests (DEV) signoff data of Agile PLM.
PC_DEV_WORKFLOW_DETAIL_ DATA	DEV Workflow Detail Data Table. Stores the details of the Agile PLM workflow such as status cycle time, status cycle time in progress for each combination of workflow states.
PC_ECO_ITEM_DATA	ECO Item Data Table. This Temporary table, reserved for ETL process, is used for configuring Agile PLM flex attributes between Item and Change Orders (ECO) relationship.
PC_ECO_SIGNOFF_DATA	ECO Signoff Data Table. This Temporary table, reserved for ETL process, is used for processing Change Orders (ECO) signoff data.
PC_ECO_WORKFLOW_DETAIL_ DATA	ECO Workflow Details Data Table. Holds the details of the Agile PLM workflows such as status cycle time, status cycle time in progress for each combination of workflow states.
PC_ECR_ITEM_DATA	ECR Item Data Table. This Temporary table, reserved for ETL process, is used for configuring Agile PLM flex attributes between Item and Change Requests (ECR) relationship.
PC_ECR_SIGNOFF_DATA	ECR Signoff Data Table. This Temporary table, reserved for ETL process, is used for processing Change Requests (ECR) signoff data of Agile PLM.
PC_ECR_WORKFLOW_DETAIL_ DATA	ECR Workflow Detail Data Table. Stores the details of the Agile PLM workflow such as status cycle time, status cycle time in progress for each combination of workflow states.
PC_MCO_ITEM_DATA	MCO Item Data Table. This Temporary table, reserved for ETL process, is used for configuring Agile PLM flex attributes between Item and Manufacturing Changes (MCO) relationship.
PC_MCO_SIGNOFF_DATA	MCO Signoff Data Table. This Temporary table, reserved for ETL process, is used for processing Manufacturing Changes (MCO) signoff data.
PC_MCO_WORKFLOW_DETAIL_ DATA	MCO Workflow Details Data Table. Stores the details of Agile PLM workflow such as status cycle time, status cycle time in progress for each combination of workflow states.
PC_SS_ITEM_DATA	The Temporary table, reserved for ETL process, is used for configuring Agile PLM flex attributes between Item and Stop Ships (SSO) relationship.
PC_SS_SIGNOFF_DATA	Stop Ship Signoff Data Table. This Temporary table, reserved for ETL process, is used for processing Stop Ships signoff data of Agile PLM.
PC_SS_WORKFLOW_DETAIL_D ATA	Stop Ship Workflow Details Data Table. Stores the details of Agile PLM workflow such as status cycle time, status cycle time in progress for each combination of workflow states.
PLM_LANG_DATA	Project Language Data Table. Stores translated strings for dimension tables. Data is extracted from localized strings for all lists managed within Agile PLM.
PQM_AUDIT_ITEM_DATA	Audit Item Data Table. This Temporary table, reserved for ETL process, is used for configuring flex attributes between Item and Audits relationship.
PQM_AUDIT_WORKFLOW_DET AIL_DATA	Audit Workflow Detailed Data Table. This table holds the details of the workflow such as status cycle time, status cycle time in progress for each combination of workflow states.
PQM_CAPA_ITEM_DATA	CAPA Item Data Table. Reserved for ETL process. Temporary table used for configuring flex attributes between Item and CAPA relationship.
PQM_CAPA_WORKFLOW_DETA IL_DATA	CAPA Workflow Details Data Table. This table holds the details of the workflow such as status cycle time, status cycle time in progress for each combination of workflow states.
PQM_NCR_ITEM_DATA	NCR Item Data Table. Reserved for ETL process. Temporary table used for configuring flex attributes between Item and Non Conformance Report (NCR) relationship.
PQM_NCR_WORKFLOW_DETAI L_DATA	NCR Workflow Detail Data Table. This table holds the details of the workflow such as status cycle time, status cycle time in progress for each combination of workflow states.
PQM_PR_ITEM_DATA	PR Item Data Table. Reserved for ETL process. Temporary table used for configuring flex attributes between Item and Problem Reports or Complaints (PR) relationship.
PQM_PR_WORKFLOW_DETAIL_ DATA	PR Workflow Details Data Table. This table holds the details of the workflow such as status cycle time, status cycle time in progress for each combination of workflow states.

Staging Tables

The stagingtables are used as interface tables betweenthe transactional databasesource tables and the targettables. The stagingtable structure is independent of sourcedata structures.

When the ETL processruns, staging tables are truncated beforethey are populated with changecapture data. Duringthe initial full ETL load, these stagingtables hold the entire sourcedata set for a definedperiod of history,but they hold only the changes and updates to data during the subsequent refresh ETL runs.

Materialized Views

A Materialized view is a logical view of your data. In Materialized views, the result set of the query is saved in a table. These tables can be indexed, so it is easy to locate information when the tables are queried. All the joins in the Materialized views are resolved when the Materialized views are refreshed. Therefore, when you query the Materialized view, there is no delay that results from the resolution of the joins in the query.

If Query rewrite is enabled in Materialized views, Oracle allows you to optimize a query such that it sources the results from your Materialized view. If you have created your Materialized views as forms of aggregate tables or as copies of frequently executed queries, the query response time is lesser than that in a regular view. This improves the response time of the end user application.

Note:

The data you receive from the materialized view is as latest as the last refresh of the Materialized view.

You can refresh the Materialized views manually or on a set schedule. You can also have the Materialized view refreshed when the database detects a change in data from the related source tables. Materialized view logs capture the change of data in the related source tables and serve as key input to the update of the Materialized views.

Data Validation Rules

Various fact tables, for example, PC_ECO_F, have a VALID_FLAG column to indicate the fact data for the row is valid or invalid. Data is valid if value is set to 1 and invalid if value is set to 0. The value is set to 0 if the object data, for example, ECO, in Agile PLM source system is not consistent or inaccurate for deriving volume, cycle-time, aging and other related measures in the Oracle Product Lifecycle Analytics application.

Following data validation rules are used for setting the value of VALID_FLAG column to 0:

1. CREATE_DATE column value for corresponding chang eobject (for example., ECO) row in the corresponding Agile PLM source table is NULL
2. WORKFLOW_ID column value for corresponding change object (for example., ECO) row in the corresponding Agile PLM source table is NULL
3. SUBMIT_DATE column value for corresponding change object (for example., ECO) row in the Agile PLM source table is less than the CREATE_DATE column value.

Note:
ETL uses CREATE_DATE as SUBMIT_DATE for various derived measures if the SUBMIT_DATE value is NULL.
4. RELEASE_DATE column value for corresponding change object (for example., ECO) row in the Agile PLM source table is less than the SUBMIT_DATE column value.

Note:
ETL uses SYSDATE as RELEASE_DATE for various derived measures if the RELEASE_DATE value is NULL.
5. FINALCOMPLETE_DATE column value for corresponding change object (for example., ECO) row in the Agile PLM source table is less than RELEASE_DATE column value.

Note:
ETL uses SYSDATE as FINALCOMPLETE_DATE for various derived measures if the FINALCOMPLETE value is NULL.

In addition to the above rules, all the workflow fact tables (for example., PC_ECO_WORKFLOW_DETAILS_F) use the following rule:

NEXT_STATUS column value in Agile PLM's CHANGE_HISTORY table is NULL and EVENT_TYPE columnvalue is either65 (Submit) or 71 (Review).

User Defined Extensions

User Defined Columns in the Fact Tables

Table 2-12 User Defined Columns in the Fact Tables

Table Column	Type	Size	Precision	Comments
USRDEF_DATE0 to USRDEF_DATE4	Number	0	User defined Date in Julian Format. [Agile PLM] these columns can be mapped to Date Type attributes in Agile PLM using Configurator.
USRDEF_LIST0 to USRDEF_LIST13	Number	22	0	User defined list. ITEM_F, ITEM_ECRSS_F, and ITEM_MFR_PART_DATA fact table have 28 user defined list columns. [Agile PLM] These user defined list columns can be mapped to List type Agile PLM attributes and appropriate dimension tables using Agile PLM BI MDS Configurator.
USRDEF_NUMBER0 to USRDEF_NUMBER9	Number	0	User defined number. [Agile PLM] these columns can be mapped to Numeric type attributes in Agile PLM using Configurator.
USRDEF_COST0 to USRDEF_COST9	Number	18	6	User Defined Cost. [Agile PLM] these columns can be mapped to Money type attributes in Agile PLM using Configurator.

User Defined Columns in the Dimension Tables

Table 2-13 User defined columns in the dimension tables

Table Column	Type	Size	Precision
USRDEF_TEXT0 to USRDEF_TEXT2	Varchar 2	256	User defined text
USRDEF_DATE0 to USRDEF_DATE2	Date	User defined date
USRDEF_NUMBER0 to USRDEF_NUMBER2	Number	User defined number
LEVEL0 to LEVEL4	Number	Columns to configure additional hierarchy into the Dimension. The level columns are populated if the dimension is a cascade list type in Agile PLM.
LEVEL0_NAME to LEVEL4_NAME	varchar2	256

Prefixes to the User Defined Columns

Besides the user defined columns listed above, the MDS also provides user defined columns for specific functionality. Such columns are identified by their prefixes listed in the table below.These prefixes denote the association of a user defined column to the category of PLM functionality.

For example, the column name USRDEF_DATE0 in the dimension and fact tables denotes the User Defined Date. The same column name when prefixed with PRJ_, hence PRJ_USRDEF_DATE0, denotes the User Defined Date for belonging to a Project.

Table 2-14 Prefixes to the user defined columns

Prefix	PLM functionality
ACT	Activities
AI	Affected Items
DEL	Deliverables
DEV	Deviations
ECO	Engineering Change Order
GATE	Gate
ITEM_MFR_PART	Item Manufacturer Part
ITEM	Items
MCO	Manufacturing Change Order
MFR_PART	Manufacturer Part
PF	Portfolio
PH	Phase
PRG	Program
PRJ	Project
SS	Stop Ship
SPEC	Specifications

User Defined Dimension Tables

You can configurethe tables USRDEF_L01_D to USRDEF_L119_D as Dimensions across Subject Areas. Use these tables to bring P2/P3/Flex attributes from Agile PLM.

User Defined Bridge Tables

Each Core Fact and Item Fact table has five Bridge tables to handle many-to-many relationships.

Table 2-15 User defined bridge tables

Fact Tables	Bridge Tables
PQM_PR_F	PQM_PR_USRDEF_ML00_B to PQM_PR_USRDEF_ML04_B
PQM_NCR_F	PQM_NCR_USRDEF_ML00_B to PQM_NCR_USRDEF_ML04_B
PQM_CAPA_F	PQM_CAPA_USRDEF_ML00_B to PQM_CAPA_USRDEF_ML04_B
PQM_AUDIT_F	PQM_AUDIT_USRDEF_ML00_B to PQM_AUDIT_USRDEF_ML04_B
PC_DEV_F	PC_DEV_USRDEF_ML00_B to PC_DEV_USRDEF_ML04_B
PC_ECO_F	PC_ECO_USRDEF_ML00_B to PC_ECO_USRDEF_ML04_B
PC_ECR_F	PC_ECR_USRDEF_ML00_B to PC_ECR_USRDEF_ML04_B
PC_MCO_F	PC_MCO_USRDEF_ML00_B to PC_MCO_USRDEF_ML04_B
PC_SS_F	PC_SS_USRDEF_ML00_B to PC_SS_USRDEF_ML04_B
PC_MFR_PART_F	PC_MFR_PART_USRDEF_ML00_B to PC_MFR_PART_USRDEF_ML04_B
PC_ITEM_F	PC_ITEM_USRDEF_ML00_B to PC_ITEM_USRDEF_ML04_B
PC_ITEM_MFR_PART_F	PC_ITEM_MFR PART_USRDEF_ML00_B to PC_ITEM_MFR_PART_USRDEF_ML04_B
PC_DOC_F	PC_DOC_USRDEF_ML00_B to PC_DOC_USRDEF_ML04_B
PPM_ACTIVITY_F	PPM_ACT_USRDEF_ML00_B to PPM_ACT_USRDEF_ML04_B
PPM_PORTFOLIO_F	PPM_PF_USRDEF_ML00_B to PPM_PF_USRDEF_ML04_B
PPM_PHASE_GATE_F	PPM_PH_USRDEF_ML00_B to PPM_PH_USRDEF_ML04_B
PPM_PROGRAM_F	PPM_PRG_USRDEF_ML00_B to PPM_PRG_USRDEF_ML04_B
PPM_PROJECT_F	PPM_PRJ_USRDEF_ML00_B to PPM_PRJ_USRDEF_ML04_B
PQM_PR_ITEM_F	PQM_PR_ITEM_USRDEF_ML00_B to PQM_PR_ITEM_USRDEF_ML04_B
PQM_CAPA_ITEM_F	PQM_CAPA_ITEM_USRDEF_ML00_B to PQM_CAPA_ITEM_USRDEF_ML04_B
PQM_AUDIT_ITEM_F	PQM_AUDIT_ITEM_USRDEF_ML00_B to PQM_AUDIT_ITEM_USRDEF_ML04_B