Business rules associated with data in the Corrective Action Module is documented below. All data, whether entered using the user interface or submitted via XML translation must meet these business rules. The business rules are organized by table as found on the structure chart.
|
|
|
Number |
Description |
|
CA-000 |
The ACTIVITY LOCATION must be opted in to participate in Corrective Action translation. (See Documentation / General Help / Application Help / User's Guide / Settings / State Participation) |
|
Number |
Description |
|
CA1-010 |
HANDLER ID must exist in HBASIC. |
|
CA1-020 |
AREA SEQUENCE NUMBER must be greater than zero. |
|
CA1-030 |
ENTIRE FACILITY INDICATOR must be ‘Y’ or ‘N’. |
|
CA1-040 |
There cannot be more than one record for a facility where ENTIRE FACILITY INDICATOR is equal to ‘Y’. |
|
CA1-050 |
AREA NAME must be provided. |
|
CA1-060 |
AIR RELEASE INDICATOR must be ‘Y’, ‘N’, or null. Note: As of June 12, 2020, this data is no longer collected. |
|
CA1-070 |
GROUNDWATER RELEASE INDICATOR must be ‘Y’, ‘N’, or null. Note: As of June 12, 2020, this data is no longer collected. |
|
CA1-080 |
SOIL RELEASE INDICATOR must be ‘Y’, ‘N’, or null. Note: As of June 12, 2020, this data is no longer collected. |
|
CA1-090 |
SURFACE WATER RELEASE INDICATOR must be ‘Y’, ‘N’, or null. Note: As of June 12, 2020, this data is no longer collected. |
|
CA1-100 |
REGULATED UNIT INDICATOR must be ‘Y’, ‘N’, or null. |
|
CA1-105 |
EPA RESPONSIBLE PERSON OWNER must equal the submitter’s agency or null. |
|
CA1-106 |
If EPA RESPONSIBLE PERSON is provided then EPA RESPONSIBLE PERSON OWNER must be provided. If EPA RESPONSIBLE PERSON OWNER is provided then EPA RESPONSIBLE PERSON must be provided. |
|
CA1-110 |
EPA RESPONSIBLE PERSON must be a valid implementer-defined value in LU_STAFF or null. |
|
CA1-115 |
STATE RESPONSIBLE PERSON OWNER must equal the submitter’s agency or null. |
|
CA1-116 |
If STATE RESPONSIBLE PERSON is provided then STATE RESPONSIBLE PERSON OWNER must be provided. If STATE RESPONSIBLE PERSON OWNER is provided then STATE RESPONSIBLE PERSON must be provided. |
|
CA1-120 |
STATE RESPONSIBLE PERSON must be a valid implementer-defined value in LU_STAFF or null. |
| CA1-130 | AREA ACREAGE must be greater than zero or null. |
|
Number |
Description |
|
CA2-010 |
HANDLER ID must exist in HBASIC. |
|
CA2-015 |
AUTHORITY TYPE OWNER must equal ‘HQ’. |
|
CA2-020 |
AUTHORITY TYPE must equal a nationally-defined authority value. |
|
CA2-030 |
AUTHORITY RESPONSIBLE AGENCY must equal ‘E’, ‘S’, or ‘J’. |
|
CA2-040 |
EFFECTIVE DATE must be on or after October 1, 1980 and no later than today. |
|
CA2-050 |
ISSUE DATE must on or before the EFFECTIVE DATE or null. |
|
CA2-060 |
END DATE must be on or after the EFFECTIVE DATE or null. |
|
CA2-070 |
REPOSITORY ESTABLISHED must equal ‘1', ‘2', ‘3', or null. |
|
CA2-080 |
RESPONSIBLE LEAD PROGRAM must equal ‘C’, ‘R’, or null. |
|
CA2-083 |
If the ACTIVITY LOCATION has indicated that the suborganization information is required then SUBORGANIZATION OWNER and SUBORGANIZATION must be provided. |
|
CA2-085 |
SUBORGANIZATION OWNER must equal the submitter’s agency or null. |
|
CA2-086 |
If SUBORGANIZATION is provided then SUBORGANIZATION OWNER must be provided. If SUBORGANIZATION OWNER is provided then SUBORGANIZATION must be provided. |
|
CA2-090 |
SUBORGANIZATION must equal an implementer-defined suborganization value or null. |
|
CA2-093 |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
CA2-095 |
RESPONSIBLE PERSON OWNER must equal the submitter’s agency or null. |
|
CA2-096 |
If RESPONSIBLE PERSON is provided then RESPONSIBLE PERSON OWNER must be provided. If RESPONSIBLE PERSON OWNER is provided then RESPONSIBLE PERSON must be provided. |
|
CA2-100 |
RESPONSIBLE PERSON must equal an implementer-defined responsible person value or null. |
|
CA2-120 |
At least one record must exist in ALN_AUTHORITY_CITATION4 or CA3. |
|
Number |
Description |
|
CA3-010 |
HANDLER ID, AUTHORITY TYPE OWNER, AUTHORITY TYPE, AUTHORITY RESPONSIBLE AGENCY, and EFFECTIVE DATE must exist in AAUTHORITY4 or CA2. |
|
CA3-020 |
STATUTORY OWNER and STATUTORY CITATION must exist in LU_STATUTORY_CITATION. |
|
Number |
Description |
|
CA4-010 |
HANDLER ID must exist in HBASIC. |
|
CA4-015 |
CORRECTIVE ACTION EVENT CODE OWNER must equal the submitter’s agency or ‘HQ’ |
|
CA4-020 |
CORRECTIVE ACTION EVENT CODE must be a valid nationally-defined corrective action event code value or an implementer-defined corrective action event code value. |
|
CA4-030 |
EVENT RESPONSIBLE AGENCY must equal ‘E’, ‘S’, or ‘J’. |
|
CA4-040 |
EVENT SEQUENCE NUMBER must be greater than zero. |
|
CA4-050 |
ACTUAL DATE must be on or after November 8, 1984 and no later than today, or null. |
|
CA4-055 |
ORIGINAL SCHEDULED EVENT DATE must on or after November 8, 1984 or null. |
|
CA4-060 |
NEW SCHEDULED EVENT DATE must be on or after November 8, 1984 or null. |
|
CA4-070 |
If ORIGINAL SCHEDULED EVENT DATE is not provided then ACTUAL DATE must be provided. |
|
CA4-080 |
If ACTUAL DATE is not provided then ORIGINAL SCHEDULED EVENT DATE must be provided. |
|
CA4-083 |
If the ACTIVITY LOCATION has indicated that the suborganization information is required then SUBORGANIZATION OWNER and SUBORGANIZATION must be provided. |
|
CA4-085 |
SUBORGANIZATION OWNER must equal the submitter’s agency or blank. |
|
CA4-086 |
If SUBORGANIZATION is provided then SUBORGANIZATION OWNER must be provided. If SUBORGANIZATION OWNER is provided then SUBORGANIZATION must be provided. |
|
CA4-090 |
SUBORGANIZATION must equal an implementer-defined suborganization value or null. |
|
CA4-093 |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
CA4-095 |
RESPONSIBLE PERSON OWNER must equal the submitter’s agency or null. |
|
CA4-096 |
If RESPONSIBLE PERSON is provided then RESPONSIBLE PERSON OWNER must be provided. If RESPONSIBLE PERSON OWNER is provided then RESPONSIBLE PERSON must be provided. |
|
CA4-100 |
RESPONSIBLE PERSON must equal an implementer-defined responsible person value or null. |
|
CA4-110 |
At least one record must exist in ALN_AREA_EVENT4 or CA5. |
|
CA4-120 |
At least one record must exist in ALN_EVENT_AUTHORITY4 or CA6. |
|
CA4-130 |
If EVENT CODE equals ‘CA770’ , ‘CA772’ or ‘CA550OF’, then NOTES must be provided. |
| CA4-140 | 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. |
| CA4-150 | 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. |
| CA4-160 | 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. |
| CA4-170 | 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 CA990CR event. |
| CA4-180 | 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. |
| CA4-190 | 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. |
| CA4-200 |
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. |
| CA4-210 | 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. |
| CA4-220 | 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. |
| CA4-230 | 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. |
| CA4-240 | 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. |
| CA4-250 | 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. |
| CA4-260 | 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. |
| CA4-270 | 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. |
| CA4-280 | 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. |
| CA4-290 | 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. |
| CA4-300 | 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. |
| CA4-310 | If EVENT CODE equals 'CA222' 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 CA222 event and the ACTUAL DATE of the CA220 event must be on or after the ACTUAL DATE of the CA218 event. |
|
Number |
Description |
|
CA5-010 |
HANDLER ID and AREA SEQUENCE NUMBER must exist in AAREA4 or CA1. |
|
CA5-020 |
HANDLER ID, EVENT CODE OWNER, EVENT CODE, EVENT RESPONSIBLE AGENCY, and EVENT SEQUENCE NUMBER must exist in AEVENT4 or CA4. |
| CA5-030 | If EVENT CODE equals 'CA550NR', 'CA550OF', or 'CA550RC' and ACTUAL DATE in CA4 is not null, the event cannot be linked to an area that is not linked to a 'CA400' event with an ACTUAL DATE. |
| CA5-040 | If EVENT CODE equals 'CA550NR', 'CA550OF', or 'CA550RC' and ACTUAL DATE in CA4 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. |
| CA5-050 | 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. |
| CA5-060 | 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. |
| CA5-070 | If EVENT CODE equals 'CA900NC', the event cannot be linked to an area that is linked to a 'CA770' or 'CA772' event. |
| CA5-080 | 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. |
| CA5-090 | 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. |
| CA5-100 | 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. |
| CA5-110 | 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. |
| CA5-120 | 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. |
| CA5-130 | 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. |
| CA5-140 | 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. |
|
Number |
Description |
|
CA6-010 |
HANDLER ID, EVENT CODE OWNER, EVENT CODE, EVENT RESPONSIBLE AGENCY, and EVENT SEQUENCE NUMBER must exist in AEVENT4 or CA4. |
|
CA6-020 |
HANDLER ID, AUTHORITY TYPE OWNER, AUTHORITY TYPE, AUTHORITY RESPONSIBLE AGENCY, and AUTHORITY EFFECTIVE DATE must exist in AAUTHORITY4 or CA2. |
|
Number |
Description |
|
CA8-010 |
HANDLER ID and AREA SEQUENCE NUMBER must exist in AAREA4 or CA1. |
|
CA8-020 |
HANDLER ID and UNIT SEQUENCE NUMBER must exist in PUNIT4. |