ICIS Database Field Name Listing
0 |
Court Enforcement Number |
1 |
Enforcement Name |
2 |
Activity Code |
3 |
Activity Status Code |
4 |
Court Docket Number |
5 |
Outcome |
6 |
HQ Division |
7 |
Branch |
8 |
Voluntary Self Disclosure Flag |
9 |
Multimedia Flag |
10 |
Enforcement Type |
11 |
Violations Type Code |
12 |
Relief Code |
13 |
Total Penalty Sought Amount |
16 |
Total SEP Amount |
17 |
Total Comp Action |
18 |
Cost Recovery Awarded Amount |
19 |
Statue Code |
20 |
Law Section Code |
21 |
Facility UIN |
22 |
Primary Name |
23 |
Location Address |
24 |
City Name |
25 |
State Code |
26 |
ZIP Code |
27 |
SIC Code |
28 |
Primary NAICS Code |
29 |
Defendant Name |
30 |
Named In Complaint Flag |
31 |
Named In Settlement Flag |
32 |
Sub Activity Type Code |
33 |
Actual Date |
34 |
Activity Person ID |
35 |
Last Name |
36 |
First Name |
37 |
Person Phone |
38 |
Activity Contact Role Code |
39 |
Pollutant Code |
40 |
Chemical Abstract Service Code |
41 |
Enforcement Conclusion ID |
42 |
Enforcement Conclusion Action Code |
43 |
Enforcement Conclusion Name |
44 |
Settlement Lodged Date |
45 |
Settlement Entered Date |
46 |
Penalty Sought Amount |
47 |
Federal Penalty Assessed Amount |
48 |
State Local Penalty Amount |
49 |
Total SEP Amount |
50 |
Total Comp Action Amount |
51 |
Cost Recovery Awarded Amount |
52 |
Pollutant Code |
53 |
Average Annual Value |
54 |
Pollutant Union Code |
55 |
Media Code |
56 |
SEP or Comp Flag |
57 |
Enforcement Conclusion ID |
58 |
Comp Action Type Code |
59 |
Comp Action Text |
60 |
Final Order ID |
61 |
Final Order Number |
62 |
Final Order Text Line Number |
63 |
Final Order Text |
64 |
SEP ID |
65 |
SEP Category Code |
66 |
Text Line Number |
67 |
Text Line Number 1 |
68 |
Enforcement Summary Line |
69 |
Enforcement Summary Text |
14 |
Total Federal Penalty Assessed Amount |
15 |
Total State Penalty Assessed Amount |