DATA ELEMENT DICTIONARY - PERMIT, CLOSURE, AND POST-CLOSURE MODULE

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. 

 

PSERIES4

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]

PEVENT4

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]

PUNIT4

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]

PUNIT_DETAIL4

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]

PLN_EVENT_UNIT_DETAIL4

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.

PLN_UNIT_DETAIL_WASTE4

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.

PLN_EVENT_COMMITMENT4

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.

PLN_MOD_EVENT

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.