| MATL_ID |
| Base Object | CMPNT_MATL |
| Attribute Name | Material Identifier |
| ColumnName | MATL_ID |
| Logical Rolename | |
| 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 Material Identifier |
NO | ||
| BICS (Oracle) CMPNT_MATL 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 |
| DESCR |
| Base Object | CMPNT_MATL |
| 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 Material Description |
NO | ||
| BICS (Oracle) CMPNT_MATL 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_TYPE_ID |
| Base Object | CMPNT_MATL |
| Attribute Name | Material Type Identifier |
| ColumnName | MATL_TYPE_ID |
| Logical Rolename | Material Type Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| MATL_TYPE_ID Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MATL_TYPE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| MATL_TYPE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MATL_TYPE_ID Security Types |
| Name | Current Value |
| MATL_TYPE_ID Bound Attachments |
| Name | Current Value |
| MATL_TYPE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MATL_TYPE_ID 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 |
| MATL_TYPE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MATL_TYPE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MATL_TYPE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MATL_TYPE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MATL_STAT_ID |
| Base Object | CMPNT_MATL |
| Attribute Name | Material Status Identifier |
| ColumnName | MATL_STAT_ID |
| Logical Rolename | Material Status Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| MATL_STAT_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MATL_STAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| MATL_STAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MATL_STAT_ID Security Types |
| Name | Current Value |
| MATL_STAT_ID Bound Attachments |
| Name | Current Value |
| MATL_STAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MATL_STAT_ID 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 |
| MATL_STAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MATL_STAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MATL_STAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MATL_STAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HIGH_VAC_IND |
| Base Object | CMPNT_MATL |
| Attribute Name | High Vacuum Indicator |
| ColumnName | HIGH_VAC_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| HIGH_VAC_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HIGH_VAC_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| HIGH_VAC_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| HIGH_VAC_IND 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_VAC_IND Security Types |
| Name | Current Value |
| HIGH_VAC_IND Bound Attachments |
| Name | Current Value |
| HIGH_VAC_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| HIGH_VAC_IND 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_VAC_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HIGH_VAC_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HIGH_VAC_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HIGH_VAC_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_HARD_IND |
| Base Object | CMPNT_MATL |
| Attribute Name | Radiation Hardness Indicator |
| ColumnName | RAD_HARD_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| RAD_HARD_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_HARD_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| RAD_HARD_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| RAD_HARD_IND 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 |
| RAD_HARD_IND Security Types |
| Name | Current Value |
| RAD_HARD_IND Bound Attachments |
| Name | Current Value |
| RAD_HARD_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_HARD_IND 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 |
| RAD_HARD_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_HARD_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_HARD_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_HARD_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHYS_PROP |
| Base Object | CMPNT_MATL |
| Attribute Name | Physical Properites |
| ColumnName | PHYS_PROP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PHYS_PROP Column Properties |
| Datatype | BLOB |
| Nullable | YES |
| Not Null Constraint |
| PHYS_PROP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| PHYS_PROP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PHYS_PROP Security Types |
| Name | Current Value |
| PHYS_PROP Bound Attachments |
| Name | Current Value |
| PHYS_PROP Data Movement Rules |
| Name | Type | Rule Text/Value |
| PHYS_PROP Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Physical Properites |
NO | ||
| BICS (Oracle) CMPNT_MATL PHYS_PROP |
NO |
| PHYS_PROP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHYS_PROP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHYS_PROP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHYS_PROP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS_URL |
| Base Object | CMPNT_MATL |
| Attribute Name | MSDS URL |
| ColumnName | MSDS_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 |
| MSDS_URL Column Properties |
| Datatype | VARCHAR2(2048) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MSDS_URL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| 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 |
| JUST_DOC |
| Base Object | CMPNT_MATL |
| 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 Material Justification Documentation |
NO | ||
| BICS (Oracle) CMPNT_MATL 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 |
| SPEC_HAND |
| Base Object | CMPNT_MATL |
| Attribute Name | Special Handling |
| ColumnName | SPEC_HAND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SPEC_HAND Column Properties |
| Datatype | BLOB |
| Nullable | YES |
| Not Null Constraint |
| SPEC_HAND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| SPEC_HAND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SPEC_HAND Security Types |
| Name | Current Value |
| SPEC_HAND Bound Attachments |
| Name | Current Value |
| SPEC_HAND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SPEC_HAND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Component Material Special Handling |
NO | ||
| BICS (Oracle) CMPNT_MATL SPEC_HAND |
NO |
| SPEC_HAND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_HAND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_HAND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_HAND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |