Table Name: RCR_CA_EVENT

Description: Activities associated with a corrective action.

Relationships:

Always is established by one RCR_HBASIC related by column HANDLER_ID.
Sometimes links one or more RCR_EVENT_AUTHORITY related by columns HANDLER_ID (=EVENT_ID), EVENT_SEQ, RESPONSIBLE_AGENCY (=EVENT_AGENCY), ACTIVITY_LOCATION (=EVENT_LOCATION), OWNER (=EVENT_OWN), and CA_EVENT_CODE (=EVENT_CODE).
Sometimes is linked by one or more RCR_AREA_EVENT related by columns HANDLER_ID (=AREA_HANDLER_ID), EVENT_SEQ, RESPONSIBLE_AGENCY, ACTIVITY_LOCATION, OWNER (=EVENT_OWN), and CA_EVENT_CODE.
Always is referenced by one RCR_CA_EVENTCODES related by columns OWNER and CA_EVENT_CODE

Columns:

Definition Source: RCRAInfo Data Element Dictionary, March 2001.

Return To: