Column Name: PWSID2

Description: Public Water System Identification Number (PWSID) (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: TUXSAMPLE

Data Source:

Data Element: PWSID Number
Oracle Table: TUXSAMPLE
Oracle Column: PWSID2

Properties:

Type: Character
Length: 21
Optional

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

Return To:

ICR Table & Column Information
Envirofacts Overview

Column Name: PWSID2

Local Navigation