|
Date |
Number |
Change Type |
Change |
|
8/9/2019 |
HD2-880 |
New |
The ACTIVITY LOCATION must be opted into Subpart P to provide Subpart P data. |
|
8/9/2019 |
HD2-890 |
New |
SUBPART P HEALTHCARE FACILITY must equal 'Y' or 'N' if RECEIVE DATE is on or after August 21, 2019. |
|
8/9/2019 |
HD2-900 |
New |
SUBPART P REVERSE DISTRIBUTOR must equal 'Y' or 'N' if RECEIVE DATE is on or after August 21, 2019. |
|
8/9/2019 |
HD2-910 |
New |
SUBPART P WITHDRAWAL must equal 'Y' or 'N' if RECEIVE DATE is on or after August 21, 2019. |
|
8/9/2019 |
HD2-920 |
New |
If SUBPART P HEALTHCARE FACILITY equals 'Y' then SUBPART P REVERSE DISTRIBUTOR must equal 'N'. |
|
8/9/2019 |
HD2-930 |
New |
If SUBPART P REVERSE DISTRIBUTOR equals 'Y' then SUBPART P HEALTHCARE FACILITY must equal 'N'. |
|
8/9/2019 |
HD2-940 |
New |
If SUBPART P WITHDRAWAL equals 'Y' then SUBPART P HEALTHCARE FACILITY must equal 'N' and SUBPART P REVERSE DISTRIBUTOR must equal 'N'. |
|
8/9/2019 |
HD2-390 |
Revised |
MIXED WASTE GENERATOR must be null on or after August 21, 2019. |
|
8/9/2019 |
HD2-640 |
Revised |
If SOURCE TYPE equals 'N', 'A', or 'T' and FEDERAL WASTE GENERATOR CATEGORY equals '1', '2', or '3', or TSD ACTIVITY equals 'Y' or RECYCLER ACTIVITY equals 'Y' or ON-SITE BURNER EXEMPTION equals 'Y' or FURNACE EXEMPTION equals 'Y' or SUBPART P REVERSE DISTRIBUTOR equals 'Y' then there must be at least one linked record in HWASTE_CODE5. |
|
8/9/2019 |
HD2-660 |
Revised |
If LOCATION COUNTRY does not equal 'US' or null then the following activities must equal 'N': FEDERAL WASTE GENERATOR CATEGORY, IMPORTER ACTIVITY, SHORT TERM GENERATOR, MIXED WASTE GENERATOR, TRANSFER FACILITY, TSD ACTIVITY, RECYCLER ACTIVITY, RECYCLER ACTIVITY NON-STORAGE, ON-SITE BURNER EXEMPTION, FURNACE EXEMPTION, UNDERGROUND INJECTION ACTIVITY, UNIVERSAL WASTE DESTINATION FACILITY, USED OIL BURNER, USED OIL TRANSFER FACILITY, USED OIL PROCESSOR, USED OIL REFINER, USED OIL SPECIFICATION MARKETER, USED OIL FUEL MARKETER, SUBPART K COLLEGE, SUBPART K HOSPITAL, SUBPART K NON-PROFIT RESEARCH INSTITUTE, SUBPART K WITHDRAWAL, RECOGNIZED TRADER IMPORTER, RECOGNIZED TRADER EXPORTER, SLAB IMPORTER, SLAB EXPORTER, SUBPART P HEALTHCARE FACILITY, SUBPART P REVERSE DISTRIBUTOR, and SUBPART P WITHDRAWAL. |
|
8/9/2019 |
HD2-750 |
Revised |
If SOURCE TYPE equals 'K' then the following activities must equal 'N': FEDERAL WASTE GENERATOR, SHORT TERM GENERATOR, MIXED WASTE GENERATOR, TSD ACTIVITY, OFF-SITE RECEIPT, RECYCLER ACTIVITY, RECYCLER ACTIVITY NON-STORAGE, ON-SITE BURNER EXEMPTION, FURNACE EXEMPTION, TRANSPORTER, TRANSFER FACILITY, UNDERGROUND INJECTION ACTIVITY, IMPORTER ACTIVITY, RECOGNIZED TRADER IMPORTER, RECOGNIZED TRADER EXPORTER, SLAB IMPORTER, SLAB EXPORTER, UNIVERSAL WASTE DESTINATION FACILITY, USED OIL TRANSPORTER, USED OIL TRANSFER FACILITY, USED OIL PROCESSOR, USED OIL REFINER, USED OIL BURNER, USED OIL MARKET BURNER, USED OIL SPEC MARKETER, SUBPART K COLLEGE, SUBPART K HOSPITAL, SUBPART K NON-PROFIT RESEARCH INSTITUTE, SUBPART K WITHDRAWAL, SUBPART P HEALTHCARE FACILITY, SUBPART P REVERSE DISTRIBUTOR, and SUBPART P WITHDRAWAL. |
|
8/9/2019 |
HDF |
New |
Data for this table cannot be provided on or after August 21, 2019. |
|
11/1/2019 |
HD2-820 |
Revised |
If FEDERAL WASTE GENERATOR CATEGORY does not equal '2', '3', or 'N' then there cannot be any linked records in HEPISODIC_EVENT. |
|
11/1/2019 |
HDL-040 |
New |
If FEDERAL WASTE GENERATOR CATEGORY equals 'N' then WASTE CODE OWNER cannot equal 'HQ'. |
|
1/24/2020 |
HDJ-150 |
New |
Multiple Episodic Events cannot exist where the HANDLER ID, EPISODIC EVENT TYPE OWNER, EPISODIC EVENT TYPE, and START DATE are the same. |
|
2/7/2020 |
HD7-070 |
New |
If UNIVERSAL WASTE OWNER equals 'HQ' and UNIVERSAL WASTE TYPE equals 'K' then the ACTIVITY LOCATION must be opted into Aerosol Cans. |
|
2/7/2020 |
HD7-080 |
New |
If UNIVERSAL WASTE OWNER equals 'HQ' and UNIVERSAL WASTE TYPE equals 'K' then the RECEIVE DATE must be on or after February 7, 2020. |
|
10/30/2020 |
HDJ-030 |
Revised |
If EPISODIC EVENT TYPE equals "P" then a previous event with an EPISODIC EVENT TYPE that equals "P" may not exist where the START DATE of the new event is in the same calendar year of the START DATE of the previous event. |
|
10/30/2020 |
HDJ-040 |
Revised |
If EPISODIC EVENT TYPE equals "U" then a previous event with an EPISODIC EVENT TYPE that equals "U" may not exist where the START DATE of the new event is in the same calendar year of the START DATE of the previous event. |
|
10/30/2020 |
HDJ-050 |
Deleted |
If EPISODIC EVENT TYPE equals 'POT' or 'UOT' then OTHER EVENT DESCRIPTION must be provided. |
|
10/30/2020 |
HDJ-060 |
Deleted |
If EPISODIC EVENT TYPE equals 'POT' or 'UOT' then OTHER EVENT DESCRIPTION must be provided. |
|
10/30/2020 |
HDJ-150 |
New |
There must be at least one linked record in HEPISODIC_PROJECT. |
|
10/30/2020 |
HDM-005 |
New |
The ACTIVITY LOCATION must be opted into Episodic Generation to provide episodic generation data. |
|
10/30/2020 |
HDM-010 |
New |
HANDLER ID, ACTIVITY LOCATION, SOURCE TYPE, and SEQ NUMBER must exist in HEPISODIC_EVENT. |
|
10/30/2020 |
HDM-020 |
New |
PROJECT CODE OWNER must equal 'HQ'. |
|
10/30/2020 |
HDM-030 |
New |
PROJECT CODE must equal a nationally-defined episodic event project code value. |
|
10/30/2020 |
HDM-040 |
New |
If PROJECT CODE equals 'POT' or 'UOT' then OTHER PROJECT DESCRIPTION must be provided. |
|
10/30/2020 |
HDM-050 |
New |
If PROJECT CODE is not equal to 'POT' or 'UOT' then OTHER PROJECT DESCRIPTION cannot be provided. |
|
10/30/2020 |
HDM-060 |
New |
If EPISODIC EVENT TYPE in HEPISODIC_EVENT = 'P' then PROJECT CODE must start with a 'P'. If EPISODIC EVENT TYPE in HEPISODIC_EVENT = 'U' then PROJECT CODE must start with a 'U'. |
|
10/30/2020 |
HD2-075 |
New |
Prior to 10/30/2020: LOCATION GIS PRIMARY must equal 'N'. 10/30/2020 - Today: LOCATION GIS PRIMARY must equal 'Y' or 'N'. |
|
10/30/2020 |
HD2-080 |
Revised |
Prior to 10/30/2020: LOCATION STREET 1 must be provided. 10/30/2020 - Today: If LOCATION GIS PRIMARY equals 'N' then LOCATION STREET 1 must be provided. |
|
10/30/2020 |
HD2-090 |
Revised |
Prior to 10/30/2020: LOCATION CITY must be provided. 10/30/2020 - Today: If LOCATION GIS PRIMARY equals 'N' then LOCATION CITY must be provided. |
|
10/30/2020 |
HD2-100 |
Revised |
Prior to 10/30/2020 If LOCATION COUNTRY equals 'US' or null and the first two characters of HANDLER ID equal 'NN' then LOCATION STATE must equal a nationally-defined state value. If LOCATION COUNTRY equals 'US' or null and the first two characters of HANDLER ID do not equal 'NN' then LOCATION STATE must equal the first two characters of HANDLER ID. 10/30/2020 - Today If LOCATION GIS PRIMARY equals 'N' and LOCATION COUNTRY equals 'US' or null and the first two characters of HANDLER ID equal 'NN' then LOCATION STATE must equal a nationally-defined state value. If LOCATION GIS PRIMARY equals 'N' and LOCATION COUNTRY equals 'US' or null and the first two characters of HANDLER ID do not equal 'NN' then LOCATION STATE must equal the first two characters of HANDLER ID. |
|
10/30/2020 |
HD2-120 |
Revised |
Prior to 10/30/2020: LOCATION ZIP must be provided. 10/30/2020 - Today: If LOCATION GIS PRIMARY equals 'N' then LOCATION ZIP must be provided. |
|
10/30/2020 |
HD2-130 |
Revised |
Prior to 10/30/2020 If LOCATION COUNTRY equals 'US' or null then LOCATION COUNTY CODE must equal a nationally-defined county value. If LOCATION COUNTRY is not equal to 'US' or null then LOCATION COUNTY CODE must be null. 10/30/2020 - Today If LOCATION GIS PRIMARY equals 'N' and LOCATION COUNTRY equals 'US' or null then LOCATION COUNTY CODE must equal a nationally-defined county value. If LOCATION GIS PRIMARY equals 'N' and LOCATION COUNTRY is not equal to 'US' or null then LOCATION COUNTY CODE must be null. |
|
10/30/2020 |
HD2-142 |
New |
Prior to 10/30/2020: LOCATION LATITUDE must be null. 10/30/2020 - Today If LOCATION GIS PRIMARY equals 'Y' then LOCATION LATITUDE must be between 0 and 90. If LOCATION GIS PRIMARY equals 'N' then LOCATION LATITUDE must be between 0 and 90 or null. |
|
10/30/2020 |
HD2-144 |
New |
Prior to 10/30/2020: LOCATION LONGITUDE must be null. 10/30/2020 - Today If LOCATION GIS PRIMARY equals 'Y' then LOCATION LONGITUDE must be between -180 and -60. If LOCATION GIS PRIMARY equals 'N' then LOCATION LONGITUDE must be between -180 and -60 or null. |
|
10/30/2020 |
HD2-146 |
New |
If LOCATION LATITUDE is provided then LOCATION LONGITUDE must be provided. If LOCATION LONGITUDE is provided then LOCATION LATITUDE must be provided. |
|
12/4/2020 |
HD2-790 |
Revised |
If SOURCE TYPE equals 'E', 'D', or 'K' then there cannot be any linked records in HLQG_CLOSURE. |
|
4/26/2021 |
HD2-032 |
New |
If HANDLER ID, ACTIVITY LOCATION, SOURCE TYPE, SEQUENCE NUMBER exist in HHANDLER5, then RECEIVE DATE must be within 30 days of the original RECEIVE DATE. |
|
4/26/2021 |
HD2-144 |
Revised |
If the first two characters of HANDLER ID do not equal 'AK' or 'XJ' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LONGITUDE must be between -180 and -60. If the first two characters of HANDLER ID equal 'AK' or 'XJ' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LONGITUDE must be between -180 and 180. If the first two characters of HANDLER ID do not equal 'AK' or 'XJ' and LOCATION GIS PRIMARY equals 'N' then LOCATION LONGITUDE must be between -180 and -60 or null. If the first two characters of HANDLER ID equal 'AK' or 'XJ' and LOCATION GIS PRIMARY equals 'N' then LOCATION LONGITUDE must be between -180 and 180 or null. |
|
7/28/2021 |
HD2-142 |
Revised |
If the first two characters of HANDLER ID do not equal 'AS' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LATITUDE must be between 0 and 90. If the first two characters of HANDLER ID equal 'AS' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LATITUDE must be between -15 and 90. If the first two characters of HANDLER ID do not equal 'AS' and LOCATION GIS PRIMARY equals 'N' then LOCATION LATITUDE must be between 0 and 90 or null. If the first two characters of HANDLER ID equal 'AS' and LOCATION GIS PRIMARY equals 'N' then LOCATION LATITUDE must be between -15 and 90 or null. |
|
7/28/2021 |
HD2-144 |
Revised |
If the first two characters of HANDLER ID do not equal 'AK', 'AS', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LONGITUDE must be between -180 and -60. If the first two characters of HANDLER ID equal 'AK', 'AS', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LONGITUDE must be between -180 and 180. If the first two characters of HANDLER ID do not equal 'AK', 'AS', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'N' then LOCATION LONGITUDE must be between -180 and -60 or null. If the first two characters of HANDLER ID equal 'AK', 'AS', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'N' then LOCATION LONGITUDE must be between -180 and 180 or null. |
| 4/14/2023 | HD2-950 | New | If RECYCLER ACTIVITY equals 'Y' then OFF-SITE RECEIPT must equal 'Y'. |
| 4/14/2023 | HD2-960 | New | If RECYCLER ACTIVITY NON-STORAGE equals 'Y' then OFF-SITE RECEIPT must equal 'Y'. |
| 6/2/2023 | HD-000 | New | The ACTIVITY LOCATION must be opted in to participate in Handler translation. |
| 1/12/2024 | HD2-970 | New | CONTACT PREFERRED LANGUAGE must equal a nationally-defined language value or null. If CONTACT PREFERRED LANGUAGE is null, a value of 'EN' will be assumed. |
| 1/12/2024 | HDN-010 | New | HANDLER ID, ACTIVITY LOCATION, SOURCE TYPE, and SEQ NUMBER must exist in HHANDLER5. |
| 1/12/2024 | HDN-020 | New | ADDITIONAL CONTACT SEQUENCE NUMBER must be greater than zero. |
| 1/12/2024 | HDN-025 | New | ADDITIONAL CONTACT TYPE OWNER must equal 'HQ' or the ACTIVITY LOCATION of the site. |
| 1/12/2024 | HDN-030 | New | ADDITIONAL CONTACT TYPE must equal a nationally-defined contact type value or an implementer-defined contact type value. |
| 1/12/2024 | HDN-040 | New | ADDITIONAL CONTACT FIRST NAME must be provided. |
| 1/12/2024 | HDN-050 | New | ADDITIONAL CONTACT LAST NAME must be provided. |
| 1/12/2024 | HDN-060 | New | ADDITIONAL CONTACT PHONE must be provided. |
| 1/12/2024 | HDN-070 | New | If ADDITIONAL CONTACT COUNTRY equals 'US' or null then ADDITIONAL CONTACT PHONE must be formatted as 9999999999 or 999-999-9999. |
| 1/12/2024 | HDN-080 | New | If ADDITIONAL CONTACT COUNTRY equals 'US' or null then ADDITIONAL CONTACT FAX must be formatted as 9999999999 or 999-999-9999. |
| 1/12/2024 | HDN-090 | New | If ADDITIONAL CONTACT COUNTRY equals 'US' or null then ADDITIONAL CONTACT ZIP must be formatted as 99999, 999999999, or 99999-9999. |
| 1/12/2024 | HDN-100 | New | If ADDITIONAL CONTACT COUNTRY equals 'US' or null then ADDITIONAL CONTACT STATE must equal a nationally-defined state value or null. |
| 1/12/2024 | HDN-110 | New | If ADDITIONAL CONTACT COUNTRY is not equal to 'US' or null then ADDITIONAL CONTACT STATE must equal a nationally-defined foreign state value or null. |
| 1/12/2024 | HDN-120 | New | ADDITIONAL CONTACT COUNTRY must equal a nationally-defined country value or null. If ADDITIONAL CONTACT COUNTRY is null, a value of 'US' will be assumed. |
| 1/12/2024 | HDN-130 | New | If ADDITIONAL CONTACT EMAIL is provided it must be formatted as X@X.AA where X is an alphanumeric character (including some special characters) and A is an alpha character. |
| 1/12/2024 | HDN-140 | New | ADDITIONAL CONTACT PREFERRED LANGUAGE must equal a nationally-defined language value or null. If ADDITIONAL CONTACT PREFERRED LANGUAGE is null, a value of 'EN' will be assumed. |
|
Date |
Number |
Change Type |
Change |
|
4/15/2019 |
CE1-133 |
New |
If the ACTIVITY LOCATION has indicated that the suborganization information is required then SUBORGANIZATION OWNER and SUBORGANIZATION must be provided |
|
4/15/2019 |
CE1-143 |
New |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
4/15/2019 |
CE1-230 |
Revised |
If EVALUATION TYPE is not equal to ‘FCI’ or 'NRR' then FOCUS AREA must be null. |
|
4/15/2019 |
CE1-240 |
New |
If NOC DATE is provided then FOUND VIOLATION must equal 'N' or FOUND VIOLATION must equal 'Y' and all violations linked to this evaluation must have an RTC ACTUAL DATE. |
|
4/15/2019 |
CE1-250 |
New |
NOC DATE must be on or after the EVALUATION START DATE and no later than today, or null. |
|
4/15/2019 |
CE1-260 |
New |
If the EVALUATION TYPE is a follow up evaluation then a non-follow up evaluation occurring on or before the followup evaluation must exist. |
|
4/15/2019 |
CE1-265 |
New |
If EVALUATION TYPE is equal to ‘NRR’ THEN FOCUS AREA OWNER must equal ‘HQ’, the entity (State or Region) associated with the submitter, or null. |
|
4/15/2019 |
CE1-270 |
New |
If the EVALUATION TYPE is equal to 'NRR' then FOCUS AREA must equal a nationally-defined focus area value, an implementer-defined focus area value where the focus area applies to an 'NRR' evaluation, or null. |
|
4/15/2019 |
CE1-280 |
New |
If EVALUATION TYPE = 'SNN' then an 'SNY' evaluation with the same RESPONSIBLE AGENCY as the 'SNN' occurring on or before the 'SNN' evaluation must exist. |
|
4/15/2019 |
CE1-290 |
New |
If EVALUATION TYPE = 'SNY' then an 'SNY' evaluation with the same ACTIVITY LOCATION, RESPONSIBLE AGENCY, and EVALUATION START DATE cannot exist. |
|
4/15/2019 |
CE8-023 |
New |
If the ACTIVITY LOCATION has indicated that the suborganization information is required then SUBORGANIZATION OWNER and SUBORGANIZATION must be provided. |
|
4/15/2019 |
CE8-033 |
New |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
4/15/2019 |
CE8-085 |
New |
FINANCIAL ASSURANCE REQUIREMENT INDICATOR must equal 'Y' or 'N'. |
|
7/12/2019 |
CE4-130 |
New |
If AGENCY WHICH DETERMINED THE VIOLATION is equal to 'E' then VIOLATION TYPE cannot equal 'XXS'. |
| 7/1/2022 | CE4-140 | New | DATE DETERMINED must be on or after the earliest EVALUATION START DATE in CEVALUATION3 that is linked to this violation. |
| 6/2/2023 | CE-000 | New | The ACTIVITY LOCATION must be opted in to participate in CM&E translation. |
|
Date |
Number |
Change Type |
Change |
| 6/2/2023 | CA-000 | New | The ACTIVITY LOCATION must be opted in to participate in Corrective Action translation. |
| 1/12/2024 | CA4-140 | New | If EVENT CODE equals 'CA550NR', 'CA550OF', or 'CA550RC' and ACTUAL DATE is not null, then an event with an EVENT CODE equal to 'CA400' with an ACTUAL DATE must exist that is linked to the same areas as the CA550 event. |
| 1/12/2024 | CA4-150 | New | If EVENT CODE equals 'CA550NR', 'CA550OF', or CA550RC' and ACTUAL DATE is null, then an event with an EVENT CODE equal to 'CA400' with an ACTUAL DATE or ORIGINAL SCHEDULED EVENT DATE must exist that is linked to the same areas as the CA550 event. |
| 1/12/2024 | CA5-030 | New | If EVENT CODE equals 'CA550NR', 'CA550OF', or 'CA550RC' and ACTUAL DATE is not null, the event cannot be linked to an area that is not linked to a 'CA400' event with an ACTUAL DATE. |
| 1/12/2024 | CA5-040 | New | If EVENT CODE equals 'CA550NR', 'CA550OF', or 'CA550RC' and ACTUAL DATE is null, the event cannot be linked to an area that is not linked to a 'CA400' event with an ACTUAL DATE or ORIGINAL SCHEDULED EVENT DATE. |
| 9/20/2024 | CA4-160 | New | If EVENT CODE equals 'CA900CR' and ACTUAL DATE is not null, then an event with an EVENT CODE starting with 'CA770' or 'CA772' with an ACTUAL DATE must exist that is linked to the same areas as the CA900CR event. |
| 9/20/2024 | CA4-170 | New | If EVENT CODE equals 'CA900CR' and ACTUAL DATE is null, then an event with an EVENT CODE starting with 'CA770' or 'CA772' with an ACTUAL DATE or ORIGINAL SCHEDULED EVENT DATE must exist that is linked to the same areas as the CA900CR event. |
| 9/20/2024 | CA4-180 | New | If EVENT CODE equals 'CA900NC', then an event with an EVENT CODE starting with 'CA770' or 'CA772' that is linked to the same areas as the CA900NC event cannot exist. |
| 9/20/2024 | CA4-190 | New | If EVENT CODE starts with 'CA770' or 'CA772', then an event with an EVENT CODE equal to 'CA900NC' that is linked to the same areas as the CA770 or CA772 event cannot exist. |
| 9/20/2024 | CA4-200 | New | If EVENT CODE starts with 'CA900' or 'CA999' and the ACTUAL DATE is not null, then the ACTUAL DATE must be on or after the latest ACTUAL DATE of all events with an EVENT CODE starting with 'CA770' or 'CA772' that are linked to the same areas as the CA900 or CA999 event. |
| 9/20/2024 | CA4-210 | New | If EVENT CODE starts with 'CA900' or 'CA999' and the ACTUAL DATE is null, then the SCHEDULED EVENT DATE (Original or New, if provided) must be on or after the latest ACTUAL DATE or SCHEDULED EVENT DATE of all events with an EVENT CODE starting with 'CA770' or 'CA772' that are linked to the same areas as the CA900 or CA999 event. |
| 9/20/2024 | CA4-220 | New | If EVENT CODE starts with 'CA770' or 'CA772' and the ACTUAL DATE is not null, then the ACTUAL DATE must be on or before the earliest ACTUAL DATE of all events with an EVENT CODE starts with 'CA990' or 'CA999' that are linked to the same areas as the CA770 or CA772 event. |
| 9/20/2024 | CA4-230 | New | If EVENT CODE starts with 'CA770' or 'CA772' and the ACTUAL DATE is null, then the SCHEDULED EVENT DATE (Original or New, if provided) must be on or before the earliest ACTUAL DATE or SCHEDULED EVENT DATE of all events with an EVENT CODE starting with 'CA900' or 'CA999' that are linked to the same areas as the CA770 or CA772 event. |
| 9/20/2024 | CA4-240 | New | If EVENT CODE equals 'CA800YE' and ACTUAL DATE is not null, then an event with EVENT CODE equal to 'CA725YE' with an ACTUAL DATE must exist that is linked to the same areas as the CA800YE event. |
| 9/20/2024 | CA4-250 | New | If EVENT CODE equals 'CA550OF' and ACTUAL DATE is not null, then an event with EVENT CODE equal to 'CA725YE' with an ACTUAL DATE must exist that is linked to the same areas as the CA550OF event. |
| 9/20/2024 | CA4-050 | Revised | ACTUAL DATE must be on or after November 8, 1984 and no later than today, or null. |
| 9/20/2024 | CA4-055 | Revised | ORIGINAL SCHEDULED EVENT DATE must on or after November 8, 1984 or null. |
| 9/20/2024 | CA4-060 | Revised | NEW SCHEDULED EVENT DATE must be on or after November 8, 1984 or null. |
| 9/20/2024 | CA5-050 | New | If EVENT CODE equals 'CA900CR' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA770' or 'CA772' event with an ACTUAL DATE. |
| 9/20/2024 | CA5-060 | New | If EVENT CODE equals 'CA900CR' and ACTUAL DATE in CA4 is null, the event cannot be linked to an area that is not linked to a 'CA770' or 'CA772' event with an ACTUAL DATE or ORIGINAL SCHEDULED EVENT DATE. |
| 9/20/2024 | CA5-070 | New | If EVENT CODE equals 'CA900NC', the event cannot be linked to an area that is linked to a 'CA770' or 'CA772' event. |
| 9/20/2024 | CA5-080 | New | If EVENT CODE equals 'CA800YE' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA725YE' event with an ACTUAL DATE. |
| 9/20/2024 | CA5-090 | New | If EVENT CODE equals 'CA550OF' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA725YE' event with an ACTUAL DATE. |
| 1/10/2025 | CA1-130 | New | AREA ACREAGE must be greater than zero or null. |
| 4/4/2025 | CA4-260 | New | If EVENT CODE equals 'CA208' and ACTUAL DATE is not null, then an event with EVENT CODE equal to 'CA206' with an ACTUAL DATE must exist that is linked to the same areas as the CA208 event and the ACTUAL DATE of the CA208 event must be on or after the ACTUAL DATE of the CA206 event. |
| 4/4/2025 | CA4-270 | New | If EVENT CODE equals 'CA218' and ACTUAL DATE is not null, then an event with EVENT CODE equal to 'CA216' with an ACTUAL DATE must exist that is linked to the same areas as the CA218 event and the ACTUAL DATE of the CA218 event must be on or after the ACTUAL DATE of the CA216 event. |
| 4/4/2025 | CA4-280 | New | If EVENT CODE equals 'CA210' and ACTUAL DATE is not null, then an event with EVENT CODE equal to 'CA208' with an ACTUAL DATE must exist that is linked to the same areas as the CA210 event and the ACTUAL DATE of the CA210 event must be on or after the ACTUAL DATE of the CA208 event. |
| 4/4/2025 | CA4-290 | New | If EVENT CODE equals 'CA212' and ACTUAL DATE is not null, then an event with EVENT CODE equal to 'CA208' with an ACTUAL DATE must exist that is linked to the same areas as the CA212 event and the ACTUAL DATE of the CA212 event must be on or after the ACTUAL DATE of the CA208 event. |
| 4/4/2025 | CA4-300 | New | If EVENT CODE equals 'CA220' and ACTUAL DATE is not null, then an event with EVENT CODE equal to 'CA218' with an ACTUAL DATE must exist that is linked to the same areas as the CA220 event and the ACTUAL DATE of the CA220 event must be on or after the ACTUAL DATE of the CA218 event. |
| 4/4/2025 | CA5-100 | New | If EVENT CODE equals 'CA208' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA206' event with an ACTUAL DATE. |
| 4/4/2025 | CA5-110 | New | If EVENT CODE equals 'CA218' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA216' event with an ACTUAL DATE. |
| 4/4/2025 | CA5-120 | New | If EVENT CODE equals 'CA210' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA208' event with an ACTUAL DATE. |
| 4/4/2025 | CA5-130 | New | If EVENT CODE equals 'CA212' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA208' event with an ACTUAL DATE. |
| 4/4/2025 | CA5-140 | New | If EVENT CODE equals 'CA220' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA218' event with an ACTUAL DATE. |
|
Date |
Number |
Change Type |
Change |
|
12/6/2019 |
PM1-033 |
New |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE_PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
12/6/2019 |
PM1-060 |
New |
ACTIVE SERIES must equal 'Y' or 'N'. |
|
12/6/2019 |
PM2-030 |
Revised |
PERMIT EVENT RESPONSIBLE AGENCY must equal 'E', 'S', 'J', or 'P'. |
|
12/6/2019 |
PM2-093 |
New |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE_PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
12/6/2019 |
PM2-103 |
New |
If the ACTIVITY LOCATION has indicated that the suborganization information is required then SUBORGANIZATION OWNER and SUBORGANIZATION must be provided. |
|
12/6/2019 |
PM2-130 |
New |
If MODIFICATION TYPE in LU_PERMIT_EVENT_CODE equals 'Subsequent' for the EVENT CODE OWNER and EVENT CODE then HANDLER ID, SERIES SEQUENCE NUMBER, EVENT SEQUENCE NUMBER, EVENT AGENCY, EVENT CODE OWNER, and EVENT CODE must exist in PLN_MOD_EVENT. |
|
12/6/2019 |
PM3-050 |
New |
ACTIVE UNIT must equal 'Y' or 'N'. |
|
12/6/2019 |
PM4-110 |
New |
If LEGAL/OPERATING STATUS is STRANGE BUT TRUE, then NOTES must be provided. |
|
12/6/2019 |
PM8-010 |
New |
MODIFICATION REQUEST HANDLER ID must equal SUBSEQUENT EVENT HANDLER ID. |
|
12/6/2019 |
PM8-020 |
New |
MODIFICATION REQUEST PERMIT EVENT OWNER and MODIFICATION REQUEST PERMIT EVENT CODE must equal a nationally-defined permit event code value or implementer-defined permit event code value where MODIFICATION TYPE = 'Request'. |
|
12/6/2019 |
PM8-030 |
New |
MODIFICATION REQUEST HANDLER ID, MODIFICATION REQUEST SERIES SEQUENCE NUMBER, MODIFICATION REQUEST EVENT SEQUENCE NUMBER, MODIFICATION REQUEST EVENT RESPONSIBLE AGENCY, MODIFICATION REQUEST PERMIT EVENT OWNER, AND MODIFICATION REQUEST PERMIT EVENT CODE must exist in PEVENT4. |
|
12/6/2019 |
PM8-040 |
New |
SUBSEQUENT EVENT PERMIT EVENT OWNER AND SUBSEQUENT EVENT PERMIT EVENT CODE must equal a nationally-defined permit event code value or implementer-defined permit event code value where MODIFICATION TYPE = 'Subsequent'. |
|
12/6/2019 |
PM8-050 |
New |
SUBSEQUENT EVENT HANDLER ID, SUBSEQUENT EVENT SERIES SEQUENT NUMBER, SUBSEQUENT EVENT EVENT SEQUENCE NUMBER, SUBSEQUENT EVENT EVENT RESPONSIBLE AGENCY, SUBSEQUENT EVENT PERMIT EVENT OWNER, AND SUBSEQUENT EVENT PERMIT EVENT CODE must exist in PEVENT4. |
|
12/19/2019 |
PM2-130 |
Revised |
If MODIFICATION TYPE in LU_PERMIT_EVENT_CODE equals 'Subsequent' for the EVENT CODE OWNER and EVENT CODE and the was created on or after December 6, 2019 then HANDLER ID, SERIES SEQUENCE NUMBER, EVENT SEQUENCE NUMBER, EVENT AGENCY, EVENT CODE OWNER, and EVENT CODE must exist in PLN_MOD_EVENT. |
| 6/23/2022 | PM2-140 | New | If PERMIT EVENT CODE equals 'OP316NO' or 'PC316NO' then NOTES must be provided. |
| 6/2/2023 | PM-000 | New | The ACTIVITY LOCATION must be opted in to participate in Permitting translation. |
|
Date |
Number |
Change Type |
Change |
|
9/11/2020 |
FA1-045 |
New |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
9/11/2020 |
FA1-100 |
Deleted |
COST ESTIMATE REASON must equal ‘S’, ‘A’, ‘I’, ‘R’, ‘C’, ‘F’, ‘L’, ‘N’, ‘P’, ‘T’, ‘V’, ‘X’, or ‘W’. |
|
11/12/2021 |
FA1-090 |
Revised |
COST ESTIMATE DATE must be on or after October 1, 1980 and no later than today. (removed If FINANCIAL ASSURANCE TYPE equals ‘C’, ‘P’, or ‘A’ Then) |
|
11/12/2021 |
FA1-095 |
Deleted |
If FINANCIAL ASSURANCE TYPE equals ‘S’, ‘N’, or ‘B’ Then COST ESTIMATE DATE must be on or after October 1, 1980 and no later than today or null. |
|
11/12/2021 |
FA1-240 |
New |
UPDATE DUE DATE must be after the COST ESTIMATE DATE or null. |
|
11/12/2021 |
FA2-100 |
New |
ACTIVE MECHANISM must equal 'Y' or 'N'. |
|
11/12/2021 |
FA2-110 |
New |
If PROVIDER CONTACT EMAIL is provided it must be formatted as X@X.AA where X is an alphanumeric character (including some special characters) and A is an alpha character. |
|
11/12/2021 |
FA3-040 |
New |
FACILITY FACE VALUE AMOUNT must be greater than or equal to zero. |
|
11/12/2021 |
FA3-050 |
New |
FACE VALUE AMOUNT must be greater than or equal to FACILITY FACE VALUE AMOUNT. |
|
11/12/2021 |
FA3-090 |
New |
If MECHANISM TYPE equals 'F' or 'C' then ALTERNATIVE must equal '1' or '2'. |
| 6/2/2023 | FA-000 | New | The ACTIVITY LOCATION must be opted in to participate in Financial Assurance translation. |
|
Date |
Number |
Change Type |
Change |
|
6/2/2023 |
GS-000 |
New |
The ACTIVITY LOCATION must be opted in to participate in GIS translation. |
| 1/10/2025 | GS1-XXX | Deleted | Removed all business rules associated with GIS4. |
| 1/10/2025 | GS2-XXX | Deleted | Removed all business rules associated with GIS_LAT_LONG4. |
| 1/10/2025 | GS1-XXX | New | Created all business rules associated with GIS_FEATURE. |
|
Date |
Number |
Change Type |
Change |
|
2/1/2021 |
SI1-730 |
New |
If LOCATION GIS PRIMARY equals 'N' and LOCATION LATITUDE is provided then LOCATION LATITUDE must be between 0 and 90. |
|
2/1/2021 |
SI1-740 |
New |
If LOCATION GIS PRIMARY equals 'N' and LOCATION LONGITUDE is provided then LOCATION LONGITUDE must be between -180 and -60. |
|
6/16/2021 |
SI1-750 |
New |
BR EXEMPT must equal 'Y' or 'N'. Note: For the 2021 cycle, if this field is null, a value of 'N' will be assumed. |
|
6/16/2021 |
SI1-760 |
New |
If BR EXEMPT equals 'Y' then GM1 data cannot be provided. |
|
6/16/2021 |
SI1-770 |
New |
If BR EXEMPT equals 'Y' then WR1 data cannot be provided. |
|
6/16/2021 |
SI1-780 |
New |
If BR EXEMPT equals 'Y' then OI1 data cannot be provided. |
|
6/16/2021 |
SI1-790 |
New |
If BR EXEMPT equals 'Y' then PUBLIC NOTES must be provided. |
|
7/28/2021 |
SI1-710 |
Revised |
If the first two characters of HANDLER ID do not equal 'AK', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LONGITUDE must be between -180 and -60 If the first two characters of HANDLER ID equal 'AK', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'Y' then LOCATION LONGITUDE must be between -180 and 180 |
|
7/28/2021 |
SI1-740 |
Revised |
If the first two characters of HANDLER ID do not equal 'AK', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'N' and LOCATION LONGITUDE is provided then LOCATION LONGITUDE must be between -180 and -60 If the first two characters of HANDLER ID equal 'AK', 'GU', 'MP', 'TT', 'XI', or 'XJ' and LOCATION GIS PRIMARY equals 'N' and LOCATION LONGITUDE is provided then LOCATION LONGITUDE must be between -180 and 180 |
|
8/11/2021 |
GM2-030 |
New |
EPA WASTE CODE may only equal 'PHRM' if the SOURCE CODE equals 'G61' and the FORM CODE equals 'W005'. |
|
8/11/2021 |
WR2-030 |
New |
EPA WASTE CODE may only equal 'PHRM' if the FORM CODE equals 'W005'. |
| 8/12/2021 | GM4-035 | Revised | EPA ID NUMBER OF THE FACILITY TO WHICH WASTE WAS SHIPPED cannot equal ‘VARIOUS’, ‘MISC’, ‘MANY’, 'MEXICO', or 'CANADA'. |
|
Date |
Number |
Change Type |
Change |
|
3/28/2023 |
SI1-800 |
New |
If RECYCLER ACTIVITY equals 'Y' then OFF-SITE RECEIPT must equal 'Y'. |
|
3/8/2023 |
SI1-810 |
New |
If RECYCLER ACTIVITY NON-STORAGE equals 'Y' then OFF-SITE RECEIPT must equal 'Y'. |