MonthlyReport file from Water Supply Inventory

Number of Records In File: 27887
Number of Data Fields In File: 201

Data That Is Stored Within This File
WSID  =  Water Supply Identification Number    
DateReceived  =  date results received in office    
SampleLoc  =  Sampling Location    
YearMonth  =  Year Month for report (MM\YYYY)    
Day1ResultT  =  Turbidity Result    
Day2ResultT  =  Turbidity Result    
Day3ResultT  =  Turbidity Result    
Day4ResultT  =  Turbidity Result    
Day5ResultT  =  Turbidity Result    
Day6ResultT  =  Turbidity Result    
Day7ResultT  =  Turbidity Result    
Day8ResultT  =  Turbidity Result    
Day9ResultT  =  Turbidity Result    
Day10ResultT  =  Turbidity Result    
Day11ResultT  =  Turbidity Result    
Day12ResultT  =  Turbidity Result    
Day13ResultT  =  Turbidity Result    
Day14ResultT  =  Turbidity Result    
Day15ResultT  =  Turbidity Result    
Day16ResultT  =  Turbidity Result    
Day17ResultT  =  Turbidity Result    
Day18ResultT  =  Turbidity Result    
Day19ResultT  =  Turbidity Result    
Day20ResultT  =  Turbidity Result    
Day21ResultT  =  Turbidity Result    
Day22ResultT  =  Turbidity Result    
Day23ResultT  =  Turbidity Result    
Day24ResultT  =  Turbidity Result    
Day25ResultT  =  Turbidity Result    
Day26ResultT  =  Turbidity Result    
Day27ResultT  =  Turbidity Result    
Day28ResultT  =  Turbidity Result    
Day29ResultT  =  Turbidity Result    
Day30ResultT  =  Turbidity Result    
Day31ResultT  =  Turbidity Result    
Day1ResultD  =  Disinfection Result    
Day2ResultD  =  Disinfection Result    
Day3ResultD  =  Disinfection Result    
Day4ResultD  =  Disinfection Result    
Day5ResultD  =  Disinfection Result    
Day6ResultD  =  Disinfection Result    
Day7ResultD  =  Disinfection Result    
Day8ResultD  =  Disinfection Result    
Day9ResultD  =  Disinfection Result    
Day10ResultD  =  Disinfection Result    
Day11ResultD  =  Disinfection Result    
Day12ResultD  =  Disinfection Result    
Day13ResultD  =  Disinfection Result    
Day14ResultD  =  Disinfection Result    
Day15ResultD  =  Disinfection Result    
Day16ResultD  =  Disinfection Result    
Day17ResultD  =  Disinfection Result    
Day18ResultD  =  Disinfection Result    
Day19ResultD  =  Disinfection Result    
Day20ResultD  =  Disinfection Result    
Day21ResultD  =  Disinfection Result    
Day22ResultD  =  Disinfection Result    
Day23ResultD  =  Disinfection Result    
Day24ResultD  =  Disinfection Result    
Day25ResultD  =  Disinfection Result    
Day26ResultD  =  Disinfection Result    
Day27ResultD  =  Disinfection Result    
Day28ResultD  =  Disinfection Result    
Day29ResultD  =  Disinfection Result    
Day30ResultD  =  Disinfection Result    
Day31ResultD  =  Disinfection Result    
Day1ResultF  =  Fluoride Result    
Day2ResultF  =  Fluoride Result    
Day3ResultF  =  Fluoride Result    
Day4ResultF  =  Fluoride Result    
Day5ResultF  =  Fluoride Result    
Day6ResultF  =  Fluoride Result    
Day7ResultF  =  Fluoride Result    
Day8ResultF  =  Fluoride Result    
Day9ResultF  =  Fluoride Result    
Day10ResultF  =  Fluoride Result    
Day11ResultF  =  Fluoride Result    
Day12ResultF  =  Fluoride Result    
Day13ResultF  =  Fluoride Result    
Day14ResultF  =  Fluoride Result    
Day15ResultF  =  Fluoride Result    
Day16ResultF  =  Fluoride Result    
Day17ResultF  =  Fluoride Result    
Day18ResultF  =  Fluoride Result    
Day19ResultF  =  Fluoride Result    
Day20ResultF  =  Fluoride Result    
Day21ResultF  =  Fluoride Result    
Day22ResultF  =  Fluoride Result    
Day23ResultF  =  Fluoride Result    
Day24ResultF  =  Fluoride Result    
Day25ResultF  =  Fluoride Result    
Day26ResultF  =  Fluoride Result    
Day27ResultF  =  Fluoride Result    
Day28ResultF  =  Fluoride Result    
Day29ResultF  =  Fluoride Result    
Day30ResultF  =  Fluoride Result    
Day31ResultF  =  Fluoride Result    
Day1ResultCT  =  CT Result    
Day2ResultCT  =  CT Result    
Day3ResultCT  =  CT Result    
Day4ResultCT  =  CT Result    
Day5ResultCT  =  CT Result    
Day6ResultCT  =  CT Result    
Day7ResultCT  =  CT Result    
Day8ResultCT  =  CT Result    
Day9ResultCT  =  CT Result    
Day10ResultCT  =  CT Result    
Day11ResultCT  =  CT Result    
Day12ResultCT  =  CT Result    
Day13ResultCT  =  CT Result    
Day14ResultCT  =  CT Result    
Day15ResultCT  =  CT Result    
Day16ResultCT  =  CT Result    
Day17ResultCT  =  CT Result    
Day18ResultCT  =  CT Result    
Day19ResultCT  =  CT Result    
Day20ResultCT  =  CT Result    
Day21ResultCT  =  CT Result    
Day22ResultCT  =  CT Result    
Day23ResultCT  =  CT Result    
Day24ResultCT  =  CT Result    
Day25ResultCT  =  CT Result    
Day26ResultCT  =  CT Result    
Day27ResultCT  =  CT Result    
Day28ResultCT  =  CT Result    
Day29ResultCT  =  CT Result    
Day30ResultCT  =  CT Result    
Day31ResultCT  =  CT Result    
MonthlyCTGoal  =  CT Result    
MonthlyTurbidityAverage  =  Monthly Turbidity Average    
PercentageOfTurbiditySamplesLessThanOrEqualToMCL  =  Percentage Of Turbidity Samples Less Than Or Equal To MCL    
WasCTValueLessThanMonthlyGoalMoreThan1DayDuringMonth  =  Was CT Value Less Than Monthly Goal More Than 1 Day During Month    
DidResidualDisinfectantConcentrationInDistributionFallBelow  =  Did Residual Disinfectant Concentration In Distribution Fall Below 0.2 mg/L    
WasConcentrationLessThanForMoreThan4Hours  =  Was Concentration Less Than 0.2 mg/L For More Than 4 Hours    
VFactor  =  V Factor (%)    
DOE  =  Date Record was entered    
UOE  =  user who entered record    
DOC  =  Date record last changed    
UOC  =  User who last changed record    
Day1TZeroIsTestedValue  =      
Day2TZeroIsTestedValue  =      
Day3TZeroIsTestedValue  =      
Day4TZeroIsTestedValue  =      
Day5TZeroIsTestedValue  =      
Day6TZeroIsTestedValue  =      
Day7TZeroIsTestedValue  =      
Day8TZeroIsTestedValue  =      
Day9TZeroIsTestedValue  =      
Day10TZeroIsTestedValue  =      
Day11TZeroIsTestedValue  =      
Day12TZeroIsTestedValue  =      
Day13TZeroIsTestedValue  =      
Day14TZeroIsTestedValue  =      
Day15TZeroIsTestedValue  =      
Day16TZeroIsTestedValue  =      
Day17TZeroIsTestedValue  =      
Day18TZeroIsTestedValue  =      
Day19TZeroIsTestedValue  =      
Day20TZeroIsTestedValue  =      
Day21TZeroIsTestedValue  =      
Day22TZeroIsTestedValue  =      
Day23TZeroIsTestedValue  =      
Day24TZeroIsTestedValue  =      
Day25TZeroIsTestedValue  =      
Day26TZeroIsTestedValue  =      
Day27TZeroIsTestedValue  =      
Day28TZeroIsTestedValue  =      
Day29TZeroIsTestedValue  =      
Day30TZeroIsTestedValue  =      
Day31TZeroIsTestedValue  =      
Day1DZeroIsTestedValue  =      
Day2DZeroIsTestedValue  =      
Day3DZeroIsTestedValue  =      
Day4DZeroIsTestedValue  =      
Day5DZeroIsTestedValue  =      
Day6DZeroIsTestedValue  =      
Day7DZeroIsTestedValue  =      
Day8DZeroIsTestedValue  =      
Day9DZeroIsTestedValue  =      
Day10DZeroIsTestedValue  =      
Day11DZeroIsTestedValue  =      
Day12DZeroIsTestedValue  =      
Day13DZeroIsTestedValue  =      
Day14DZeroIsTestedValue  =      
Day15DZeroIsTestedValue  =      
Day16DZeroIsTestedValue  =      
Day17DZeroIsTestedValue  =      
Day18DZeroIsTestedValue  =      
Day19DZeroIsTestedValue  =      
Day20DZeroIsTestedValue  =      
Day21DZeroIsTestedValue  =      
Day22DZeroIsTestedValue  =      
Day23DZeroIsTestedValue  =      
Day24DZeroIsTestedValue  =      
Day25DZeroIsTestedValue  =      
Day26DZeroIsTestedValue  =      
Day27DZeroIsTestedValue  =      
Day28DZeroIsTestedValue  =      
Day29DZeroIsTestedValue  =      
Day30DZeroIsTestedValue  =      
Day31DZeroIsTestedValue  =      

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

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