Table Name: RCR_VIOLATION

Description: Infringements of RCRA regulatory requirements.

Relationships:

Always occurs at one RCR_HBASIC related by column HANDLER_ID.
Always is described by one RCR_EVALVIOL_AREA related by columns VIOL_OWN (=OWNER) and VIOL_TYPE (=AREA_TYPE).
Sometimes has one or more RCR_EVALUATION_VIOLATION related by columns HANDLER_ID (=VIOL_HANDLER_ID), ACTIVITY_LOCATION (=VIOL_LOCATION), VIOLATION_SEQ (=VIOL_SEQ), and DETERMINED_BY_AGENCY (=VIOL_AGENCY).
Sometimes has one or more RCR_COMPLIANCE_SCHEDULE related by columns HANDLER_ID (=VIOL_HANDLER_ID), ACTIVITY_LOCATION (=VIOL_ACTIVITY_LOCATION), VIOLATION_SEQ (=VIOL_SEQ), and DETERMINED_BY_AGENCY (=VIOL_AGENCY).

Columns:

Definition Source: RCRAInfo Data Element Dictionary, March 2001.

Return To: