Table Name: SDW_WATER_SYSTEM
Description: Describes a water system.
Relationships:
- Sometimes is the subject of one or many SDW_ENFORCEMENT_ACTION re lated from column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes contracts one or many SDW_WATER_PURCHASE related from c olumn(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes is related to one or many SDW_WATER_SYS_GEO_AREA_ASGMT related from column(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes supplies water to one or many SDW_WATER_SYS_SERV_AREA_A SGMT related from column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes specifies one or many SDW_WATER_SYS_LEGAL_ENT_CONT rela ted from column(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes is described by one or many SDW_ANNUAL_OPERATING_PERIOD related from column(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes supplies one or many SDW_WATER_PURCHASE related from co lumn(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes is regulated by one or many SDW_REGULATING_AGENCY_ASGMT related from column(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes has attached to it one or many SDW_SERVICE_CONNECTION_C AT related from column(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes provides one or many SDW_SAMPLE related from column(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE to columns(s) TINWSYS_IS_NUMBER, TINWSYS_ST_CODE
- Sometimes incurs one or many SDW_VIOLATION related from column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes is characterized by one or many SDW_SIGNIFICANT_NON_COM PLIER related from column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes is characterized as one or many SDW_EXCEPTION related f rom column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes is applicable to one or many SDW_FISCAL_YEAR_TRACKER re lated from column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes is examined by one or many SDW_VISIT related from colum n(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes is documented by one or many SDW_MILESTONE_EVENT relate d from column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes receives one or many SDW_DEVIATION related from column( s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- Sometimes is supplied by one or many SDW_WATER_SYS_FACILITY_ASGMT related from column(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER to columns(s) TINWSYS_ST_CODE, TINWSYS_IS_NUMBER
- ACTIVITY_DATE
- ACTIVITY_RSN_TXT
- ACTIVITY_STATUS_CD
- ALTERNATE_ST_NUM
- AVG_DAILY_PROD_MSR
- D_FED_PRIM_SRC_CD
- D_FIRST_IDENT_TS
- D_HISTORY_IND_CD
- D_LAST_INV_UPDT_TS
- D_LAST_UPDT_TS
- D_POPULATION_COUNT
- D_PRIN_CITY_SVD_NM
- D_PRIN_CNTY_SVD_NM
- D_PWS_FED_TYPE_CD
- D_PWS_ST_TYPE_CD
- D_ST_PRIM_SRC_CD
- D_TTL_STOR_CAP_MSR
- D_USERID_CODE
- EXCEP_STAT_IND_CD
- EXCEP_STAT_IND_DT
- GRND_WTR_PUR_RATIO
- GRND_WTR_RATIO
- GRND_WTR_UDI_PURCH
- GRND_WTR_UDI_RATIO
- LOCAL_NAME
- MEMO_TEXT
- NAME
- OPER_CATEGORY_CD
- OWNER_TYPE_CODE
- PWS_ID
- SURF_WTR_PUR_RATIO
- SURF_WTR_RATIO
- TINWSYS_IS_NUMBER
- TINWSYS_ST_CODE
- TOTAL_DSGN_CAP_MSR
- TTL_EMERG_CAP_MSR
Return To:
![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif)