Violations file from Water Supply Inventory

Number of Records In File: 11271
Number of Data Fields In File: 20

Data That Is Stored Within This File
WSID  =  Water Supply Identification Number    
WellDrillerID  =  Well Driller ID number    
Identifier  =  Violation Unique Identifier    
Type  =  Type of Violation Code    
Contaminent  =  Contaminent that is cause of violation    
BeginningofCompliancePeriodDate  =  Beginning of Compliance Period Date    
Duration  =  Duration (# of months)    
Federal  =  Federal Violation (if field is 1, is true)    
SentToEPA  =  Sent Notice of Violation to EPA (if field is 1, is true)    
SenttoEPADate  =  Sent To EPA Date    
AwarenessDate  =  Awareness Date    
Major  =  Major Violation? (no samples taken?) (if field is 1, is true)    
MCL  =  MCL for contaminent in violation    
Result  =  Result for Constituent in violation    
ReportasDeleted  =  Report Violation as deleted to EPA (if field is 1, is true)    
ReportasDeletedDate  =  Report as Deleted to EPA Date:    
UOE  =  user of entry    
DOE  =  date of record entry    
UOC  =  user who last changed record    
DOC  =  date of last record change    

Related Files and Return To Hyperlinks
 Enforcement To Relate information between files, find records where Identifier here = Identifier there
 INVENTRY To Relate information between files, find records where WSID here = WSID there
 LPCONST To Relate information between files, find records where Contaminent here = Constituent there
 PublicNotice To Relate information between files, find records where Identifier here = ViolationIdentifier there
 Rolodex To Relate information between files, find records where WellDrillerID here = WellDrillerID there
 VViolationType To Relate information between files, find records where Type here = Type there

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