Enforcement file from Water Supply Inventory

This file lists all the enforcement action taken against systems. many of these are directly linked to a violation, however, some are stand-alone as there is not a violation for the enforcement action taken

Number of Records In File: 28902
Number of Data Fields In File: 15

Data That Is Stored Within This File
WSID  =  Water Supply Identification Number    
Identifier  =  Violation Identifier    
WellDrillerID  =  Well Driller Identification Number    
EnforcementDate  =  Enforcement Date    
UniqueEnforcementIdentifier  =  Unique Enforcement Identifier    
FollowupAction  =  Followup Action Code    
SentToEPA  =  Enforcement Action sent to EPA's databases (if field is 1, it was)    
SentToEPADate  =  Sent To EPA's databases on this date    
ReportasDeleted  =  Enforcement Action reported to EPA's databases as deleted(if field is 1, it was)    
ReportasDeletedDate  =  Enforcement Action reported to EPA's databases as deleted on this date    
PenaltyAmount  =  Penalty Amount    
UOE  =  User Who Entered record    
DOE  =  Date REcord was entered    
UOC  =  User who last changed record    
DOC  =  date of last change of record    

Related Files and Return To Hyperlinks
 Rolodex To Relate information between files, find records where WellDrillerID here = WellDrillerID there
 VFollowupAction To Relate information between files, find records where FollowupAction here = FollowupAction there
 Violations To Relate information between files, find records where Identifier here = Identifier there

 Return To Index
 Return To Compact List of All Files/All Variables