Contains a list of all of the chemicals in the HMMS system

HMMIS Chemical Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Chemical recId		VARCHAR(6)	NO	The record ID for the chemical - uniquely identifies the entry
primaryName		VARCHAR(80)	NO	Primary or official name of the chemical
casNumber		VARCHAR(50)	YES	CAS number
pure		BIT	NO	***Indicates that the chemical is pure (not a mixture)
carcinogen		BIT	NO	Indicates that the chemical is a carcinogen
specialCondition		BIT	NO	Indicates that the chemical represents a special condition as defined by ORNL
shelfLife		INTEGER	YES	Lists the default shelf life of the chemical (if any)
shelfLifeComments		VARCHAR(255)	YES	Comments about the shelf life. Often used to explain the value provided in the shelfLife field (i.e. units)
trackInventory		BIT	NO	Indicates that inventory is to be tracked for this chemical
sortableName		VARCHAR(80)	YES	A sortable/comparable name for the chemical. Similar to primaryName however without spaces or any special characters
rtecsNumber		VARCHAR(50)	YES	RTECS number
rowguid		UNIQUEID	NO
hideFromQueries		BIT	NO
flammability		VARCHAR(2)	YES
epaGroup		CHAR(1)	YES
classificationsCompleted		BIT	NO
mistFormOnly		BIT	NO
status		CHAR(1)	YES

HMMIS Chemical Keys

Key Name	Key Type	Keys
PK_CHEMICAL	PrimaryKey	Chemical recId

HMMIS Chemical Relationships

Parent Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Sample Classification	Non-Identifying	Zero or One to Zero or More					NO

HMMIS Chemical Check Constraints

Check Constraint Name

CheckConstraint

HMMIS Chemical Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

HMMIS Chemical Security Types

Name	Current Value

HMMIS Chemical Bound Attachments

Name	Current Value

HMMIS Chemical Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical SMPL.HMMIS Chemical	NO
ALARM_MYSQL (MySQL) Does Not Exist	NO
ALARM_ORACLE (Oracle) Does Not Exist	NO
BICS (Oracle) Does Not Exist	NO
BLM (Oracle) Does Not Exist	NO
BYPASS_REQ (Oracle) Does Not Exist	NO
CHAN_ARCH (Oracle) Does Not Exist	NO
CNMS_PRPSL (Oracle) Does Not Exist	NO
DIAG (Oracle) Does Not Exist	NO
DIAG_MPS (Oracle) Does Not Exist	NO
ENGA (Oracle) Does Not Exist	NO
EPICS (Oracle) Does Not Exist	NO
EQUIP (Oracle) Does Not Exist	NO
EXPRESS (Oracle) Does Not Exist	NO
ICS_SFTW_APPL (Oracle) Does Not Exist	NO
INSTR (Oracle) Does Not Exist	NO
Instrument Logbook (Oracle) Does Not Exist	NO
INVT (Oracle) Does Not Exist	NO
IONSRC (Oracle) Does Not Exist	NO
IONSRC1 (Oracle) Does Not Exist	NO
IPTSv5 (Oracle) Does Not Exist	NO
IRMISBase (Oracle) Does Not Exist	NO
Logbook (Oracle) Does Not Exist	NO
Magnet (Oracle) Does Not Exist	NO
MPS (Oracle) Does Not Exist	NO
NS_OPER (Oracle) Does Not Exist	NO
OPER (Oracle) Does Not Exist	NO
PART (Oracle) Does Not Exist	NO
PRINT (Oracle) Does Not Exist	NO
PROC (Oracle) Does Not Exist	NO
PRPSL (Oracle) Does Not Exist	NO
PUBL (Oracle) Does Not Exist	NO
PUBL_V1 (Oracle) Does Not Exist	NO
PV_LOGGER (Oracle) Does Not Exist	NO
SCORE (Oracle) Does Not Exist	NO
SICAT (Oracle) Does Not Exist	NO
SMPL (Oracle) SMPL.HMMIS_CHEM	NO
SMPLACT (Oracle) Does Not Exist	NO
SURVEY (Oracle) Does Not Exist	NO
Watchman (Oracle) Does Not Exist	NO
XAL_OPTICS (Oracle) Does Not Exist	NO
XF_ADMIN (Oracle) Does Not Exist	NO

HMMIS Chemical Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Sample
SMPL (Oracle)	Main Model

HMMIS Chemical Data Movement Rules

Name

Type

Rule Text/Value