Column Name: PWSID

Description: PWSID number (9 characters). The Public Water System Identification without the additional time stamp created by the Water Utility Database System. This is the PWSID that should be used to join to other information systems (information systems other than those that support ICR data).

Envirofacts Table Name: TUXUTDES

Data Source:

Data Element: PWS ID Number
Oracle Table: TUXUTDES
Oracle Column: PWSID

Properties:

Type: Character
Length: 9
Mandatory

Definition Source: Data Element Dictionary for the Information Collection Rule Auxiliary 1 Database.

Return To:

ICR Table & Column Information
Envirofacts Overview

Column Name: PWSID

Local Navigation