| MSDS recid |
| Base Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | MSDS recid |
| Logical Rolename | |
| ColumnName | MSDS_RECID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | The chemical with which this MSDS is associated |
| Note |
| MSDS recid Logical Attribute Properties |
| Logical Attribute Name | MSDS recid |
| Datatype | VARCHAR(6) |
| Nullable | NO |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | msdsID |
| Logical Rolename | |
| ColumnName | msdsID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Unique identifier for the MSDS |
| Note |
| msdsID Logical Attribute Properties |
| Logical Attribute Name | msdsID |
| Datatype | INTEGER |
| Nullable | NO |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | manufacturerNumber |
| Logical Rolename | |
| ColumnName | manufacturerNumber |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | The manufacturer that provided this MSDS |
| Note |
| manufacturerNumber Logical Attribute Properties |
| Logical Attribute Name | manufacturerNumber |
| Datatype | VARCHAR(6) |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | productName |
| Logical Rolename | |
| ColumnName | productName |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | The product name, if any, directly associated with this MSDS |
| Note |
| productName Logical Attribute Properties |
| Logical Attribute Name | productName |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | productNumber |
| Logical Rolename | |
| ColumnName | productNumber |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | The product number directly associated with this MSDS |
| Note |
| productNumber Logical Attribute Properties |
| Logical Attribute Name | productNumber |
| Datatype | VARCHAR(500) |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | preparationDate |
| Logical Rolename | |
| ColumnName | preparationDate |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | The date that the MSDS was prepared |
| Note |
| preparationDate Logical Attribute Properties |
| Logical Attribute Name | preparationDate |
| Datatype | DATETIME |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | technicalDataModification |
| Logical Rolename | |
| ColumnName | technicalDataModification |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | ***Indicates if modifications were made to the technical data (chemical classification |
| Note |
| technicalDataModification Logical Attribute Properties |
| Logical Attribute Name | technicalDataModification |
| Datatype | BIT |
| Nullable | NO |
| technicalDataModification Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | ((0)) | ||
| Bound Default | DF_MaterialSafetyDataSheets_technicalDataModification |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | fileShare |
| Logical Rolename | |
| ColumnName | fileShare |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | The file share where this MSDS is stored |
| Note |
| fileShare Logical Attribute Properties |
| Logical Attribute Name | fileShare |
| Datatype | NUMERIC(18, 0) |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | rowguid |
| Logical Rolename | |
| ColumnName | rowguid |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| rowguid Logical Attribute Properties |
| Logical Attribute Name | rowguid |
| Datatype | UNIQUEID |
| Nullable | NO |
| rowguid Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | (newid()) | ||
| Bound Default | DF_MaterialSafetyDataSheets_rowguid |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | dateReceived |
| Logical Rolename | |
| ColumnName | dateReceived |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| dateReceived Logical Attribute Properties |
| Logical Attribute Name | dateReceived |
| Datatype | DATETIME |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | changedBy |
| Logical Rolename | |
| ColumnName | changedBy |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| changedBy Logical Attribute Properties |
| Logical Attribute Name | changedBy |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | plantCode |
| Logical Rolename | |
| ColumnName | plantCode |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| plantCode Logical Attribute Properties |
| Logical Attribute Name | plantCode |
| Datatype | CHAR(1) |
| Nullable | YES |
| 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 Entity | HMMIS Material Safety Data Sheet |
| Attribute Name | currentAsOfDate |
| Logical Rolename | |
| ColumnName | currentAsOfDate |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| currentAsOfDate Logical Attribute Properties |
| Logical Attribute Name | currentAsOfDate |
| Datatype | DATETIME |
| Nullable | YES |
| 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 |