Jump to main content.

EF/EMCI Logo Entity & Attribute Information

The EMCI entity types (database tables) are organized into three subject areas:

Blue Triangle Chemicals: Consists of all entity types that contain data related to EPA chemicals.

Blue Triangle Program Office Systems: Consists of reference tables containing identification data about the EPA program office systems that contain environmental data.

Blue Triangle EPA Organization: Consists of an entity that contains identification data about EPA offices.

Relational Structure

The tables in the Chemicals subject area are linked by the EMCI internal reference number (EMCIRN), which is the same number as the CAS Registry Number (CASRN) where the CASRN has been identified. The Chemical Substance table (CHEM_SUBST) is the master list of unique substances contained in EMCI. The Substance Relationship table type (SUBST_REL) provides a linkage among chemicals contained in a group, such as a category or mixture. The System Chemical table (SYS_CHEM) identifies chemicals contained in program office systems by their EMCIRN. SYS_CHEM also identifies the Envirofacts program system components that contain data for a given chemical and the identifier used by the component for that chemical substance.

The Program Systems table (PRGM_SYS) is a reference table that identifies the program office systems referenced in SYS_CHEM by SYS_CODE.

The EPA Office table (EPA_OFFICE) is a reference table that identifies the EPA office that manages a program office system referenced by OFF_ACRN in PRGM_SYS.

Environmental data, based on chemical identity are obtained by linking the SYS_CHEMID for the desired chemical and system with the following entities and attributes: 


	System	Entity			Attribute

	PCS	DMR_MEASUREMENT		PARAMETER_CODE
		EFFLUENT_LIMIT		PARAMETER_CODE

	TRIS	TRI_CHEM_REPORT		TRI_CHEM_ID
		TRI_CHEM_WASTE		TRI_CHEM_ID
		TRI_CHEM_INFO		CAS_NUM

	RCRIS	RCRIS_WASTE		WASTE_CODE

Data for EF AIR/AFS may be obtained from the POLLUTANT_CODE and/or
CAS_NUM, and EMCIRN attributes in the following entities:

		AFS_PLANT_PLLT
		AFS_AIR_PGM_PLLT
		AFS_AIRPGMPLT_CMPL
		AFS_AIRPGMPLT_CLSS
		AFS_AIRPGMPLT_ATNM
		AFS_PLANT_ACTION
		AFS_VIOL_POLLUTANT
		AFS_POINT_PLLT
		AFS_POINT_AIR_PGM
		AFS_POINT_ACTION
		AFS_PNT_VIOL_POLL
		AFS_PLLT_CHEMICAL
		AFS_SEGMENT_PLLT_1
		AFS_SEGMENT_PLLT_2
		AFS_SEGPLT_CTL_EQP
		AFS_STACK_PLLT

Local Navigation

Jump to main content.