Oracle Product Lifecycle Analytics Operational Data Reference Manual Release 3.5 E70276-01 |
|
![]() Previous |
![]() Next |
This chapter includes information on the types of tables and columns in the OPLA Staging schema, including the naming conventions used.
OPLA Staging Schema Database table names follow a three-part naming convention - PREFIX_NAME_SUFFIX.
The prefix indicates the part of the Agile PLM Database schema to which a table belongs.
The suffix indicates the type of the table in the Agile PLM BI MDS schema.
Table 2-2 Standard Table Suffixes in Oracle Agile PLM BI Tables
Suffix | Description |
---|---|
_MAP |
Bridge tables that resolve multi-list attribute data. |
_D |
Dimension table for list attributes in PLM. |
_TEMP |
These are reserved temporary tables used by internal ETL process. Note: Do not alter or delete these tables. |
_CTL |
Control tables |
The Published Data Model comprises the following:
Bridge Tables ("Map Tables")
Data Entities:
Table 2-3 ETL Control Entities
Entity Name | Description |
---|---|
DM_LOAD_CTL |
Stores ETL run type, status. Updated during ETL process and is Read-Only for others. |
ODM_LISTDIM_CTL |
Stores List dimension table information for lists. |
ODM_LISTDIM_CTL_BKP |
Used by configuration tool |
PARAMETER |
Table to store variables that control ETL process |
VERSION |
Stores Version information about PLM, OS, DB server, Datamart |
Table 2-4 Metadata and Translation Entities
Entity Name | Description |
---|---|
ODM_ATTR_METADATA |
Table describes attribute metadata of Agile PLM objects. |
ODM_CLASS_METADATA |
Table describes class metadata Agile PLM objects. |
ODM_FLEXCOLS_METADATA |
Table describes flex attribute metadata for Agile PLM objects. |
ODM_WORKFLOW_METADATA |
Table describes metadata for all configured workflows and their process steps within Agile PLM. |
ODM_DATA_DICTIONARY |
Stores data dictionary for Data Mart table including source and target mapping details. |
In Data Mart, dimension tables are created for different types of lists. The ODM_LISTDIM_CTRL table enables you to identify the dimension type.
The ODM_LISTDIM_CTRL table is as follows:
Table 2-5 ODM_LISTDIM_CTRL
IND_FLAG | List Type |
---|---|
1 |
Normal Lists |
2 |
Cascade Lists |
3 |
Dynamic Lists |
4 |
For a list no entry values in PLM |
Table 2-6 Columns in Dynamic and Normal lists
ENTRY_ID | Primary key |
---|---|
ENTRY_ID |
Primary key |
ENTRY_VALUE |
Dimension member name |
LIST_ID |
Parent list ID |
CREATE_DATE |
Created On |
UPDATE_DATE |
Last Updated On |
DELETE_FLAG |
Identify whether this object is soft deleted. The value is 1 for soft delete. |
LANG_ID |
Language ID |
Table 2-7 Cascade List Dimension Entities
Column | Comments |
---|---|
ENTRY_ID |
Unique Identifier for dimension member |
ENTRY_VALUE |
Member Name |
CASCADE_VALUE |
Cascaded Path of the List Entries with Hierarchy |
CASCADE_PATH |
Cascaded Path of the Lists with Hierarchy |
PARENT_ENTRY |
Parent Entry of the Entry_ID |
LEVEL0 |
Hierarchy of Entry_ID (Parent Entry ID) |
LEVEL1 |
Hierarchy of Entry_ID (Child of LEVEL0 Entry_ID) |
LEVEL2 |
Hierarchy of Entry_ID (Child of LEVEL1 Entry_ID) |
LEVEL3 |
Hierarchy of Entry_ID (Child of LEVEL2 Entry_ID) |
LEVEL4 |
Hierarchy of Entry_ID (Child of LEVEL3 Entry_ID) |
LIST_ID |
Agile PLM List ID |
IS_LEAF |
Identifier of the leaf node: 1-Yes 0-No |
DELETE_FLAG |
Identify if this is a deleted object: 1-Deleted 0-Not Deleted |
LANG_ID |
Language ID |
The following table lists the dimension tables available in Data Mart:
Table 2-8 Dimension tables available in Data Mart
Entity Name | PLM List ID | Description |
---|---|---|
ODM_8704_CURRENCY_D |
8704 |
Currencies |
ODM_ABWF_ACT_DUR_D |
2000010054 |
|
ODM_ABWF_ACT_RSC_D |
2000010055 |
|
ODM_ABWF_PROC_PHS_D |
200010057 |
|
ODM_ABWF_WRK_ITEM_D |
2000010056 |
|
ODM_ACT_INACT_D |
7117 |
|
ODM_ACTION_D |
3876 |
Action List |
ODM_ACTION_STATUS_D |
18414 |
Action Status |
ODM_ACTION_TYPE_D |
201 |
Action Type List |
ODM_ACTIVITY_RSRC_TYPE_D |
||
ODM_ACTIVITY_STATE_D |
19983 |
Activity State List |
ODM_ACTIVITY_TYPE_OBJ_D |
||
ODM_AGILEUSER_TYPE_OBJ_D |
11605 |
Agile PLM User |
ODM_ALLOW_ESCDEPAPP_D |
3750 |
|
ODM_AML_D |
11936 |
Site AML List |
ODM_AML_LIST_D |
12068 |
Site Specific Bom/AML List |
ODM_AML_ON_BUY_D |
11935 |
AML on Buy List |
ODM_AML_PREF_STATUS_D |
2249 |
AML Preferred Status |
ODM_AML_STATUS_D |
4559 |
AML_STATUS |
ODM_APPROVE_GROUP_D |
||
ODM_ATT_CHKOUT_STATUS_D |
6396 |
|
ODM_ATTACH_LIFECYCLE_PHASE_D |
6333 |
Attachments |
ODM_ATTACH_TYPE_D |
4682 |
Attach Type List |
ODM_AUDIT_RESULT_D |
6820 |
Audit Result |
ODM_AUDIT_TYPE_OBJ_D |
4428 |
Audit Type Object |
ODM_BUYER_D |
8934 |
Buyer |
ODM_BUYER_RESP_SUPP_D |
4590 |
|
ODM_CALC_COMPLIANCE_D |
2000001019 |
Calculated Compliance |
ODM_CALENDAR_LIBRARY_D |
2000025603 |
Calendar Library |
ODM_CAPA_TYPE_OBJ_D |
4928 |
CAPA Object |
ODM_CATEGORY10_LIST_D |
2000000192 |
Category 10 List |
ODM_CATEGORY7_LIST_D |
2000000189 |
Category 7 List |
ODM_CATEGORY8_LIST_D |
2000000190 |
Category 8 List |
ODM_CATEGORY9_LIST_D |
2000000191 |
Category 9 List |
ODM_CHANGE_ANALYST_D |
730 |
Change Analysts |
ODM_CHANGE_CATEGORY_D |
411 |
Change Category |
ODM_CHANGE_OBJ_D |
8223 |
All Change Objects |
ODM_CHG_ORDERS_TYPE_OBJ_D |
6000 |
Change Orders Object |
ODM_CHG_REQS_TYPE_OBJ_D |
7000 |
Change Request Object |
ODM_CHNG_FUNCTION_D |
331 |
Change Function |
ODM_COMMODITIES_ITEMS_D |
12941 |
Commodities for Items |
ODM_COMMODITY_TYPE_D |
2000004868 |
Commodity Type |
ODM_COMPLIANCE_MGR_D |
2000004949 |
Compliance Manager |
ODM_COMPONENT_ENGRS_D |
750 |
Component Engineers |
ODM_COMPOSITION_TYPE_D |
2000007577 |
Composition Type |
ODM_CONTINENT_D |
4598 |
Continent |
ODM_COST_STATUS_D |
18781 |
Cost Statuses |
ODM_COUNTRY_D |
365 |
Country |
ODM_CURRENCY_D |
8704 |
Currencies |
ODM_CUSTOMER_D |
2000000107 |
Customer List |
ODM_CUSTOMER_LIFECYCLE_PHASE_D |
5799 |
Customers |
ODM_CUSTOMER_OBJ_D |
6505 |
All Customer Objects |
ODM_CUSTOMER_TYPE_OBJ_D |
4983 |
Customer Type |
ODM_DATEFORMAT_D |
4475 |
Date Formats |
ODM_DECLARATIONS_OBJ_D |
2000002155 |
All Declaration Objects |
ODM_DECLARE_COMPLIANCE_D |
2000001394 |
Declared Compliance |
ODM_DEPENDENCIES_TYPE_D |
18506 |
|
ODM_DEPENDENCY_TYPE_D |
2000007820 |
|
ODM_DEVIATION_TYPE_D |
737 |
DEV Type List |
ODM_DISC_PRIORITY_LIST_D |
18412 |
Discussion Priority List |
ODM_DISCUSSION_OBJ_D |
8229 |
All Discussion Objects |
ODM_DISPOSITION_D |
431 |
Disposition |
ODM_DIVISION_D |
2000000105 |
Division List |
ODM_DOC_CATEGORY_D |
321 |
Document Category |
ODM_DOCUMENT_TYPE_D |
739 |
Doc Type List |
ODM_DOCS_TYPE_OBJ_D |
9000 |
Document Objects |
ODM_DURATION_TYPE_D |
18792 |
Duration Types |
ODM_ENCODE_TYPE_D |
2000007049 |
Encoded Language List |
ODM_EXEMPTIONS_D |
2000001449 |
Exemptions |
ODM_EXTRACTION_FORMAT_D |
13045 |
Extraction Format |
ODM_FILE_FOLDERS_OBJ_D |
8220 |
All File Folder Objects |
ODM_FILE_FLDR_TYPE_OBJ_D |
6159 |
File Folder Type ojbect |
ODM_FILE_PRDITY_PREF_D |
2000011016 |
|
ODM_GATES_TYPE_OBJ_D |
18387 |
Gates Objects |
ODM_GERMAN_D |
31123 |
German List |
ODM_HISTORY_ACTION_D |
4506 |
HistoryActionList |
ODM_HIST_RPT_FF_TYPE_OBJ_D |
6367 |
|
ODM_HISTORICAL_RPT_TYPE_D |
7114 |
|
ODM_INCORP_STATUS_D |
706 |
Incorporation Status |
ODM_IPC_FILE_D |
2000005842 |
IPC File Type |
ODM_IPC_FORM_D |
2000005839 |
IPC Form Type |
ODM_IPC_LEGAL_D |
2000007596 |
IPC Legal Definition Type |
ODM_IPC_MSL_D |
2000005847 |
IPC J-STD-020 MSL Rating |
ODM_IPC_NUMBER_PROCESS_D |
2000005846 |
IPC Number of Processing Cycles |
ODM_IPC_SUPPLIER_D |
2000007595 |
IPC Supplier Acceptance |
ODM_IPC_TERMINAL_BASE_D |
2000005845 |
IPC Terminal Base Alloy |
ODM_IPC_TERMINAL_PLATING_D |
2000005844 |
IPC Terminal Plating / Grid Array Material |
ODM_IPC_UNIT_D |
2000005843 |
IPC Unit Type |
ODM_IPC1752_1_DECL_D |
2000005841 |
IPC 1752-1 Declaration Type |
ODM_IPC1752_2_DECL_D |
2000005840 |
IPC 1752-2 Declaration Type |
ODM_ITEM_CHANGE_FILTER_D |
16914 |
Item Change Filter List |
ODM_ITEM_FAILUREMODE_D |
21620 |
Failure Mode List - [Part] |
ODM_ITEM_LIFECYCLE_PHASE_D |
1514 |
Items |
ODM_ITEM_OBJ_D |
8222 |
All Item Objects |
ODM_ITEM_SITES_QUOTE_D |
6043 |
Item_Sites Quote_As List |
ODM_ITEM_STATE_D |
4566 |
ITEM_STATE |
ODM_ITMMREV_STATE_D |
4558 |
ITEMREV_STATE |
ODM_JGPSSI_UNIT_D |
2000007462 |
JGPSSI Units |
ODM_JGPSSI_Y_N_D |
2000007463 |
JGPSSI Yes/No |
ODM_JIG_LEVEL_D |
2000011094 |
JIG Level |
ODM_LANGUAGE_DISPLAY_D |
4519 |
|
ODM_LAUNCH_YEAR_LIST_D |
2000000108 |
Launch Year List |
ODM_LAYOUT_ACCESS_D |
7113 |
|
ODM_LAYOUT_PAPER_ORI_D |
7118 |
Paper Layout |
ODM_LAYOUT_PAPER_SIZE_D |
7119 |
Paper Size |
ODM_LIST_HISTORY_ACTION_D |
44546 |
|
ODM_LIST_MAIN_TOOLBAR_D |
2345 |
Main Toolbar Design |
ODM_LIST_WF_EVENT_D |
4457 |
Workflow Events List |
ODM_LIST_WORKWEEK_D |
5968 |
Days of the Week |
ODM_LISTS_D |
8819 |
Roles List |
ODM_LOCATION_D |
4542 |
Location |
ODM_MAKE_BUY_D |
12065 |
Make/Buy |
ODM_MANUFACTURER_OBJ_D |
8224 |
All Manufacturer Objects |
ODM_MANUFACTURER_PART_OBJ_D |
8225 |
All Manufacturer Part Objects |
ODM_MANU_PARTS_TYPE_OBJ_D |
1843 |
Manufacturer Parts Type Objects |
ODM_MANUFACTURERS_TYPE_OBJ_D |
1442 |
Manufacturers Type Objects |
ODM_MASS_DISCLOSURE_D |
2000011081 |
Disclosure Types List |
ODM_MATERIAL_LIFECYCLE_PHASE_D |
2000004147 |
Material |
ODM_MFR_ORDERS_TYPE_OBJ_D |
1450 |
MCO Objects |
ODM_MFRPART_LIFECYCLE_PHASE_D |
1515 |
Manufacturer Parts |
ODM_MCO_TYPE_D |
742 |
MCO Type List |
ODM_MFR_LIFECYCLE_PHASE_D |
1516 |
Manufacturers |
ODM_MFR_TYPE_D |
740 |
Mfr Type List |
ODM_MFRPART_TYPE_D |
741 |
Mfr Part Type List |
ODM_NCR_TYPE_OBJ_D |
4895 |
NCR Type Objects |
ODM_NEWS_TYPE_D |
18406 |
News Type List |
ODM_NOTIFY_LIST_D |
||
ODM_NUMBER_FORMAT_D |
4452 |
Number Format List |
ODM_ORGANIZATION_TYPE_OBJ_D |
17570 |
Organization Type Objects |
ODM_ORG_STATUS_D |
4516 |
ORG_STATUS |
ODM_ORG_SUPPLIER_D |
4545 |
ORG_SUPPLIER_TYPE |
ODM_ORG_TYPE_D |
4515 |
ORG_TYPE |
ODM_ORGANIZATION_OBJ_D |
13555 |
All Organization Objects |
ODM_OUTBOUND_RESPONSE_D |
12353 |
Outbound Response List |
ODM_OVERALL_STATUS_D |
18820 |
Overall Statuses |
ODM_OVERLAY_ICON_D |
8974 |
Overlay Icon List |
ODM_PART_CATEGORY_D |
311 |
Part Category |
ODM_PART_COMPLIANCE_D |
2000002025 |
Part Compliance List |
ODM_PART_FAMILY_COMM_OBJ_D |
2000007001 |
All Part Family Commodity Objects |
ODM_PART_FAMILY_OBJ_D |
2000004418 |
All Part Family Objects |
ODM_PART_FAMILY_TYPE_OBJ_D |
2000004409 |
|
ODM_PART_TYPE_D |
735 |
Part Type List |
ODM_PARTFY_LIFECYCLE_PHASE_D |
2000004283 |
Part Family |
ODM_PARTS_TYPE_OBJ_D |
10000 |
Parts Type List Objects |
ODM_PKG_CATEGORY_D |
412 |
Package Categories |
ODM_PLANNER_D |
8933 |
Planner |
ODM_PR_DISPOSITION_D |
5131 |
PR Disposition List |
ODM_PR_TYPE_OBJ_D |
4878 |
PR Type List Object |
ODM_PREFERRED_CLIENT_D |
13261 |
Preferred Client List |
ODM_PREFERRED_INBOX_D |
7121 |
|
ODM_PREFERRED_PRG_D |
7123 |
|
ODM_PREFERRED_STA_PRG_D |
7122 |
|
ODM_PRG_HIST_ACT_D |
2000007020 |
|
ODM_PRICE_ADMIN_OBJ_D |
8524 |
Price Administrators |
ODM_PRICE_CHGORDERS_TYPE_OBJ_D |
10516 |
Price Change Orders Type List Objects |
ODM_PRICE_LIFECYCLE_PHASE_D |
10897 |
Price |
ODM_PRICE_OBJ_D |
8523 |
All Price Objects |
ODM_PRICE_SCEN_D |
4597 |
|
ODM_PRICEPOINT_PRD_D |
4565 |
|
ODM_PRIORITY_D |
12868 |
Priority |
ODM_PROD_LINE_D |
2000000106 |
Product Line List |
ODM_PRODUCT_LINES_D |
291 |
Product Lines |
ODM_PROGRAM_TYPE_D |
2000000103 |
Program Type List |
ODM_PROGRAMS_OBJ_D |
8228 |
All Program Objects |
ODM_PROJECT_LIFECYCLE_PHASE_D |
10905 |
Projects |
ODM_PROJECT_LINE_ITEM_D |
4527 |
|
ODM_PROJECT_TYPE_D |
4531 |
|
ODM_PSR_CATEGORY_D |
5129 |
Problem Report Category |
ODM_PSR_OBJ_D |
8227 |
All PSR Objects |
ODM_PSR_PR_PRODUCTLINE_D |
5948 |
Product Lines(PSR) |
ODM_PSR_SEVERITY_D |
6629 |
PSR Severity List |
ODM_PUB_ACTION_D |
203 |
Publisher Actions List |
ODM_PUB_PRICE_TYPE_OBJ_D |
10321 |
Publisher Price Type List Object |
ODM_QCR_CATEGORY_D |
6819 |
QCR Category |
ODM_QCR_OBJ_D |
8226 |
All QCR Objects |
ODM_QUALITY_ADMIN_OBJ_D |
5198 |
Quality Administrators |
ODM_QUALITY_ANALYST_OBJ_D |
5199 |
Quality Analysts |
ODM_QUALITY_STATUS_D |
18783 |
Quality Statuses |
ODM_QUOTE_HIST_TYPE_OBJ_D |
10338 |
Quote History type list ojbects |
ODM_READINESS_STATE_D |
4591 |
Readines State |
ODM_REASONCODE_D |
351 |
Reason Code |
ODM_REDLINE_TYPE_D |
16917 |
Redline Type |
ODM_REF_DESIGN_IND_D |
2000007046 |
Reference Designator Range Indicator List |
ODM_REGION_D |
4599 |
Region/Province/State |
ODM_REGION_LIST_D |
2000000104 |
Region List |
ODM_REGIONS_D |
4518 |
Time zones of the Region |
ODM_RELEASE_TYPE_D |
4539 |
RELEASE_TYPE |
ODM_REPOST_SCH_EXE_FQN_D |
7116 |
Report scheduling |
ODM_REPORT_SCH_STATE_D |
7115 |
|
ODM_RESPONSE_D |
4537 |
RESPONSE |
ODM_REQ_LIST_D |
3877 |
|
ODM_REQUESTS_QUOTE_D |
16441 |
Requests for Quote |
ODM_RESOURCE_TYPE_D |
2000000748 |
Resource Type List |
ODM_RESPONSE_BID_DECI_D |
4541 |
Bid responses |
ODM_RESPONSE_BID_STATE_D |
4579 |
Bid response status |
ODM_RESPONSE_EDITMODE_D |
8211 |
Response Editing modes |
ODM_RESPONSE_LIFECYCLE_PHASE_D |
10915 |
Responses |
ODM_RESPONSE_LINE_ITEM_D |
4526 |
Response Line Item |
ODM_RESPONSE_LINE_STATUS_D |
4564 |
RESPONSE_LINE_STATUS |
ODM_RESPONSE_STATE_D |
4536 |
RESPONSE_STATE |
ODM_RESPONSE_TYPE_D |
4552 |
RESPONSE_TYPE |
ODM_RESRC_STATUS_D |
18782 |
Resource Statuses |
ODM_REV_OBJECT_D |
7090 |
REV_OBJECT |
ODM_RFQ_LIFECYCLE_PHASE_D |
10910 |
RFQ |
ODM_RFQ_LINE_STATUS_D |
4550 |
RFQ_LINE_STATUS |
ODM_RFQ_OBJ_D |
8521 |
All RFQ Objects |
ODM_RFQ_RESPN_D |
16635 |
RFQ Responses |
ODM_RFQ_RESPONSE_OBJ_D |
8522 |
All RFQ Response Objects |
ODM_RFQ_STATE_D |
4533 |
RFQ_STATE |
ODM_RFQ_TYPE_D |
4534 |
RFQ_TYPE |
ODM_RLSHIP_TYPE_D |
2000007913 |
Relationship types |
ODM_ROHS_DEC_D |
2000005848 |
RoHS Declaration |
ODM_ROHS_EXEMPTION_D |
2000007599 |
RoHS Exemption |
ODM_ROLES_D |
4523 |
ROLES |
ODM_ROLL_UP_D |
2000004142 |
Rollup Selection |
ODM_ROW_PER_PAG_D |
12884 |
Number of rows per page |
ODM_SEARCHES_D |
8821 |
Searches list |
ODM_SEVER_LOC_D |
13300 |
Server Location |
ODM_SEVERITY_D |
6504 |
Severity |
ODM_SHIP_FROM_D |
10311 |
Ship From |
ODM_SHIP_LOCATION_OBJ_D |
17501 |
Ship To Location List |
ODM_SITE_CHGORDERS_TYPE_OBJ_D |
11907 |
Site Change Orders type list objects |
ODM_SITE_COLOR_D |
13389 |
Colors list |
ODM_SITE_ERP_D |
11934 |
Site ERP List |
ODM_SITE_LIFECYCLE_PHASE_D |
11962 |
Sites |
ODM_SITES_OBJ_D |
13166 |
All Sites Objects |
ODM_SITES_TYPE_OBJ_D |
11760 |
Sites type list objects |
ODM_SIZE_D |
421 |
Size |
ODM_SRC_PROJECT_OBJ_D |
8520 |
All Sourcing Project Objects |
ODM_SOURCING_PRJ_D |
16433 |
Sourcing Projects |
ODM_SPEC_LIFECYCLE_PHASE_D |
2000004150 |
Specification |
ODM_SPEC_VALIDATION_D |
2000001531 |
Spec Validation |
ODM_SPECIFICATION_OBJ_D |
2000001991 |
All Specification Objects |
ODM_STATE_D |
353 |
State List |
ODM_STATE_PROV_REGION_D |
12645 |
State/Province/Region List |
ODM_STATUS_LISTS_D |
3921 |
Status Lists |
ODM_STATUS_TYPE_D |
3644 |
Status Type Selection |
ODM_STOPSHIPS_TYPE_D |
738 |
SS Type List |
ODM_SUBSCRIBERS_D |
12825 |
Subscribers |
ODM_SUBSTANCES_OBJ_D |
2000002154 |
All Substance Objects |
ODM_SUBSTANCE_REPORT_D |
2000002499 |
Substance Reporting |
ODM_SUPP_OFFER_RAT_D |
4522 |
Supplier Offering Rating |
ODM_SUPPLIER_AML_STATUS_D |
4560 |
SUPPLIER_AML_STATUS |
ODM_SUPPLIER_GROUP_D |
17669 |
Supplier Group Type |
ODM_SUPPLIER_LIFECYCLE_PHASE_D |
10901 |
Suppliers |
ODM_SUPPLIER_RESP_STATUS_D |
4562 |
Supplier Response Status |
ODM_SUPPLIER_TYPE_D |
4554 |
SUPPLIER_TYPE |
ODM_SUPPLIERS_OBJ_D |
17667 |
All Supplier Objects |
ODM_SUPPLIER_OFFER_TYPE_D |
17504 |
List of Supplier Offering Types |
ODM_TIMEFORMAT_D |
4476 |
Time formats |
ODM_TIMEZONE_D |
4474 |
List of TimeZone display strings |
ODM_TRANSMISSION_STATUS_D |
12823 |
Transmission Status List |
ODM_TRANSPORT_TERMS_D |
4587 |
Transportation Terms |
ODM_UOM_D |
2000001990 |
Units of Measure |
ODM_USER_CATEGORY_D |
9279 |
User Category |
ODM_USER_GROUP_OBJ_D |
13048 |
All User Group Objects |
ODM_USER_GROUP_TYPE_D |
12082 |
User Group Type List |
ODM_USER_GROUP_TYPE_OBJ_D |
12082 |
User Group Type Objects |
ODM_USERS_OBJ_D |
361 |
All User Objects |
ODM_YES_NO_D |
2000003226 |
Yes/No Cost List |
ODM_YES_NO_SELECTION_D |
451 |
Map tables are created for every multi-list attribute for all the supported classes. These tables are created dynamically during ETL run.
The following table lists the columns in the Map tables:
The following table lists the various Map tables in OPLA Operational Schema:
Table 2-10 Map tables in OPLA Operational Schema
Entities | Description |
---|---|
ODM_ASL_MAP |
– |
ODM_ATTACHMENT_MAP |
Stores Mapping information about the attachments |
ODM_CACHE_FILE_MAP1 |
– |
ODM_DEV_SUPPLIER_MAP |
Stores Mapping information about the suppliers. |
ODM_ECO_SUPPLIER_MAP |
Stores Mapping information about the suppliers. |
ODM_ECR_SUPPLIER_MAP |
Stores Mapping information about the suppliers. |
ODM_MATERIAL_DECLARATION_MAP |
Stores Mapping information about the material declaration. |
ODM_MCO_SUPPLIER_MAP |
Stores Mapping information about the suppliers. |
ODM_OBJECT_MAP |
Stores Mapping information about the objects. |
ODM_PART_FAMILY_MAP |
Stores Mapping information about part family. |
ODM_PCO_SUPPLIER_MAP |
Stores Mapping information about the suppliers. |
ODM_PRODUCT_LINE_MAP |
Stores Mapping information about product lines. |
ODM_RENDITION_FILE_MAP |
Stores Mapping information about rendition files |
ODM_SCO_SUPPLIER_MAP |
Stores Mapping information about the suppliers. |
ODM_SS_SUPPLIER_MAP |
Stores Mapping information about the suppliers. |
ODM_SUBSTANCE_MAP |
Stores Mapping information about substance and other PLM Classes |
ODM_THUMBNAIL_FILE_MAP |
– |
ODM_THUMBNAIL_OBJECT_MAP |
– |
ODM_VERSION_FILE_MAP |
– |
ODM_WF_DEF_SIGNOFF_MAP |
– |
These are views which contain information about Subclass-specific attributes. These subclass views are available for Agile PLM modules such as PQM, PC, PPM, PCM, and PG&C.
Table 2-11 Data Entities, Common
Entity Name | Description |
---|---|
ODM_ACTION_ITEM |
Stores the Action item related information used in Discussion and Activity objects |
ODM_ADMINMSATT |
Stores assignment/default values for Workflows, Roles, Privileges, Criteria, Filter and Viewable Tabs |
ODM_AGILEUSER |
Stores information about Users |
ODM_ASL_MAP |
This table maps Suppliers (in the ORGANIZATION table) to Items and Manufacturer Parts. |
ODM_ATT_DESIGNS |
Stores the File Folders Design Information |
ODM_ATT_FILE_FLDR |
This table support attachment being the file folder class object |
ODM_ATT_HIST_RPT_FF |
This table support attachment being the History Report File Folder class object |
ODM_ATTACHMENT_MAP |
Relationship mapping between Attachment, Version and Files tables. This table implements the many-to-many relationship between business objects and attachments. The table contains three foreign keys, attach_id, parent_id, parent_class and parent_id2 that will represent the relationship between an attachment and a business object. In addition, the table will also include a set of flex fields. |
ODM_CHANGE_HISTORY |
Stores user actions on routable objects |
ODM_CONVERSION |
Currency conversion rates stored in this table are used to convert currency values to the selected corporate currency. |
ODM_CUSTOMER |
This is the main customer record. |
ODM_DISCUSSION |
Stores discussion objects and its replies |
ODM_ESCALATIONS |
Stores workflow escalations for users. |
ODM_FILE_INFO |
Stores the information of the File. |
ODM_FILES |
Each row in the table represents a single file of a version of an attachment object. |
ODM_FOLDER_STRUCTURE |
Stores the Structure of the Folder which will hold all the Objects. |
ODM_ITEM_DOCS |
This is the main item table for Documents. |
ODM_ITEM_HISTORY |
Stores all user actions that have acted upon all non- routable objects |
ODM_ITEM_PARTS |
This is the main item table for Parts. |
ODM_LANGTABLE |
Stores the attribute contents or values with the Language ID. |
ODM_MANU_BY |
Stores relationship instances between agile parts and manufacturer parts. |
ODM_MANU_PARTS |
Stores relationship instances between agile parts and manufacturer parts. |
ODM_OBJECTACL |
Store each object level access control information |
ODM_MANUFACTURERS |
Stores Information about Manufacturers |
ODM_MATERIAL_DECLARATION_MAP |
Identifies the price declared on the item |
ODM_NOTIFICATION |
Stores information about notifications |
ODM_ORGANIZATION |
Store information about organization |
ODM_PAGE_THREE |
Stores the Page Three information of all the objects |
ODM_PART_FAMILY |
Stores Part Group details |
ODM_PART_FAMILY_MAP |
Stores the details of the mapping of Part Family. |
ODM_PRICE_PUB_PRICE |
Stores the published price information |
ODM_PRICE_QUOTE_HIST |
Stores the Historical Price Information. |
ODM_PRODUCT_LINE |
Stores the information of product line |
ODM_PRODUCT_LINE_MAP |
Stores the Product Line mapping Information. |
ODM_RELATIONSHIP |
You can specify ad hoc relationships between Agile objects by setting up relationships between them. Such a relationship is created when you add an object to a table in the Relationships tab of another object. Classes of objects that can be referenced on a Relationship tab include routable objects (which always have a Relationships tab), items, manufacturers, manufacturer parts, suppliers, customers, projects, RFQs, and supplier responses. |
ODM_REV |
Stores item revision information. This is the instance of the revision of the object |
ODM_SIGNOFF |
Stores user signoff status details. |
ODM_SITE |
Stores PCM Ship to Locations |
ODM_SITES |
Sites represent manufacturing locations. |
ODM_USER_ASSIGNMENT |
Stores relationship between user and roles - Appears to be an associative entity. |
ODM_USER_GROUP |
Stores User Groups as defined in the admin interface. |
ODM_USER_ROLE |
Stores the user roles. |
ODM_USER_SITE |
Associative entity between AGILEUSER and SITES |
ODM_USER_USAGE_HISTORY |
History of when users log in and out of system ID Primary key. |
ODM_VERSION |
Each row in the table represents a single version of an attachment object. |
ODM_VERSION_FILE_MAP |
This table will store the info of each row in Files Tab for different versions. This table will also implement the many-to-many relationship between files and versions. Different row in different version in the files tab may point to the same physical files. This is to avoid duplicating the physical file content when the file is unchanged when we create a new version. |
ODM_WF_DEF_SIGNOFF_MAP |
Map table to identify a user associated with the workflow state is Approver/Observer |
ODM_WORKFLOW_PROCESS |
Stores workflow status occurring sequence for all the workflow routable objects. |
Table 2-12 Data Entities, PPM
Entity Name | Description |
---|---|
ODM_ACTIVITY_BASELINE |
Stores baselines for activity objects |
ODM_ACTIVITY_DEPENDENCY |
Stores Activity dependency relationship between Activity records. TO_ID is dependant on the FROM_ID with both ID's being ACTIVITY records. |
ODM_APPROVAL_ITEMS |
Stores Gates object's approval items |
ODM_BASELINE_REV |
Stores item revision information. This is the instance of the revision of the object |
ODM_FLEX_FIELD |
Stores flex fields of action item This is used to extend ACTION_ITEM and NEWS |
ODM_NEWS |
Stores news objects for Activity and Gates object. This is used in PE product |
ODM_PRG_ACTIVITY |
Stores the Program Activities Information |
ODM_PRG_GATES |
Stores information about Gates Object |
ODM_PROGRAM_HISTORY |
Stores history logs for Activity, Gates and Discussion objects |
ODM_TEAM |
Stores the Resources information associated with Programs |
ODM_TEAM_BASELINE |
Stores the Resources information of every baselined activity for all versions. |
Table 2-13 Data Entities, PC
Entity Name | Description |
---|---|
ODM_BOM |
Stores Bill of material related information |
ODM_CHNG_CHG_ORDERS |
Stores information about change order objects |
ODM_CHNG_CHG_REQS |
Stores information about change request objects |
ODM_CHNG_DEVIATION |
Stores information about deviation objects |
ODM_CHNG_MFR_ORDERS |
Stores the changes regarding the manufacturer orders. |
ODM_CHNG_PRICE_CHGORDERS |
Stores information about price change order objects |
ODM_CHNG_SITE_CHGORDERS |
Stores information about site change order objects |
ODM_CHNG_STOP_SHIPS |
Stores information about stop ships objects |
ODM_ITEM_SITES |
Store relationship between item and sites - Not a pure associative entity. |
ODM_REFDESIG |
Stores reference designator labels. |
Table 2-14 Data Entities, PQM
Entity Name | Description |
---|---|
ODM_PSR_NCR |
Stores the Non Conformance Reports |
ODM_PSR_NCR_ITEM |
Mapping between NCR object and its Affected Items |
ODM_PSR_PR |
Stores the Problem Reports |
ODM_PSR_PR_ITEM |
Mapping between PR object and its Affected Items |
ODM_QCR_AUDIT |
Stores the Audits |
ODM_QCR_AUDIT_ITEM |
Mapping between an Audit object and its Affected Items |
ODM_QCR_CAPA |
Stores the Corrective and Preventive Actions |
ODM_QCR_CAPA_ITEM |
Mapping between a CAPA object and its Affected Items |
Table 2-15 Data Entities, PCM
Entity Name | Description |
---|---|
ODM_BUYER_LINE_CARD |
Stores information about Supplier and Projects regarding RFQs |
ODM_GEOGRAPHY_ROUTING |
Stores Geographical routing information about sourcing projects |
ODM_OBJECT_LOCKS |
stores information about object locks |
ODM_PRICEENTRY |
Stores Pricing information for Sourcing projects |
ODM_PRICELINE |
Stores Pricing information for Sourcing projects |
ODM_PRICEPOINT |
Stores Pricing information for Sourcing projects |
ODM_PRICE_HISTORY |
Stores History information about pricing in sourcing project |
ODM_PROJECT |
Stores All Sourcing Projects.Class ID 16433 |
ODM_RESPONSE |
Stores All RFQs.Class ID 16635 |
ODM_RESPONSE_HEADER |
Stores All RFQ Response.Class ID 16441 |
ODM_RESPONSE_RFQ_MAPPING |
Stores mapping information about RFQ and responses. |
ODM_RFQ_COMMENTS |
Stores comments about RFQs |
ODM_RFQ_COMMENT_RECIPIENT |
Stores comments about RFQ's from suppliers |
ODM_RFQ_HEADER |
Stores All RFQ's.Class ID 16635 |
ODM_RFQ_LINE |
Stores information sourcing project product line |
ODM_SC_AML |
Stores all relationship about Item to Mfr Item Map for Sourcing Projects |
ODM_SC_BOM |
Stores information about the original and delta boms for sourcing projects |
ODM_SC_COMMENT |
Stores comments about sourcing projects |
ODM_SC_COST_QTY_ROLLUP |
Stores information about Cost rollup for sourcing Projects |
ODM_SC_DELTA_BOM |
Stores the delta bom for the given parent item in blob |
ODM_SC_ITEM |
Stores item information related to sourcing projects |
ODM_SC_PROJECT_SITES |
Stores information about Project and Sites for sourcing projects |
ODM_SC_SUPPLIERS |
Stores information about Partner assignment for items in the Sourcing Projects |
ODM_SC_WORK_IN_PROGRESS |
Stores information about Sourcing project completion status |
ODM_SUPPLIER_LINE_CARD |
Stores information about Supplier and Projects regarding RFQs |
Table 2-16 Data Entities, PGC
Entity Name | Description |
---|---|
ODM_AGGR_SUBSTANCE |
Stores Aggregated Information about Substances |
ODM_COMPLIANCE |
Stores Compliance information about Substances |
ODM_MATERIAL_DCLRNS_HGNUS |
Stores All Homogeneous Material Declarations.Class ID 2000002395 |
ODM_MATERIAL_DCLRNS_IPC_1 |
Stores All IPC 1752-1 Material Declarations.Class ID 2000005977 |
ODM_MATERIAL_DCLRNS_IPC_2 |
Stores All IPC 1752-2 Material Declarations.Class ID 2000005735 |
ODM_MATERIAL_DCLRNS_JGPSSI |
Stores All JGPSSI Material Declarations.Class ID 2000002423 |
ODM_MATERIAL_DCLRNS_PRTS |
Stores All Parts Material Declarations.Class ID 2000002367 |
ODM_MATERIAL_DCLRNS_SBTNCE |
Stores All Substance Material Declarations.Class ID 2000002882 |
ODM_MATERIAL_DCLRNS_SUPPLR |
Stores All Supplier Material Declarations.Class ID 2000002395 |
ODM_REGULATION |
Stores All Specifications.Class ID 2000001992 |
ODM_RGULTN_P2_MAPPING |
Stores information specifications |
ODM_SUBSTANCE_GROUPS |
Stores All Substance Groups.Class ID 2000001119 |
ODM_SUBSTANCE_MAP |
Stores Mapping information about substance and other PLM Classes |
ODM_SUBSTANCE_MATERIALS |
Stores All Substance Materials.Class ID 2000002467 |
ODM_SUBSTANCE_SUBPARTS |
Stores All Substance Sub Parts.Class ID 2000002445 |
ODM_SUBSTANCE_SUBSTANCES |
Stores All Substance Substances.Class ID 2000001018 |
Suffixes have been used to indicate columns that must contain specific values.
Table 2-17 Standard column suffixes in Agile PLM DM tables
Suffix | Value |
---|---|
_CD |
This column value is based on the contents of A_LIST_ENTRY.ENTRY_CD (originally LISTENTRY.ENTRYID) (this is not a FK). For a column with a Dynamic List whose values are not stored in List Entry table, we can treat it as a normal FK to an Agile table. |
_DATE |
This column contains a date or datetime value |
_FLAG |
This column contains a numeric value for Boolean value; 1 indicates True or Yes 0 indicates False or No |
_ID |
This column contains ID values. |
The Entity Relationship Diagrams are categorized into the following groups:
The following are the various Entity Relationship diagrams specific to Product Collaboration:
The following are the various Entity Relationship diagrams specific to Product Portfolio Management:
The following are the various Entity Relationship diagrams specific to Product Quality Management:
The following are the various Entity Relationship diagrams specific to Product Governance and Compliance:
The following are the various Entity Relationship diagrams specific to Product Cost Management: