DWSRF file from Water Supply Inventory

Number of Records In File: 279
Number of Data Fields In File: 64

Data That Is Stored Within This File
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  =      

Related Files and Return To Hyperlinks
 DWSRFLoanConditions To Relate information between files, find records where PriorityListNumber here = PriorityListNumber there
 DWSRFLoanInfo To Relate information between files, find records where PriorityListNumber here = PriorityListNumber there
 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