Table Name: TUXPLTMON
Description: Monthly operational plant data for each sampling period. The table combines operational plant data, sample analytical result data, and specific unit process data characteristics.
Relationships:
- Must have utility operational data provided by one or more TUXUNPRO related by column ICRWTPID.
- Must have water resource data provided by one or more TUXWRMON related by column ICRWTPID.
- Must have plant design provided by one and only one TUXPLTDES related by column ICRWTPID.
- Must provide monthly operational plant data for one or more TUXSAMPLE related by columns ICRWTPID and SAMP_PER.
- May have hypochlorite stock solution results provided by one and only one TUXHYPO related by columns ICRWTPID and SAMP_PER.
- Must have utility operational data provided by one and only one TUXUTMON related by column ICRPWSID.
- AL_DOSE
- AWSAVGQ
- AWSDAYQ
- AWSTYPE
- BFCOMP
- BLNDFLAG
- CLD
- COAGTYPE
- COMFLG01
- DS_DIS
- EVENT_ID
- FE_DOSE
- FINAVGQ
- FINMAXQ
- ICRPWSID
- ICRWTPID
- INFLAVGQ
- INFLDAYQ
- MPTNAME
- MPT_TYPE
- MSRC_CAT
- MSWCAT
- MWTPTYPE
- QAFLG01
- SAMPPTN
- SAMP_PER
- SLDGPROD
- SLDGPSOL
- WTP_DIS
- WWRAVGQ
- WWRCOAG
- WWRDAYQ
- WWRDIS
- WWRFILT
- WWROTH
- WWRSED
- WWRTYPE
Return To: