PART_ID |
Base Object | CMPNT |
Attribute Name | Part Identifier |
ColumnName | PART_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
PART_ID Column Properties |
Datatype | VARCHAR2(30) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PART_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 30 |
Percent Null | 0 |
PART_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PART_ID Security Types |
Name | Current Value |
PART_ID Bound Attachments |
Name | Current Value |
PART_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PART_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Part Identifier |
NO | ||
BICS (Oracle) CMPNT PART_ID |
NO |
PART_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_TYPE_ID |
Base Object | CMPNT |
Attribute Name | Component Type Identifier |
ColumnName | CMPNT_TYPE_ID |
Logical Rolename | Component Type Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
CMPNT_TYPE_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMPNT_TYPE_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
CMPNT_TYPE_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMPNT_TYPE_ID Security Types |
Name | Current Value |
CMPNT_TYPE_ID Bound Attachments |
Name | Current Value |
CMPNT_TYPE_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CMPNT_TYPE_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Component Type Identifier |
NO | ||
BICS (Oracle) CMPNT CMPNT_TYPE_ID |
NO |
CMPNT_TYPE_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_TYPE_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_TYPE_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_TYPE_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_STAT_ID |
Base Object | CMPNT |
Attribute Name | Component Status Identifier |
ColumnName | CMPNT_STAT_ID |
Logical Rolename | Component Status Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
CMPNT_STAT_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMPNT_STAT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
CMPNT_STAT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMPNT_STAT_ID Security Types |
Name | Current Value |
CMPNT_STAT_ID Bound Attachments |
Name | Current Value |
CMPNT_STAT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CMPNT_STAT_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Component Status Identifier |
NO | ||
BICS (Oracle) CMPNT CMPNT_STAT_ID |
NO |
CMPNT_STAT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_STAT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_STAT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_STAT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR |
Base Object | CMPNT |
Attribute Name | Description |
ColumnName | DESCR |
Logical Rolename | |
RoleName | |
Domain | Description |
Physical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
DESCR Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DESCR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
DESCR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DESCR Security Types |
Name | Current Value |
DESCR Bound Attachments |
Name | Current Value |
DESCR Data Movement Rules |
Name | Type | Rule Text/Value |
DESCR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Description |
NO | ||
BICS (Oracle) CMPNT DESCR |
NO |
DESCR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MATL_ID |
Base Object | CMPNT |
Attribute Name | Material Identifier |
ColumnName | MATL_ID |
Logical Rolename | Material Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
MATL_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MATL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
MATL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MATL_ID Security Types |
Name | Current Value |
MATL_ID Bound Attachments |
Name | Current Value |
MATL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
MATL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Material Identifier |
NO | ||
BICS (Oracle) CMPNT MATL_ID |
NO |
MATL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MATL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MATL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MATL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID |
Base Object | CMPNT |
Attribute Name | Manufacturer Id |
ColumnName | MNFCTR_ID |
Logical Rolename | Manufacturer Id |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Manufacturer Identifier: The unique code used to identify a manufacturer. |
Note |
MNFCTR_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MNFCTR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
MNFCTR_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MNFCTR_ID Security Types |
Name | Current Value |
MNFCTR_ID Bound Attachments |
Name | Current Value |
MNFCTR_ID Data Movement Rules |
Name | Type | Rule Text/Value |
MNFCTR_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Manufacturer Id |
NO | ||
BICS (Oracle) CMPNT MNFCTR_ID |
NO |
MNFCTR_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_VAL |
Base Object | CMPNT |
Attribute Name | Component Value |
ColumnName | CMPNT_VAL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CMPNT_VAL Column Properties |
Datatype | NUMBER(20, 2) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMPNT_VAL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 0 |
CMPNT_VAL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMPNT_VAL Security Types |
Name | Current Value |
CMPNT_VAL Bound Attachments |
Name | Current Value |
CMPNT_VAL Data Movement Rules |
Name | Type | Rule Text/Value |
CMPNT_VAL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Component Value |
NO | ||
BICS (Oracle) CMPNT CMPNT_VAL |
NO |
CMPNT_VAL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_VAL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_VAL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMPNT_VAL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TOL |
Base Object | CMPNT |
Attribute Name | Tolerance |
ColumnName | TOL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Tolerance: +/- percent accuracy in component value. |
Note |
TOL Column Properties |
Datatype | NUMBER(5, 2) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TOL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
TOL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TOL Security Types |
Name | Current Value |
TOL Bound Attachments |
Name | Current Value |
TOL Data Movement Rules |
Name | Type | Rule Text/Value |
TOL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Tolerance |
NO | ||
BICS (Oracle) CMPNT TOL |
NO |
TOL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TOL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TOL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TOL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RTG |
Base Object | CMPNT |
Attribute Name | Rating |
ColumnName | RTG |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Rating: Maximum Voltage, Wattage, Torque, RAD hardness, etc. |
Note |
RTG Column Properties |
Datatype | NUMBER(10, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RTG Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
RTG Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RTG Security Types |
Name | Current Value |
RTG Bound Attachments |
Name | Current Value |
RTG Data Movement Rules |
Name | Type | Rule Text/Value |
RTG Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Rating |
NO | ||
BICS (Oracle) CMPNT RTG |
NO |
RTG Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RTG Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RTG Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RTG Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DATASHEET |
Base Object | CMPNT |
Attribute Name | Datasheet |
ColumnName | DATASHEET |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DATASHEET Column Properties |
Datatype | BLOB |
Nullable | YES |
Not Null Constraint |
DATASHEET Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
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_MDL_URL |
Base Object | CMPNT |
Attribute Name | CAD Model URL |
ColumnName | CAD_MDL_URL |
Logical Rolename | |
RoleName | |
Domain | URL |
Physical Only | NO |
Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
Note |
CAD_MDL_URL Column Properties |
Datatype | VARCHAR2(2048) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CAD_MDL_URL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
CAD_MDL_URL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CAD_MDL_URL Security Types |
Name | Current Value |
CAD_MDL_URL Bound Attachments |
Name | Current Value |
CAD_MDL_URL Data Movement Rules |
Name | Type | Rule Text/Value |
CAD_MDL_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_MDL_URL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAD_MDL_URL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAD_MDL_URL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAD_MDL_URL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DRAW_BASE_URL |
Base Object | CMPNT |
Attribute Name | Drawing Baseline URL |
ColumnName | DRAW_BASE_URL |
Logical Rolename | |
RoleName | |
Domain | URL |
Physical Only | NO |
Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
Note |
DRAW_BASE_URL Column Properties |
Datatype | VARCHAR2(2048) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DRAW_BASE_URL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
DRAW_BASE_URL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DRAW_BASE_URL Security Types |
Name | Current Value |
DRAW_BASE_URL Bound Attachments |
Name | Current Value |
DRAW_BASE_URL Data Movement Rules |
Name | Type | Rule Text/Value |
DRAW_BASE_URL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Drawing Baseline URL |
NO | ||
BICS (Oracle) CMPNT DRAW_BASE_URL |
NO |
DRAW_BASE_URL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DRAW_BASE_URL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DRAW_BASE_URL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DRAW_BASE_URL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TEST_PROC |
Base Object | CMPNT |
Attribute Name | Test Procedure |
ColumnName | TEST_PROC |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TEST_PROC Column Properties |
Datatype | BLOB |
Nullable | YES |
Not Null Constraint |
TEST_PROC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
TEST_PROC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TEST_PROC Security Types |
Name | Current Value |
TEST_PROC Bound Attachments |
Name | Current Value |
TEST_PROC Data Movement Rules |
Name | Type | Rule Text/Value |
TEST_PROC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Test Procedure |
NO | ||
BICS (Oracle) CMPNT TEST_PROC |
NO |
TEST_PROC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEST_PROC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEST_PROC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TEST_PROC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
JUST_DOC |
Base Object | CMPNT |
Attribute Name | Justification Documentation |
ColumnName | JUST_DOC |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
JUST_DOC Column Properties |
Datatype | BLOB |
Nullable | YES |
Not Null Constraint |
JUST_DOC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
JUST_DOC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
JUST_DOC Security Types |
Name | Current Value |
JUST_DOC Bound Attachments |
Name | Current Value |
JUST_DOC Data Movement Rules |
Name | Type | Rule Text/Value |
JUST_DOC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Justification Documentation |
NO | ||
BICS (Oracle) CMPNT JUST_DOC |
NO |
JUST_DOC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
JUST_DOC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
JUST_DOC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
JUST_DOC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOLE_SRC_JUST |
Base Object | CMPNT |
Attribute Name | Sole Source Justification |
ColumnName | SOLE_SRC_JUST |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SOLE_SRC_JUST Column Properties |
Datatype | BLOB |
Nullable | YES |
Not Null Constraint |
SOLE_SRC_JUST Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
SOLE_SRC_JUST Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SOLE_SRC_JUST Security Types |
Name | Current Value |
SOLE_SRC_JUST Bound Attachments |
Name | Current Value |
SOLE_SRC_JUST Data Movement Rules |
Name | Type | Rule Text/Value |
SOLE_SRC_JUST Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Component Sole Source Justification |
NO | ||
BICS (Oracle) CMPNT SOLE_SRC_JUST |
NO |
SOLE_SRC_JUST Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOLE_SRC_JUST Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOLE_SRC_JUST Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOLE_SRC_JUST Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |