Fields in File for INVENTRY

INVENTRY file from Water Supply Inventory

This is the main file that lists all the water supplies or water systems within the state of Vermont. 08/14/2003 - removed PermitReapplicationDate

Number of Records In File: 0
Number of Data Fields In File: 123

Data That Is Stored Within This File
DescriptionOfCrossConnectionControlProgram  =
FireFightNote  =  Note about low pressure for fires
Comments1  =  Comments
EmergPlanDesc  =  Emergency Plan Description
OutageNote  =  Desciption of Outage Cause and Duration
Comments  =  Comments
LeaksNote  =  Frequency and Cause of leaks
LowPressNote  =  Low Pressure Under Normal Conditions note    dbasename=LowPress
CrossConnectionsDescription  =  Cross Connections Description
WSID  =  Water Supply ID number
WaterSysName  =  Water System Name
WSIDClass  =  Water Supply Class
CommFlag  =  Community Flag
WaterSysTn  =  Water System Town
WaterSysSt  =  Water System State
TownCode  =  County Town Code
ConsecutiveSystem  =  Consecutive System? Y/N/NA
OwnershpFlag  =  Owership Flag
ActivityFlag  =  Activity Flag
DeActDate  =  Deactivated Date
PopServed  =  Population Served
PopKnownEst  =  Population Known or Estimated
SeasPop  =  Seasonal Population
NonSeasPop  =  Non-seasonal population
NumServices  =  Number of Service Connections
TypYrlyCost  =  Typical Yearly Cost
AvDayGPD  =  Average Date Demand GPD
MaxDayGPM  =  Max Day Demand GPM
DemandBasis  =  Basis for Demand
PExpDate  =  Permit Expiration Date
Region  =  Region
ExmtFromFees  =  Exempt from Operating Fees
HaveCrossConnectionControlProgram  =  HaveCrossConnectionControlProgram (Y,N,NA)
SamplePlDate  =  Sampling Plan Approved Date
SurveyDate  =  Date of Last Sanitary Survey at the system
Surveyee  =  Principal Person Surveyor talked with
LeadSurveyorNumber  =  Lead Surveyor's Sanitary Survey ID Number
WaterSystemZip  =  ZIP code for Water System
SeasonStarts  =  Seaon Starts Date (format MM/DD)
SeasonEnd  =  Season End's Date (format MM/DD)
PrimaryCountyServed  =  Primary County Served Code
OtherCountiesServed1  =  Other County Served Code 1
OtherCountiesServed2  =  Other County Served Code 2
PrimaryCityServed  =  Primary City Served
OtherCitiesServed  =  Other Cities Served
RecipientWSID1  =  Recipient WSID (WSID of another system buying water from this one)
RecipientWSID2  =  Recipient WSID (WSID of a system buying water from this one)
RecipientWSID3  =  Recipient WSID (WSID of another system buying water from this one)
RecipientWSID4  =  Recipient WSID (WSID of another system buying water from this one)
PrimaryServiceCat  =  Primary Service Category
OtherServiceCat1  =  Other Service Category
OtherServiceCat2  =  Other Service Category
OtherServiceCat3  =  Other Service Category
OtherServiceCat4  =  Other Service Category
AvOffSeasonDemand  =  Average Off Season Demand (gallons per minute)
MaxOffSeasonDemand  =  Maximum Off Season Demand (Gallons per minute)
OffSeasonDemandBasis  =  how off-seaon demand is determined
OffSeasonDemandNotApplicable  =  do not think used. should probably remove
AvDesignDemand  =  Average Design Demand (gallons per minute)
MaxDesignDemand  =  Maximum Design Demand (Gallons per minute)
DesignDemandBasis  =  Design Demand Basis Code
SystemMasterMeter  =  System Master Meter Y/N/NA
SystemMasterMeterLocation  =  System Master Meter Location
ReserveCapacity  =  Reserve Capacity (Y,N,NA)
ReserveAmount  =  Reserve Amount (gallons per day)
IsSystemExpasionLimitedbyYield  =  IsSystemExpasionLimitedbyYield (Y,N,NA)
IsSystemExpansionLimitedbyStorage  =  IsSystemExpansionLimitedbyStorage (Y,N,NA)
IsSystemExpansionLimitedByContamination  =  Is System Expansion Limited By Contamination (Y,N,NA)
AnyLeadFtgs  =  Any Lead Ftgs (Y,N,NA)
NumAirRelValves  =  Number of Air Release Valves
NumBlowoffValves  =  Number of Blow Off valves
NumDeadLines  =  Number of Dead Lines
BlowoffFrequency  =  Blow-off valve flushing frequency
NumFireHydrants  =  Number of Fire Hydrants
HydrantFlushingFreq  =  Fire Hydrant Flushing Frequency
ValveExrFreq  =  Valve Exercising Frequency
LastHydTestDate  =  Last Fire Hydrant Test Date
PressRedValveMain  =  Number of Pressure Reducing Valves on Main Line
PressRedValveService  =  Number of Pressure Reducing Valves on Service line    changed to a short on 09/25/2003 for RN 849
PressureReducingValveLastTestingDate  =  Pressure Reducing Valve Last Testing Date
ServiceConnectionsMetered  =  Service Connections Metered (Y,N,NA)
BackFlowPrevention  =  Back Flow Prevention (Y,N,NA)
HighRiskConnsHaveBackFlow  =  High Risk Conns Have BackFlow (Y,N,NA)
BackFlowTestedPeriodically  =  BackFlowTestedPeriodically (Y,N,NA)
NumberChlorineBoosters  =  Number of Distribution Chlorine Boosters in distribution
ChlorineTestKitAvailable  =  Chlorine Test Kit Available
ChlorineTestKitChemsOkay  =  Chlorine Test Kit Chemicals Okay
AppropriateTestKitsAvailable  =  AppropriateTestKitsAvailable (Y,N,NA)
AreTestKitChemsOkayAndMetersCalibrated  =  AreTestKitChemsOkayAndMetersCalibrated (Y,N,NA)
TurbidimeterCalibrationDate  =  Turbidimeter Calibration Date
DistributionSystemLeaks  =  Distribution System Leaks (Y,N,NA)
LowPressNormal  =  Low Press Normal (Y,N,NA)
MaxOpPress  =  Maximum Routine Operating Pressure
MinOpPress  =  Minimum Routine Operating Pressure
LowPressFire  =  Low Pressure when fire-fighting (Y,N,NA)
FireFightingPressureMinimum  =  Fire-Fighting Operating Pressure Minimum
EmergPlan  =  Emergency Contingency Plan (if field 1, answer is Yes)
OutageOccur  =  Water Outage Occur since last survey (Y,N,NA)
OEMManual  =  OEM manual current and available to operator (Y,N,NA)
AreAllConfinedSpacesIdentifiedAndLabeled  =  Are All Confined Spaces Identified And Labeled (Y,N,NA)
DistributionPlans  =  Distribution Plans current and available to operator (Y,N,NA)
SystemRecordsMaintained  =  System Records Maintained as required by regulations (Y,N,NA)
OnsiteMonitoring  =  Onsite Monitoring being accomplished and recorded (Y,N,NA)
WaterConservationProgram  =  Have Water Conservation Program (Y,N,NA)
LongRangePlan  =  Is there a long range plan for improvements/expansion/replacement (Y,N,NA)
WaterRateStructure  =  Water Rate Structure
AverageYearlyCost  =  Average Yearly House-Hold Cost
PTOPINNumber  =  Permit To Operate PIN Number
PermitType  =  Permit Type (1=Full, 2= Temporary 3=None)
PermitIssuedDate  =  Permit Issued Date
LinkedToIDType  =  Linked To ID Type (identifies record type as a water supply when linked to a Rolodex record)
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change
VDHLicensedDate  =  Vermont Department Of Health License Date
AverageDailyNumberOfPersonsServed  =  Average Daily Number Of Persons Served
RestaurantSeatingCapacity  =  Restaurant Seating Capacity
LodgingCapacityBeds  =  Lodging Capacity (Beds)
AreThereAnyCrossConnectionsIdentifiedInSystem  =  Are There Any Cross Connections Identified In System
RegulatedByPublicServiceBoard  =  Regulated By Public Service Board (Y,N)
E911Address  =
PermitApplicationReceivedDate  =      added 08/14/2003 for RN 815

Related Files and Return To Hyperlinks
Bacterial89 To Relate information between files, find records where WSID here = WSID there
BottledWaterViol To Relate information between files, find records where WSID here = WSID there
CCRIssued To Relate information between files, find records where WSID here = WSID there
ChemGrWv To Relate information between files, find records where WSID here = WSID there
ColiformRepeats To Relate information between files, find records where WSID here = WSID there
DWSRF To Relate information between files, find records where WSID here = WSID there
EnfStat To Relate information between files, find records where WSID here = WSID there
FoodAndLodging To Relate information between files, find records where WSID here = WSID there
H2OQual To Relate information between files, find records where WSID here = WSID there
InventoryStatus To Relate information between files, find records where WSID here = WSID there
Invoices 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
LCPUBLED To Relate information between files, find records where WSID here = WSID there
LCRESULTS To Relate information between files, find records where WSID here = WSID there
MonthlyReport To Relate information between files, find records where WSID here = WSID there
PublicNotice To Relate information between files, find records where WSID here = WSID there
ReliableConsistent To Relate information between files, find records where WSID here = WSID there
RolodexToWSID To Relate information between files, find records where LinkedToIDType here = LinkedToIDType there and WSID here = LinkedToID there
SchedGen1 To Relate information between files, find records where WSID here = WSID there
SchedGen2 To Relate information between files, find records where WSID here = WSID there
SERVICES To Relate information between files, find records where WSID here = WSID there
SOURCES To Relate information between files, find records where WSID here = WSID there
SpecialNotice To Relate information between files, find records where WSID here = WSID there
SRFNeeds To Relate information between files, find records where WSID here = WSID there
SRFPotentialProjects To Relate information between files, find records where WSID here = WSID there
SRFPrioritiesP To Relate information between files, find records where WSID here = WSID there
Staff To Relate information between files, find records where LeadSurveyorNumber here = SurveyorNumber there
SystemDeficiencies To Relate information between files, find records where WSID here = WSID there
Tracking To Relate information between files, find records where WSID here = WSID there
TrainingTestingReEmbursementVoucher To Relate information between files, find records where WSID here = WSID there
TransAct To Relate information between files, find records where WSID here = WSID there
Violations To Relate information between files, find records where WSID here = WSID there
WATERUSG To Relate information between files, find records where WSID here = WSID there
WSCONSTW To Relate information between files, find records where WSID here = WSID there
WSMSLOC To Relate information between files, find records where WSID here = WSID there

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