DATA ELEMENT DICTIONARY - CORRECTIVE ACTION MODULE

The data fields associated with the tables in the Corrective Action Module are documented, by table, below.  Click here to see the Corrective Action Structure Chart. 

 

 

AAREA4

English Name Oracle Name Edit Rule Description
EPA Handler ID HANDLER_ID

CA1-010

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note:  Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located.
Area Sequence Number AREA_SEQ

CA1-020

System-generated value used for administrative purposes to uniquely designate a single unit, or a group of units with a common history and projection of corrective action requirements.

Area Name AREA_NAME

CA1-050

Name or number assigned by the implementing agency to identify a corrective action area.
Entire Facility Indicator ENTIRE_FACILITY_IND

CA1-030, CA1-040

Indicates that the corrective action applies to the entire facility. [Y - Yes; N - No] Note: A facility can have only one area indicated as the entire facility.
Regulated Unit Indicator REGULATED_UNIT_IND

CA1-100

Indicates that the corrective action applies to a regulated unit. [Y - Yes; N - No]
Air Release Indicator AIR_RELEASE_IND

CA1-060

Indicates that there has been a release to air (either within or beyond the facility boundary) from the unit/area. This may include releases of subsurface gas. [Y - Yes; N - No]

Groundwater Release Indicator

GROUNDWATER_RELEASE_IND

CA1-070

Indicates that there has been a release to groundwater from the unit/area.  [Y - Yes; N - No]
Soil Release Indicator SOIL_RELEASE_IND

CA1-080

Indicates that there has been a release to soil (either within or beyond the facility boundary) from the unit/area. This may include sub-soil contamination beneath the unit/area. [Y - Yes; N - No]

Surface Water Release Indicator SURFACE_WATER_RELEASE_IND

CA1-090

Indicates that there has been a release to surface water (either within or beyond the facility boundary) from the unit/area. [Y - Yes; N - No]
EPA Responsible Person Owner EPA_RESPONSIBLE_PERSON_OWNER

CA1-105,

CA1-106

Indicates the agency that defined the EPA Responsible Person.
EPA Responsible Person EPA_RESPONSIBLE_PERSON

CA1-106,

CA1-110

The EPA person currently responsible for overseeing the corrective action area.
State Responsible Person Owner STATE_RESPONSIBLE_PERSON_OWNER

CA1-115,

CA1-116

Indicates the agency that defined the State Responsible Person.
State Responsible Person STATE_RESPONSIBLE_PERSON

CA1-116,

CA1-120

The state person currently responsible for overseeing the corrective action area.
Area Acreage AREA_ACREAGE CA1-130 The number of acres associated with the handler or area.
User ID of Last Change USERID

 

Records the user ID of the last person to change the data.

Date of Last Change LAST_CHANGE

 

Records the date that the data was last changed.
Notes NOTES

 

Additional information regarding the corrective action area.  Note:  These notes are not  released to the public
Date of Area Record Creation CREATED_DATE   Records the date that the area record was created.
User Id of Area Record Creation CREATED_BY_USERID   Records the user identification of the person who created the area record.
Origin of Data DATA_ORIGIN   Computer-generated field that indicates they method by which the area was created.  [see nationally-defined values]

AAUTHORITY4

English Name Oracle Name Edit Rule Description
EPA Handler ID HANDLER_ID

CA2-010

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note:  Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located.
Authority Activity Location AUTHORITY_ACTIVITY_LOCATION

 

Indicates the location of the agency regulating the activity.  [see nationally-defined values]

Authority Agency AUTHORITY_AGENCY

CA2-030

Code indicating the agency responsible for originating the specific order, permit, or permit modification, and for overseeing the activities imposed by that authority.  [see nationally-defined values]

Authority Type Owner AUTHORITY_OWNER

CA2-015

Indicates the agency that defined the Authority Type.
Authority Type AUTHORITY_TYPE CA2-020 Code indicating whether a permit, administrative order, or other authority has been issued to implement the corrective action process. [see nationally-defined values]
Authority Effective Date

AUTHORITY_EFFECTIVE_DATE

CA2-040, CA2-050, CA2-060

For a permit modification, the effective date is cited in that document. For a unilateral order or consent decree, it is the date the authorized agency official signs the order, unless a different date is cited within the order.

Issue Date

ISSUE_DATE

CA2-050 The date the authorized agency official signs the order, permit, or permit modification.
End Date END_DATE CA2-060 The date when the corrective action authority is revoked or ended.
Repository Established REPOSITORY CA2-070

Indicates if the Director requires the owner/operator to establish and maintain an information repository at a location near the facility for the purpose of making accessible to interested parties documents, reports, and other public information relevant to public understanding of the activities, findings, and plans for such corrective action initiatives.  [Y-Yes; N-No]

Responsible Person Owner RESPONSIBLE_PERSON_OWNER CA2-093, CA2-095, CA2-096 Indicates the agency that defined the Responsible Person.
Responsible Person RESPONSIBLE_PERSON CA2-093, CA2-096, CA2-100 Person responsible for overseeing the activities undertaken by the authority.  
Suborganization Owner SUBORGANIZATION_OWNER CA2-083, CA2-085, CA2-086 Indicates the agency that defined the Suborganization.
Suborganization SUBORGANIZATION CA2-083, CA2-086, CA2-090 Name or abbreviation of a state division/section (suborganization).

Lead Program

LEAD_PROGRAM CA2-080 Code indicating the program in which the organization establishes the applicable guidance that the authority should be issued.  [R-RCRA; C-CERCLA]  Note:  Beginning on April 4, 2025, this data element is no longer being collected.
User ID of Last Change USERID   Records the user ID of the last person to change the data.
Date of Last Change LAST_CHANGE   Records the date that the data was last changed.
Notes NOTES   Additional description of the authority.  Note:  These notes are not released to the public
Date of Authority Record Creation CREATED_DATE   Records the date that the authority record was created.
User Id of Authority Record Creation CREATED_BY_USERID   Records the user identification of the person who created the authority record.
Origin of Data DATA_ORIGIN   Computer-generated field that indicates they method by which the authority was created.  [see nationally-defined values]

ALN_AUTHORITY_CITATION4

English Name Oracle Name Edit Rule Description
EPA Handler ID HANDLER_ID CA3-010

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note: Handlers associated with Navajo Nation should be assigned Handler IDs beginning with 'NN' regardless of where the handler is physically located.

Authority Activity Location AAUTHORITY_ACTIVITY_LOCATION CA3-010

Indicates the location of the agency regulating the activity.

Authority Agency AUTHORITY_AGENCY CA3-010

Code indicating the agency responsible for originating the specific order, permit, or permit modification, and for overseeing the activities imposed by that authority.  [S-State; E-EPA; J-Joint]

Authority Type Owner AUTHORITY_OWNER CA3-010 Indicates the agency that defined the Authority Type.
Authority Type AUTHORITY_TYPE CA3-010 Code indicating whether a permit, administrative order, or other authority has been issued to implement the corrective action process. [see nationally-defined values]
Authority Effective Date AUTHORITY_EFFECTIVE_DATE CA3-010

For a permit modification, the effective date is cited in that document. For a unilateral order or consent decree, it is the date the authorized agency official signs the order, unless a different date is cited within the order.

Statutory Citation Owner STATUTORY_OWNER CA3-020 Indicates the agency that defined the Statutory Citation.
Statutory Citation STATUTORY_CITATION CA3-020 Code designating specific statutory or regulatory provision providing legal authority for imposition of requirements.  [see nationally-defined values]
User ID of Last Change USERID   Records the user ID of the last person to change the data.
Date of Last Change LAST_CHANGE   Records the date that the data was last changed.

AEVENT4

English Name Oracle Name Edit Rule Description
EPA Handler ID HANDLER_ID CA4-010

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note:  Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located.

Event Activity Location EVENT_ACTIVITY_LOCATION   Indicates the location of the agency regulating the activity.
Event Sequence Number EVENT_SEQ CA4-040 System-generated value used to uniquely identify multiple occurrences of a corrective action event.
Event Agency EVENT_AGENCY CA4-030 Code indicating the agency responsible for overseeing a specific corrective action event.  [see nationally-defined values]
Corrective Action Event Code Owner EVENT_OWNER

CA4-015, CA4-130,

CA4-140,

CA4-150

Indicates the agency that defined the Corrective Action Event.
Corrective Action Event Code EVENT_CODE

CA4-020, CA4-130,

CA4-140,

CA4-150

Code that corresponds to a specific event or event type. The first two characters indicate the event category and the last three characters the numeric event number.  [see nationally-defined values]

Original Scheduled Event Date SCHEDULE_DATE_ORIG

CA4-055, CA4-070, CA4-080

The original scheduled completion date for an event. This date cannot be changed once entered. Slippage of the scheduled completion date is recorded in the New Scheduled Event Date field.

New Scheduled Event Date SCHEDULE_DATE_NEW

CA4-060

Revised scheduled completion date of the corrective action event. This date is used in conjunction with the Original Scheduled Event Date to allow tracking scheduled date slippage.

Actual Date of Event ACTUAL_DATE

CA4-050, CA4-070, CA4-080,

CA4-140,

CA4-150

The date on which actual completion of a corrective action event occurs.  
Best Date for Event BEST_DATE   The best date for determining the occurrence of the corrective action event.
Suborganization Owner SUBORGANIZATION_OWNER CA4-083, CA4-085, CA4-086 Indicates the agency that defined the  Suborganization.
Suborganization SUBORGANIZATION CA4-083, CA4-086, CA4-090 Name or abbreviation of a state division/section (Suborganization).
Event Responsible Person Owner RESPONSIBLE_PERSON_OWNER CA4-093, CA4-095, CA4-096 Indicates the agency that defined the Event Responsible Person.
Event Responsible Person RESPONSIBLE_PERSON CA4-093, CA4-096, CA4-100 The person currently responsible for overseeing the corrective action event.
User ID of Last Change

USERID

  Records the user ID of the last person to change the data.
Date of Last Change LAST_CHANGE   Records the date that the data was last changed.
Notes NOTES CA4-130

Additional description of the corrective action event.  Note:  These notes are not  released to the public.

Public Notes PUBLIC_NOTES   Additional information regarding the corrective action event.  Note:  These notes may be released to the public.
Date of Event Record Creation CREATED_DATE   Records the date that the event record was created.
User Id of Event Record Creation CREATED_BY_USERID   Records the user identification of the person who created the event record.
Origin of Data DATA_ORIGIN   Computer-generated field that indicates they method by which the event was created.  [see nationally-defined values]

ALN_AREA_EVENT4

English Name Oracle Name Edit Rule Description
Area Handler ID AREA_HANDLER_ID CA5-010

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note:  Handlers associated with Navajo Nation should be assigned Handler IDs beginning with 'NN' regardless of where the handler is physically located.

Area Sequence Number AREA_SEQ CA5-010

System-generated value used for administrative purposes to uniquely designate a single unit, or a group of units with a common history and projection of corrective action requirements.

Event Handler ID EVENT_HANDLER_ID CA5-020

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note:  Handlers associated with Navajo Nation should be assigned Handler IDs beginning with 'NN' regardless of where the handler is physically located.

Event Activity Location EVENT_ACTIVITY_LOCATION CA5-020 Indicates the location of the agency regulating the activity.
Event Sequence Number EVENT_SEQ CA5-020 System-generated value used to uniquely identify multiple occurrences of a corrective action event.
Event Agency EVENT_AGENCY CA5-020 Code indicating the agency responsible for overseeing a specific corrective action event.
Corrective Action Event Code Owner EVENT_OWNER CA5-020 Indicates the agency that defined the Corrective Action Event.
Corrective Action Event Code EVENT_CODE CA5-020

Code indicating a specific corrective action event or event type. The first two characters indicate the event category and the last three characters the numeric event number.  [see nationally-defined values]

User ID of Last Change USERID   Records the user ID of the last person to change the data.
Date of Last Change LAST_CHANGE   Records the date that the data was last changed.

ALN_EVENT_AUTHORITY4

English Name Oracle Name Edit Rule Description
Event Handler ID EVENT_HANDLER_ID CA6-010

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note: Handlers associated with Navajo Nation should be assigned Handler IDs beginning with 'NN' regardless of where the handler is physically located.

Event Activity Location EVENT_ACTIVITY_LOCATION CA6-010 Indicates the location of the agency regulating the activity.
Event Sequence Number EVENT_SEQ CA6-010 System-generated value used to uniquely identify multiple occurrences of a corrective action event.
Event Agency EVENT_AGENCY CA6-010 Code indicating the agency responsible for overseeing a specific corrective action event.
Corrective Action Event Code Owner EVENT_OWNER CA6-010 Indicates the agency that defined the Corrective Action Event.
Corrective Action Event Code EVENT_CODE CA6-010

Code indicating a specific event or event type. The first two characters indicate the event category and the last three characters the numeric event number.  [see nationally-defined values]

Authority Handler ID AUTHORITY_HANDLER_ID CA6-020

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note: Handlers associated with Navajo Nation should be assigned Handler IDs beginning with 'NN' regardless of where the handler is physically located.

Authority Activity Location AUTHORITY_ACTIVITY_LOCATION CA6-020 Indicates the location of the agency regulating the activity.
Authority Agency AUTHORITY_AGENCY CA6-020

Code indicating the agency responsible for originating the specific order, permit, or permit modification, and for overseeing the activities imposed by that authority.  [S-State; E-EPA; J-Joint]

Authority Type Owner AUTHORITY_OWNER CA6-020 Indicates the agency that defined the Authority Type.
Authority Type AUTHORITY_TYPE CA6-020 Code indicating whether a permit, administrative order, or other authority has been issued to implement the corrective action process.  [see nationally-defined values]
Authority Effective Date AUTHORITY_EFFECTIVE_DATE CA6-020

For a permit modification, the effective date is cited in that document. For a unilateral order or consent decree, it is the date the authorized agency official signs the order, unless a different date is cited within the order.

User ID of Last Change USERID   Records the user ID of the last person to change the data.
Date of Last Change LAST_CHANGE   Records the date that the data was last changed.

ALN_AREA_UNIT4

English Name Oracle Name Edit Rule Description
Area Handler ID AREA_HANDLER_ID CA8-010

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note: Handlers associated with Navajo Nation should be assigned Handler IDs beginning with 'NN' regardless of where the handler is physically located.

Area Sequence Number AREA_SEQ CA8-010

System-generated value used for administrative purposes to uniquely designate a single unit, or a group of units with a common history and projection of corrective action requirements.

Unit Handler ID UNIT_HANDLER_ID CA8-020

Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities).  Note: Handlers associated with Navajo Nation should be assigned Handler IDs beginning with 'NN' regardless of where the handler is physically located.

Process Unit Sequence Number UNIT_SEQ CA8-020 System-generated value used to uniquely identify a process unit.
User ID of Last Change USERID   Records the user ID of the last person to change the data.
Date of Last Change LAST_CHANGE   Records the date that the data was last changed.