| Material Identifier |
| Base Entity | Component Material |
| 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 Material Identifier |
NO | ||
| BICS (Oracle) CMPNT_MATL 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 |
| Description |
| Base Entity | Component Material |
| 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 Material Description |
NO | ||
| BICS (Oracle) CMPNT_MATL 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 Type Identifier |
| Base Entity | Component Material |
| Attribute Name | Material Type Identifier |
| Logical Rolename | |
| ColumnName | MATL_TYPE_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Material Type Identifier Logical Attribute Properties |
| Logical Attribute Name | Material Type Identifier |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Material Type Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Material Type Identifier Security Types |
| Name | Current Value |
| Material Type Identifier Bound Attachments |
| Name | Current Value |
| Material Type Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Material Type Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Material Type Identifier |
NO | ||
| BICS (Oracle) CMPNT_MATL MATL_TYPE_ID |
NO |
| Material Type Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Type Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Type Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Type Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Status Identifier |
| Base Entity | Component Material |
| Attribute Name | Material Status Identifier |
| Logical Rolename | |
| ColumnName | MATL_STAT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Material Status Identifier Logical Attribute Properties |
| Logical Attribute Name | Material Status Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Material Status Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Material Status Identifier Security Types |
| Name | Current Value |
| Material Status Identifier Bound Attachments |
| Name | Current Value |
| Material Status Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Material Status Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Material Status Identifier |
NO | ||
| BICS (Oracle) CMPNT_MATL MATL_STAT_ID |
NO |
| Material Status Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Status Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Status Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Material Status Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Vacuum Indicator |
| Base Entity | Component Material |
| Attribute Name | High Vacuum Indicator |
| Logical Rolename | |
| ColumnName | HIGH_VAC_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| High Vacuum Indicator Logical Attribute Properties |
| Logical Attribute Name | High Vacuum Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| High Vacuum Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| High Vacuum Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| High Vacuum Indicator Security Types |
| Name | Current Value |
| High Vacuum Indicator Bound Attachments |
| Name | Current Value |
| High Vacuum Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| High Vacuum Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material High Vacuum Indicator |
NO | ||
| BICS (Oracle) CMPNT_MATL HIGH_VAC_IND |
NO |
| High Vacuum Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Vacuum Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Vacuum Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Vacuum Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Hardness Indicator |
| Base Entity | Component Material |
| Attribute Name | Radiation Hardness Indicator |
| Logical Rolename | |
| ColumnName | RAD_HARD_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Radiation Hardness Indicator Logical Attribute Properties |
| Logical Attribute Name | Radiation Hardness Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Radiation Hardness Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Radiation Hardness Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Radiation Hardness Indicator Security Types |
| Name | Current Value |
| Radiation Hardness Indicator Bound Attachments |
| Name | Current Value |
| Radiation Hardness Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radiation Hardness Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Radiation Hardness Indicator |
NO | ||
| BICS (Oracle) CMPNT_MATL RAD_HARD_IND |
NO |
| Radiation Hardness Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Hardness Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Hardness Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Hardness Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Physical Properites |
| Base Entity | Component Material |
| Attribute Name | Physical Properites |
| Logical Rolename | |
| ColumnName | PHYS_PROP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Physical Properites Logical Attribute Properties |
| Logical Attribute Name | Physical Properites |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Physical Properites Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Physical Properites Security Types |
| Name | Current Value |
| Physical Properites Bound Attachments |
| Name | Current Value |
| Physical Properites Data Movement Rules |
| Name | Type | Rule Text/Value |
| Physical Properites Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Physical Properites |
NO | ||
| BICS (Oracle) CMPNT_MATL PHYS_PROP |
NO |
| Physical Properites Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Physical Properites Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Physical Properites Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Physical Properites Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS URL |
| Base Entity | Component Material |
| Attribute Name | MSDS URL |
| Logical Rolename | |
| ColumnName | MSDS_URL |
| RoleName | |
| Domain | URL |
| Logical Only | NO |
| Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
| Note |
| MSDS URL Logical Attribute Properties |
| Logical Attribute Name | MSDS URL |
| Datatype | VARCHAR(2048) |
| Nullable | YES |
| MSDS URL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MSDS URL Security Types |
| Name | Current Value |
| MSDS URL Bound Attachments |
| Name | Current Value |
| MSDS URL Data Movement Rules |
| Name | Type | Rule Text/Value |
| MSDS URL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material MSDS URL |
NO | ||
| BICS (Oracle) CMPNT_MATL MSDS_URL |
NO |
| MSDS URL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS URL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS URL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS URL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Documentation |
| Base Entity | Component Material |
| 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 Material Justification Documentation |
NO | ||
| BICS (Oracle) CMPNT_MATL 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 |
| Special Handling |
| Base Entity | Component Material |
| Attribute Name | Special Handling |
| Logical Rolename | |
| ColumnName | SPEC_HAND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Special Handling Logical Attribute Properties |
| Logical Attribute Name | Special Handling |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Special Handling Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Special Handling Security Types |
| Name | Current Value |
| Special Handling Bound Attachments |
| Name | Current Value |
| Special Handling Data Movement Rules |
| Name | Type | Rule Text/Value |
| Special Handling Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Special Handling |
NO | ||
| BICS (Oracle) CMPNT_MATL SPEC_HAND |
NO |
| Special Handling Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Handling Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Handling Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Handling Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |