Bacterial89 file from Water Supply Inventory
Number of Records In File: 226247
Number of Data Fields In File: 26
Data That Is Stored Within This File
Note  =  Note about sample   
WSID  =  Water Supply Identification Number   
SampleLoc  =  Sampling Location   
SamplerName  =  Sampler's Name   
SamplerTitle  =  Sampler's Title   
PurpOfSampl  =  Purpose Of Sample (1=Routine,2=Repeat,3=Replacement,4=Other,5=Invalided)   
TypeofSampl  =  Type of Sample (1=source,2=distribution,3=other)   
DateOfSampl  =  Date of Sample   
TimeOfSampl  =  Time Of Sample   
ChlorType  =  Chlorine Type (1=free,2=total,3=not measured,4=not chlorinated)   
ChlorResult  =  Chlorine Result   
BactResult  =  Bactis Result   
TotalColiform  =  Total Coliform(A=Active,P=Present,N=NotAnalyzed,I=Invalid)   
FecalColiform  =  Fecal Coliform (A=Active,P=present,N=not analyzed,E=not reported,c=not recorded)   
NonColiformBacteria  =  Non-Coliform Bacteria   
LabRptNbr  =  Lab Report Number   
LabCode  =  Laboratory Code   
LabNbrPrefix  =  Lab Number Prefix   
Confirmation  =  Confirmation   
MinimumColiformCount  =  Minimum Coliform Count   
DOE  =  Date of Entry of Record   
UOE  =  User Who Entered Record   
DOC  =  Date of Last Change Of Record   
UOC  =  User Who Last Changed Record   
TotalColiformCount  =    
FecalColiformCount  =    
Related Files and Return To Hyperlinks
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
Return To Index
Return To Compact List of All Files/All Variables