| MSDS_RECID |
| Base Object | HMMIS_MSDS |
| Attribute Name | MSDS recid |
| ColumnName | MSDS_RECID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | The chemical with which this MSDS is associated |
| Note |
| MSDS_RECID Column Properties |
| Datatype | VARCHAR2(6) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MSDS_RECID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| MSDS_RECID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MSDS_RECID Security Types |
| Name | Current Value |
| MSDS_RECID Bound Attachments |
| Name | Current Value |
| MSDS_RECID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MSDS_RECID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet MSDS recid |
NO | ||
| SMPL (Oracle) HMMIS_MSDS MSDS_RECID |
NO |
| MSDS_RECID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS_RECID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS_RECID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MSDS_RECID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| msdsID |
| Base Object | HMMIS_MSDS |
| Attribute Name | msdsID |
| ColumnName | msdsID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Unique identifier for the MSDS |
| Note |
| msdsID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| msdsID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| msdsID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| msdsID Security Types |
| Name | Current Value |
| msdsID Bound Attachments |
| Name | Current Value |
| msdsID Data Movement Rules |
| Name | Type | Rule Text/Value |
| msdsID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet msdsID |
NO | ||
| SMPL (Oracle) HMMIS_MSDS msdsID |
NO |
| msdsID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| msdsID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| msdsID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| msdsID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| manufacturerNumber |
| Base Object | HMMIS_MSDS |
| Attribute Name | manufacturerNumber |
| ColumnName | manufacturerNumber |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | The manufacturer that provided this MSDS |
| Note |
| manufacturerNumber Column Properties |
| Datatype | VARCHAR2(6) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| manufacturerNumber Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| manufacturerNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| manufacturerNumber Security Types |
| Name | Current Value |
| manufacturerNumber Bound Attachments |
| Name | Current Value |
| manufacturerNumber Data Movement Rules |
| Name | Type | Rule Text/Value |
| manufacturerNumber Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet manufacturerNumber |
NO | ||
| SMPL (Oracle) HMMIS_MSDS manufacturerNumber |
NO |
| manufacturerNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| manufacturerNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| manufacturerNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| manufacturerNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| productName |
| Base Object | HMMIS_MSDS |
| Attribute Name | productName |
| ColumnName | productName |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | The product name, if any, directly associated with this MSDS |
| Note |
| productName Column Properties |
| Datatype | VARCHAR2(256) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| productName Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 256 |
| Percent Null | 0 |
| productName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| productName Security Types |
| Name | Current Value |
| productName Bound Attachments |
| Name | Current Value |
| productName Data Movement Rules |
| Name | Type | Rule Text/Value |
| productName Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet productName |
NO | ||
| SMPL (Oracle) HMMIS_MSDS productName |
NO |
| productName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| productName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| productName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| productName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| productNumber |
| Base Object | HMMIS_MSDS |
| Attribute Name | productNumber |
| ColumnName | productNumber |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | The product number directly associated with this MSDS |
| Note |
| productNumber Column Properties |
| Datatype | VARCHAR2(500) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| productNumber Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 500 |
| Percent Null | 0 |
| productNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| productNumber Security Types |
| Name | Current Value |
| productNumber Bound Attachments |
| Name | Current Value |
| productNumber Data Movement Rules |
| Name | Type | Rule Text/Value |
| productNumber Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet productNumber |
NO | ||
| SMPL (Oracle) HMMIS_MSDS productNumber |
NO |
| productNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| productNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| productNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| productNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| preparationDate |
| Base Object | HMMIS_MSDS |
| Attribute Name | preparationDate |
| ColumnName | preparationDate |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | The date that the MSDS was prepared |
| Note |
| preparationDate Column Properties |
| Datatype | TIMESTAMP(6) |
| Nullable | YES |
| Not Null Constraint | |
| Time Zone | NO |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| preparationDate Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| preparationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| preparationDate Security Types |
| Name | Current Value |
| preparationDate Bound Attachments |
| Name | Current Value |
| preparationDate Data Movement Rules |
| Name | Type | Rule Text/Value |
| preparationDate Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet preparationDate |
NO | ||
| SMPL (Oracle) HMMIS_MSDS preparationDate |
NO |
| preparationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| preparationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| preparationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| preparationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| technicalDataModification |
| Base Object | HMMIS_MSDS |
| Attribute Name | technicalDataModification |
| ColumnName | technicalDataModification |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | ***Indicates if modifications were made to the technical data (chemical classification |
| Note |
| technicalDataModification Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| technicalDataModification Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| technicalDataModification Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | ((0)) |
| Bound Default |
| technicalDataModification Security Types |
| Name | Current Value |
| technicalDataModification Bound Attachments |
| Name | Current Value |
| technicalDataModification Data Movement Rules |
| Name | Type | Rule Text/Value |
| technicalDataModification Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet technicalDataModification |
NO | ||
| SMPL (Oracle) HMMIS_MSDS technicalDataModification |
NO |
| technicalDataModification Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| technicalDataModification Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| technicalDataModification Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| technicalDataModification Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| fileShare |
| Base Object | HMMIS_MSDS |
| Attribute Name | fileShare |
| ColumnName | fileShare |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | The file share where this MSDS is stored |
| Note |
| fileShare Column Properties |
| Datatype | NUMBER(18, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| fileShare Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| fileShare Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| fileShare Security Types |
| Name | Current Value |
| fileShare Bound Attachments |
| Name | Current Value |
| fileShare Data Movement Rules |
| Name | Type | Rule Text/Value |
| fileShare Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet fileShare |
NO | ||
| SMPL (Oracle) HMMIS_MSDS fileShare |
NO |
| fileShare Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| fileShare Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| fileShare Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| fileShare Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid |
| Base Object | HMMIS_MSDS |
| Attribute Name | rowguid |
| ColumnName | rowguid |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| rowguid Column Properties |
| Datatype | RAW(16) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| rowguid Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 16 |
| Percent Null | 0 |
| rowguid Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | (newid()) |
| Bound Default |
| rowguid Security Types |
| Name | Current Value |
| rowguid Bound Attachments |
| Name | Current Value |
| rowguid Data Movement Rules |
| Name | Type | Rule Text/Value |
| rowguid Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet rowguid |
NO | ||
| SMPL (Oracle) HMMIS_MSDS rowguid |
NO |
| rowguid Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| dateReceived |
| Base Object | HMMIS_MSDS |
| Attribute Name | dateReceived |
| ColumnName | dateReceived |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| dateReceived Column Properties |
| Datatype | TIMESTAMP(6) |
| Nullable | YES |
| Not Null Constraint | |
| Time Zone | NO |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| dateReceived Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| dateReceived Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| dateReceived Security Types |
| Name | Current Value |
| dateReceived Bound Attachments |
| Name | Current Value |
| dateReceived Data Movement Rules |
| Name | Type | Rule Text/Value |
| dateReceived Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet dateReceived |
NO | ||
| SMPL (Oracle) HMMIS_MSDS dateReceived |
NO |
| dateReceived Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| dateReceived Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| dateReceived Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| dateReceived Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| changedBy |
| Base Object | HMMIS_MSDS |
| Attribute Name | changedBy |
| ColumnName | changedBy |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| changedBy Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| changedBy Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| changedBy Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| changedBy Security Types |
| Name | Current Value |
| changedBy Bound Attachments |
| Name | Current Value |
| changedBy Data Movement Rules |
| Name | Type | Rule Text/Value |
| changedBy Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet changedBy |
NO | ||
| SMPL (Oracle) HMMIS_MSDS changedBy |
NO |
| changedBy Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| changedBy Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| changedBy Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| changedBy Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| plantCode |
| Base Object | HMMIS_MSDS |
| Attribute Name | plantCode |
| ColumnName | plantCode |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| plantCode Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| plantCode Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| plantCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| plantCode Security Types |
| Name | Current Value |
| plantCode Bound Attachments |
| Name | Current Value |
| plantCode Data Movement Rules |
| Name | Type | Rule Text/Value |
| plantCode Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet plantCode |
NO | ||
| SMPL (Oracle) HMMIS_MSDS plantCode |
NO |
| plantCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| plantCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| plantCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| plantCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| currentAsOfDate |
| Base Object | HMMIS_MSDS |
| Attribute Name | currentAsOfDate |
| ColumnName | currentAsOfDate |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| currentAsOfDate Column Properties |
| Datatype | TIMESTAMP(6) |
| Nullable | YES |
| Not Null Constraint | |
| Time Zone | NO |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| currentAsOfDate Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| currentAsOfDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| currentAsOfDate Security Types |
| Name | Current Value |
| currentAsOfDate Bound Attachments |
| Name | Current Value |
| currentAsOfDate Data Movement Rules |
| Name | Type | Rule Text/Value |
| currentAsOfDate Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Material Safety Data Sheet currentAsOfDate |
NO | ||
| SMPL (Oracle) HMMIS_MSDS currentAsOfDate |
NO |
| currentAsOfDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| currentAsOfDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| currentAsOfDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| currentAsOfDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |