Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• Acronyms

2 OPLA Staging Schema Data Model

• Naming Conventions for OPLA Staging Schema Tables
  • Standard Table Prefixes in Staging Schema Tables
  • Standard Table Suffixes in Oracle Agile PLM BI Tables
• Table Types in OPLA Staging Schema
  • ETL Control Entities
  • Metadata and Translation Entities
  • Dimension Tables
    • Cascade List Dimension Entities
  • Map Tables
  • Subclass Views
  • Summary Views
  • P4 Tables
• Data Entities, Common
• Data Entities, PPM
• Data Entities, PC
• Data Entities, PQM
• Data Entities, PCM
• Data Entities, PGC
• Standard Column Suffixes in Agile PLM DM Tables
• Entity Relationship Diagrams
  • Product Collaboration
    • Change Orders
    • Change Orders Signoff
    • Item Parts
    • Item Manufacturer Parts
    • Item Rev Sites
    • Item Rev Site BOM Redlines
  • Product Portfolio Management
    • Activities
    • Discussions
  • Product Quality Management
    • PSR – NCR
    • PSR – NCR – Items
    • PSR – NCR Relationship
    • PSR – PR
    • PSR – PR – Items
    • PSR – PR Relationships
    • QCR – Audits
    • QCR – Audits – Items
    • QCR – Audit Relationships
    • QCR – CAPA
    • QCR – CAPA Items
    • QCR – CAPA Relationships
  • Product Governance and Compliance
    • Declaration
    • Specifications
    • Substances
  • Product Cost Management
    • Sourcing Project
    • Request for Quote
    • RFQ Response

3 Table Columns

• AGILE_FLEX
• DM_LOAD_CTL
• LISTENTRY
• LISTNAME
• NODETABLE
• ODM_ACTION_ITEM
• ODM_ACTIVITY_BASELINE
• ODM_ACTIVITY_DEPENDENCY
• ODM_ACTIVITY_PLM_REF
• ODM_ADMINMSATT
• ODM_AGGR_SUBSTANCE
• ODM_AGILEUSER
• ODM_APPROVAL_ITEMS
• ODM_ATT_DESIGNS
• ODM_ATT_FILE_FLDR
• ODM_ATT_HIST_RPT_FF
• ODM_ATTR_METADATA
• ODM_BASELINE_REV
• ODM_BOM
• ODM_BOM_RESULT
• ODM_CACHE_FILE_MAP1
• ODM_CHANGE_HISTORY
• ODM_CHNG_CHG_ORDERS
• ODM_CHNG_CHG_REQS
• ODM_CHNG_DEVIATION
• ODM_CHNG_MFR_ORDERS
• ODM_CHNG_PRICE_CHGORDERS
• ODM_CHNG_SITE_CHGORDERS
• ODM_CHNG_STOP_SHIPS
• ODM_CLASS_METADATA
• ODM_COMPLIANCE
• ODM_CONVERSION
• ODM_CONTRACT
• ODM_CURRENCY
• ODM_CUSTOMER
• ODM_DATA_DICTIONARY
• ODM_DELETE_TXN
• ODM_DISCUSSION
• ODM_DOCS_MANU_BY
• ODM_ESCALATIONS
• ODM_EVENT_HISTORY
• ODM_FILE_INFO
• ODM_FILES
• ODM_FLEXCOLS_METADATA
• ODM_FOLDER
• ODM_FOLDER_STRUCTURE
• ODM_FUN_TEAM_OBJ_D
• ODM_GEOGRAPHY_ROUTING
• ODM_INDEX_COLUMN_CTL
• ODM_ITEM_DOCS
• ODM_ITEM_HISTORY
• ODM_ITEM_HISTORY2
• ODM_ITEM_PARTS
• ODM_ITEM_SITES
• ODM_LANGTABLE
• ODM_LISTDIM_CTL
• ODM_LISTENTRY_STG
• ODM_LISTNAME_STG
• ODM_MANU_BY
• ODM_MANU_PARTS
• ODM_MANUFACTURER
• ODM_MANUFACTURERS
• ODM_MASTER_INDEX_CTL
• ODM_MATERIAL_DCLRNS_HGNUS
• ODM_MATERIAL_DCLRNS_IPC_1
• ODM_MATERIAL_DCLRNS_IPC_2
• ODM_MATERIAL_DCLRNS_JGPSSI
• ODM_MATERIAL_DCLRNS_PRTS
• ODM_MATERIAL_DCLRNS_SBTNCE
• ODM_MATERIAL_DCLRNS_SUPPLR
• ODM_MSATT
• ODM_NEWS
• ODM_NOTIFICATION
• ODM_OBJECT_LOCKS
• ODM_OBJECTACL
• ODM_ORGANIZATION
• ODM_P3_SD_CTL
• ODM_PAGE_THREE
• ODM_PART_FAMILY
• ODM_PARTS_MANU_BY
• ODM_PDP
• ODM_PRG_ACTIVITY
• ODM_PRG_GATES
• ODM_PRICE_HISTORY
• ODM_PRICE_PUB_PRICE
• ODM_PRICE_QUOTE_HIST
• ODM_PRICEENTRY
• ODM_PRICELINE
• ODM_PRICEPOINT
• ODM_PRODUCT_LINE
• ODM_PROGRAM
• ODM_PROGRAM_HISTORY
• ODM_PROGRAM_TEMPLATE
• ODM_PROJECT
• ODM_PSR_NCR
• ODM_PSR_NCR_ITEM
• ODM_PSR_PR
• ODM_PSR_PR_ITEM
• ODM_QCR_AUDIT
• ODM_QCR_AUDIT_ITEM
• ODM_QCR_CAPA
• ODM_QCR_CAPA_ITEM
• ODM_QUOTE_HISTORY
• ODM_REDLINE_ATTRIBUTE
• ODM_REDLINE_MSATTRIBUTE
• ODM_REFDESIG
• ODM_REGULATION
• ODM_RELATIONSHIP
• ODM_RESPONSE
• ODM_RESPONSE_HEADER
• ODM_RESPONSE_RFQ_MAPPING
• ODM_RES_SUBSTANC_COMPLIANCE
• ODM_RESULT_OBJ_COMPLIANCE
• ODM_REV
• ODM_REV_CHG_ORDERS
• ODM_REV_CHG_REQS
• ODM_REV_DEVIATION
• ODM_REV_DOCS
• ODM_REV_MFR_ORDERS
• ODM_REV_PARTS
• ODM_REV_PRCE_CHGORDS
• ODM_REV_SITE_CHGORDS
• ODM_REV_STOP_SHIPS
• ODM_RFQ_COMMENT_RECIPIENT
• ODM_RFQ_COMMENTS
• ODM_RFQ_HEADER
• ODM_RFQ_LINE
• ODM_RGULTN_P2_MAPPING
• ODM_ROLLUP_COMPOSIT_DECL
• ODM_ROLLUP_COMPOSITION
• ODM_SC_AML
• ODM_SC_BOM
• ODM_SC_COMMENT
• ODM_SC_COST_QTY_ROLLUP
• ODM_SC_DELTA_BOM
• ODM_SC_ITEM
• ODM_SC_PROJECT_SITES
• ODM_SC_SUPPLIERS
• ODM_SC_WORK_IN_PROGRESS
• ODM_SIGNOFF
• ODM_SIMPLE_RELATION
• ODM_SIMPLE_VISIT_HISTORY
• ODM_SITE
• ODM_SITES
• ODM_SPECIFIC_SUBSTANCES
• ODM_SUBSCRIPTIONS
• ODM_SUBSTANCE_GROUPS
• ODM_SUBSTANCE_MATERIALS
• ODM_SUBSTANCE_SUBPARTS
• ODM_SUBSTANCE_SUBSTANCES
• ODM_TA_ESC
• ODM_TEAM
• ODM_TEAM_BASELINE
• ODM_TIMESHEET
• ODM_USAGE_HISTORY
• ODM_USER_ASSIGNMENT
• ODM_USER_FUNCTION_MAP
• ODM_USER_GROUP
• ODM_USER_ROLE
• ODM_USER_SITE
• ODM_USER_USAGE_HISTORY
• ODM_VERSION
• ODM_VISIT_HISTORY
• ODM_WORKFLOW_METADATA
• ODM_WORKFLOW_PROCESS
• PARAMETER
• PROPERTYTABLE
• TLOG
• TLOGLEVEL
• VERSION
• VLOG