H2OQual 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) This file contains a list of the tests themselves. The various results of the tests are in the H2OReslt file

Number of Records In File: 73704
Number of Data Fields In File: 33

Data That Is Stored Within This File
LabCode  =  Laboratory Code    
DateLabRcvd  =  Date Lab Received Sample    
LabNbrPrefix  =  Laboratory Number Prefix    
LabRptNbr  =  Laboratory Report Number    
WSID  =  Water Supply Identification Number    
SampleLoc  =  Sampling Location    
SamplerName  =  Sampler's Name    
SamplerTitle  =  Sampler's Title    
PurpOfSampl  =  Purpose of Sampling    
TypeofSampl  =  Type of Sampling    
ChlorResult  =  Chlorine Result    
ChlorType  =  Chlorine Type    
DateofSampl  =  Date of Sampling    
TimeofSampl  =  Time of Sampling    
SamplerRmks  =  Sampler's Remarks    
PHField  =  Ph Field    
TempDegrees  =  Temperature in Degrees    
TempFlag  =  Temperature Flag    
SourceNbr  =  Source Number    
SourceText  =  Source Text    
DateReportd  =  Date Reported    
DateofAnal  =  Date of Analysis    
AnalystName  =  Analyst's Name    
SampleCltctNm  =  Sample Collected Name    
SampleSealNm  =  Sample Sealed Name    
SampleSealDt  =  Sample Sealed Date    
SampleRcvdNm  =  Sample Received Name    
SealIntactNm  =  Seal Intact Name    
SealIntactDt  =  Seal Intact Date    
DOE  =  Date of Entry    
UOE  =  User of Entry    
DOC  =  Date of Change    
UOC  =  User of Change    

Related Files and Return To Hyperlinks
 H2OReslt 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
 INVENTRY To Relate information between files, find records where WSID here = WSID there
 LPLAB To Relate information between files, find records where LabCode here = LabCode there
 LPLNP To Relate information between files, find records where LabNbrPrefix here = LabNbrPrefix there
 WSMSLOC To Relate information between files, find records where WSID here = WSID there and SampleLoc here = SampleLoc there

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