SRFPrioritiesP file from Water Supply Inventory
Number of Records In File: 453
Number of Data Fields In File: 121
Data That Is Stored Within This File
PriorityReason = Reason for Priority Override
ByPassReason = Reason For Bypass
ProjectDescription = Project Description
Comments =
YearForLoan = Year for Loan (YYYY)
LoanType = Loan Type Code
WSID = Water Supply Identification number
Region = Region Water Supply is in
PriorityOverRide = Prority override (if field is 1, there is a priority overide in effect)
ByPass = By Pass (if field is 1, there is a bypass in effect)
FundingProvidedIn = Funding Provided in
TechnicalScore = Technical Score
PopulationServed = Population Water Supply Serves
Points = Priority Points
BactMicro = Bacteriological/Microbiological (1= no MCl violations,2=1-2 MCL violations,3=greater than 2 mcl violations,4=permanent boil status)
Nitrate = Nitrate (1=no nitrate level above 1.0 mg/L,2=level above 1.0mg/L but below MCL,3=MCL violations)
Turbidity = Turbidity (1=no mcl violations,2=1-2 MCL Violations,3=greater than 2 MCL violations)
PrimaryIOR = Primary Inorganic, Organic and Radio (1=no MCL violations,2=MCL violation(s),3=greater than 2 MCL violations)
SMCLS = Second Inorganic/Physical/Chemical Standards (1=no MCL violations,2=1-2 MCL Violations,3=greater than two MCL violations)
DoNotDrink = Do Not Drink Order (1=none,2=non-mcl,3=MCL)
SystemEnforcement = System is under a Health Enforcement Order (if field is 1, it is true)
ContaminatedSource = Contaminated Source (if field is 1, it is true)
WaterShortage =
DocumentationForDemand = Documentation of Capacity of permanent source or major equipment to meet demand (if field is 1, it is true)
NoTreatUnderInfluence = No Treatment for surface water filtration or groundwater under the direct influence of surface water (if field is 1, it is true)
InadequateCTdisinfect = Inadequate CT disinfection (if field is 1, it is true)
BadFiltration = Inadequate filtration performance (if field is 1, it is true)
FEmncontaminants = Fe/MN and other secondary non-acute contaminants (if field is 1, it is true)
CorrosionControl = Corrosion control for lead & copper or other acute contaminants (if field is 1, it is true)
ChronicContam = Chronic Contaminants such as certain metals (cadmium) or organic (if field is 1, it is true)
BadSourceConstruction = Inadequate Source Construction (if field is 1, it is true)
VulToContamin = Vulnerable to potential sources of contamination (if field is 1, it is true)
NoSSP = No Source Protection Plan (if field is 1 it is true)
BadFinStorCap = Inadequate finished storage capacity (if field is 1, it is true)
BadFinStorConst = Inadequate finished storage construction (if field is 1, it is true)
BadDisFac = Inadequate disinfection facility (if field is 1, it is true)
BadSysPress = Inadequate system pressure (if field is 1, it is true)
BadWWDispos = Inadequate water treatment backwash (if field is 1, it is true)
BadPumpStat = Inadequate Pumping Station (if field is 1, it is true)
BadTransSys = Inadequate Transmission Main System (if field is 1, it is true)
BadDistrSys = Inadequate Distribution System (if field is 1, it is true)
BadCrossConnectionControl = Inadequate Cross-Connection Control (if field is 1, it is true)
Other = Other Facility Deficiency (if field is 1, it is true)
RedundCritComp = Redundancy of Critical Components (if field is 1, it is true)
Automation = Control/automation for operational efficiency (if field is 1, it is true)
Consolidation = Consolidation or interconnection of two or more drinking water systems (if field is 1, it is true)
ManOpFin = Improvement of managerial, operation or financial services of 2 or more systems (if field is 1, it is true)
Meters = Master and customer meters to be installed and maintained (if field is 1, is true)
RateStructure = Rate Structure Promotes Conservation (if field is 1, is true)
UnAccountedWater = Conduct Study to Determine unaccounted water loss (if field is 1, is true)
WaterConStrat = Water Conservation Strategy being used (if field is 1, it is true)
CrossConnectInstall = Installation of cross-connection control devices (if field is 1, it is true)
IsolationZoneControlObtained = Isolation Zone Control Obtained (if field is 1, it is true)
PrimaryRechargeZoneControlObtained = Primary Recharge Zone Control Obtained (if field is 1, it is true)
MicrobiologicalPSOCsAddressed = Microbiological PSOCs Addressed (if field is 1, it is true)
NitratePSOCsAddressed = Nitrate PSOCs Addressed (if field is 1, it is true)
PrimaryInorganicOrOrganicPSOCsAddressed = Primary Inorganic Or Organic PSOCs Addressed (if field is 1, it is true)
PopulationCriteria = Population Criteria (1= rnage of 0-24,2=range of 25-500,3=range of 501-3500,4=range of 3501-10000,5=greater than 10000)
PrelimEngDone = Preliminary Engineering Completed/Permit to construct application (if field is 1, is true)
BondVoted = Bonds/Funds voted for local match (if applicable) (if field is 1, is true)
FinalPlanDone = Final Plan and Specifications Complete (if field is 1, is true)
CommunityMHI = Community MHI (median household income)
ReFinancing = Eligability for Using Refinancing Points (if field is 1, is true)
Fundable = Fundable (if field is 1, is true)
Funded = Funded (if field is 1, is true)
MunicipalorPrivate = Municipal or Private (1= Municipal,2=private)
DateofProjectStart = Date of Project Start
ProjectCost = Project Cost/Loan Amount
LoanInterestRate = Interest Rate of Loan
TermOfLoan = Term of Loan in Years
AmountOfSubsidy = Amount of Subsidy
Disadvantaged = Disadvantaged System (if field is 1, is true)
PlanningDesign = Planning Design (if field is 1, is true)
DOE = Date of Entry
UOE = User of Entry
DOC = Date of Change
UOC = User of Change
FacilitiesImprovementScore =
ConsolidationScore =
AffordabilityScore =
PopulationScore =
DownTownPreferenceScore =
SourceProtectionScore =
PriorityRankingType =
MicrobiologicalContaminantedSource =
ContaminantsAboveMCL =
UnPermittedSourceOfWater =
ActionLevelFor8ChemicalsOfConcernToDOHDEC =
InAdequateFiltrationPerformance =
NoTreatmentUnderInfluenceOfSurfaceWater =
InadequateChlorinationOrDisinfectionFacilities =
DailyOrRoutineWaterShortage =
LackOfStandbyDisinfectionFacilities =
FinishedStorageVulnerableToContamination =
LeadAndCopperCorrosionControl =
ContaminantBelowMCL =
SeasonalWaterShortage =
RoutinePressureBelow20PSIInDistributionSystem =
SourceVulnerableToPSOCs =
PressureUnder20PSIDuringFireFlow =
RedundancyOfCriticalComponents =
IronAndManganeseAndOtherSecondaryContaminants =
InadequateFinishedStorageConstruction =
InadequateTransmissionMain =
InadequateFinishedStorageCapacity =
InadequatePumpingFacilities =
LackOfReserveCapacity =
InadequateCrossConnectionControl =
InadequateDistributionFacilities =
InadequateBackWash =
RoutineDistributionPressureBelow35PSI =
PhysicalConsolidationOfWaterSystems =
SCMI =
PopulationRange =
ProjectImprovesServiceToADesignatedDownTownArea =
ProjectIsolationZoneControl =
ProjectAchievesPrimaryRechargeZoneControl =
ProjectAddressesMicrobiologicalPSCOCs =
ProjectAddressesNitratePSOCs =
ProjectAddressesPrimaryInorganicOrOrganicPSOCs =
TotalPoints2001 =
Related Files and Return To Hyperlinks
INVENTRY To Relate information between files, find records where WSID here = WSID there
VSRFLoanType To Relate information between files, find records where LoanType here = LoanType there
Return To Index
Return To Compact List of All Files/All Variables