Chemical recId |
Base Entity | HMMIS Chemical |
Attribute Name | Chemical recId |
Logical Rolename | |
ColumnName | CHEM_RECID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | The record ID for the chemical - uniquely identifies the entry |
Note |
Chemical recId Logical Attribute Properties |
Logical Attribute Name | Chemical recId |
Datatype | VARCHAR(6) |
Nullable | NO |
Chemical recId Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Chemical recId Security Types |
Name | Current Value |
Chemical recId Bound Attachments |
Name | Current Value |
Chemical recId Data Movement Rules |
Name | Type | Rule Text/Value |
Chemical recId Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical Chemical recId |
NO | ||
SMPL (Oracle) HMMIS_CHEM CHEM_RECID |
NO |
Chemical recId Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Chemical recId Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Chemical recId Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Chemical recId Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
primaryName |
Base Entity | HMMIS Chemical |
Attribute Name | primaryName |
Logical Rolename | |
ColumnName | primaryName |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Primary or official name of the chemical |
Note |
primaryName Logical Attribute Properties |
Logical Attribute Name | primaryName |
Datatype | VARCHAR(80) |
Nullable | NO |
primaryName Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
primaryName Security Types |
Name | Current Value |
primaryName Bound Attachments |
Name | Current Value |
primaryName Data Movement Rules |
Name | Type | Rule Text/Value |
primaryName Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical primaryName |
NO | ||
SMPL (Oracle) HMMIS_CHEM primaryName |
NO |
primaryName Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
primaryName Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
primaryName Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
primaryName Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
casNumber |
Base Entity | HMMIS Chemical |
Attribute Name | casNumber |
Logical Rolename | |
ColumnName | casNumber |
RoleName | |
Domain | |
Logical Only | NO |
Definition | CAS number |
Note |
casNumber Logical Attribute Properties |
Logical Attribute Name | casNumber |
Datatype | VARCHAR(50) |
Nullable | YES |
casNumber Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
casNumber Security Types |
Name | Current Value |
casNumber Bound Attachments |
Name | Current Value |
casNumber Data Movement Rules |
Name | Type | Rule Text/Value |
casNumber Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical casNumber |
NO | ||
SMPL (Oracle) HMMIS_CHEM casNumber |
NO |
casNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
casNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
casNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
casNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
pure |
Base Entity | HMMIS Chemical |
Attribute Name | pure |
Logical Rolename | |
ColumnName | pure |
RoleName | |
Domain | |
Logical Only | NO |
Definition | ***Indicates that the chemical is pure (not a mixture) |
Note |
pure Logical Attribute Properties |
Logical Attribute Name | pure |
Datatype | BIT |
Nullable | NO |
pure Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | ((0)) | ||
Bound Default | DF_Chemicals_pure |
pure Security Types |
Name | Current Value |
pure Bound Attachments |
Name | Current Value |
pure Data Movement Rules |
Name | Type | Rule Text/Value |
pure Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical pure |
NO | ||
SMPL (Oracle) HMMIS_CHEM pure |
NO |
pure Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
pure Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
pure Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
pure Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
carcinogen |
Base Entity | HMMIS Chemical |
Attribute Name | carcinogen |
Logical Rolename | |
ColumnName | carcinogen |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Indicates that the chemical is a carcinogen |
Note |
carcinogen Logical Attribute Properties |
Logical Attribute Name | carcinogen |
Datatype | BIT |
Nullable | NO |
carcinogen Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | ((0)) | ||
Bound Default | DF_Chemicals_carcinogen |
carcinogen Security Types |
Name | Current Value |
carcinogen Bound Attachments |
Name | Current Value |
carcinogen Data Movement Rules |
Name | Type | Rule Text/Value |
carcinogen Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical carcinogen |
NO | ||
SMPL (Oracle) HMMIS_CHEM carcinogen |
NO |
carcinogen Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
carcinogen Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
carcinogen Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
carcinogen Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
specialCondition |
Base Entity | HMMIS Chemical |
Attribute Name | specialCondition |
Logical Rolename | |
ColumnName | specialCondition |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Indicates that the chemical represents a special condition as defined by ORNL |
Note |
specialCondition Logical Attribute Properties |
Logical Attribute Name | specialCondition |
Datatype | BIT |
Nullable | NO |
specialCondition Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | ((0)) | ||
Bound Default | DF_Chemicals_specialCondition |
specialCondition Security Types |
Name | Current Value |
specialCondition Bound Attachments |
Name | Current Value |
specialCondition Data Movement Rules |
Name | Type | Rule Text/Value |
specialCondition Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical specialCondition |
NO | ||
SMPL (Oracle) HMMIS_CHEM specialCondition |
NO |
specialCondition Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
specialCondition Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
specialCondition Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
specialCondition Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLife |
Base Entity | HMMIS Chemical |
Attribute Name | shelfLife |
Logical Rolename | |
ColumnName | shelfLife |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Lists the default shelf life of the chemical (if any) |
Note |
shelfLife Logical Attribute Properties |
Logical Attribute Name | shelfLife |
Datatype | INTEGER |
Nullable | YES |
shelfLife Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
shelfLife Security Types |
Name | Current Value |
shelfLife Bound Attachments |
Name | Current Value |
shelfLife Data Movement Rules |
Name | Type | Rule Text/Value |
shelfLife Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical shelfLife |
NO | ||
SMPL (Oracle) HMMIS_CHEM shelfLife |
NO |
shelfLife Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLife Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLife Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLife Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLifeComments |
Base Entity | HMMIS Chemical |
Attribute Name | shelfLifeComments |
Logical Rolename | |
ColumnName | shelfLifeComments |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Comments about the shelf life. Often used to explain the value provided in the shelfLife field (i.e. units) |
Note |
shelfLifeComments Logical Attribute Properties |
Logical Attribute Name | shelfLifeComments |
Datatype | VARCHAR(255) |
Nullable | YES |
shelfLifeComments Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
shelfLifeComments Security Types |
Name | Current Value |
shelfLifeComments Bound Attachments |
Name | Current Value |
shelfLifeComments Data Movement Rules |
Name | Type | Rule Text/Value |
shelfLifeComments Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical shelfLifeComments |
NO | ||
SMPL (Oracle) HMMIS_CHEM shelfLifeComments |
NO |
shelfLifeComments Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLifeComments Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLifeComments Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
shelfLifeComments Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
trackInventory |
Base Entity | HMMIS Chemical |
Attribute Name | trackInventory |
Logical Rolename | |
ColumnName | trackInventory |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Indicates that inventory is to be tracked for this chemical |
Note |
trackInventory Logical Attribute Properties |
Logical Attribute Name | trackInventory |
Datatype | BIT |
Nullable | NO |
trackInventory Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | ((1)) | ||
Bound Default | DF_Chemicals_trackInventory |
trackInventory Security Types |
Name | Current Value |
trackInventory Bound Attachments |
Name | Current Value |
trackInventory Data Movement Rules |
Name | Type | Rule Text/Value |
trackInventory Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical trackInventory |
NO | ||
SMPL (Oracle) HMMIS_CHEM trackInventory |
NO |
trackInventory Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
trackInventory Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
trackInventory Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
trackInventory Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
sortableName |
Base Entity | HMMIS Chemical |
Attribute Name | sortableName |
Logical Rolename | |
ColumnName | sortableName |
RoleName | |
Domain | |
Logical Only | NO |
Definition | A sortable/comparable name for the chemical. Similar to primaryName however without spaces or any special characters |
Note |
sortableName Logical Attribute Properties |
Logical Attribute Name | sortableName |
Datatype | VARCHAR(80) |
Nullable | YES |
sortableName Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
sortableName Security Types |
Name | Current Value |
sortableName Bound Attachments |
Name | Current Value |
sortableName Data Movement Rules |
Name | Type | Rule Text/Value |
sortableName Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical sortableName |
NO | ||
SMPL (Oracle) HMMIS_CHEM sortableName |
NO |
sortableName Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
sortableName Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
sortableName Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
sortableName Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
rtecsNumber |
Base Entity | HMMIS Chemical |
Attribute Name | rtecsNumber |
Logical Rolename | |
ColumnName | rtecsNumber |
RoleName | |
Domain | |
Logical Only | NO |
Definition | RTECS number |
Note |
rtecsNumber Logical Attribute Properties |
Logical Attribute Name | rtecsNumber |
Datatype | VARCHAR(50) |
Nullable | YES |
rtecsNumber Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
rtecsNumber Security Types |
Name | Current Value |
rtecsNumber Bound Attachments |
Name | Current Value |
rtecsNumber Data Movement Rules |
Name | Type | Rule Text/Value |
rtecsNumber Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical rtecsNumber |
NO | ||
SMPL (Oracle) HMMIS_CHEM rtecsNumber |
NO |
rtecsNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
rtecsNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
rtecsNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
rtecsNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
rowguid |
Base Entity | HMMIS Chemical |
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_Chemicals_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 Chemical rowguid |
NO | ||
SMPL (Oracle) HMMIS_CHEM 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 |
hideFromQueries |
Base Entity | HMMIS Chemical |
Attribute Name | hideFromQueries |
Logical Rolename | |
ColumnName | hideFromQueries |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
hideFromQueries Logical Attribute Properties |
Logical Attribute Name | hideFromQueries |
Datatype | BIT |
Nullable | NO |
hideFromQueries Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | ((0)) | ||
Bound Default | DF_Chemicals_hideFromQueries |
hideFromQueries Security Types |
Name | Current Value |
hideFromQueries Bound Attachments |
Name | Current Value |
hideFromQueries Data Movement Rules |
Name | Type | Rule Text/Value |
hideFromQueries Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical hideFromQueries |
NO | ||
SMPL (Oracle) HMMIS_CHEM hideFromQueries |
NO |
hideFromQueries Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
hideFromQueries Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
hideFromQueries Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
hideFromQueries Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
flammability |
Base Entity | HMMIS Chemical |
Attribute Name | flammability |
Logical Rolename | |
ColumnName | flammability |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
flammability Logical Attribute Properties |
Logical Attribute Name | flammability |
Datatype | VARCHAR(2) |
Nullable | YES |
flammability Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
flammability Security Types |
Name | Current Value |
flammability Bound Attachments |
Name | Current Value |
flammability Data Movement Rules |
Name | Type | Rule Text/Value |
flammability Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical flammability |
NO | ||
SMPL (Oracle) HMMIS_CHEM flammability |
NO |
flammability Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
flammability Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
flammability Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
flammability Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
epaGroup |
Base Entity | HMMIS Chemical |
Attribute Name | epaGroup |
Logical Rolename | |
ColumnName | epaGroup |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
epaGroup Logical Attribute Properties |
Logical Attribute Name | epaGroup |
Datatype | CHAR(1) |
Nullable | YES |
epaGroup Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
epaGroup Security Types |
Name | Current Value |
epaGroup Bound Attachments |
Name | Current Value |
epaGroup Data Movement Rules |
Name | Type | Rule Text/Value |
epaGroup Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical epaGroup |
NO | ||
SMPL (Oracle) HMMIS_CHEM epaGroup |
NO |
epaGroup Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
epaGroup Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
epaGroup Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
epaGroup Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
classificationsCompleted |
Base Entity | HMMIS Chemical |
Attribute Name | classificationsCompleted |
Logical Rolename | |
ColumnName | classificationsCompleted |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
classificationsCompleted Logical Attribute Properties |
Logical Attribute Name | classificationsCompleted |
Datatype | BIT |
Nullable | NO |
classificationsCompleted Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
classificationsCompleted Security Types |
Name | Current Value |
classificationsCompleted Bound Attachments |
Name | Current Value |
classificationsCompleted Data Movement Rules |
Name | Type | Rule Text/Value |
classificationsCompleted Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical classificationsCompleted |
NO | ||
SMPL (Oracle) HMMIS_CHEM classificationsCompleted |
NO |
classificationsCompleted Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
classificationsCompleted Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
classificationsCompleted Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
classificationsCompleted Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
mistFormOnly |
Base Entity | HMMIS Chemical |
Attribute Name | mistFormOnly |
Logical Rolename | |
ColumnName | mistFormOnly |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
mistFormOnly Logical Attribute Properties |
Logical Attribute Name | mistFormOnly |
Datatype | BIT |
Nullable | NO |
mistFormOnly Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | ((0)) | ||
Bound Default | DF__Chemicals__mistF__22427747 |
mistFormOnly Security Types |
Name | Current Value |
mistFormOnly Bound Attachments |
Name | Current Value |
mistFormOnly Data Movement Rules |
Name | Type | Rule Text/Value |
mistFormOnly Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical mistFormOnly |
NO | ||
SMPL (Oracle) HMMIS_CHEM mistFormOnly |
NO |
mistFormOnly Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
mistFormOnly Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
mistFormOnly Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
mistFormOnly Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
status |
Base Entity | HMMIS Chemical |
Attribute Name | status |
Logical Rolename | |
ColumnName | status |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
status Logical Attribute Properties |
Logical Attribute Name | status |
Datatype | CHAR(1) |
Nullable | YES |
status Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
status Security Types |
Name | Current Value |
status Bound Attachments |
Name | Current Value |
status Data Movement Rules |
Name | Type | Rule Text/Value |
status Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical HMMIS Chemical status |
NO | ||
SMPL (Oracle) HMMIS_CHEM status |
NO |
status Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
status Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
status Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
status Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |