H2OReslt file from Water Supply Inventory

This file lists all the water sampling testing that is done for chemical monitoring (nitrate, arsenic, benzyne.. pretty much anything but coliform)

Number of Records In File: 504994
Number of Data Fields In File: 22

Data That Is Stored Within This File
LabCode  =  Laboratory Code    
WSID  =  Water Supply Identification Number    
SampleLoc  =  Sampling Location    
DateofSampl  =  Date Sample was Taken    
LabNbrPrefix  =  Laboratory Number Prefix    
LabRptNbr  =  Laboratory Report Number    
DateOfAnal  =  Date of Analysis    
MethodNbr  =  Method Number    
Constituent  =  Constituent    
ConstituentName  =  Name of consituent (chemical)    
Prefix  =  Prefix    
Result  =  Result    
Tolerance  =  Tolerance    
DOE  =  Date of Entry    
UOE  =  User of Entry    
ConstitUnits  =  Constituent Units for Result    
DOC  =  Date of Change    
UOC  =  User of Change    
Violation  =  result is above limits, but Fine (F or blank)    
Violation1  =  Ignore Result When Generating Schedules (I or blank)    
Violation2  =  Potential Violation Type (blank,T=above triggering level,D=above detection level,M=above MCL,U=unable to calculate)    
GroupCode  =  Group Code (provides way of grouping chemcials from the same group together)    

Related Files and Return To Hyperlinks
 H2OQual To Relate information between files, find records where WSID here = WSID there and SampleLoc here = SampleLoc there and DateofSampl here = DateofSampl there and LabCode here = LabCode there and LabNbrPrefix here = LabNbrPrefix there and LabRptNbr here = LabRptNbr there
 LPCONST To Relate information between files, find records where Constituent here = Constituent there
 LPMETHOD To Relate information between files, find records where MethodNbr here = MethodNbr there
 VResultMethodNbr To Relate information between files, find records where MethodNbr here = MethodNumber there

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