Table Name: RCR_EVENT_AUTHORITY
Description: Identifies associations between corrective action events and authorities.
Relationships:
- Always is linked with one RCR_CA_EVENT related by columns EVENT_ID (=HANDLER_ID), EVENT_OWN (=OWNER), EVENT_CODE (=CA_EVENT_CODE), EVENT_SEQ, EVENT_AGENCY (=RESPONSIBLE_AGENCY), and EVENT_LOCATION (=ACTIVITY_LOCATION).
- Sometimes is linked by one or more RCR_CA_AUTHORITY related by columns AUTHORITY_ID (=HANDLER_ID), AUTHORITY_OWN (=OWNER), AUTHORITY_TYPE, EFFECTIVE _DATE, AUTHORITY_AGENCY (=RESPONSIBLE_AGENCY), and AUTHORITY_LOCATION (=ACTIVITY_LOCATION).
- AUTHORITY_AGENCY
- AUTHORITY_ID
- AUTHORITY_LOCATION
- AUTHORITY_OWN
- AUTHORITY_TYPE
- EFFECTIVE_DATE
- EVENT_AGENCY
- EVENT_CODE
- EVENT_ID
- EVENT_LOCATION
- EVENT_OWN
- EVENT_SEQ
Return To:
![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif)