Table Name: CER_SITE

Description: A geographic area where hazardous waste is either abandoned or uncontrolled, as mandated and defined by the Comprehensive Energency Response, Compensation, and Liability Act (CERCLA).

Relationships:

May be associated with one or more CER_SITE_ALIAS related by column SITE_ID
May be divided into one or more CER_OPERABLE_UNIT related by column SITE_ID
May be associated with one or more CER_ACTION related by column SITE_ID
May consist of one or more CER_WST_SRC_MEDIA_CONTAMINATED related by column SITE_ID
May have incident type classified by one and only one CER_REF_SITE_INCIDENT_TYPE related by column RSIT_CODE
May have ownership classified by one and only one CER_REF_OWNERSHIP_TYPE related by column ROT_CODE.
May have NPL status described by one and only one CER_REF_NPL_STATUS related by column RNPL_STATUS_CODE
Must have federal facility status described by one and only one CER_REF_FEDERAL_FACILITY related by column RFED_FCLTY_CODE
Must be located in one and only one CER_REF_STATE related by column RSTATE_CODE
Must be located in one and only one CER_REF_REGION related by column RREGION_CODE
May be associated with one or more CER_CONTACT related by column SITE_ID
May be listed by one and only one CER_FEDERAL_REGISTER related by column SITE_ID
May be described by one or more CER_CMT_SITE related by column SITE_ID
May be characterized by one or more CER_SITE_CHARACTERISTIC related by column SITE_ID
May be geographically located by one or more CER_LOCATION related by column SITE_EPA_ID

Columns:

Definition Source: CERCLIS 3 Relational Data Model, March 1998

Return To:

Table Name: CER_SITE

Local Navigation