| Part Identifier |
| Base Entity | Component |
| Attribute Name | Part Identifier |
| Logical Rolename | |
| ColumnName | Part ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Part Identifier Logical Attribute Properties |
| Logical Attribute Name | Part Identifier |
| Datatype | VARCHAR(30) |
| Nullable | NO |
| Part Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Part Identifier Security Types |
| Name | Current Value |
| Part Identifier Bound Attachments |
| Name | Current Value |
| Part Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Part Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Part Identifier |
NO | ||
| BICS (Oracle) CMPNT PART_ID |
NO |
| Part Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Part Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Part Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Part Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Type Identifier |
| Base Entity | Component |
| Attribute Name | Component Type Identifier |
| Logical Rolename | |
| ColumnName | CMPNT_TYPE_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Component Type Identifier Logical Attribute Properties |
| Logical Attribute Name | Component Type Identifier |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Component Type Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Component Type Identifier Security Types |
| Name | Current Value |
| Component Type Identifier Bound Attachments |
| Name | Current Value |
| Component Type Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Component Type Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Component Type Identifier |
NO | ||
| BICS (Oracle) CMPNT CMPNT_TYPE_ID |
NO |
| Component Type Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Type Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Type Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Type Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Status Identifier |
| Base Entity | Component |
| Attribute Name | Component Status Identifier |
| Logical Rolename | |
| ColumnName | CMPNT_STAT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Component Status Identifier Logical Attribute Properties |
| Logical Attribute Name | Component Status Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Component Status Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Component Status Identifier Security Types |
| Name | Current Value |
| Component Status Identifier Bound Attachments |
| Name | Current Value |
| Component Status Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Component Status Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Component Status Identifier |
NO | ||
| BICS (Oracle) CMPNT CMPNT_STAT_ID |
NO |
| Component Status Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Status Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Status Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Status Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description |
| Base Entity | Component |
| Attribute Name | Description |
| Logical Rolename | |
| ColumnName | DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| Description Logical Attribute Properties |
| Logical Attribute Name | Description |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Description Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Description Security Types |
| Name | Current Value |
| Description Bound Attachments |
| Name | Current Value |
| Description Data Movement Rules |
| Name | Type | Rule Text/Value |
| Description Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Description |
NO | ||
| BICS (Oracle) CMPNT DESCR |
NO |
| Description Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Identifier |
| Base Entity | Component |
| Attribute Name | Material Identifier |
| Logical Rolename | |
| ColumnName | MATL_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Material Identifier Logical Attribute Properties |
| Logical Attribute Name | Material Identifier |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Material Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Material Identifier Security Types |
| Name | Current Value |
| Material Identifier Bound Attachments |
| Name | Current Value |
| Material Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Material Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Identifier |
NO | ||
| BICS (Oracle) CMPNT MATL_ID |
NO |
| Material Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Manufacturer Id |
| Base Entity | Component |
| Attribute Name | Manufacturer Id |
| Logical Rolename | |
| ColumnName | MNFCTR_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Manufacturer Identifier: The unique code used to identify a manufacturer. |
| Note |
| Manufacturer Id Logical Attribute Properties |
| Logical Attribute Name | Manufacturer Id |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Manufacturer Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Manufacturer Id Security Types |
| Name | Current Value |
| Manufacturer Id Bound Attachments |
| Name | Current Value |
| Manufacturer Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Manufacturer Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Manufacturer Id |
NO | ||
| BICS (Oracle) CMPNT MNFCTR_ID |
NO |
| Manufacturer Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Manufacturer Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Manufacturer Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Manufacturer Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Value |
| Base Entity | Component |
| Attribute Name | Component Value |
| Logical Rolename | |
| ColumnName | CMPNT_VAL |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Component Value Logical Attribute Properties |
| Logical Attribute Name | Component Value |
| Datatype | NUMERIC(20, 2) |
| Nullable | YES |
| Component Value Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Component Value Security Types |
| Name | Current Value |
| Component Value Bound Attachments |
| Name | Current Value |
| Component Value Data Movement Rules |
| Name | Type | Rule Text/Value |
| Component Value Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Component Value |
NO | ||
| BICS (Oracle) CMPNT CMPNT_VAL |
NO |
| Component Value Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Value Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Value Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Value Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tolerance |
| Base Entity | Component |
| Attribute Name | Tolerance |
| Logical Rolename | |
| ColumnName | TOL |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Tolerance: +/- percent accuracy in component value. |
| Note |
| Tolerance Logical Attribute Properties |
| Logical Attribute Name | Tolerance |
| Datatype | NUMERIC(5, 2) |
| Nullable | YES |
| Tolerance Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Tolerance Security Types |
| Name | Current Value |
| Tolerance Bound Attachments |
| Name | Current Value |
| Tolerance Data Movement Rules |
| Name | Type | Rule Text/Value |
| Tolerance Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Tolerance |
NO | ||
| BICS (Oracle) CMPNT TOL |
NO |
| Tolerance Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tolerance Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tolerance Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tolerance Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rating |
| Base Entity | Component |
| Attribute Name | Rating |
| Logical Rolename | |
| ColumnName | RTG |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Rating: Maximum Voltage, Wattage, Torque, RAD hardness, etc. |
| Note |
| Rating Logical Attribute Properties |
| Logical Attribute Name | Rating |
| Datatype | NUMERIC(10, 0) |
| Nullable | YES |
| Rating Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Rating Security Types |
| Name | Current Value |
| Rating Bound Attachments |
| Name | Current Value |
| Rating Data Movement Rules |
| Name | Type | Rule Text/Value |
| Rating Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Rating |
NO | ||
| BICS (Oracle) CMPNT RTG |
NO |
| Rating Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rating Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rating Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rating Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Datasheet |
| Base Entity | Component |
| Attribute Name | Datasheet |
| Logical Rolename | |
| ColumnName | DATASHEET |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Datasheet Logical Attribute Properties |
| Logical Attribute Name | Datasheet |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Datasheet Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Datasheet Security Types |
| Name | Current Value |
| Datasheet Bound Attachments |
| Name | Current Value |
| Datasheet Data Movement Rules |
| Name | Type | Rule Text/Value |
| Datasheet Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Datasheet |
NO | ||
| BICS (Oracle) CMPNT DATASHEET |
NO |
| Datasheet Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Datasheet Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Datasheet Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Datasheet Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAD Model URL |
| Base Entity | Component |
| Attribute Name | CAD Model URL |
| Logical Rolename | |
| ColumnName | CAD_MDL_URL |
| RoleName | |
| Domain | URL |
| Logical Only | NO |
| Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
| Note |
| CAD Model URL Logical Attribute Properties |
| Logical Attribute Name | CAD Model URL |
| Datatype | VARCHAR(2048) |
| Nullable | YES |
| CAD Model URL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CAD Model URL Security Types |
| Name | Current Value |
| CAD Model URL Bound Attachments |
| Name | Current Value |
| CAD Model URL Data Movement Rules |
| Name | Type | Rule Text/Value |
| CAD Model URL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component CAD Model URL |
NO | ||
| BICS (Oracle) CMPNT CAD_MDL_URL |
NO |
| CAD Model URL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAD Model URL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAD Model URL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAD Model URL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drawing Baseline URL |
| Base Entity | Component |
| Attribute Name | Drawing Baseline URL |
| Logical Rolename | |
| ColumnName | DRAW_BASE_URL |
| RoleName | |
| Domain | URL |
| Logical Only | NO |
| Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
| Note |
| Drawing Baseline URL Logical Attribute Properties |
| Logical Attribute Name | Drawing Baseline URL |
| Datatype | VARCHAR(2048) |
| Nullable | YES |
| Drawing Baseline URL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Drawing Baseline URL Security Types |
| Name | Current Value |
| Drawing Baseline URL Bound Attachments |
| Name | Current Value |
| Drawing Baseline URL Data Movement Rules |
| Name | Type | Rule Text/Value |
| Drawing Baseline URL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Drawing Baseline URL |
NO | ||
| BICS (Oracle) CMPNT DRAW_BASE_URL |
NO |
| Drawing Baseline URL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drawing Baseline URL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drawing Baseline URL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drawing Baseline URL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Procedure |
| Base Entity | Component |
| Attribute Name | Test Procedure |
| Logical Rolename | |
| ColumnName | TEST_PROC |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Test Procedure Logical Attribute Properties |
| Logical Attribute Name | Test Procedure |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Test Procedure Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Test Procedure Security Types |
| Name | Current Value |
| Test Procedure Bound Attachments |
| Name | Current Value |
| Test Procedure Data Movement Rules |
| Name | Type | Rule Text/Value |
| Test Procedure Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Test Procedure |
NO | ||
| BICS (Oracle) CMPNT TEST_PROC |
NO |
| Test Procedure Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Procedure Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Procedure Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Procedure Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Documentation |
| Base Entity | Component |
| Attribute Name | Justification Documentation |
| Logical Rolename | |
| ColumnName | JUST_DOC |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Justification Documentation Logical Attribute Properties |
| Logical Attribute Name | Justification Documentation |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Justification Documentation Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Justification Documentation Security Types |
| Name | Current Value |
| Justification Documentation Bound Attachments |
| Name | Current Value |
| Justification Documentation Data Movement Rules |
| Name | Type | Rule Text/Value |
| Justification Documentation Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Justification Documentation |
NO | ||
| BICS (Oracle) CMPNT JUST_DOC |
NO |
| Justification Documentation Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Documentation Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Documentation Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Documentation Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sole Source Justification |
| Base Entity | Component |
| Attribute Name | Sole Source Justification |
| Logical Rolename | |
| ColumnName | SOLE_SRC_JUST |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sole Source Justification Logical Attribute Properties |
| Logical Attribute Name | Sole Source Justification |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Sole Source Justification Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sole Source Justification Security Types |
| Name | Current Value |
| Sole Source Justification Bound Attachments |
| Name | Current Value |
| Sole Source Justification Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sole Source Justification Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Sole Source Justification |
NO | ||
| BICS (Oracle) CMPNT SOLE_SRC_JUST |
NO |
| Sole Source Justification Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sole Source Justification Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sole Source Justification Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sole Source Justification Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |