|
***WARNING*** The data (primarily notes / comments) may contain line feeds, carriage returns, and/or end of transmission blocks. These need to be ignored when uploading your data. ***WARNING*** |
The CSV file specifications associated with the tables in the Compliance, Monitoring, and Enforcement Module are documented, by table, below.
|
English Name |
Excel Column |
Field Length |
Data Type |
| EPA Handler ID | A |
12 |
Alphanumeric |
| Evaluation Activity Location | B |
2 |
Alphanumeric |
| Evaluation Identifier | C |
3 |
Alphanumeric |
| Evaluation Start Date | D |
8 |
Date (YYYYMMDD) |
| Evaluation Responsible Agency | E |
1 |
Alphanumeric |
| Found Violation | F |
1 |
Alphanumeric |
|
Citizen Complaint Indicator |
G |
1 |
Alphanumeric |
|
Multimedia Indicator |
H |
1 |
Alphanumeric |
| Sampling Indicator | I |
1 |
Alphanumeric |
| Not Subtitle C Indicator | J |
1 |
Alphanumeric |
| Evaluation Type | K |
3 |
Alphanumeric |
| Evaluation Type Description | L |
80 |
Alphanumeric |
| Focus Area | M |
3 |
Alphanumeric |
| Focus Area Description | N |
80 |
Alphanumeric |
| Evaluation Responsible Person Identifier | O |
5 |
Alphanumeric |
| Evaluation Responsible Suborganization | P |
10 |
Alphanumeric |
| Handler Activity Location | Q |
2 |
Alphanumeric |
| Handler Name | R |
80 |
Alphanumeric |
| Region | S |
2 |
Alphanumeric |
| State | T |
2 |
Alphanumeric |
| Land Type | U |
1 |
Alphanumeric |
| Request Sequence | V |
6 |
Integer |
| Date of Request | W |
8 |
Date (YYYYMMDD) |
| Date Response Received | X |
8 |
Date (YYYYMMDD) |
| Request Agency | Y |
1 |
Alphanumeric |
| Request Activity Location | Z |
2 |
Alphanumeric |
| Violation Activity Location | AA |
2 |
Alphanumeric |
| Violation Sequence Number | AB |
4 |
Integer |
| Agency Which Determined Violation | AC |
1 |
Alphanumeric |
| Violation Type | AD |
10 |
Alphanumeric |
| Violation Short Description | AE |
50 |
Alphanumeric |
| Former Citation | AF |
35 |
Alphanumeric |
| Date Violation Was Determined | AG |
8 |
Date (YYYYMMDD) |
| Actual Return to Compliance Date | AH |
8 |
Date (YYYYMMDD) |
| Return to Compliance Qualifier | AI |
1 |
Alphanumeric |
| Violation Responsible Agency | AJ |
1 |
Alphanumeric |
| Scheduled Compliance Date | AK |
8 |
Date (YYYYMMDD) |
| Enforcement Activity Location | AL |
2 |
Alphanumeric |
| Enforcement Identifier | AM |
12 |
Alphanumeric |
| Date of Enforcement Action | AN |
8 |
Date (YYYYMMDD) |
| Enforcement Responsible Agency | AO |
1 |
Alphanumeric |
| Enforcement Docket Number | AP |
15 |
Alphanumeric |
| Enforcement Attorney | AQ |
5 |
Alphanumeric |
| Corrective Action Component | AR |
1 |
Alphanumeric |
| Appeal Initiated Date | AS |
8 |
Date (YYYYMMDD) |
| Appeal Resolution Date | AT |
8 |
Date (YYYYMMDD) |
| Disposition Status Date | AU |
8 |
Date (YYYYMMDD) |
| Disposition Status | AV |
2 |
Alphanumeric |
| Disposition Status Description | AW |
80 |
Alphanumeric |
| Consent Agreement/Final Order (CA/FO) Sequence Number | AX |
6 |
Integer |
| CA/FO Respondent Name | AY |
200 |
Alphanumeric |
| CA/FO Lead Agency | AZ |
2 |
Alphanumeric |
| Enforcement Type | BA |
3 |
Alphanumeric |
| Enforcement Type Description | BB |
80 |
Alphanumeric |
| Enforcement Responsible Person | BC |
5 |
Alphanumeric |
| Enforcement Responsible Suborganization | BD |
10 |
Alphanumeric |
| SEP Sequence Number | BE |
2 |
Integer |
| SEP Expenditure Amount | BF |
13 |
Number |
| SEP Scheduled Completion Date | BG |
8 |
Date (YYYYMMDD) |
| SEP Actual Date | BH |
8 |
Date (YYYYMMDD) |
| SEP Defaulted Date | BI |
8 |
Date (YYYYMMDD) |
| Supplemental Environmental Project (SEP) Type | BJ |
3 |
Alphanumeric |
| SEP Type Description | BK |
80 |
Alphanumeric |
| Proposed Amount | BL |
14 |
Number |
| Final Monetary Amount | BM |
14 |
Number |
| Paid Amount | BN |
14 |
Number |
| Final Count | BO |
4 |
Integer |
| Final Amount | BP |
14 |
Number |
| Evaluation Last Change Date | BQ |
8 |
Date (YYYYMMDD) |
| Violation Last Change Date | BR |
8 |
Date (YYYYMMDD) |
| Enforcement Last Change Date | BS |
8 |
Date (YYYYMMDD) |
| Notice of Compliance Date | BT |
8 |
Date (YYYYMMDD) |
| Financial Assurance Requirement | BU |
1 |
Alphanumeric |
|
English Name |
Excel Column |
Field Length |
Data Type |
| EPA Handler ID | A |
12 |
Alphanumeric |
| Violation Activity Location | B |
2 |
Alphanumeric |
|
Violation Sequence Number |
C |
4 |
Integer |
| Agency Which Determined Violation | D |
1 |
Alphanumeric |
| Citation Sequence Number | E |
6 |
Integer |
|
Violation Type Owner |
F |
2 |
Alphanumeric |
|
Violation Type |
G |
10 |
Alphanumeric |
|
Citation Owner |
H |
2 |
Alphanumeric |
|
Citation |
I |
80 |
Alphanumeric |
|
Citation Type |
J |
2 |
Alphanumeric |
|
English Name |
Excel Column |
Field Length |
Data Type |
| Citation Owner | A |
2 |
Alphanumeric |
| Citation | B |
80 |
Alphanumeric |
| Citation Type | C |
2 |
Alphanumeric |
| Citation Description | D |
200 |
Alphanumeric |
| Active Status | E |
1 |
Alphanumeric |