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
- ACT_ACTL_CMPLTN_DATE
- ACT_ACTL_STRT_DATE
- ACT_CODE_ID
- ACT_CURR_PLN_CMPLTN_DATE
- ACT_CURR_PLN_CMPLTN_FYQ
- ACT_CURR_PLN_STRT_DATE
- ACT_CURR_PLN_STRT_FYQ
- OU_ID
- RAA_CODE
- RACT_CRITICAL_FLAG_CODE
- RALT_CODE
- RAQ_ACTION_QUAL_CODE
- RAT_CODE
- RPS_CODE
- SITE_ID
Return To:
![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif)