All Variables for Water Supply Inventory

Compact List of All Files/All Variables for Water Supply Inventory

Remember, you can use the FIND features of a web-browser (look at the menu bar or hit Control-F on your keyboard) to locate keywords on this page

ActLog   Activity Log File    This file captures changes to a selection of other files. As records are altered, the deltas are captured and place into this file to form a continuous record of what has happened to the file's records.
UserID  =
ProcName  =  Procedure
FileName  =  File being edited
FieldName  =  Field that was changed
OldValue  =  Original Field contents
NewValue  =  New field contents
Date  =  Date Changed
Time  =
RecordID  =  Unique Record Identifier
RecordID2  =  Second Unique ID
User1  =  User Defined Field 1
User2  =  User Defined Field 2
User3  =  User Defined Field 2
User4  =  User Defined Field 2
MemoPointer  =  Link to ActLogM
DelPointer  =
Type  =  M Memo D Deleted
ComputerName  =
DeletedFilename  =
PrimaField  =  Primary Field

ActLogM   Memo File    This file is linked to the ActLog file and serves as the storage area for memo fields (since ActLog is not configured to store memos). There is a link from this file back into ActLog and it serves the same function of providing storage for memos as the user changes them (thus capturing the deltas over time)
OldMemo  =
NewMemo  =
MemoPointer  =

ApplicationTracking   application tracking - environmental notice bulletins    This file contains the information that is sent into the Environmental Notice Board for the Water Supply Division
RN  =  Record Number - uniquely IDs record
ProgramCode  =  Program Code
ProjectID  =  Project ID (PIN Number)
PermitID  =  Permit ID
ProjectName  =  Project Name
Town1  =  Town
Town2  =  Town
Fee  =  Fee For Permit
ProjectDescription  =  Project Description
Contact  =  Name of Contact Person on WS Staff
ApplicationReceivedDate  =  Application Received Date
NeedInformationDate  =  Need Information Date
ApplicationCompleteDate  =  Application Completed Date
NoticeBeginDate  =  Notice Begin Date
NoticeEndDate  =  Notice End Date
PublicMeetingDate  =  Public Meeting Date
HoldInfoDate  =  Hold Info Date
InformationReceivedDate  =  Information Received Date
FinalActionDate  =  Final Action Date
FinalStatus  =  Final Status
StatusComment  =  Status Comment
DECDays  =  DEC Days (# of days in DEC's hands)

Bacterial89   Bacterial sampling since 1989
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  =

BillCycl   lookup table for Permit Fee Billing cycles
BillCycle  =  Billing Cycle Code
BillCyclDesc  =  Billing Cycle Description

BottledWaterViol   bottled water violations
WSID  =  Water Supply Identification Number
YearMonth  =  Year/Month of violation (format YYYY-MM)
Description  =  Description of violation

CalcType   lookup for Permit Fee Billing calculation type
CalcType  =  Calculation Type
CalcDesc  =  Calculation Description

CCRIssued   Consumer Confidence Reported Issued Date
WSID  =  Water Supply Identification Number
CCRIssuedDate  =  Consumer Confidence Report Issued Date
YearIssuedFor  =  Year Issued For
CertificationReceivedDate  =  Certification Received by Water Supply Division Date

ChemGr   Look up for Chemical Groups    Chemicals are frequently handled as groups (SOCs, IOCs, VOCs) that are similar in behavior or regulatory prace. This file defines the various groups that water supply's databases are built to accomodate
SpecialNotes  =  Special Notes
ChemGroupCode  =  Chemical Group Code
Description  =  Description
VDHLabKit  =  VHD Lab Kit
GroupCode  =  Group Code
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change
specific  =  specific

ChemGrCn   Constituents for a Chemical Group File    Chemicals are frequently handled as chemical groups (SOCs, VOCs, IOCs) that are alike in chemical behavior or regulatory practices. This file defines which chemicals are considered parts of which groups with in the water supply division
ChemGroupCode  =  Chemical Group Code
Constituent  =  Chemical Constituent Code
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change

ChemGrWv   Chemical Group Waivers for a WSID
WSID  =  Water Supply Identification Number
ChemGroupCode  =  Chemical Group Code
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change
ExpireDate  =  Waiver Expiration Date
EffectiveDate  =  Date On Which Waiver is Effective
SampleLoc  =  Sampling Location
ApplicationReceivedDate  =

ColiformRepeats   coliform repeats    This file retains the repeat monitoring that systems have been required to do as a result of hits seen when they were doing normal bacterial monitoring
Note  =  Note about requirement to do more testing
WSID  =  Water Supply Identification Number
DateofSample  =  Date of Sample
RepeatsThisMonth  =  # of Repeats to be done within same month as sample
RepeatsNextMonth  =  # of repeats to be done the month after the month of the sample
RoutinesNextMonth  =  # of routine samples to be done the month after the sample
DOE  =  Date that Record was Entered
UOE  =  User Who Entered The Record

CountyCodes   lookup table for the county code numbers
CountyCode  =  County Code
CountName  =  County's Name

CountyTownCodes   lookup table for County Town Codes database
OtherCommunities  =  Other Communities within the town
CountyTownCode  =  County Town Code
CountyTownName  =  Name of County/Town that is coded
FIPS  =  FIPS code

DWSRF   Drinking Water State Revolving Loan Fund
Comments  =  General Comments
ProjectDescription  =
WSID  =  Water Supply Identification Number
YearForLoan  =  Year For Load (format YYYY)
LoanType  =  Loan Type
PriorityListNumber  =  Priority List Number
PriorityListPoints  =  Priority List Points
PriorityListLoanAmount  =  Priority List Loan Amount
CurrentEstimatedLoanAmount  =  Current Estimated Loan Amount
BondAmount  =  Bond Amount
LoanNumber  =  Loan Number
PIDNumber  =  PID Number
PriorityListInterestRate  =  Priority List Interest Rate
MostRecentInterestRateEstimate  =  Most Recent Interest Rate Estimate
MostRecentTermofLoan  =  Most Recent Term of Loan
ProjectStatus  =  Project Status (1=Active,2=bypassed,3=addon)
MultiYearProject  =  Mutiple Year Project (if field is 1, it is)
SystemType  =  System Type (1=municipal,2=private(non-profit),3=other private)
MoreThan80PercentFullTimeOccupants  =  More Than 80 Percent Full Time Occupants (if field is 1, it is)
PopulationServed  =  Population Served
ProjectScheduleDue  =  Project Schedule Due Date
ProjectScheduleApproved  =  Project Schedule Approved Date
PreliminaryLoanApplicationProjectedDate  =  Preliminary Loan Application Projected Date
PreliminaryLoanApplicationActualDate  =  Preliminary Loan Application Actual Date
FinalDesignLoanApplicationSubmittedProjectedDate  =  Final Design Loan Application Submitted Projected Date
FinalDesignLoanApplicationSubmittedActualDate  =  Final Design Loan Application Submitted Actual Date
ConstructionLoanApplicationSubmittedProjectedDate  =  Construction Loan Application Submitted Projected Date
ConstructionLoanApplicationSubmittedActualDate  =  Construction Loan Application Submitted Actual Date
PlanningLoanApplicationSubmittedProjectedDate  =  Planning Loan Application Submitted Projected Date
PlanningLoanApplicationSubmittedActualDate  =  Planning Loan Application Submitted Actual Date
SourceProtectionLoanApplicationSubmittedProjectedDate  =  Source Protection Loan Application Submitted Projected Date
SourceProtectionLoanApplicationSubmittedActualDate  =  Source Protection Loan Application Submitted Actual Date
VoterBorrowingApprovalProjectedDate  =  Voter Borrowing Approval Projected Date
VoterBorrowingApprovalActualDate  =  Voter Borrowing Approval Actual Date
PreliminaryEngineeringCompleteProjectedDate  =  Preliminary Engineering Complete Projected Date
PreliminaryEngineeringCompleteActualDate  =  Preliminary Engineering Complete Actual Date
FinalDesignCompletedProjectedDate  =  Final Design Completed Projected Date
FinalDesignCompletedActualDate  =  Final Design Completed Actual Date
VTWSDConstructionPermitApplicatedSubmittedProjectedDate  =  Vermont Water Supply Division Construction Permit Application Submitted Projected Date
VTWSDConstructionPermitApplicatedSubmittedActualDate  =  Vermont Water Supply Division Construction Permit Application Submitted Actual Date
ConstructionStartedProjectedDate  =  Construction Started Projected Date
ConstructionStartedActualDate  =  Construction Started Actual Date
ConstructionCompletedProjectedDate  =  Construction Completed Projected Date
ConstructionCompletedActualDate  =  Construction Completed Actual Date
ProjectSubsidy  =  Project Subsidy
MedianHouseHoldIncomeCensus  =  Median House Hold Income Census
MedianHouseHoldIncomeSurvey  =  Median House Hold Income Survey
IncomeSurveyApproved  =  Income Survey Approved Date
ApprovedOMCost  =  Approved OM Cost
UserRateEstimated  =  User Rate Estimated
CategoricalExclusionRequested  =  Categorical Exclusion Requested Date
CategoricalExclusionIssued  =  Categorical Exclusion Issued Date
CategoricalExclusionEffective  =  Categorical Exclusion Effective Date
PlanningEngineeringContractAwardedProjectedDate  =
PlanningEngineeringContractAwardedActualDate  =
PlanningCompletedProjectedDate  =
PlanningCompletedActualDate  =
FinalDesignEngineeringContractAwardedProjectedDate  =
FinalDesignEngineeringContractAwardedActualDate  =
ConstructionContractsAwardedProjectedDate  =  Construction Contracts Awarded Projected Date
ConstructionContractsAwardedActualDate  =  Construction Contracts Awarded Actual Date
RecordID  =
PreviousPlanningLoan  =
PreviousPlanningLoanNumber  =

DWSRFConstructionAction   Construction Action Codes List
PriorityListNumber  =  Priority List Number
ActionItemNumber  =  Action Item Number
ActionItem  =  Action Item Description
UnderReview  =  Under Review (Y,N)
CompletionDate  =  Completion Date
WhoEnteredCompletionDate  =  Who Entered Completion Date (staff peron's user id)

DWSRFLoanConditions   Drinking Water State REvolving Loan Fund Loan Conditions
PriorityListNumber  =  Priority List Number
LoanConditionCode  =  Loan Condition Code
LoanConditionDueDate  =  Loan Condition Due Date
LoanConditionCompleteDate  =  Loan Condition Complete Date

DWSRFLoanInfo   Drinking Water State Revolving Loan Fund Loan Info
PriorityListNumber  =  Priority List Number
LoanType  =  Loan Type (1=preliminary engineering,2=final design,3=construction,4=conservation easement,5=planning only)
LoanActive  =  Loan Active (if field is 1, it is)
LoanAmount  =  Loan Amount
InterestRate  =  Interest Rate
Term  =  Loan Term (in # of years)
Subsidy  =  Subsidy Amount
DECApprovalDate  =  Department of Environmental Conservation Approval Date
LoanExecutedDate  =  Loan Executed Date

EnfNotes   enforcement notes
NOTE  =
CASENUMBER  =
DATE  =
DOE  =
UOE  =
DOC  =
UOC  =

Enforcement   enforcements    This file lists all the enforcement action taken against systems. many of these are directly linked to a violation, however, some are stand-alone as there is not a violation for the enforcement action taken
WSID  =  Water Supply Identification Number
Identifier  =  Violation Identifier
WellDrillerID  =  Well Driller Identification Number
EnforcementDate  =  Enforcement Date
UniqueEnforcementIdentifier  =  Unique Enforcement Identifier
FollowupAction  =  Followup Action Code
SentToEPA  =  Enforcement Action sent to EPA's databases (if field is 1, it was)
SentToEPADate  =  Sent To EPA's databases on this date
ReportasDeleted  =  Enforcement Action reported to EPA's databases as deleted(if field is 1, it was)
ReportasDeletedDate  =  Enforcement Action reported to EPA's databases as deleted on this date
PenaltyAmount  =  Penalty Amount
UOE  =  User Who Entered record
DOE  =  Date REcord was entered
UOC  =  User who last changed record
DOC  =  date of last change of record

EnfStat   enforcement status
CASENUMBER  =  Case Number
CASENAME  =  Case Name
ReasonForEnforcement  =  Reason For Enforcement
WSID  =  Water Supply Identification Number
WellDrillerID  =  Well Driller Identification Number
EPA_ActionCode  =  EPA Action Code
EPA_Action_Date  =  EPA Action Date
STINITLETC  =  Final State Action Code
STINITLETD  =  Final State Action Date
ReportedActionCode  =  Reported Action Code
ReportedActionDate  =  Reported Action Date
ENTFRDS  =  Date Entered into FRDS
DateEnforcementInitiated  =  Date Enforcement Action Was Initiated
EnforcementActionComplete  =  Enforcement Action Complete
DOE  =  Date of Entry of Record
UOE  =  User who Entered record
DOC  =  Date of last change of record
UOC  =  User who last entered record

EPAEnfCd   EPA enforcement code numbers
EPAENFCODE  =  EPA Enforcement Code number
EPAENFCDESC  =  EPA Enforcement Code Description
DOE  =  date of entry of the record
UOE  =  user who entered the record
DOC  =  date of last change of the record
UOC  =  user who last changed the record

ErrorMsg   Permit Fee Billing error messages
ErrorMessage  =  Error Message
WSID  =  Water Supply Identification number
InvoiceNbr  =  Invoice Number
TestNbr  =  Test Number
MessageType  =  Message Type

FoodAndLodging   food and lodging IDs to WSID
WSID  =  Water Supply Identification Number
FoodAndLodgingID  =  Food and Lodging ID
FoodAndLodgingEstablishName  =  Food and Lodging Establishment Name

GroupCond   Group Set Conditions    this file lists the condition tables that are fed to the Schedule Generator to guide it as it generates monitoring schedule entries for different groups of chemicals.
ConditionSet  =  Condition Set Number
ConditionState  =  Condition State Number
StartDate  =  Date to Start schedule Generation on
Interval  =  interval to find a result in
LowerPopulation  =  Lower Population Limit
UpperPopulation  =  Upper Population Limit
Waiver  =  Waiver
Grandfather  =  Grandfather
SurfaceWater  =  Surface Water Flag
TNCSWFlag  =  TNCSW Flag
TriggerFlag  =  Trigger Flag
ReliableFlag  =  Reliable Flag
NextStateF  =  NextState if this one is False
NextStateT  =  NextState if this one is true
NextStateR  =  NextState if no result Found
NextStateS  =  NextState for Schedule Printout
mclFlag  =  MCL flag
LConnections  =  Lower Limit on Connections
UConnections  =  Upper Limit on Connections
IntervalPrio  =

H2OQual   H2o Quality Data    This file lists all the water sampling testing that is done for chemical monitoring (nitrate, arsenic, benzyne.. pretty much anything but coliform) This file contains a list of the tests themselves. The various results of the tests are in the H2OReslt file
LabCode  =  Laboratory Code
DateLabRcvd  =  Date Lab Received Sample
LabNbrPrefix  =  Laboratory Number Prefix
LabRptNbr  =  Laboratory Report Number
WSID  =  Water Supply Identification Number
SampleLoc  =  Sampling Location
SamplerName  =  Sampler's Name
SamplerTitle  =  Sampler's Title
PurpOfSampl  =  Purpose of Sampling
TypeofSampl  =  Type of Sampling
ChlorResult  =  Chlorine Result
ChlorType  =  Chlorine Type
DateofSampl  =  Date of Sampling
TimeofSampl  =  Time of Sampling
SamplerRmks  =  Sampler's Remarks
PHField  =  Ph Field
TempDegrees  =  Temperature in Degrees
TempFlag  =  Temperature Flag
SourceNbr  =  Source Number
SourceText  =  Source Text
DateReportd  =  Date Reported
DateofAnal  =  Date of Analysis
AnalystName  =  Analyst's Name
SampleCltctNm  =  Sample Collected Name
SampleSealNm  =  Sample Sealed Name
SampleSealDt  =  Sample Sealed Date
SampleRcvdNm  =  Sample Received Name
SealIntactNm  =  Seal Intact Name
SealIntactDt  =  Seal Intact Date
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change

H2OReslt   H2O Results    This file lists all the water sampling testing that is done for chemical monitoring (nitrate, arsenic, benzyne.. pretty much anything but coliform)
LabCode  =  Laboratory Code
WSID  =  Water Supply Identification Number
SampleLoc  =  Sampling Location
DateofSampl  =  Date Sample was Taken
LabNbrPrefix  =  Laboratory Number Prefix
LabRptNbr  =  Laboratory Report Number
DateOfAnal  =  Date of Analysis
MethodNbr  =  Method Number
Constituent  =  Constituent
ConstituentName  =  Name of consituent (chemical)
Prefix  =  Prefix
Result  =  Result
Tolerance  =  Tolerance
DOE  =  Date of Entry
UOE  =  User of Entry
ConstitUnits  =  Constituent Units for Result
DOC  =  Date of Change
UOC  =  User of Change
Violation  =  result is above limits, but Fine (F or blank)
Violation1  =  Ignore Result When Generating Schedules (I or blank)
Violation2  =  Potential Violation Type (blank,T=above triggering level,D=above detection level,M=above MCL,U=unable to calculate)
GroupCode  =  Group Code (provides way of grouping chemcials from the same group together)

InvcWUsg   Permit Fee Billing invoice water usage
WSID  =  Water Supply Identification Number
InvoiceNbr  =  Invoice Number
BegOfPeriod  =  Beginning Date that Gallons Used is for
EndOfPeriod  =  Ending Date that Gallons Used Is For
GallonsUsed  =  Gallons Used

InventoryReports   Inventory Reports file    This database contains pointers to a collection of reports that can be run from inside the Water Supply Inventory itself. These records describe the reports and set specific access permissions for them
ReportMemo  =  description of hte report (what is does, how it works, what is asked the user to do)
ReportName  =  Report name in an external library
ReportLibraryFilePath  =  external library that report is called from
Task  =  general task that report is for
Title  =  Title of the Report
PreferredPrinter  =  Preferred Printer to print the report on
InputOptions  =  Input Options
LimitVisibility  =  Limit Visiblity (used to limit access to reports that specified users)
UOE  =  User of Entry
DOE  =  Date of Entry
BuiltInReportNumber  =  Built In Report Number (identifies built-in reports to the application so it knows what to run)
RunTimeOptions  =  a collection of Ys and Ns that controls runtime request for information from the user running the report
ReportMessage  =  message shown to user when the report is run

InventoryStatus   water supply status report    This file lists a series of standard questions about water supplies and answers that are periodically refreshed (the Inventory Status Date file contains when the report for each water supply was last refreshed)
WSID  =  Water Supply Identification
QuestionID  =  Question ID (sorting key used to make things come out int he proper order)
AnswerID  =  Answer ID (sorting key used to make things come out in the proper order)
TextLine  =  What the question or answer is

InventoryStatusDate   date water supply status made    This file lists the dates that InventoryStatus records were refreshed for each water supply
WSID  =  Water Supply Identification Number
DateStatusReportMade  =  Date Status Report was last refreshed

INVENTRY   List of Water Supplies    This is the main file that lists all the water supplies or water systems within the state of Vermont. 08/14/2003 - removed PermitReapplicationDate
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

Invoices   PFB invoices
Notes  =  general note
WSID  =  Water Supply Identification Number
InvoiceNbr  =  Invoice Number
InvoiceType  =  Invoice Type
InvoiceFrom  =  Invoice From Date
InvoiceTo  =  Invoice To Date
InvoiceDate  =  Date Invoice Generated
AmountDue  =  Amount Due
Status  =  Status (O=Open, C=Closed)
GallonsUsed  =  Gallons of Water Used
Multplier  =  Multiplier
CalcType  =  Calculation Type Code
BillCycle  =  Billing Cycle Code
WarningFlag  =  Warning Flag (internal usage)
ErrorFlag  =  Error Flag (internal usage)
FixedFlag  =  Fixed Flag (internal Usage)
AcceptAsIs  =  Accept as Is (internal flag)
ActlDataStat  =  Actual Data Status
AutoGeneratd  =  Automatically Generated Invoice (internal usage)
DOE  =  Date of Entry Of Record
UOE  =  User Who Entered The Record
DOC  =  Date of Change of The Record
UOC  =  User Who Changed The Record

InvoiceType   Lookup for Permit Fee billing Invoice Type
InvoiceType  =  Invoice Type Code
InvcTypeDesc  =  Invoice Type Description
CommFlag  =  Community Flag (indicates type of system that the invoice type is for)
MiniumFee  =
DollarsPer1000Gallons  =

LCMASTER   Lead and Copper Master File (LC)
Notes  =  notes
WSID  =  Water Supply Identification Number
TrmtRecDue  =  Treatment Recommendation Due Date
TrmtRecDone  =  Treatment Recommendation Done Date
AdInfoRqDue  =  Additional Information Due Date
AdInfoRqDone  =  Additional Information Required Done
AddInfSuDue  =  Additional Information Submittal Due
AddInfSuDone  =  Additional Information Submittal Done
StTmtDetDue  =  State Treatment Determination Due
StTmtDetDone  =  State Treatment Determination Done
StTmtDetDoneToEPA  =  Report State Treatment Determintation Done To EPA At Next Chance (if field is 1, answer is yes)
TrmtInstDue  =  Treatment Installation Due Date
TrmtInstDone  =  Treatment Installation Done Date
TrmtInstDoneToEPA  =  Report Treatment Installation Done to EPA At Next Chance (if field is 1, answer is yes)
TrmtReqPb  =  Treatment Required for Lead
DateFailPb  =  Date First Failed Lead
TrmtReqdCu  =  Treatment Required Copper
DateFailCu  =  Date First Failed Copper
Deemed  =  Deemed (Y/N)
DateDeemed  =  Date Deemed
DeemedMileStoneReasonCode  =  Deemed Mile Stone Reason Code
Done  =  Done (Y/N)
DateDone  =  Date Done
UnDone  =  Undone (Y/N)
DateUnDone  =  Date Undone
ConsecutiveNotIncludedInParent  =
ConsecutiveIncludedInParent  =

LCPUBLED   Lead and Copper Public Education (LC)
Notes  =  Public Education Notes
WSID  =  Water Supply Identification number
DueDate  =  Required Date for Public education (format YYYY-MM)
DoneDate  =  Public Education Done Date (format YYYY-MM)

LCRESULTS   Lead and Copper Results
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

LinkGroupCond   Link Group Conditions Set to Groups
ConditionSet  =  Condition Set Code
Description  =  Description

LPCONST   lookup table for Constituents/Chemicals
LikelySourceOfContamination  =  Likely Source Of Contamination
HealthEffects  =  Health Effects
Constituent  =  Constituent Code
CurrentMCL  =  Current MCL
EPAMDL  =  EPA MDL
LabMDL  =  Lab MDL
MCLG  =  Maximum Contamination Level Goal
Regulated  =  Regulated Y/N
StateWideWaver  =  State Wide Waiver Y/N
VDHLabKit  =  VDH Lab Kit
ConstitDesc  =  Constituent Description
ConstitUnits  =  MCL/MDL Units
ConstitGroup  =  Constituent Group
Sequence  =  Sequence
ResultFmt  =  Result Format
TolnceFmt  =  Tolerance Format
HasNoMCL  =  Has No MCL (if field is 1, this is true)
HasNoEPAMDL  =  Has No MCL (if field is 1, this is true)
HasNoLabMDL  =  Has No Lab MDL (if field is 1, this is true)
HasNoMCLG  =  Has No MCLG (if field is 1, this is true)

LPLAB   Lookup table for laboratory where testing was analyzed
LabCode  =  Laboratory Code
LabDesc  =  Laboratory Description

LPLNP   lookup table for Lab Number Prefix
LabNbrPrefix  =  Lab Number Prefix
LabNbrPreDesc  =  Lab Number Prefix Description

LPMETHOD   lookup table for Lab Method
MethodNbr  =  Method Number
MethodDesc  =  Method Description

LPST   lookup table for Sampler Title
SamplerTitle  =  Sampler Title
SamplerDesc  =  Sampler Description

LPTS   lookup table for Type of Sample
TypeofSampl  =  Type of Sample
TOSDesc  =  Type of Sample Description

MenuCode   stores the different access menu codes
MenuCode  =
Description  =

MinFee   lookup table for Permit Fee Billing minimum fee
WaterSysType  =  Water System Type
MinimumFee  =  Minimum Fee
Notes  =  Note

MonthlyReport   Monthly Operations Reports For Water Systems
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  =

NotesForWaterSupplies   assorted notes about water supply
SystemNote  =
NoteFor  =
UserID  =
LineDescription  =
DateNoteLastChanged  =
NoteNoLongerRelevent  =
IncludeNoteOnSanitarySurveyForm  =

Photos   Digital Photos
Description  =  Description of Picture
Title  =  Title of Picture
DatePhotoTaken  =  Date Photo was Taken
Photographer  =  Photographer
WSID  =  Water Supply Identification Number
PhotoFileName  =  Photograph File Path and Name (where the digital image physically is on the network)
DOE  =  Date of Entry of Record
UOE  =  User Who Entered Record
DOC  =  Date of Change Of Record
UOC  =  User of Change Of Record

ProgramDefaults   Program Defaults File
DefaultName  =
Long1  =
String1  =

PublicNotice   public notices
Comments  =  Note
Note  =  Note
WSID  =  Water Supply Identification Number
TypeOfNoticeIfForViolation  =  Type of Notice If For A Violation Code
TypeOfNoticeIfNotForViolation  =  Type Of Notice If Not For Violation (0=No Entry,1= Boil Water,2=Chemical Detection,3=Do Not Drink)
DateNoticeIssued  =  Date Notice Issued
ViolationIdentifier  =  Violation Identifier (if public notice is for a violation)
BeginningOfCompliancePeriod  =  Beginning Of Compliance Period (format MM/YY)
DateNoticeDue  =  Date Notice Due
RadioTVNotice  =  Public Notice was Made via Radio TV (if field is 1, this was method)
DailyNewsPaperNotice  =  Public Notice was Made via Daily News Paper (if field is 1, this was method)
WeeklyNewsPaperNotice  =  Public Notice was Made via Weekly Newspaper (if field is 1, this was method)
MailDeliveryNotice  =  Public Notice was Made via Mail Delivery(if field is 1, this was method)
HandDeliveryNotice  =  Public Notice was Made via Hand Delivery(if field is 1, this was method)
DateReminderLetterSent  =  Date Reminder Letter Sent
DateOfAction  =  Date of Action
DOE  =  Date of Entry of Record
UOE  =  User Who Entered Record
DOC  =  Date of Change Of Record
UOC  =  User Who Changed Record
PublicNoticeRecordNumber  =  Public Notice Record Number

PublicNoticeStateActions
PublicNoticeRecordNumber  =  Public Notice Record Number
StateAction  =  State Action Taken
DateOfAction  =

ReliableConsistent   Reliable and Consistent Database    List chemical constituents that monitoring for is considered to be reliable and consistent
WSID  =  Water Supply Identification Number
SampleLoc  =  Sampling Location
Constituent  =  Constituent Code
RC_Date  =  Reliable and Consistent on Date
DOE  =  Date of Entry Of Record
UOE  =  User Who Entered Record
DOC  =  Date of Last Change Of Record
UOC  =  User Who Last Changed Record

ReportDefinitions       added 04/29/2003 to provide support for the ability to generate many Word documents in a sweep through a file RN 646
Description  =
Type  =
Name  =
FilterExpression  =
SortingExpression  =
HeaderExpression  =
DetailExpression  =
Title  =
RecordID  =
BoilerplateWordDocument  =
CreateFilesInDirectory  =
CreatedFileNameExpression  =
Locked  =  If record is locked, only the last person to access it can change it
UOE  =  User Of Entry of the Record
DOE  =  Date of Entry Of The Record
UOC  =  User of Change of the Record (last user who altered it)
DOC  =  Date of Change (date of last alteration of the record)
Deleted  =  is record deleted (field not used at this time)

ReportDefinitionsRunTimes       added 04/29/2003 to provide support for the ability to generate many Word documents in a sweep through a file RN 646
Description  =
UserPrompt  =  prompt user sees when runing the Function to assign a value to the Runtime Variable
RunTimeVariable  =  Select RunTime Variable to accept the input data
FunctionToCallToAssignRunTimeVariable  =  what function procedure to call to assign the runtime variable
RecordID  =
RPDRecordID  =  recordID of the ReportDefinition record this record is linked to
Locked  =  If record is locked, only the last person to access it can change it
UOE  =  User Of Entry of the Record
DOE  =  Date of Entry Of The Record
UOC  =  User of Change of the Record (last user who altered it)
DOC  =  Date of Change (date of last alteration of the record)
Deleted  =  is record deleted (field not used at this time)
FunctionParameters  =  optional parameters to modify function's behavior

Rolodex   ! main rolodex listing of people/companies
Note  =  Note for this Person
RolodexPIN  =
FirstName  =  First Name
MiddleInitial  =  Middle Initial
LastName  =  Last Name
DivisionThatOwnsRecord  =
Title  =
CompanyName  =
WSOpID  =  Water Supply Operator ID
Primary  =  Primary Contact Info
PrimaryAddr1  =  PrimaryAddr1
PrimaryAddr2  =  Primary Address 2
PrimaryAddr3  =
PrimaryAddr4  =
PrimaryCity  =  Primary City
PrimaryState  =
PrimaryZip  =  Primary Zip Code
PrimaryPhone  =  Primary Phone
PrimaryPhoneExtension  =
PrimaryFax  =  Primary FAX
PrimaryEMail  =
PrimaryCellPhone  =
PrimaryPager  =
Secondary  =
SecondaryAddr1  =  Work Address 1
SecondaryAddr2  =  Secondary Address 2
SecondaryAddr3  =
SecondaryAddr4  =
SecondaryCity  =  City
SecondaryState  =
SecondaryZIP  =  Secondary Zip
SecondaryPhone  =  Work Phone Number
SecondaryPhoneExtension  =
SecondaryFAX  =  Secondary FAX
SecondaryEMail  =
SecondaryCellPhone  =
SecondaryPager  =
WSOperatorRank  =  WS Operator Rank at Facility
WSGPCertfctn  =  WS GrandParented Certification (Y/N)
WSGPCertClass  =  GrandParented Certification Class
WSGPExpDate  =  GrandParented Certification Expiration D
WSFCertfctn  =  Full Certification (Y/N)
WSFCertClass  =  Full Certification Class
WSFExpDate  =  Full Certification Expire Date
WSIssuedCert  =  Issued Certification (Y/N)
WSOpStatus  =  OpStatus
WellDrillerID  =
WellDrillerLicenseExpirationDate  =
WellDrillerStatus  =
RecordStatus  =
QualifyingIndividualWSPin  =
QualifyingIndividualName  =
QualifyingIndividualLicenseNumber  =
DateDrillerCertificateSent  =
WWSiteTechCertNumber  =
WWSiteTechCertificationType  =
WWSiteTechYearCertifiedTypeA  =
WWSiteTechYearCertifiedTypeB  =
WWSiteTechStatus  =
WWSiteTechExpirationDate  =
WWSiteTechLastRenewalDate  =
WWSiteTechRenewalFeeReceivedDate  =
WWSiteTechWantsToReceiveMailings  =
WWSiteTechCountyCode  =
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change
Deleted  =
WWOpCertificationNumber  =
WWOpStatus  =

RolodexToWSID   Rolodex To WSID link
LinkedToID  =  Linked To ID
RolodexPIN  =  Rolodex PIN
LastName  =
Relationship  =
LinkedToDescription  =
LinkedToIDType  =
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change

Sanitarian   Sanitary List for Hydro Projects
SanCode  =  Sanitarian Code
Name  =  Sanitarian Name

SchedGen1   Schedule Generator Specials
WSID  =  Water Supply Identification Number
SampleLoc  =  Sampling Location
ChemGroupCode  =  Chemical Group Code
ConditionSet  =  Condition Set
BeginofPeriod  =  Beginning of Period Date
EndofPeriod  =  End of Period Date
DOE  =  date of record entry
UOE  =  user of record entry
DOC  =  date of last change of record
UOC  =  user of last change of record
AutoUpdate  =  Auto Update (Y,N)
WhyAutoUpdateN  =  Why Auto Update N

SchedGen2   Schedule Generator Listing    This file contains the monitoring scheule entires for hte systems
WSID  =  Water Supply Identification Number
SampleLoc  =  Sampling Location
ChemGroupCode  =  Chemical Group Code
BeginOfPeriod  =  Beginning of Monitoring Period
EndOfPeriod  =  End of Monitoring Period
DOE  =  Date Of Entry
DOC  =  Date Of Change
UOE  =  User Of Entry
UOC  =  User Of Change
Followed  =  Schedule Followed?(Y/N)
Interval  =  Interval
GroupDate  =  Group Date
BaseDate  =  Base Date
GQuarter  =  GQuarter
Superceded  =  Superceded (if 1, this schedule entry is superceded by another)

SchedGen5   schedule information    Information About when a monitoring schedule was last generated or checked
WSID  =  Water Supply Identification Number
DateOfGeneration  =  Date of Last Generation
DateOfComplianceCheck  =  Date Compliance Was Last Checked

ScheduleRadiologicalsFollowup
WSID  =
Q1  =
Q2  =
Q3  =
Q4  =
Q5  =
Q6  =
Q7  =
Q8  =

SERVCAT   lookup for Service Category Code
ServCat  =  Service Category
ServCatDesc  =  Service Category Description
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change

SERVICES   Services provided by WS
RecordID  =      added 07/30/2003 for RN 776
WSID  =  Water Supply Identification
ServCat  =  Service Category Code
PrimaryService  =  Is This the Primary Service of WS?
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change

SourceFilterMedia   Filter Media for sources
WSID  =  Water Supply Identification Number
SourceNumber  =  Source Number
FilterMediaCode  =  Filter Media Code

SourceMPAUpcomingSamplingPeriods
WSID  =  Water Supply Identification Number
SourceNumber  =  Source Number
YearForSampling  =  Year of Sampling (YYYY)
SpringOrFall  =  Spring or Fall (S,F)
RecordNumber  =  Record Number

SourceProtectionPlanAdditionalInfoRequested   date source protection plans additional information requested
WSID  =  Water Supply Identification Number
SourceNumber  =  Source Identification Number
SPPAdditionalInfoRequestedDate  =  Source Protection Plan Updated on Date
SPPAdditionalInfoResubmittedDate  =  SPP Additional Info Resubmitted Date

SourceProtectionPlanUpdate   date source protection plans updated
WSID  =  Water Supply Identification Number
SourceNumber  =  Source Identification Number
SPPUpdatedOn  =  Source Protection Plan Updated on Date

SOURCES   Water System Sources Data
WSID  =  Water System Identification Number
SourceNumber  =  Source Identification Number
SourceName  =  Source Name
SourceOtherName  =  Other Name for the Source
EPASourceType  =  EPA Source Type
HasSourceBeenConnectedInViolationOfWSRule  =
LatDegree  =  Latitude of Source (degrees)
LatMinutes  =  Latitude of Source (minutes)
LatSeconds  =  Latitude of Source (seconds)
LongDegree  =  Longitude of Source (degrees)
LongMinutes  =  Longitude of Source (minutes)
LongSeconds  =  Longitude of Source (seconds)
LatLongDetMethod  =  Latitude-Longitude Determination Method Code
LatLongDetDate  =  Latitude-Longitude Determination Date
GWUDIStatus  =  GWUDI Status Code
GWUDIDeterminationLetterSent  =  GWUDI Determination Letter Sent
WHPA_SPAStatus  =  Well Head Protection Area, Source Protection Area Status (1=Delineated area,2=default area,3=unknown)
AverageDailyYield  =  Average Daily Yield (gallons per day)
MaximumDailyYield  =  Maximum Daily Yield (gallons per minute)
AverageYieldBasisCode  =  Average Yield Basis Code
MaxYieldBasisCode  =  Maximum Yield Basis Code
SourceMetered  =  Source Metered (Y=Individually,C=with other sources,N=not metered)
CorrosionControl  =  old field. should be removed
DisinfectionContactTimeGT20minutes  =  Disinfection Contact Time greater than 20 minutes
VTSourceType  =  Vermont Source Type
GW_w_SWContam  =  GW, could there be SW contamination?
RecordType  =  old field. should be deleted
SourceUse  =  Source Use Code
ComplianceStatus  =  old field. should be deleted
SellerID  =  WSID water is purchased from
SPPApprovedDate  =  Source Protection Plan Approved Date
SourceProtectionAreaActivitiesReport  =  Source Protection Area Activities Report Submitted
SourceProtectionPlanReceivedDate  =  Source Protection Plan Received Date
SourceProtectionPlanReviewer  =  Source Protection Plan Received
ANRWellReportNumber  =  ANR Well Report Number
ANRTagNumber  =  ANR Well Tag Number
SourceDiameter  =  Source Diameter
SourceDepth  =  Source Depth
CasingLength  =  Casing Length
CasingSpringBoxType  =  Casing Spring Box Type (1=steel,2=concrete,3=galvanized,4=aluminum,5=plastic,6=stone/block/fieldstone,7=wood,8=welltiles,9=other)
YearConstructed  =  YearConstructed
YearofRepairConstr  =  Year of Repair/Construction
DescriptionofRepairConstr  =  Description of Repair Construction
CleaningRedevelopedDate  =  Cleaning Redeveloped Date
Grouted  =  Grouted (Y,N,U=Unknown)
SourceCoverCapAdequate  =  Source Cover/Cap Adequate (Y,N,NA)
ScreenMeetsStandards  =  Screened vent meets Standards (Y,N,NA)
DrainageDitches  =  Site Drainage and Diversion Ditches OK (Y,N,NA)
ScreenOverflows  =  Screened overflows okay (Y,N,NA)
SurfaceWaterIntakeStructureAdequate  =  Surface Water Intake Structure Adequate (Y,N,NA)
StaticWaterLevel  =  Static Water Level
SourcePumpDepth  =  Source Pump Depth
SourcePumpControls  =  Source Pump Controls (1=timeclock,2=manual,3=probe,4=Pressure Guage,5=other)
SourceCapacity  =  Source pump or gravity pipe capacity (GPM)
StandbyPower  =  Standby Power Available (Y,N,NA)
SourceSecurityAdequate  =  Source Security Adequate (Y,N,NA)
TestedFailedWillBeReconstructedTested  =  If Source Tested Failed, Will Source Be Reconstructed Tested (Y,N,NA)
SystemAppliedForAvoidanceOfFiltration  =  Has System Applied For Avoidance Of Filtration for this source (Y,N,NA)
HasAvoidanceOfFiltrationWaiverBeenGranted  =  Has Avoidance Of Filtration Waiver Been Granted (Y,N,NA)
HasAvoidanceOfFiltrationWaiverBeenDenied  =  Has Avoidance Of Filtration Waiver Been Denied (Y,N,NA)
DoesDisinfectionContactTimemeetSWTRForSWGWUDI  =  Does Disinfection Contact Timemeet SWTRF or SWGWUDI (Y,N,NA)
TreatmentRequiredForIron  =  Treatment Required For Iron (Y,N,NA)
TreatmentRequiredForMaganese  =  Treatment Required For Maganese (Y,N,NA)
InComplianceForIronMaganeseTreatment  =  In Compliance For Iron Maganese Treatment (Y,N,NA)
IsContinuousChlorinationRequired  =  Is Continuous Chlorination Required (Y,N,NA)
IsCorrosionControlRequired  =  Is Corrosion Control Required (Y,N,NA)
HasCorrosionControlBeenOptimized  =  Has Corrosion Control Been Optimized (Y,N,NA)
InComplianceWiththeSWTRFiltrationRequirements  =  In Compliance Withthe SWTR Filtration Requirements (Y,N,NA)
InComplianceWithMonitoringForAvoidanceOfFiltrationWater  =  In Compliance With Monitoring For Avoidance Of Filtration Water (Y,N,NA)
IsChemicalSpillContainmentAdequate  =  Is Chemical Spill Containment Adequate (Y,N,NA)
IsAppropriateSafetyEquipmentAdequate  =  Is Appropriate Safety Equipment Adequate (Y,N,NA)
RequiredRadioChemTreatmentInCompliance  =  Required Radio Chem Treatment In Compliance (Y,N,NA)
RequiredFluoridationInCompliance  =  Required Fluoridation In Compliance (Y,N,NA)
RequiredVOCTreatmentInCompliance  =  Required VOC Treatment In Compliance(Y,N,NA)
IsolationZoneSize  =  Isolation Zone Size
IsolationZoneCompromised  =  Isolation Zone Compromised (community systems) (Y,N,NA)
IsolationZoneControl  =  Isolation Zone Control (community systems) (Y,N,NA)
VOCsWithin200feet  =  VOCs stored, used or transported within 200 feet
Viruses200feet  =  Viruses (wastewater stored, transported or treated within 200 feet)
Pestacides200feet  =  Pestacides/herbicides stored, transported, used within 200 feet
DateSourceApproved  =  Date Source Approved
YieldApprovedForSource  =  Yield Approved For Source (GPM)
RequiredTreatmentForArsenicIsInCompliance  =  Required Treatment For Arsenic Is In Compliance (Y,N,NA)
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change
RecordNumber  =  Record Number
BasinNumber  =  Basin Number
WellDrillerReportUniqueGISName  =  Unique GIS Name of the Well Driller report that list information for the well that is this source
SeasonalDisinfection  =  Does this Source get Disinfected Seasonally?
WSIDSN  =

SourceTNCGWUDI   TNC GWUDI for sources
SourcesID  =
SourceTNCGWUDIID  =
GWUDIStatus  =
NotGWUDIDateLetterSent  =
GWUDIDateDeterminationLetterSent  =
DateInitialTestingLetterSent  =
DateMPATestingLetterSent  =
DateRepairFollowupLetterSent  =

SourceTNCGWUDINotes   TNC GWUDI Notes for sources
Note  =
SourceTNCGWUDINotesID  =
SourceTNCGWUDIID  =
Title  =
Date  =

SourceTreatments   treatments for Sources
WSID  =  Water Supply Identification Number
SourceNumber  =  Source Number
TreatmentCode  =  Treatment Code

SpecialNotice   special notice file
Note  =
WSID  =  Water Supply Identification Number
NoticeType  =  Notice Type (1=Boil,2=partial boil,3=indefinite boil,4=do not drink,5=partial do not drink,6=sodium,7=other,8=voluntary boil)
DateNoticeOn  =  Date Notice On
DateReissued  =  Date Notice Reissued
DateNoticeOff  =  Date Notice Off
DateLastPublicNoticeReceived  =  Date Last Public Notice Received
NoticeReason  =  Notice Reason (1=acute MCL,2=nonacute MCL,3=emergency code,4=disease outbreak,5=system deficiencies,6=untreated supply,7=system maintenance,8=lack of water,9=other,10=GWUDISW,11=TRB MCL,12=chemical contamination)
Comments  =  Comments
DOE  =  Date of entry for record
UOE  =  user who entered record
DOC  =  date of last change of record
UOC  =  user of last change of record
OtherText  =
EnforcementAction  =

SRFNeeds   State Revolving Loan Fund Needs
WSID  =  Water Supply Identification Number
OwnerShip  =  Ownership
FinancialStatus  =  Financial Status (Profit, Non-Profit, Other)
WNPIN  =  Rolodex PIN of Contact's Name
BestTimeToCall  =  Best Time To Call Contact
HaveANeed  =  Have A Need (Y,N,I)
WantsApplication  =  Wants Application (Y,N,I)
WantsAdditionalInfo  =  Wants Additional Info (Y,N,I)
InterestedinMeetings  =  Interested in Meetings (Y,N,I)
DOE  =  Date of Entry of Record
UOE  =  User of Entry of Record
DOC  =  Date of last change of record
UOC  =  user who last changed record

SRFPotentialProjects   State Revolving Loan Fund Potential Projects
DescriptionNote  =  note about protential project
WSID  =  Water Supply Identification Number
ProjectDescription  =  Project Description
EstimatedCost  =  Estimated Cost
ConstructionStartDate  =  Construction Start Date
RefinanceProject  =  Refinance Project (Yes,No,Unknown)
SourceCompliance  =  Source Compliance (Yes,No,Unknown)
TreatmentCompliance  =  Treatment Compliance (Yes,No,Unknown)
DistributionCompliance  =  Distribution Compliance (Yes,No,Unknown)
StorageCompliance  =  Storage Compliance (Yes,No,Unknown)
OtherCompliance  =  Other Compliance (Yes,No,Unknown)
CapitalImprovement  =  Capital Improvement (Yes,No,Unknown)
SystemProjectPriority  =  System Project Priority
RequestedFundingYear  =  Requested Funding Year (YYYY)
RecommendedFundingYear  =  Recommended Funding Year (YYYY)
CostCode  =  Cost Code (EE,CE,BG)
PriorityScore  =  Priority Score
ProjectFunded  =  Project Funded (Y,N)
DOE  =  Date of entry of record
UOE  =  user who entered record
DOC  =  date of last change of record
UOC  =  user who last changed record

SRFPrioritiesP   SRf Priorities for New Projects
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  =

Staff   Water Supply Staff database
StaffNumber  =  Staff Number
SurveyorNumber  =  Sanitary Surveyor Number
Name  =  Staff Person's Name
UserID  =  Staff Person's User ID

STATEWWV   State Wide Waivers
SpecialNotes  =  Note
Constituent  =  Constituent Code
WSSourceType  =  Water System Source Type (1=Both,2=GroundWater,3=Surface Water)
AppliesToAllWS  =  Applies to all WAter Supplyes (Y,N)
ExpireDate  =  Expiration Date
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change
EffectiveDate  =  Effective Date

SurveyContamination   survey sources of contamination
WSID  =  Water Supply Identification Number
SourceNumber  =  Source Number
ContaminationSource  =  Contamination Source
Distance  =  Distance
Direction  =  Direction
UpslopeDownSlope  =  Upslope/DownSlop (1,2)

SurveyPipeMaterials   survey Pipe materials
WSID  =  Water Supply Identification Number
Material  =  Pipe Material Code

SurveyPipes   survey Pipe information
WSID  =  Water Supply Identification Number
EntryNumber  =  Entry Number
Material  =  Pipe Material Code
Size  =  Diamater in inches
Length  =  Total Length of Pipes (feet)
PercentofSystem  =  Percent of System
YearInstalled  =  Date Installed
RecordNumber  =  Record Number

SurveyPump   Survey Pump Stations information
GeneralConditionDescription  =  General Condition Description
WSID  =  Water Supply Identification Number
PumpStationName  =  Pump Station Name
PumpStationNumber  =  Pump Station Number
YearBuilt  =  Year Built
Purpose  =  Purpose (g=to gravity storage,d=to distribution system,GD=both)
NumberServiceConnections  =  Number of Service Connections
IncomingPressure  =  Incoming Pressure (PSI)
LowOutGoingPressure  =  Low Out Going Pressure (PSI)
HighOutGoingPressure  =  High Out Going Pressure (PSI)
StandbyPower  =  Standby Power Available (Y,N,NA)
StandbyPowerRequired  =  StandBy Power Required (Y,N,NA)
PumpStationCapacity  =  Pump Station Capacity (GPM)
NumberofPumps  =  Number of Pumps
DualPumpsAvailableAndOnLine  =  Dual Pumps Available And On Line (Y,N,NA)
TotalTankVolume  =  Total Tank Volume
NumberofTanks  =  Number of Tanks (per station)
AirVolumeControlType  =  Air Volume Control Type (1=bladder tank,2=air compressor,3=manual,4=none)
PressureGaugeAvailable  =  Pressure Guage Available (Y,N,NA)
SecurityOkay  =  Security OK (Y,N,NA)
GeneralCondition  =  Pump station and equipment general condition (1= good,2=adequate,3=repair needed)
DOE  =  Date of Entry of Record
UOE  =  User of Entry of Record
DOC  =  Date of Change of Record
UOC  =  User of Change of Record
DosHydropneumaticTankFloatOnSystem  =  Dos Hydropneumatic Tank Float On System (Y,N,NA)
PumpStationType  =  Pump Station Type (BP=booster pump station,HP=Hydropneumatic,BO=both)
IsPressureControlVesselInGoodWorkingOrder  =  Is Pressure Control Vessel In Good Working Order (Y/N)
RecordNumber  =  Record Number

SurveyStorage   Survey Storage information
WSID  =  Water Supply Identification Number
StorageName  =  Storage Name
StorageNumber  =  Storage Number
StorageType  =  Storage Type Code
NominalCapacity  =  Nominal Capacity (gallons)
OperatingCapacity  =  Operating Capacity (gallons)
IsStorageVolumeGTE1AverageDayDemand  =  Is Storage Volume equal to or greater than one Average Day System Demand (Y,N,NA)
IfFireHydrantsOnSystemIsSufficientFireFlowVolumeAvailable  =  If Fire Hydrants On System, Is Sufficient (ISO) Fire Flow Volume Available (Y,N,NA)
HighLevelAlarm  =  High Level Alarm (Y,N,NA)
LowLevelAlarm  =  Low Level Alarm (Y,N,NA)
Use  =  Use (G=gravity,P=pumping station,GP=gravity pumping station)
YearBuilt  =  Year Built (YYYY)
CoverRoofOkay  =  Cover Roof OK (Y,N,NA)
AccessOkay  =  Access Okay (Y,N,NA)
VentOkay  =  Vent OK (Y,N,NA)
SecurityOkay  =  Security OK (Y,N,NA)
OverflowOkay  =  Overflow OK (Y,N,NA)
SeperateDrainAvailable  =  Seperate Ability To Drain Tank Available (Y,N,NA)
IntegrityOkay  =  Integrity OK (Y,N,NA)
FreqofCleaning  =  Frequency of cleaning/draining/inspection (Y,N,NA)
AboveGroundConstruction  =  Above Ground Ground (Y,N)
BelowGroundConstruction  =  Below Ground Construction (Y,N)
IsStorageTankBuried  =  Is Storage Tank Buried (Y,N)
RecordNumber  =  Record Number