DATA ELEMENT DICTIONARY - COMPLIANCE MONITORING AND ENFORCEMENT MODULE

The data fields associated with the tables in the Compliance Monitoring and Enforcement (CM&E) Module are documented, by table, below. Click here to see the CM&E Module Structure Chart.

CEVALUATION3	CREQUEST3	CLN_EVALUATION_COMMITMENT3	CVIOLATION3
CCITATION3	CLN_EVALUATION_VIOLATION3	CENFORCEMENT3	CLN_VIOLATION_ENFORCEMENT3
CSEP3	CSNY_DATE3	CPENALTY3	CPAYMENT3

CEVALUATION3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CE1-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.
Evaluation Activity Location	EVAL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Evaluation Identifier	EVAL_IDENTIFIER	CE1-030	Name or number assigned by the implementing agency to identify an evaluation.
Evaluation Start Date	EVAL_START_DATE	CD1-020, CE1-250	The first day of the inspection or record review regardless of the duration of the inspection.
Evaluation Responsible Agency	EVAL_AGENCY	CE1-040, CE1-210	Code indicating the agency responsible for conducting the evaluation. Note: There is no relationship between a State's authorization status and the Evaluation Responsible Agency. The value 'L' - Local is only available to Region 9 states unless requested by other states/regions.
Day Zero	DAY_ZERO	CE1-060, CE1-065, CE1-070, CE1-080	The date used to evaluate timeliness in regards to the standards outlined in the Enforcement Response Policy (ERP). Note: There can only be one Day Zero per evaluation. Guidance: For SNY evaluations, Day Zero will be one of the following: Evaluation Start Date of a non-followup evaluation by this agency; Latest Enforcement Date for an 810 or 820 action (if the agency is EPA then the date of an 810 enforcement action, if the agency is State then the date of an 820 enforcement action); or Any valid date if the facility is a reclassified secondary violator. For SNN evaluations, Day Zero must be null. For follow-up evaluations, Day Zero will be the evaluation date of a non-followup evaluation by this agency. For all other evaluations, Day Zero is equal to the Evaluation Start Date.
Found Violation	FOUND_VIOLATION	CE1-050, CE1-110, CE1-120, CE1-125, CE1-130, CE1-200, CE1-240	Code indicating whether an evaluation discovered any violations at the facility. For CAV evaluations, the found violation indicator shows whether the evaluation found any discrepancies at the facility. [Y - Yes; N - No; U - Undetermined]
Citizen Complaint Indicator	CITIZEN_COMPLAINT	CE1-160	Indicates whether the evaluation was initiated because of a tip/complaint. [Y - Yes; N - No]
Multimedia Indicator	MULTIMEDIA_INSPECTION	CE1-170	Indicates whether the evaluation was part of a multimedia inspection activity. [Y - Yes; N - No]
Sampling Indicator	SAMPLING	CE1-180	Indicates whether the evaluation conducted included the collection of samples. [Y - Yes; N - No]
Not Subtitle C Indicator	NOT_SUBTITLE_C	CE1-190	For an inspection that was conducted pursuant to RCRA 3007 or State equivalent, indicates whether the site is not a Subtitle C facility. [Y - Yes; N - No]
Evaluation Type Owner	EVAL_OWNER	CE1-085	Indicates the agency that defined the Evaluation Type. [HQ-Headquarters]
Evaluation Type	EVAL_TYPE	CE1-090, CE1-120, CE1-125, CE1-200, CE1-215, CE1-220, CE1-230 ,CE1-260, CE1-270, CE1-280, CE1-290	Code indicating the type of evaluation conducted at the site. [see nationally-defined values]
Focus Area Owner	FOCUS_AREA_OWNER	CE1-215, CE1-231, CE1-265	Indicates the agency that defined the Focus Area.
Focus Area	FOCUS_AREA	CE1-220, CE1-230, CE1-231, CE1-270	Code identifying the subject of a Focused Compliance Inspection or a Non-financial Record Review. [see nationally-defined values]
Evaluation Responsible Person Owner	RESPONSIBLE_PERSON_OWNER	CE1-143, CE1-145, CE1-146	Indicates the agency that defined the Evaluation Responsible Person.
Evaluation Responsible Person Identifier	RESPONSIBLE_PERSON	CE1-143, CE1-146, CE1-150	Code indicating the person within the agency that is responsible for conducting the evaluation.
Evaluation Responsible Suborganization Owner	SUBORGANIZATION_OWNER	CE1-133, CE1-135, CE1-136	Indicates the agency that defined the Evaluation Responsible Suborganization.
Evaluation Responsible Suborganization	SUBORGANIZATION	CE1-133, CE1-136, CE1-140	Code indicating the branch/district within the agency that is responsible for conducting the evaluation.
Notice of Compliance Date	NOC_DATE	CE1-240, CE1-250	Date that the facility was notified that there were no violations discovered or that the violations previously discovered by this evaluation have returned to compliance.
User ID of Last Change	USERID		Records the user identification of the last person to change the evaluation data.
Date of Last Change	LAST_CHANGE		Records the date that the evaluation data was last changed.
Notes	NOTES		Additional description or information pertaining to the evaluation.
Date of Evaluation Record Creation	CREATED_DATE		Records the date that the evaluation record was created.
User Id of Evaluation Record Creation	CREATED_BY_USERID		Records the user identification of the person who created the evaluation record.
Origin of Data	DATA_ORIGIN		Computer-generated field that indicates they method by which the evaluation was created. [see nationally-defined values]

CREQUEST3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CE2-010, CE2-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.
Request Sequence	REQUEST_SEQ	CE2-020	Assigned number to uniquely identify a 3007 information request record.
Evaluation Activity Location	EVAL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Evaluation Identifier	EVAL_IDENTIFIER	CE2-030	Name or number assigned by the implementing agency to identify an evaluation.
Evaluation Start Date	EVAL_START_DATE	CE2-030	The first day of the inspection or record review regardless of the duration of the inspection.
Evaluation Responsible Agency	EVAL_AGENCY	CE2-030	Code indicating the agency responsible for conducting the evaluation.
Date of Request	DATE_OF_REQUEST	CE2-040, CE2-056	The date that a 3007 information request was submitted.
Date Response Received	DATE_RESPONSE_RECEIVED	CE2-050, CE2-055	The date that 3007 information is received.
Request Agency	AGENCY	CE2-060	Code indicating the agency responsible for submitting the 3007 information request.
Request Activity Location	ACTIVITY_LOCATION		The location (i.e. State) where the request took place. [see nationally-defined values]
User ID of Last Change	USERID		Records the user identification of the last person to change the 3007 information request data.
Date of Last Change	LAST_CHANGE		Records the date that the 3007 information request data was last change.
Notes	NOTES		Additional description or information pertaining to the 3007 information request.

CLN_EVALUATION_COMMITMENT3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CE3-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.
Evaluation Activity Location	EVAL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Evaluation Identifier	EVAL_IDENTIFIER	CE3-020	Name or number assigned by the implementing agency to identify an evaluation.
Evaluation Start Date	EVAL_START_DATE	CE3-020	The first day of the inspection or record review regardless of the duration of the inspection.
Evaluation Responsible Agency	EVAL_AGENCY	CE3-020	Code indicating the agency responsible for conducting the evaluation.
Commitment Lead	COM_LEAD	CE3-010	The lead implementing agency for the commitment/initiative.
Commitment Sequence Number	COM_SEQ	CE3-010	Assigned number to uniquely identify a commitment/initiative.
User ID of Last Change	USERID		Records the user identification of the last person to change the evaluation to commitment link data.
Date of Last Change	LAST_CHANGE		Records the date that the evaluation to commitment link data was last changed.

CVIOLATION3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CE4-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.
Violation Activity Location	VIOL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Violation Sequence Number	VIOL_SEQ	CE4-010, CE4-020	Assigned number to uniquely identify each violation record.
Agency Which Determined Violation	VIOL_DETERMINED_BY_AGENCY	CE4-010, CE4-030, CE4-035, CE4-037, CE4-100, CE4-130	The agency that actually determined the violation. Note: The Agency Which Determined the Violation and Violation Responsible Agency must be the same unless a referral (enforcement action 810 or 820) has been issued. Only the agency listed in the Violation Responsible Agency field will be allowed to update the violation's Actual Return to Compliance Date and Return to Compliance Qualifier type.
Violation Type Owner	VIOL_OWNER	CE4-039	Indicates the agency that defined the Violation Type. [HQ - Headquarters]
Violation Type	VIOL_TYPE	CE4-040, CE4-130	Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes. Note: Implementers who are broader-in-scope will be able to use Violation Type 'XXS'. Additional clarification should be addressed through the use of the Citation field.
Former Citation	FORMER_CITATION		The citation from Federal or State regulations or statutes that specifies a violation or pending violation in sufficient detail to distinguish it from other violations intended to be addressed separately by other enforcement actions. These regulation numbers or citations can be found in the Code of Federal Regulations or in State regulation publications. They should be part of the inspection or evaluation report prepared by the person identifying the violation. New violations do not supersede resolved violations of the same regulation. Note: This field was created to maintain historical citation data entered into RCRAInfo prior to Version 3. This data cannot be changed (added, updated, or deleted).
Date Violation Was Determined	DETERMINED_DATE	CE4-050	Date that a determination is made that the violation exists. This is not necessarily the same date as the date of the inspection or evaluation. For example, the Date Violation Was Determined may be when the agency receives sample results or a legal determination.
Actual Return to Compliance Date	ACTUAL_RTC_DATE	CE4-060, CE4-080, CE4-090	Date that the agency determines that the handler demonstrated full physical compliance (the date compliance was verified). The handler will be considered to be out-of-full-physical-compliance until the Actual Returned to Compliance Date has been determined. Actual Return to Compliance Date does not necessarily mean that all enforcement actions are completed for this violation. For violations of omission (such as not manifesting a load of waste), the Actual Return to Compliance Date is the date of a written commitment by the handler to comply in the future or the day of conviction in a criminal action. Penalty payment is not a condition of full physical compliance; however if non-payment is the only violation then the Actual Return to Compliance Date is the date that payment is received. Note: Because of the verification requirement, Actual Return to Compliance Date will rarely match Scheduled Compliance Date. Where orders address multiple violations, program implementers may not verify physical compliance for all violations until the handler indicates that all violations have been corrected.
Return to Compliance Qualifier	RTC_QUALIFIER	CE4-070, CE4-080, CE4-090	Code Indicating the conditions under which actual compliance was observed. Note: The value "O" (observed) was used for ALL RTC violations brought forward from RCRIS.
Violation Responsible Agency	RESPONSIBLE_AGENCY	CE4-100, CE4-110, CE4-120	Code indicating the agency responsible for the violation. Note: The Agency Which Determined the Violation and Violation Responsible Agency must be the same unless a referral (enforcement action 810 or 820) has been issued.
User ID of Last Change	USERID		Records the user identification of the last person to change the violation data.
Date of Last Change	LAST_CHANGE		Records the date that the violation data was last changed.
Notes	NOTES		Additional description or information pertaining to the violation.
Date of Violation Record Creation	CREATED_DATE		Records the date that the violation record was created.
User Id of Violation Record Creation	CREATED_BY_USERID		Records the user identification of the person who created the violation record.

CLN_EVALUATION_VIOLATION3

English Name	Oracle Name	Edit Rule	Description
Evaluation Handler ID	EVAL_HANDLER_ID	CE5-010, CE5-020, CE5-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.
Evaluation Activity Location	EVAL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Evaluation Identifier	EVAL_IDENTIFIER	CE5-010, CE5-030	Name or number assigned by the implementing agency to identify an evaluation.
Evaluation Start Date	EVAL_START_DATE	CE5-010, CE5-030	The first day of the inspection or record review regardless of the duration of the inspection.
Evaluation Responsible Agency	EVAL_AGENCY	CE5-010, CE5-030	Code indicating the agency responsible for conducting the evaluation.
Violation Handler ID	VIOL_HANDLER_ID	CE5-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.
Violation Activity Location	VIOL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Violation Sequence Number	VIOL_SEQ	CE5-020	Assigned number to uniquely identify each violation record.
Agency Which Determined Violation	VIOL_DETERMINED_BY_AGENCY	CE5-020	The agency that actually determined the violation.
User ID of Last Change	USERID		Records the user identification of the last person to change the evaluation to violation link data.
Date of Last Change	LAST_CHANGE		Records the date that the evaluation to violation link data was last changed.

CCITATION3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CE6-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.
Violation Activity Location	VIOL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Violation Sequence Number	VIOL_SEQ	CE6-010	Assigned number to uniquely identify each violation record.
Agency Which Determined Violation	VIOL_DETERMINED_BY_AGENCY	CE6-010	The agency that actually determined the violation.
Citation Sequence Number	CITATION_SEQ	CE6-030	Assigned number of uniquely identify each citation record.
Violation Type Owner	VIOL_OWNER	CE6-010, CE6-020	Indicates the agency that defined the Violation Type. [HQ-Headquarters]
Violation Type	VIOL_TYPE	CE6-010, CE6-020	Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.
Citation Owner	CITATION_OWNER	CE6-020	Indicates the agency that defined the Citation.
Citation	CITATION	CE6-020	The citation from Federal or State regulations or statutes that specifies a violation in sufficient detail to distinguish it from other violations intended to be addressed separately by other enforcement actions. These regulation numbers or citations can be found in the Code of Federal Regulations or in State regulation publications.
Citation Type	CITATION_TYPE	CE6-020	Code indicating the origin of the citation listed in regulation violated. [see nationally-defined values]
User ID of Last Change	USERID		Records the user identification of the last person to change the citation data.
Date of Last Change	LAST_CHANGE		Records the date that the citation data was last changed.
Notes	NOTES		Additional description or information pertaining to the citation.

CENFORCEMENT3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CE8-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.
Enforcement Activity Location	ENF_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Enforcement Identifier	ENF_IDENTIFIER	CE8-060	Name or number assigned by the implementing agency to identify an enforcement.
Date of Enforcement Action	ENF_ACTION_DATE	CE8-045, CE8-050	The date the enforcement action was issued. For all formal actions involving written documents, the date should be the same as the date the document is signed. For an informal action, the date should reflect the date the handler received actual notification.
Enforcement Responsible Agency	ENF_AGENCY	CE8-070	Agency responsible for issuing the enforcement action.
Enforcement Docket Number	DOCKET_NUMBER		The relevant docket number that enforcement staff have assigned for tracking of enforcement actions.
Enforcement Attorney	ATTORNEY		Identifies the attorney within the agency that is responsible for issuing the enforcement action.
Corrective Action Component	CA_COMPONENT	CE8-080	Indicates whether the enforcement action contains a corrective action component. [Y - Yes; N - No] Note: As a result of a compliance monitoring evaluation, the responsible agency may determine that an enforcement response is necessary to address violations discovered during the evaluation. The following types of enforcement actions involving corrective action should be tracked in the CM&E module: 1. Orders to correct violations of a corrective action permit. 2. Orders to correct violations of a corrective action order. 3. Orders to correct Corrective Action violations (without penalty). 4. Orders to correct Corrective Action violations (with penalty). 5. Order to correct violations at unregulated SWMUs. The following types of actions involving corrective action are considered outside the scope of compliance monitoring and enforcement and should be tracked only in the Corrective Action module: 1. Orders for Corrective Action and/or Post-closure purposes.
Financial Assurance Requirement	FA_REQUIREMENT	CE8-085	Indicates whether the enforcement action contains a financial assurance requirement. [Y - Yes; N - No. For Enforcement Actions with an Action Date prior to 4/14/2019, N indicates Unknown]
Consent Agreement/Final Order (CA/FO) Sequence Number	CAFO_SEQ	CE8-090	Identifies the consent agreement / final order that this enforcement action is a part of. Note: The lead Region or State will enter the first site of the CA/FO into the LU_CAFO table and obtain a CA/FO sequence number. It is the responsibility of the lead Region/State to ensure that all other Regions and States involved use that sequence number.
Appeal Initiated Date	APPEAL_INITIATED_DATE	CE8-100	Date that the appeal was initiated.
Appeal Resolution Date	APPEAL_RESOLVED_DATE	CE8-110	Date that the appeal was resolved.
Disposition Status Date	DISPOSITION_STATUS_DATE	CE8-120, CE8-135, CE8-140	Date that the enforcement action was closed, terminated, or discontinued.
Disposition Status Owner	DISPOSITION_STATUS_OWNER	CE8-125, CE8-135, CE8-140, CE8-150	Indicates the agency that defined the Disposition Status. [HQ - Headquarters]
Disposition Status	DISPOSITION_STATUS	CE8-130, CE8-135, CE8-140, CE8-150	Code indicating how an enforcement action was closed, terminated, or discontinued. [see nationally-defined values]
Enforcement Type Owner	ENF_OWNER	CE8-015	Indicates the agency that defined the Enforcement Type.
Enforcement Type	ENF_TYPE	CE8-020, CE8-160	Code identifying the type of action being taken against a site. [see nationally-defined values]
Responsible Person Owner	RESPONSIBLE_PERSON_OWNER	CE8-033, CE8-035, CE8-036	Indicates the agency that defined the Responsible Person.
Responsible Person	RESPONSIBLE_PERSON	CE8-033, CE8-036, CE8-040	Code indicating the person within the agency responsible for the enforcement action.
Suborganization Owner	SUBORGANIZATION_OWNER	CE8-023, CE8-025, CE8-026	Indicates the agency that defined the Suborganization.
Suborganization	SUBORGANIZATION	CE8-023, CE8-026, CE8-030	Code indicating the branch/district within the agency that is responsible for the enforcement action.
User ID of Last Change	USERID		Records the user identification of the last person to change the enforcement action data.
Date of Last Change	LAST_CHANGE		Records the date that the enforcement action data was last changed.
Notes	NOTES		Additional description or information pertaining to the enforcement action.
Date of Enforcement Record Creation	CREATED_DATE		Records the date that the enforcement record was created.
User Id of Enforcement Record Creation	CREATED_BY_USERID		Records the user identification of the person who created the enforcement record.
Origin of Data	DATA_ORIGIN		Computer-generated field that indicates they method by which the enforcement was created. [see nationally-defined values]

CLN_VIOLATION_ENFORCEMENT3

English Name	Oracle Name	Edit Rule	Description
Violation Handler ID	VIOL_HANDLER_ID	CE9-010, CE9-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.
Violation Activity Location	VIOL_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Violation Sequence Number	VIOL_SEQ	CE9-010	Assigned number to uniquely identify each violation record.
Agency Which Determined Violation	VIOL_DETERMINED_BY_AGENCY	CE9-010	The agency that actually determined the violation.
Enforcement Handler ID	ENF_HANDLER_ID	CE9-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.
Enforcement Activity Location	ENF_ACTIVITY_LOCATION	CE9-020	The location (i.e. State) where the activity took place. [see nationally-defined values]
Enforcement Identifier	ENF_IDENTIFIER	CE9-020	Name or number assigned by the implementing agency to identify an enforcement.
Date of Enforcement Action	ENF_ACTION_DATE	CE9-020	Date the enforcement action was issued.
Enforcement Responsible Agency	ENF_AGENCY	CE9-020	Agency responsible for issuing the enforcement action.
Scheduled Compliance Date	SCHEDULED_COMPLIANCE_DATE	CE9-030	Date by which the handler is to submit to the agency its documentation that the violation has been brought into compliance. Scheduled response dates are specified in enforcement actions as the compliance schedule. If a number of activities are to be performed according to a compliance schedule with more than one date, enter the date of the last action to be taken by the handler to return to compliance.
User ID of Last Change	USERID		Records the user identification of the last person to change the violation to enforcement link data.
Date of Last Change	LAST_CHANGE		Records the date that the violation to enforcement link data was last changed.

CSEP3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CEB-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.
Enforcement Activity Location	ENF_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Enforcement Identifier	ENF_IDENTIFIER	CEB-010	Name or number assigned by the implementing agency to identify an enforcement.
Date of Enforcement Action	ENF_ACTION_DATE	CEB-010	Date the enforcement action was issued.
Enforcement Responsible Agency	ENF_AGENCY	CEB-010	Agency responsible for issuing the enforcement action.
SEP Sequence Number	SEP_SEQ	CEB-020	Assigned number uniquely identify each Supplemental Environmental Project (SEP).
SEP Expenditure Amount	EXPENDITURE_AMOUNT	CEB-090, CEB-100	The actual amount of the Supplemental Environmental Project expenditure.
SEP Scheduled Completion Date	SCHEDULED_COMPLETION_DATE	CEB-040, CEB-060, CEB-070, CEB-080	Date set by an enforcement action for the full or partial expenditure of funds for a Supplemental Environmental Project.
SEP Actual Date	ACTUAL_COMPLETION_DATE	CEB-050, CEB-060, CEB-110	The actual date of a Supplemental Environmental Project expenditure.
SEP Defaulted Date	DEFAULTED_DATE	CEB-080, CEB-100, CEB-110, CEB-120	Date that a site defaulted on a Supplemental Environmental Project.
SEP Type Owner	SEP_OWNER	CEB-025	Agency responsible for defining the Supplemental Environmental Project type.
Supplemental Environmental Project (SEP) Type	SEP_TYPE	CEB-030	Code indicating the type of Supplemental Environmental Project associated with the enforcement action. [see nationally-defined values]
User ID of Last Change	USERID		Records the user identification of the last person to change the Supplemental Environmental Project data.
Date of Last Change	LAST_CHANGE		Records the date that the Supplemental Environmental Project data was last changed.
Notes	NOTES		Additional description or information pertaining to the Supplemental Environmental Project.

CSNY_DATE3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CEC-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.
Enforcement Activity Location	ENF_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Enforcement Identifier	ENF_IDENTIFIER	CEC-010	Name or number assigned by the implementing agency to identify an enforcement.
Date of Enforcement Action	ENF_ACTION_DATE	CEC-010	The date the enforcement action was issued.
Enforcement Responsible Agency	ENF_AGENCY	CEC-010	Agency responsible for issuing the enforcement action.
SNY Date	SNY_DATE	CEC-020	Date of the SNY evaluation that this enforcement action is addressing.
User ID of Last Change	USERID		Records the user identification of the last person to change the SNY date data.
Date of Last Change	LAST_CHANGE		Records the date that the SNY date data was last changed.

CPENALTY3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CEE-010, CEE-035	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.
Enforcement Activity Location	ENF_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Enforcement Identifier	ENF_IDENTIFIER	CEE-010	Name or number assigned by the implementing agency to identify an enforcement.
Date of Enforcement Action	ENF_ACTION_DATE	CEE-010	The date the enforcement action was issued.
Enforcement Responsible Agency	ENF_AGENCY	CEE-010	Agency responsible for issuing the enforcement action.
Penalty Type Owner	PENALTY_OWNER	CEE-015	Indicates the agency that defined the Penalty Type. [HQ - Headquarters]
Penalty Type	PENALTY_TYPE	CEE-020, CEE-040, CEE-050, CEE-060, CEE-070, CEE-080, CEE-090, CEE-100, CEE-110	Code indicating the type of penalty associated with the penalty amount. [see nationally-defined values]
Penalty Amount	AMOUNT	CEE-030	The dollar amount associated with the penalty.
User ID of Last Change	USERID		Records the user identification of the last person to change the penalty data.
Date of Last Change	LAST_CHANGE		Records the date that the penalty data was last changed.
Notes	NOTES	CEE-100	Additional description or information pertaining to the penalty.

CPAYMENT3

English Name	Oracle Name	Edit Rule	Description
EPA Handler ID	HANDLER_ID	CEF-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.
Enforcement Activity Location	ENF_ACTIVITY_LOCATION		The location (i.e. State) where the activity took place. [see nationally-defined values]
Enforcement Identifier	ENF_IDENTIFIER	CEF-010	Name or number assigned by the implementing agency to identify an enforcement.
Date of Enforcement Action	ENF_ACTION_DATE	CEF-010	Date the enforcement action was issued.
Enforcement Responsible Agency	ENF_AGENCY	CEF-010	Agency responsible for issuing the enforcement action.
Penalty Type Owner	PENALTY_OWNER	CEF-010	Indicates the agency that defined the Penalty Type. [HQ - Headquarters]
Penalty Type	PENALTY_TYPE	CEF-010	Code indicating the type of penalty associated with the penalty amount. [see nationally-defined values]
Payment Sequence Number	PAYMENT_SEQ	CEF-020	Assigned number uniquely identify each payment.
Payment Defaulted Date	DEFAULTED_DATE	CEF-130, CEF-140	Date that the site defaulted on the penalty payment.
Scheduled Payment Date	SCHEDULED_DATE	CEF-030, CEF-070, CEF-080, CEF-090, CEF-100, CEF-140	Date set by an enforcement action for the full or partial payment of the non-SEP portion of a penalty.
Scheduled Payment Amount	SCHEDULED_AMOUNT	CEF-040, CEF-090	The amount set by an enforcement action for payment on a given day.
Actual Payment Date	PAID_DATE	CEF-050, CEF-070, CEF-120, CEF-130	The actual date for the full or partial non-SEP payment of a penalty, either assessed and/or settled penalty, made by the handler to the responsible agency. This is the date on the check, money order, or other form of payment of penalty by the handler.
Actual Payment Amount	PAID_AMOUNT	CEF-060, CEF-110	The actual dollar amount of the non-SEP payment amount, whether for penalty assessed or for penalty agreed to during settlement.
User ID of Last Change	USERID		Records the user identification of the last person to change the payment data.
Date of Last Change	LAST_CHANGE		Records the date that the payment data was last changed.
Notes	NOTES		Additional description or information pertaining to the payment.