Go to primary content

Oracle® Product Lifecycle Analytics Multi-Dimensional Schema Data Reference Manual Release 3.6 E84200-01 |
| Contents

Previous | Next |

# 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.

1. ETL Control Entities

2. Fact Tables

3. Dimension Tables

4. Bridge Tables

5. Data Tables

6. 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.

1. Level 0 - Continent

2. Level 1 - Region

3. Level 2 - Country

4. Level 3 - States

5. 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. 1. CREATE_DATE column value for corresponding chang eobject (for example., ECO) row in the corresponding Agile PLM source table is NULL

2. 2. WORKFLOW_ID column value for corresponding change object (for example., ECO) row in the corresponding Agile PLM source table is NULL

3. 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. 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. 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 | Comments
--- | --- | --- | --- | ---
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