LCRESULTS file from Water Supply Inventory

Number of Records In File: 6247
Number of Data Fields In File: 11

Data That Is Stored Within This File
Notes  =  notes    
WSID  =  Water Supply Identification Number    
YearQuarterSmplReqd  =  Date Sample Required (format YYYY-Q with Q being quarter of the year)    
CompletionCd  =  Completion Code (0=not complete,1=complete,2=inadequate # of samples,3=sampling information missing,4=inadequate sampes and information,5=other)    
PB90LessThan  =  Lead 90th Percentile less than (either blank or <)    
Pb90Pct  =  Lead 90th Percentile Result    
ReportedLeadToEPA  =  Reported Lead To EPA Already (if field is 1, it has been reported)    
Cu90LessThan  =  Copper 90th Percentile less than (either blank or <)    
Cu90Pct  =  Copper 90th Percentile Result    
ReportedCopperToEPA  =  Reported Copper To EPA (if field is 1, it was reported)    
DateDeterminedPending  =  Date Determined Green Sheet Pending    

Related Files and Return To Hyperlinks
 INVENTRY To Relate information between files, find records where WSID here = WSID there
 LCMASTER To Relate information between files, find records where WSID here = WSID there

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