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