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.
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] |
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] |
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. |
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] |
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. |
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. |
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. |