Table Name: CER_ACTION

Description: The enforcement and cleanup actions taken by EPA at a site.

Relationships:

Must be performed for one and only one CER_SITE related by column SITE_ID
May refer to one and only one CER_OPERABLE_UNIT related by columns SITE_ID, OU_ID
May incur one or more CER_FINANCIAL_TRANSACTION related by columns SITE_ID, RAT_CODE, ACT_CODE_ID
May have planning status defined by one and only one CER_REF_PLANNING_STATUS related by column RPS_CODE
Must be described by one and only one CER_REF_ACTION_TYPE related by column RAT_CODE
May be qualified by one and only one CER_REF_ACTION_QUALIFIER related by column RAQ_ACTION_QUAL_CODE
May have urgency indicated by one and only one CER_REF_ACTION_CRITICAL_FLAG related by column RACT_CRITICAL_FLAG_CODE
May be the responsibility of one and only one CER_REF_ACTION_LEAD_TYPE related by RALT_CODE
May have anomalies defined by one and only one CER_REF_ACTION_ANOMALY related by column RAA_CODE

Columns:

Definition Source: CERCLIS 3 Relational Data Model, March 1998

Return To: