Selection of Columns for Expert Query

table_name:WATERS.V_CBR_PRJ_LOC_LOAN_BORROWER TABLEOWNER:WATERS

Selection of Columns

STEP 2: Select one or more column(s) for your output by clicking on the square box next to the column name. When you are finished selecting columns, click on the "STEP 3: Enter Search Criteria" button at the bottom of this page.

TABLE NAME: V_CBR_PRJ_LOC_LOAN_BORROWER
	*	All data elements in the view or table are selected. If selected, all other data elements selections will be ignored!
	Count Function for *. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS! COUNT
	PROJECTKEY	"Concatenated primary key of the combined ProjectKey, LoanKey, UseType, and UseCode fields. ProjectKey is the primary key from the ProjectInformation table."
	PROJECTRECORDNUMBER	Project specific key value.
	STATE	The state abbreviation (US Postal) for the state. This field is included for all entries.
	REGION	EPA Region (1-10). This field is included for all entries.
	MAP_CBR_PROJECT	A web link which when clicked will produce a map of the associated CBR Project.
	NPSPROJECTCOUNT	The number of nonpoint source projects in the group for this project record, usually those that not only share the same activity but also that occur in the same watershed.
	CWNSNUMBER	Clean Watershed Needs Survey number for the facility.
	CWNS I	Secondary Treatment Need Category Amount
	Group Functions for CWNS_I. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS II	Advanced Treatment Need Category Amount
	Group Functions for CWNS_II. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS III_A	Infiltrate/Inflow Correction Need Category Amount
	Group Functions for CWNS_III_A. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS III_B	Replace/Rehab of Sewers Need Category Amount
	Group Functions for CWNS_III_B. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS IV_A	New Collector Sewers Need Category Amount
	Group Functions for CWNS_IV_A. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS IV_B	New Interceptor Sewers Need Category Amount
	Group Functions for CWNS_IV_B. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS V	Combined Sewer Overflow Need Category Amount
	Group Functions for CWNS_V. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VI	Separate Storm Sewer System Need Category Amount
	Group Functions for CWNS_VI. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_A	NPS-Agriculture (cropland) Need Category Amount
	Group Functions for CWNS_VII_A. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_B	NPS-Agriculture (animals) Need Category Amount
	Group Functions for CWNS_VII_B. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_C	NPS-Silviculture Need Category Amount
	Group Functions for CWNS_VII_C. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_D	NPS-Urban Need Category Amount
	Group Functions for CWNS_VII_D. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_E	NPS-Ground Water - Unknown Source Need Category Amount
	Group Functions for CWNS_VII_E. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_F	NPS-Marinas Need Category Amount
	Group Functions for CWNS_VII_F. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_G	NPS-Resource Extraction Need Category Amount
	Group Functions for CWNS_VII_G. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_H	NPS-Brownfields Need Category Amount
	Group Functions for CWNS_VII_H. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_I	NPS-Storage Tanks Need Category Amount
	Group Functions for CWNS_VII_I. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_J	NPS-Sanitary Landfills Need Category Amount
	Group Functions for CWNS_VII_J. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS VII_K	NPS-Hydromodification Need Category Amount
	Group Functions for CWNS_VII_K. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS_VII_L	NPS-Individual/Decentralized Systems Need Category Amount
	CWNS VIII	Confined Animals (Point Source) Need Category Amount
	Group Functions for CWNS_VIII. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS IX	Mining (Point Source) Need Category Amount
	Group Functions for CWNS_IX. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	You may select any of the following Group Numerical Functions for the column above: You must select an additional column other than one of these group functions! HELP on STATISTICS! SUM AVERAGE MAX MIN STANDARD DEVIATION VARIANCE
	CWNS_X	Recycled Water Distribution Need Category Amount
	CBR_DESCRIPTION	Description of the project.
	FACILITYNAME	Name of the treatment facility(ies) associated with the project.
	PROJECTPOPULATIONSERVED	The current population that the project serves.
	FACILITYPOPULATIONSERVED	Current population connected to the facility or system that the project improves.
	PROJECTWASTEWATERVOLUME	The design flow that the project directly affects.
	PROJECTVOLUMEELIMINATEDCONSERV	The flow reduced/removed/eliminated due to a CSO, SSO, reuse, or conservation project.
	FACILITYWASTEWATERVOLUME	The design flow for the facility or system that the project improves.
	PROJECTINCLUDESPLANNINGDESIGN
	OCEANOUTFALL	Indicates whether the project affects the discharge to an Ocean Outfall.
	ESTUARYCOASTALBAY	Indicates whether the project affects the discharge to an Estuary or Coastal Bay.
	WETLAND	Indicates whether the project affects the discharge to a Wetland.
	SURFACEWATER	Indicates whether the project affects the discharge to a Surface Water (Stream, River, Lake).
	GROUNDWATER	Indicates whether the project affects a discharge to Groundwater.
	LANDAPPLICATION	Indicates whether the project affects the discharge to land application.
	OTHERREUSE	Indicates whether the project affects the discharge to an effluent reuse/recycling project or something other than this list of discharge options.
	ELIMINATESDISCHARGE	Indicates whether the project eliminates a discharge to a waterbody.
	NOCHANGENODISCHARGE	The project does not affect the discharge/there is No Discharge.
	NEPSTUDY	Indicates whether the project is located within a National Estuary Program (NEP) Study Area.
	CBR_SEASONAL	Indicates whether the discharge is seasonal.
	NPDESPERMITNUMBER	A National Pollutant Discharge Elimination System (NPDES) code used to uniquely identify a permitted NPDES facility.
	MANUALNPDESENTRY	Indicates whether the NPDES permit number is or is not in the PCS database for this Project.
	NONPDESPERMIT	There is no NPDES permit for this Project.
	PERMITTYPE	Any type of permit (other than NPDES) that applies to this project.
	PERMITNUMBER	Permit numbers (other than NPDES) that apply to this project.
	NOVALIDREACHCODE	There is no 14 digit reach code for this waterbody.
	PRIMARYIMPACTEDWATERBODYID	The NHD Reach Code (or HUC code for NPS project groups) for the waterbody first and foremost affected by the project.
	PRIMARYIMPACTEDWATERBODYNAME	The name of the waterbody first and foremost affected by the project.
	RECEIVINGWATERBODYPRIMARY	Indicates whether the Primary Impacted Waterbody is the receiving waterbody.
	PRIMARYIMPACTEDSTATEWATERBODYI	The state waterbody ID number/code for the waterbody first and foremost affected by the project.
	OTHERIMPACTEDWATERBODYID	The NHD Reach Code (or HUC code for NPS project groups) for the secondary impacted waterbody.
	OTHERIMPACTEDWATERBODYNAME	Name of the secondary impacted waterbody.
	RECEIVINGWATERBODYOTHER	Indicates whether the Other Impacted Waterbody is the receiving waterbody.
	OTHERIMPACTEDSTATEWATERBODYID	The state waterbody ID for the secondary impacted waterbody.
	WATERQUALITY	Indicates whether the project is aimed at the 'Improvement' or 'Maintenance' of the impacted waterbody.
	COMPLIANCEOBJECTIVE	Compliance objective of the project (Achieve Compliance, Maintain Compliance, Not Applicable).
	AFFECTEDWATERBODYSTATUS	Status of the affected waterbody (Meeting Standards, Impaired, Threatened, Not Assessed, Not Applicable).
	ADDRESSESEXISTINGTMDL	Indicates whether the project helps address an existing TMDL.
	ADDRESSESPROJECTEDTMDL	Indicates whether the project helps address a projected TMDL.
	ADDRESSESWATERSHEDMANAGEMENTPL	Indicates whether the project helps address a watershed management plan.
	CBR_COMMENTS	Comments on the project.
	PROJINF_LASTMODIFIEDDATE	Date and time Project record was last modified.
	PROJINF_LASTMODIFIEDUSER	User who last modified the Project record.
	PROJECTLOCATIONID	Primary key. Entered sequentially for the whole table.
	LOCATIONDESCRIPTION	Describes what the corresponding latitude/longitude pair refers to.
	LATITUDE	Latitude describing facility location.
	LONGITUDE	Longitude describing facility location.
	RADIUS	Radius (in miles) from the center point (the lat/long) that approximates the area of the project(s).
	LOCATIONORDER	Ignore. For future use.
	LOCINF_LASTMODIFIEDDATE	Date and time Project Locations record was last modified.
	LOCINF_LASTMODIFIEDUSER	User who last modified the Project Locations record.
	LOANKEY	Primary key from the Loan Information table.
	LOANRECORDNUMBER	Loan specific key value.
	LOANDATE	The loan execution date (YYYY/MM/DD)
	LOANNUMBER	The state's internal unique loan number.
	OTHERNUMBER	Any other number that is used to track this loan.
	ASSISTANCETYPE	Type of CWSRF assistance provided (Loan, Refinance Short-term Debt, Refinance Long-term Debt, Guarantee/Purchase Insurance, Sub-state Revolving Fund).
	INTERESTRATE	Interest rate on the CWSRF loan (including fees).
	INCREMENTALFUNDING	Indicates whether the loan is an extension of a previous loan.
	PHASENUMBER	Phase of funding if the loan is an extension of a previous loan.
	LOANAMOUNT	The dollar amount of the CWSRF loan (including fees).
	REPAYMENTPERIOD	The repayment period, in years, of the loan
	PREVIOUSLOANNUMBER	LoanNumber (unique loan number) of the first loan if the loan is an extension of a previous loan.
	SAMEENVIRONMENTALRESULTS	For projects where there has been an extension of funding, indicates whether the extension results in the same project activity and thus the same population served and environmental outcome as the previous (first) loan.
	FINALAMOUNTFLAG	For completed projects, indicates whether the CWSRF Assistance Amount $ has been adjusted to reflect actual final disbursements.
	PERCENTFUNDEDBYCWSRF	The percent of overall funding for the project(s) provided from the CWSRF.
	NONPOINTSOURCEPROJECTS	Indicates whether the Loan Amount represents funding for multiple nonpoint source projects that are being reported as a group.
	ENTRYCOMPLETEFLAG	Indicates whether the record is complete.
	LOANINF_LASTMODIFIEDDATE	Date and time Loan record was last modified.
	LOANINF_LASTMODIFIEDUSER	User who last modified the Loan record.
	BORROWERID	Primary Key from Borrower Table
	BORROWER	Name of the Borrower
	BORROWERS_LASTMODIFIEDDATE	Date and time Borrowers record was last modified.
	BORROWERS_LASTMODIFIEDUSER	User who last modified the Borrowers record.