3 Entity-Relationship Diagrams

This chapter consists of the Entity Relationships in the Oracle Product Lifecycle Analytics MDS.

ER Diagrams for Agile A9 PLM Source

The ER's under the following sections are specific to only Agile A9 PLM source:

• Problem Reports

• Non Conformance Reports

• Corrective and Preventive Actions

• Audit

• Deviations

• Engineering Change Order

• Engineering Change Request

• Item

• Manufacturer Change Order

• Stop Ship

Note: The tables showing P4P are applicable only when the source is Agile PLM for process.

ER Diagrams for Agile PLM for Process Source

The ER's under the following sections are specific to only Agile PLM for Process source:

• Project Metrics

• Phase gate Signoff

• Project Detail Workflow

• Project Detail Signoff

• Specifications

• Specifications Workflow

Problem Reports

Problem Reports Fact

Figure 3-1 Problem Reports Fact

Problem Reports Item Fact

Figure 3-2 Problem Reports Item Fact

Problem Reports - Workflow Detail

Figure 3-3 Problem Reports - Workflow Detail

Non Conformance Reports

NCR Fact

Figure 3-4 NCR Fact

NCR Workflow Detail

Figure 3-5 NCR Workflow Detail

Corrective and Preventative Actions

CAPA Fact

Figure 3-6 CAPA Fact

CAPA Item

Figure 3-7 CAPA Item

CAPA Workflow Detail

Figure 3-8 CAPA Workflow Detail

Audit

Audit Fact

Figure 3-9 Audit Fact

Audit Item

Figure 3-10 Audit Item

Audit Workflow Detail

Figure 3-11 Audit Workflow Detail

Deviations

DEV Fact

Figure 3-12 Dev Fact, part 1 of 2

Figure 3-13 DEV Fact, part 2 of 2

DEV Item Fact

Figure 3-14 DEV Item Fact, part 1 of 2

Figure 3-15 DEV Item Fact, part 2 of 2

DEV Sign-off Fact

Figure 3-16 DEV Sign-off Fact

DEV Workflow Detail

Figure 3-17 DEV Workflow Detail

Engineering Change Order

ECO Fact

Figure 3-18 ECO Fact, part 1 of 2

Figure 3-19 ECO Fact, part 2 of 2

ECO Item Fact

Figure 3-20 ECO Item Fact, part 1 of 2

Figure 3-21 ECO Item Fact, part 2 of 2

ECO Sign-off Fact

Figure 3-22 ECO Sign-off Fact

ECO Workflow Detail

Figure 3-23 ECO Workflow Detail

Engineering Change Request

ECR Fact

Figure 3-24 ECR Fact, part 1 of 2

Figure 3-25 ECR Fact, part 2 of 2

ECR Item Fact

Figure 3-26 ECR Item Fact, part 1 of 2

Figure 3-27 ECR Item Fact, part 2 of 2

ECR Workflow Detail Fact

Figure 3-28 ECR Workflow Detail Fact

ECR Sign-off Fact

Figure 3-29 ECR Sign-off Fact

Item

Item Fact

Figure 3-30 Item Fact, part 1 of 3

Figure 3-31 Item Fact, part 2 of 3

Figure 3-32 Item Fact, part 3 of 3

Manufacturer Part Fact

Figure 3-33 Manufacturer Part Fact, part 1 of 2

Figure 3-34 Manufacturer Part Fact, part 2 of 2

Item Manufacturer Part Fact

Figure 3-35 Item Manufacturer Part Fact, part 1 of 2

Figure 3-36 Item Manufacturer Part Fact, part 2 of 2

Manufacturer Change Order

MCO Fact

Figure 3-37 MCO Fact, part 1 of 2

Figure 3-38 MCO Fact, part 2 of 2

MCO Item Fact

Figure 3-39 MCO Item Fact, part 1 of 2

Figure 3-40 MCO Item Fact, part 2 of 2

MCO Signoff Fact

Figure 3-41 MCO Signoff Fact

MCO Workflow Detail Fact

Figure 3-42 MCO Workflow Detail Fact

Stop Ship

Stop Ship Fact

Figure 3-43 Stop Ship Fact, part 1 of 2

Figure 3-44 Stop Ship Fact, part 2 of 2

Stop Ship Item Fact

StopShipItemFact

Figure 3-45 Stop Ship Item Fact, part 1 of 2

Figure 3-46 Stop Ship Item Fact, part 2 of 2

Stop Ship Signoff Fact

Figure 3-47 Stop Ship Signoff Fact

Stop Ship Workflow Detail Fact

Figure 3-48 Stop Ship Workflow Detail Fact

PPM

PPM - Activity

Figure 3-49 PPM - Activity, diagram 1 of 2

Figure 3-50 PPM - Activity, diagram 2 of 2

PPM - Baseline

Figure 3-51 PPM - Baseline

PPM - Phase Gate

Figure 3-52 PPM - Phase Gate

Phase Gate Singoff

Figure 3-53 Phase Gate Signoff

PPM - Portfolio

Figure 3-54 PPM - Portfolio, part 1 of 2

Figure 3-55 PPM - Portfolio, part 2 of 2

PPM - Project Cost

Figure 3-56 PPM - Project Cost, part 1 of 2

Figure 3-57 PPM - Project Cost, part 2 of 2

PPM Project Details

PPM Project Details, Signoff

Figure 3-58 PPM Project Details, Signoff

PPM Project Details, Workflow

Figure 3-59 Project Details, Workflow

PPM - Project Summary

Figure 3-60 PPM - Project Summary

PPM - Project Forecast Revenue

Figure 3-61 PPM - Project Forecast Revenue, part 1 of 2

Figure 3-62 PPM - Project Forecast Revenue, part 2 of 2

PPM - Program

Figure 3-63 PPM - Program, part 1 of 2

Figure 3-64 PPM - Program, part 2 of 2

PPM - Snapshot

Figure 3-65 PPM - Snapshot

The ER diagrams for the cumulative ECO fact tables are same as the ECO fact tables exceptf or the time dimension.

PC_ECO_CUM_COMP_FSCL_YEAR_F, PC_ECO_CUM_COMPLETED_YEAR_F,PC_ECO_CUM_NEW_FSCL_YEAR_F, PC_ECO_NEW_YEAR_F,

PC_ECO_CUM_REL_FSCL_YEAR_F, PC_ECO_CUM_RELEASED _YEAR_F tables are qualified with time dimension at year level.

PC_ECO_CUM_COMP_FSCL_QTR_F, PC_ECO_CUM_COMPLETED_ QTR_F,PC_ECO_CUM_NEW_ QTR_YEAR_F, PC_ECO_NEW_ QTR_F, PC_ECO_CUM_REL_FSCL_

QTR_F, PC_ECO_CUM_RELEASED _ QTR_F are qualified at the quarter level.

PC_ECO_CUM_COMP_FSCL_MONTH_F, PC_ECO_CUM_COMPLETED_ MONTH_F, PC_ECO_CUM_NEW_ QTR_ MONTH_F,PC_ECO_NEW_ MONTH_F,

PC_ECO_CUM_REL_FSCL_ MONTH_F,PC_ECO_CUM_RELEASED _ MONTH_Fare qualified at month level.

PC_ECO_CUM_COMP_FSCL_WEEK_F, PC_ECO_CUM_COMPLETED_ WEEK_F, PC_ECO_CUM_NEW_ QTR_ WEEK_F, PC_ECO_NEW_ WEEK_F, PC_ECO_CUM_REL_FSCL_

WEEK_F, PC_ECO_CUM_RELEASED _ WEEK_F are qualified at week level.