The data fields associated with the tables in the Permit, Closure, and Post-Closure Module are documented, by table, below. Click here to see the Permit, Closure, and Post-Closure Module Structure Chart.
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | PM1-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. |
Series Sequence Number | SERIES_SEQ | PM1-020 | System-generated value used to uniquely identify a permit series. |
Series Name | SERIES_NAME | PM1-030 | Name or number assigned by the implementing agency to identify a permit or permit application. Note: To easily recognize a series, it is recommended that the series name be unique. |
Responsible Person Owner | RESPONSIBLE_PERSON_OWNER | PM1-033, PM1-035, PM1-036 | Indicates the agency that defined the Responsible Person. |
Responsible Person | RESPONSIBLE_PERSON | PM1-033, PM1-036, PM1-040 | The EPA or State person currently assigned to oversee the permit activity. |
Active Series |
ACTIVE_SERIES | PM1-060 | Indicates that the series is active. [Y - Yes; N - No] |
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 permit series. | |
Date of Series Record Creation | CREATED_DATE | Records the date that the series record was created. | |
User Id of Series Record Creation | CREATED_BY_USERID | Records the user identification of the person who created the series record. | |
Origin of Data | DATA_ORIGIN | Computer-generated field that indicates they method by which the series was created. [see nationally-defined values] |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID |
HANDLER_ID |
PM2-010, PM2-120, PM2-130 |
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. |
Series Sequence Number | SERIES_SEQ | PM2-010, PM2-120, PM2-130 | System-generated value used to uniquely identify a permit series. |
Permit Event Activity Location | EVENT_ACTIVITY_LOCATION | Indicates the location of the agency regulating the activity. [see nationally-defined values] | |
Event Sequence Number | EVENT_SEQ | PM2-040, PM2-120, PM2-130 | System-generated value used to uniquely identify a permit event. |
Event Agency | EVENT_AGENCY | PM2-030, PM2-120, PM2-130 | Code indicating the agency responsible for conducting a specific permitting/closure program event |
Event Code Owner | EVENT_OWNER | PM2-015, PM2-120, PM2-130 | Indicates the agency that defined the Event Code. |
Event Code | EVENT_CODE | PM2-020, PM2-120, PM2-130 | Code indicating a specific permitting/closure program event and status that has actually occurred or is scheduled to occur. [see nationally-defined values] |
Original Scheduled Event Date | SCHEDULE_DATE_ORIG | PM2-060, PM2-080, PM2-090 | The original scheduled completion date for an event. Note: Arkansas was authorized in 1979 prior to the promulgation of the federal regulations in 1980, therefore, they may provide an Original Scheduled Event Date prior to May 19, 1980. |
New Scheduled Event Date | SCHEDULE_DATE_NEW | PM2-070 |
Revised date on which completion of a permitting/closure event is scheduled or projected to occur, used for tracking changes to Original Scheduled Event Date. Note: Arkansas was authorized in 1979 prior to the promulgation of the federal regulations in 1980, therefore, they may provide a New Scheduled Event Date prior to May 19, 1980. |
Actual Date of Event | ACTUAL_DATE | PM2-050, PM2-080, PM2-090 | Date on which actual completion of a permitting/closure event occurs. Note: For specific permitting/closure requirements with which implementers are required to comply, Actual Date is the date on which the requirement became effective based on a statutory or regulatory deadline. Arkansas was authorized in 1979 prior to the promulgation of the federal regulations in 1980, therefore, they may provide an Actual Event Date prior to May 19, 1980. |
Best Date for Event | BEST_DATE | The best date for determining the occurrence of the permitting/closure event. | |
Event Responsible Person Owner |
RESPONSIBLE_PERSON_OWNER |
PM2-093, PM2-095, PM2-096 | Indicates the agency that defined the Event Responsible Person. |
Event Responsible Person | RESPONSIBLE_PERSON | PM2-093, PM2-096, PM2-100 | The person currently responsible for the event. |
Suborganization Owner | SUBORGANIZATION_OWNER | PM2-103, PM2-105, PM2-106 | Indicates the agency that defined the Suborganization. |
Suborganization | SUBORGANIZATION | PM2-103, PM2-106, PM2-110 | Name or abbreviation of a state division/section (suborganization). |
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 permit event. | |
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 |
EPA Handler | HANDLER_ID | PM3-010, PM3-040 |
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 | PM3-020, PM3-040 | System-generated value used to uniquely identify a process unit. |
Process Unit Name | UNIT_NAME | PM3-030 | Name or number assigned by the implementing agency to identify a process unit group. |
Active Unit |
ACTIVE_UNIT | PM3-050 | Indicates that the unit is active. This indicator is used within the application to determine when to display a unit. [Y - Yes; N - No] |
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 process unit group. | |
Date of Unit Record Creation | CREATED_DATE | Records the date that the unit record was created. | |
User Id of Unit Record Creation | CREATED_BY_USERID | Records the user identification of the person who created the unit record. | |
Origin of Data | DATA_ORIGIN | Computer-generated field that indicates they method by which the unit was created. [see nationally-defined values] |
English Name |
Oracle Name |
Edit Rule |
Description |
EPA Handler ID | HANDLER_ID | PM4-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. |
Process Unit Sequence Number | UNIT_SEQ | PM4-010 | System-generated value used to uniquely identify a process unit. |
Process Unit Detail Sequence Number | UNIT_DETAIL_SEQ | PM4-020 | System-generated value used to uniquely identify a process unit detail. |
Process Status Effective Date | EFFECTIVE_DATE | PM4-040 |
The date specifying when the other information in the process detail data record (i.e., process, capacity, and operating and legal status) became effective. |
Process Code Owner | PROCESS_CODE_OWNER | PM4-025 | Indicates the agency that defined the Process Code. [HQ - Headquarters] |
Process Code |
PROCESS_CODE |
PM4-030 |
Code specifying the unit group's current waste treatment, storage, or disposal process. [see nationally-defined values] |
Number of Units within Process Unit Group |
NUMBER_OF_UNITS |
PM4-070 |
Total number of units of the same process grouped together to form a single process unit group. |
Process Capacity |
CAPACITY |
PM4-050 |
The capacity of the process unit. |
Capacity Type |
CAPACITY_TYPE |
PM4-060 |
Code indicating the type of capacity. |
Unit of Measure Type Owner |
UOM_OWNER |
PM4-026 |
Indicates the agency that defined the Unit of Measure Type. [HQ - Headquarters] |
Unit of Measure Type |
UOM_TYPE |
PM4-030 |
Code indicating the unit of measure of the associated design capacity. [see nationally-defined values] |
Legal/Operating Status Code Owner |
LEGAL_OPERATING_STATUS_OWNER |
PM4-085 |
Indicates the agency that defined the Legal/Operating Status Code. [HQ - Headquarters] |
Legal/Operating Status Code |
LEGAL_OPERATING_STATUS |
PM4-090 |
Code indicating the programmatic (operating and legal status) conditions that reflect RCRA program activity requirements of a unit. [see nationally-defined values] |
Commercial Status Code |
COMMERCIAL_STATUS |
PM4-080 |
Code indicating that the facility, whether public or private, accepts hazardous waste for the process unit group from a third party. [see nationally-defined values] |
Standardized Permit Indicator |
STANDARDIZED_PERMIT_IND |
PM4-100 |
Flag to indicate if the unit detail is permitted under a standardized permit. |
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 process unit group detail. Note: If the Legal/Operating Status Code is "Strange but True", then Notes must be provided. |
Date of Unit Detail Record Creation | CREATED_DATE | Records the date that the unit detail record was created. | |
User Id of Unit Detail Record Creation | CREATED_BY_USERID | Records the user identification of the person who created the unit detail record. | |
Origin of Data | DATA_ORIGIN | Computer-generated field that indicates they method by which the unit detail was created. [see nationally-defined values] | |
Current Unit Detail | CURRENT_UNIT_DETAIL | System-generated indicator to show which unit detail linked to a unit is considered to be the "current" detail information. [Y - Yes; N - No] |
English Name | Oracle Name | Edit Rule | Description |
Event Handler ID | EVENT_HANDLER_ID | PM5-010, PM5-030 |
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. |
Series Sequence Number | EVENT_SERIES_SEQ | PM5-010, PM5-030 | System-generated value used to uniquely identify a permit series. |
Permit Event Activity Location | EVENT_ACTIVITY_LOCATION | PM5-010, PM5-030 | Indicates the location of the agency regulating the activity. [see nationally-defined values] |
Event Sequence Number | EVENT_SEQ | PM5-010, PM5-030 | System-generated value used to uniquely identify a permit event. |
Event Agency | EVENT_AGENCY | PM5-010, PM5-030 | Code indicating the agency responsible for conducting a specific permitting/closure program event. [S - State; E - EPA; J - Joint. with State Lead; P - Joint with EPA Lead] |
Event Code Owner | EVENT_OWNER | PM5-010, PM5-030 | Indicates the agency that defined the Event Code. |
Event Code | EVENT_CODE | PM5-010, PM5-030 | Code indicating a specific permitting/closure program event and status that has actually occurred or is scheduled to occur. [see nationally-defined values] |
Permit Unit Handler ID | UNIT_DETAIL_HANDLER_ID | PM5-020, PM5-030 |
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 | PM5-020, PM5-030 | System-generated value used to uniquely identify a process unit. |
Process Unit Detail Sequence Number | UNIT_DETAIL_SEQ | PM5-020, PM5-030 | System-generated value used to uniquely identify a process unit detail. |
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 | PM6-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. |
Process Unit Sequence Number | UNIT_SEQ | PM6-010 | System-generated value used to uniquely identify a process unit. |
Process Unit Detail Sequence Number | UNIT_DETAIL_SEQ | PM6-010 | System-generated value used to uniquely identify a process unit detail. |
Hazardous Waste Code Owner | WASTE_CODE_OWNER | PM6-015 | Indicates the agency that defined the Waste Code. |
Hazardous Waste Code | WASTE_CODE | PM6-020 |
State or Federal codes corresponding to the hazardous waste generated by a site. These codes are listed in 40 CFR Part 261, Subparts C and D, or are assigned by States for wastes that are either: 1) regulated and defined as hazardous by the State but are not regulated as RCRA hazardous waste, or 2) State equivalent waste codes for RCRA regulated hazardous wastes. [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 |
Commitment Lead | COM_LEAD | The lead implementing agency for the commitment/initiative. | |
Commitment Sequence Number | COM_SEQ | A system-generated sequence number to uniquely identify commitments/initiatives. | |
Event Handler ID | EVENT_HANDLER_ID |
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. |
|
Series Sequence Number | EVENT_SERIES_SEQ | System-generated value used to uniquely identify a permit series. | |
Permit Event Activity Location | EVENT_ACTIVITY_LOCATION | Indicates the location of the agency regulating the activity. [see nationally-defined values] | |
Event Sequence Number | EVENT_SEQ | System-generated value used to uniquely identify a permit event. | |
Event Agency | EVENT_AGENCY | Code indicating the agency responsible for conducting a specific permitting/closure program event. | |
Event Code Owner | EVENT_OWNER | Indicates the agency that defined the Event Code. | |
Event Code | EVENT_CODE | Code used to indicate a specific permitting/closure program event and status that has actually occurred or is scheduled to occur. [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 |
Modification Request Handler ID | MOD_HANDLER_ID | PM8-010, PM8-030 |
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. |
Modification Request Series Sequence Number | MOD_SERIES_SEQ | PM8-030 | System-generated value used to uniquely identify a permit series. |
Modification Request Activity Location | MOD_ACTIVITY_LOCATION | PM8-030 | Indicates the location of the agency regulating the activity. [see nationally-defined values] |
Modification Request Sequence Number | MOD_SEQ | PM8-030 | System-generated value used to uniquely identify a permit event. |
Modification Request Agency | MOD_AGENCY | PM8-030 | Code indicating the agency responsible for conducting a specific permitting/closure program event. [S - State; E - EPA; J - Joint. with State Lead; P - Joint with EPA Lead] |
Modification Request Event Code Owner | MOD_OWNER | PM8-020, PM8-030 | Indicates the agency that defined the Event Code. |
Modification Request Event Code | MOD_CODE | PM8-020, PM8-030 | Code indicating a specific permitting/closure program modification event and status that has actually occurred or is scheduled to occur. [see nationally-defined values] |
Subsequent Modification Event Handler ID | EVENT_HANDLER_ID | PM8-010, PM8-050 |
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. |
Subsequent Modification Event Series Sequence Number | EVENT_SERIES_SEQ | PM8-050 | System-generated value used to uniquely identify a permit series. |
Subsequent Modification Event Activity Location | EVENT_ACTIVITY_LOCATION | PM8-050 | Indicates the location of the agency regulating the activity. [see nationally-defined values] |
Subsequent Modification Event Sequence Number | EVENT_SEQ | PM8-050 | System-generated value used to uniquely identify a permit event. |
Subsequent Modification Event Agency | EVENT_AGENCY | PM8-050 | Code indicating the agency responsible for conducting a specific permitting/closure program event. [S - State; E - EPA; J - Joint. with State Lead; P - Joint with EPA Lead] |
Subsequent Modification Event Code Owner | EVENT_OWNER | PM8-040, PM8-030 | Indicates the agency that defined the Event Code. |
Subsequent Modification Event Code | EVENT_CODE | PM8-040, PM8-050 | Code indicating a specific permitting/closure program subsequent modification event and status that has actually occurred or is scheduled to occur. [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. |