# Attribute

Description:
The User ID of the person who created this record.  Field introduced during the SSWr1 release.  All records added prior to release will show SSWr1 in this field.


Description:
The timestamp of when this record was created.  Field introduced during the SSWr1 release.  All records added prior to that release will show as "2005-01-01.00:01.


Description:
The d_last_updt_ts value from the sampling point record being captured in history.


Description:
The d_userid_cd value from the sampling point record being captured in history.


Description:
The timestamp of when this record was created.  Field introduced during the SSWr1 release.  All records added prior to that release will show as "2005-01-01.00:01."


Description:
A text area to record additional information for the storage facility.


Description:
The number of inches the well cap is above the grade.


Description:
User-defined name for driller.  If populated, Driller_Name is not a defined Legal Entity and no driller association to LEGAL ENTITY will exist.


Description:
The system-generated internal system number. Will be populated using the next higher number within the associated Well Facility.


Description:
The type of casing material.  Examples include brick, asbestos-cement, concrete, galv. iron, wrought iron, other metal, pvc or plastic, rock or stone, steel, tile, coated steel, wood, or other.


Description:
The diameter of the interior of the casing in inches.


Description:
The measurement of the casing.  Used with top measure relativity to indicate the definition of top.


Description:
The relativity of the top as defined by ground level.


Description:
The unit of measure for the top measure.


Description:
The unit of measure for the bottom depth measure.


Description:
The timestamp at the update of the record.


Description:
The User ID of the person who last updated this record.


Description:
The timestamp at the creation of the record.


Description:
The User ID of the creator of the record.


Description:
The system-generated internal system number. Will be populated using the next higher number within the associated Water System Facility.


Description:
The User ID of the last person to modify this record.


Description:
This attribute will enable users to record and keep a history of when the facility was assessed for security status.


Description:
This attribute will enable users to record and keep a history of when the security status for the facility was determined.


Description:
User-defined name for assessor.  If populated, Assessor_Name is not a defined Legal Entity.


Description:
A text area to record observations about the security assessment.


Description:
The User ID of the person who created this record.


Description:
This attribute identifies the water system facilities that are part of the same flow.


Description:
This attribute identifies the order of the water system facilities in a specific flow.


Description:
A system administrator controlled code of the type of water flowing between the facilities.


Description:
The number that represents the proportional distance on the ground for one unit of measure on the map or photo.


Description:
The timestamp of when this record was created. Field introduced during the SSWr1 release. All records added prior to that release will show as "2005-01-01.00:01."


Description:
A System Administration-controlled code of the reason a water system has the status indicated.  This may be used to indicate why a water system has been inactivated but also may be used to indicate why it is active or proposed.


Description:
This field will be used to to enter the number of days a water system serves at least 25 persons. This field will be used to override the calculated population served via Annual Operating Period durations when they do not adequately describe the days served for the water system.

Note that for this numeric attribute, a true null will be used so that zero means zero and does not mean null.


Description:
This field will be used to indicate whether or not the Water System is new, with only minimal information as entered on the Add New Water System page.


Description:
The User ID of the person who created this record. Field introduced during the SSWr1 release. All records prior to that release will show SSWR1 in this field.


Description:
The User ID of the person who created this record. Field introduced during the SSWr1 release. All records added prior to that release will show SSWR1 in this field.


Description:
The timestamp of when this record was created. Field introduced during the SSWr1 release. All records added prior to this release will show as "2005-01-01.00:01."


Description:
The timestamp of when this record was created. Field introduced during the SSWr1 release. All records added prior to this release will show as 2005-01-01.00:01."


Description:
The timestamp of when this record was created. Field introduced during the SSWr1 release. All records added prior to this 
release will show as "2005-01-01.00:01."


Description:
The User ID of the person who created this record. Field introduced during the SSWr1 release. All records added prior to that 
release will show SSWR1 in this field.


Description:
The Last Update Timestamp value from the water system record being captured in history.


Description:
The Last Update User ID value from the water system record being captured in history.


Description:
This field indicates whether a substitute should always be allowed to satisfy the schedule even if a matching result exists, optionally be allowed to satisfy the schedule, i.e., when a matching result does not exist or never allowed to satisfy the schedule.


Description:
A code indicating the process that should act on this row.  Allowed values will be GDV for Gen Derived Values and ETCR for Evaluate TCR.  These will not be implemented as permitted values.


Description:
The name of the inventory change that is triggering the process.


Description:
The timestamp of when this record was created. Field introduced during the SSWr1 release. All records added prior to this release will show as "2005-01-01."


Description:
The date that the legal entity was associated with the water system facility.


Description:
The date that the legal entity was disassociated from the water system facility.


Description:
A designer attribute to indicate if the Sampling Plan is associated to an Analyte, an Analyte Group, or neither (blank).


Description:
The system-generated internal system number.  Will be populated using the next higher number within the associated Sampling Plan Sample Point Asgmt (TMNSPSPA).


Description:
The intended date on which a sample will be taken.


Description:
The number of days, plus or minus that the actual sample collection date can be deviated from the planned sampling date.  A value of 0 means no deviation is allowed and the dates must match. 

Example:  Planned Sampling Date = 12/02/2000.  Tolerance Days Count = 1 then the sample collection end date may be 12/01/2002 to 12/03/2000.


Description:
The User ID of the person who created this record.  Field introduced during the SSWr1 release.  All records added prior to that release will show SSWR1 in this field.


Description:
The number of times a sample or group of samples exceeded a regulated level.  The exceedence could be by a given sample or for a group of samples over a period of time.


Description:
Will record the required number of samples.  Will be used with the number of actual samples collected to determine the samples missing count.


Description:
Will record the number of samples missing by calculating the value from the number of samples required less the number of samples collected.


Description:
The code that indicates whether the row is defined by Federal rules, indicated with a value of 'HQ' or state rules, indicated by the primacy state code.


Description:
The indication of whether the data element is required to have a value or restricted from having a value.  Permitted Values will be 'REQUIRE' and 'RESTRICT.'  A value of require will be used to ensure that the specified data element contains a value.  A value of restrict will be used to ensure that the specified data element does not contain a value.


Description:
The name of the data element to which the rule code is applicable.  It corresponds to a data element on the VIOLATION entity.


Description:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
The date that the rule becomes effective.


Description:
The date that the rule is last effective.  May contain a null value.


Description:
The code that indicates whether the row is defined by Federal rules, indicated with a value of 'HQ' or state rules, indicated by the primacy state code.  When the value is set to 'HQ' the row applies to the derivation of the violation's federal_period_begin_date and federal_period_end_date.  When the value is set to other than 'HQ' the row applies to the derivation of the violation's state_period_begin_date and state_period_end_date.


Description:
A code used to indicate how the violation period begin date should be determined.  All permitted values are described in reference to a monitoring period.  This will be used for CDS processes.  For online violation maintenance and Migration to SDWIS/STATE, the state violation period begin date will be used in the determination of the federal violation period dates.


Description:
A date used to limit the violation period begin date.  When a value is provided the violation period begin date cannot be prior to this date.


Description:
A date used to limit the violation period begin date.  When a value is provided the violation period begin date cannot be after this date.


Description:
A date used to limit the violation period end date.  When a value is provided the violation period end date cannot be prior to this date.


Description:
A date used to limit the violation period end date.  When a value is provided the violation period end date cannot be after this date.


Description:
Indication that the violation period end date can be left null when the value is set to 'Y'.


Description:
Indication that the violation period begin date can be after the date of creation when the value is set to 'Y'.


Description:
The value will indicate whether the associated analyte is allowed for the violation type or is to be denied for the violation type.


Description:
The timestamp when this record was created.  Field introduced during the sSWr1 release.  All records added prior to that release will show 1/1/2005 in the field.


Description:
The value in this field represents the highest value generated via the last-executed schema migration script.  It is populated so that an historical reference point is created for external system numbers generated by schema migration versus those generated post-schema migration.


Description:
The User ID of the user when the record was created.


Description:
This field may be used to record the purpose or other additional classification for collection of the sample.


Description:
This field may be used the type of sample results associated to the sample, for instance IOC, VOC, TC, etc


Description:
The timestamp at the time the record was created.


Description:
A system-generated value that indicates when the record was first posted to the database.


Description:
A system-generated value that indicates the specific person that first posted this record to the database.


Description:
The system-generated internal system identifier.


Description:
The state code of the data owner. For federal ownership value will be 'HQ'.


Description:
A code or abbreviation for a unit of measure.


Description:
The name of a unit of measure used primarily to report the outcome of a laboratory analytical result.


Description:
A category name used to group units of measures mostly by type of measurement made.


Description:
A code that loosely correlates to the type of analyte for which the unit of measure is appropriate. This field is used to determine the maintenance page for which the UOM is appropriate.


Description:
The result value to be used for compliance of the sample schedule in the designated monitoring period.


Description:
A code or abbreviation for a unit of measure that applies to the compliance value.


Description:
The system generated internal identifier number of the row.


Description:
The name of the measure type for the sample. This value is populated from the name field of the selected OTHER SAMPLE PERMITTED MEASURE.


Description:
The numeric value of the measure made. Mutually exclusive with value_text, one of these two fields must have a value. This field will be populated when the data_type field of the selected SAMPLE_MEASURE_TYPE = 'N'. The value of this field cannot be exceed the field_size or decimal_places as indicated in the selected SAMPLE MEASURE TYPE values.


Description:
The text value of the measure made. This field will be populated when the data_type field of the selected SAMPLE MEASURE TYPE = 'T'. The value of this field cannot exceed the field_size as indicated by the selected SAMPLE MEASURE TYPE value.


Description:
The unit of measure abbreviation for the selected OTHER SAMPLE PERMITTED MEASURE.


Description:
The system generated internal system number used to identify the data row.


Description:
The state code used to identify ownership of the data. For federally owned data the value will be 'HQ'.


Description:
The name of a measure type appropriate as a permitted value for a sample.


Description:
The data type appropriate for the values used with the measure type. This field controls the data type of the value entered in the Value field when entering or maintaining a record in OTHER SAMPLE MEASURE.


Description:
The field size allowed in the Value field when entering or maintaining a record in OTHER SAMPLE MEASURE.


Description:
The number of decimals allowed in the Value field when entering or maintaining a numeric data type record in OTHER SAMPLE MEASURE. The value in this field cannot be greater than the value in the field_size attribute.


Description:
The unit of measure abbreviation for the selected OTHER SAMPLE ANALYSIS PERMITTED MEASURE.


Description:
The text value of the measure made. This field will be populated when the data_type field of the selected SAMPLE ANALYSIS MEASURE TYPE = 'T'. The value of this field cannot exceed the field_size as indicated by the selected SAMPLE ANALYSIS MEASURE TYPE value.


Description:
The numeric value of the measure made. Mutually exclusive with value_text, one of these two fields must have a value. This field will be populated when the data_type field of the selected SAMPLE ANALYSIS MEASURE TYPE = 'N'. The value of this field cannot exceed the field_size or decimal_places as indicated by the selected SAMPLE ANALYSIS MEASURE TYPE values.


Description:
The name of the measure type for the sample analytical result. This value is populated from the name field of the selected OTHER SAMPLE ANALYSIS PERMITTED MEASURE.


Description:
An abbreviation of the name of a measure type appropriate as a permitted value for a sample analysis.


Description:
The data type appropriate for the values used with the measure type. This field controls the data type of the value entered in the Value field when entering or maintaining a record in OTHER SAMPLE MEASURE. Permitted values are: N - Numeric, T - text.


Description:
This field is used to determine the sequence of presentation of permitted values for a result.


Description:
The User ID of the person who created this record. Field introduced during the SSWr1 release. All records added prior to release will show SSWr1 in this field.


Description:
This field will be used to indicate whether or not the Water System Facility is a source facility.


Description:
The percent of a water system's total quantity of water that is supplied by the water system facility on average. The value entered here for consecutive connections and non-piped facilities will be displayed in the purchase records on both the buyer and seller side so that a primacy agency can estimate the total number of people served by a water system that sells water.


Description:
This attribute will enable users to record and keep a history of when physical modifications were made to a facility.  The software will create a WSF History record when this date is changed, thus making a record of a previously entered modification date.  When updated for a subsequent physical modification date, the prior physical modification date is retained on the WSF History record.


Description:
This attribute will allow users to record the date the source water was determined to be under or not under the influence of surface water.


Description:
SWAP is the acronym for Source Water Assessment Program.  This indicator will allow user to indicate status of SWAP report.


Description:
This attribute will allow users to record the date of the current SWAP report status.  SWAP is the acronym for Source Water Assessment Program.


Description:
A System Administrator-controlled code of the reason a water system facility has the status indicated.  This may be used to indicate why a water system facility has been inactivated but also may be used to indicate why it is active or proposed.


Description:
A System Administration-controlled code of the reason a water system facility has the status indicated.  This field will capture the filtration status of non-emergency SW or GU source water.  EPA requires reporting of the filtration status of all surface water (SW) and ground water under the influence of surface water (GU) sources that supply water to a public water system.


Description:
This attribute will allow users to record the date the Filtration Status was determined.


Description:
The history of when physical modifications were made to a facility.


Description:
The history of the filtration status of a facility.


Description:
The history of the date the Filtration Status for a facility was determined.


Description:
The d_last_updt_ts value from the water system facility record being captured in history.


Description:
The d_userid_cd value from the water system facility record being captured in history.


Description:
The timestamp when the record was last modified.


Description:
A code or abbreviation for a unit of measure in upper case.


Description:
Amount of a microbial analyte which treatment plant is credited with being able to remove, based on design.


Description:
Amount of analyte which treatment plant has achieved removal of, based on performance.


Description:
Amount of analyte which the treatment plant is required by federal or state mandate to remove.


Description:
Amount of analyte inactivation needed.  Generally the amount required, minus the amount achieved.


Description:
Unit of measure code for all four counts.


Description:
A text area to document additional information.


Description:
The status of the contact time determination.


Description:
The status of the disinfection profile benchmark for Giardia inactivation.


Description:
The disinfection profile benchmark for Giardia inactivation percent.


Description:
The disinfection profile benchmark for virus inactivation in Logs.


Description:
The status of the disinfection profile benchmark for Virus inactivation.


Description:
The disinfection profile benchmark for virus inactivation percent.


Description:
The date the disinfection virus benchmark was determined.


Description:
The status of the BIN determination for the Long Term 2 Surface Water Treatment Rule.


Description:
The BIN number for the Long Term 2 Surface Water Treatment Rule.


Description:
The date the BIN number was determined for the Long Term 2 Surface Water Treatment Rule.


Description:
The status of a request from the water system to request an alternate location for return of the filter backwash.


Description:
The date that the water system requested an alternate location for return of the filter backwash.


Description:
The status of corrective action by the water system as required by the primacy agency after review of the schematic of the filter backwash flow in the treatment plant.


Description:
The date that the water system achieved the corrective action required for the filter backwash.


Description:
A memo field into which a user may enter comments about the Filter Backwash Recycled Rule.


Description:
Code representing a second classification of the treatment unit.  Permitted values set in Permitted Values (TINPVALS) code-name = UNITSUBTYP.


Description:
The system-generated internal system number.  Will be populated using the next higher number within the associated Treatment Unit.


Description:
A code to identify the train or flow of water through treatment units within the treatment plant.


Description:
A code to identify the sequence of this treatment unit flow within the train.


Description:
A text area where additional documentation can be provided.


Description:
This field indicates whether the associated analyte is being removed or inactivated or whether it is being added to the water supply via the treatment plant.


Description:
Amount of analyte removed by or added at the treatment objective and process at this treatment unit.


Description:
A timestamp when valued or updated will indicate that an SSMPA needs to be processed by CDS Setup.


Description:
User id whose indirect update to the SSMPA requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
The system-generated internal system number. Will be populated using the next higher number within the associated Water System.


Description:
The date/time that the step was initiated.


Description:
The name of the step which can be any of the following: Extract, Copy to Server, Migration to State (Update), Export (Refresh), Import (Refresh), or BuildSyncTable (Refresh).


Description:
The date/time that the step was successfully completed.


Description:
Sequential number assigned to the request.


Description:
The network machine name of the tablet PC.


Description:
The date/time that the SDWIS/STATE ToGo process was initiated.


Description:
The date/time that the SDWIS/STATE ToGo process was successfully completed.


Description:
The number of times an unfinished request is restarted.


Description:
The total number of rows in all the staging tables.


Description:
The type of request.  The valid values are as follows: "Update" and "Refresh".


Description:
The status of the current processing step. The valid values are as follows: "Request Completed", "Processing Started", "MTS COMPLETED SUCCESSFULLY", "<Step name> Started" and "<Step name> Completed", where <Step name> is the actual name of the process.


Description:
The name of the table in which modifications and insertions will be extracted from the Distributed Database.  

For the initial release of SDWIS/STATE ToGo, the field will contain one of the following values: TINVISIT, TINDEFCY, TINSVINA, TINSVDFA.


Description:
The date/time the table was copied from the Central Database to the Distributed Database.  Because the tablet PC may be in a different time zone than the Central Database, the date/time of the tablet PC is used.


Description:
The highest internal system number of the table at the time of the refresh.


Description:
The IS Number of the water system facility to which the advisory applies.   This attribute in conjunction with the WSF_TINWSF_ST_CODE is a virtual foreign key to the Water system facility entity type.


Description:
The St Code of the water system facility to which the advisory applies.  This attribute in conjunction with the WSF_TINWSF_IS_NUMBER is a virtual foreign key to the Water system facility entity type.


Description:
The IS Number of the sampling point to which the advisory applies.  This attribute in conjunction with the SP_TSASMPPT_ST_CODE is a virtual foreign key to the sampling point entity type.


Description:
The St Code of the sampling point to which the advisory applies.  This attribute in conjunction with the SP_TSASMPPT_IS_NUMBER is a virtual foreign key to the sampling point entity type.


Description:
The IS Number of the sample schedule to which the advisory applies.  This attribute in conjunction with the SS_TMNSASCH_ST_CODE is a virtual foreign key to the sample schedule entity type.


Description:
The St Code of the sample schedule to which the advisory applies.  This attribute in conjunction with the SS_TMNSASCH_IS_NUMBER is a virtual foreign key to the sample schedule entity type.


Description:
The IS Number of the sample schedule group to which the advisory applies.  This attribute in conjunction with the SS_TMNSSGRP_ST_CODE is a virtual foreign key to the sample schedule group entity type.


Description:
The St Code of the sample schedule group to which the advisory applies.  This attribute in conjunction with the SS_TMNSSGRP_IS_NUMBER is a virtual foreign key to the sample schedule group entity type.


Description:
The IS Number of the sample to which the advisory applies.  This attribute in conjunction with the SMP_TSASAMPL_ST_CODE is a virtual foreign key to the sample entity type.


Description:
The St Code of the sample to which the advisory applies.  This attribute in conjunction with the SMP_TSASAMPL_IS_NUMBER is a virtual foreign key to the sample entity type.


Description:
The IS Number of the sample result to which the advisory applies.  This attribute in conjunction with the SAR_TSASAR_ST_CODE is a virtual foreign key to the sample result entity type.


Description:
The St Code of the sample result to which the advisory applies.  This attribute in conjunction with the SAR_TSASAR_IS_NUMBER is a virtual foreign key to the sample result entity type.


Description:
This attribute would be populated from the TSAANGRP_IS_NUMBER  attribute of the Analyte Group entity type.

The analyte group will be the one associated to the schedule group of the hidden schedule that is assessed.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute would be populated from the tsaangrp_st_code attribute of the Analyte Group entity type.

The analyte group will be the one associated to the schedule group of the hidden schedule that is assessed.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute would be populated from the Code attribute of the Analyte Group entity type.

The analyte group will be the one associated to the schedule group of the hidden schedule that is assessed.


Description:
This attribute would be populated from the Name attribute of the Analyte Group entity type.

The analyte group will be the one associated to the schedule group of the hidden schedule that is assessed.


Description:
The name of the database schema to which the SDWIS/STATE application is connected.


Description:
A unique message that advises the user of potential issues with data or items to check.


Description:
The system-generated internal system number.  Will be populated using the next higher number within the associated CDS Setup Processing Log.


Description:
Identifies the specific CDS Setup process that generated the advisory.


Description:
The IS Number of the water system to which the advisory applies.  By including the internal system number and state code, users will be able to easily create reports that separate the advisories by regulating agency.  This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a virtual foreign key to the Water system entity type.


Description:
The St Code of the water system to which the advisory applies.  By including the internal system number and state code, users will be able to easily create reports that separate the advisories by regulating agency.  This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a virtual foreign key to the Water system entity type.


Description:
The last update user ID from the record that generated the advisory.  For example, if a change to a water system generated the advisory, this field would be valued with the d_userid_code of the water system record.


Description:
The water system number to which the advisory applies.


Description:
The water system name to which the advisory applies.


Description:
When a change to the D_PWS_FEDERAL_TYPE_CODE for a water system triggers an advisory, the value recorded in the D_PWS_FEDERAL_TYPE_CODE in the WATER_SYSTEM_HISTORY record will be recorded in this field.


Description:
When a change to the D_PWS_FEDERAL_TYPE_CODE for a water system triggers an advisory, the value recorded in the D_PWS_FEDERAL_TYPE_CODE in the WATER_SYSTEM record will be recorded in this field.


Description:
When a change to the D_POPULATION_COUNT for a water system triggers an advisory, the value recorded in the D_POPULATION_COUNT in the WATER_SYSTEM_HISTORY record will be recorded in this field.


Description:
When a change to the D_POPULATION_COUNT for a water system triggers an advisory, the value recorded in the D_POPULATION_COUNT in the WATER_SYSTEM record will be recorded in this field.


Description:
When a change to the D_FED_PRIMARY_SOURCE_CODE for a water system triggers an advisory, the value recorded in the D_FED_PRIMARY_SOURCE_CODE in the WATER_SYSTEM_HISTORY record will be recorded in this field.


Description:
When a change to the D_FED_PRIMARY_SOURCE_CODE for a water system triggers an advisory, the value recorded in the D_FED_PRIMARY_SOURCE_CODE in the WATER_SYSTEM record will be recorded in this field.


Description:
When a change to a record that references a water system facility triggers an advisory, the state_asgn_identification_code for the water system facility will be recorded in this field.


Description:
When a change to a record that references a water system facility triggers an advisory, the name for the water system facility will be recorded in this field.


Description:
When a change to a record that references a sampling point triggers an advisory, the identification_code for the sampling point will be recorded in this field.


Description:
When a change to a record that references a sampling point triggers an advisory, the description_text for the sampling point will be recorded in this field.


Description:
When a sampling point is inactivated and CDS Setup deletes one or more of the associations between the sampling point and a schedule, the activity_date of the sampling point will be recorded in this field.


Description:
When the change to the population for a PWS crosses from one category to another as defined by a rule, the abbreviation_text of the rule (from the Rule table) will be recorded in this field for the first rule category change identified.


Description:
When the change to the population for a PWS crosses from one category to another as defined by a rule, the abbreviation_text of the rule (from the Rule table) will be recorded in this field for the second rule category change identified.


Description:
When the change to the population for a PWS crosses from one category to another as defined by a rule, the abbreviation_text of the rule (from the Rule table) will be recorded in this field for the third rule category change identified.


Description:
When the change to the population for a PWS crosses from one category to another as defined by a rule, the abbreviation_text of the rule (from the Rule table) will be recorded in this field for the fourth rule category change identified.


Description:
When the change to the population for a PWS crosses from one category to another as defined by a rule, the abbreviation_text of the rule (from the Rule table) will be recorded in this field for the fifth rule category change identified.


Description:
When the change to the population for a PWS crosses from one category to another as defined by a rule, the abbreviation_text of the rule (from the Rule table) will be recorded in this field for the sixth rule category change identified.


Description:
The code of the analyte for the Sample Schedule that was impacted when a sampling point was inactivated.


Description:
The code of the analyte group of the Group Schedule associated to the Sample Schedule that was impacted when a sampling point was inactivated.


Description:
The begin date of the Sample Schedule that was impacted when a sampling point was inactivated.


Description:
The abbreviation of the rule for the Sample Plan that was impacted when a sampling point was inactivated.


Description:
The name of the regulating agency for the Sample Plan that was impacted when a sampling point was inactivated.


Description:
The code of the analyte or analyte group for the Sample Plan that was impacted when a sampling point was inactivated.


Description:
The begin date of the Sample Plan that was impacted when a sampling point was inactivated.


Description:
The lab_assigned_id_number of the Sample identified in the advisory.


Description:
The collection_end_date of the Sample identified in the advisory.


Description:
The analyte code referenced by the result identified in the advisory.


Description:
The name of the monitoring period identified in the advisory.


Description:
The begin date of the monitoring period identified in the advisory.


Description:
The end date of the monitoring period identified in the advisory.


Description:
The violation type of the candidate violation identified in the advisory.


Description:
The analyte code of the candidate violation identified in the advisory.


Description:
The begin date of the candidate violation identified in the advisory.


Description:
The end date of the candidate violation identified in the advisory.


Description:
The value in fiscal_year for the violation identified in the advisory.


Description:
The value in external_system_number (i.e., the FedRep ID) for a violation or group_number for a violation_group identified in the advisory.


Description:
The value in d_current_status_type_code for a violation identified in the advisory.


Description:
The analyte code referenced by the violation or the analyte group code referenced by the violation group identified in the advisory.


Description:
The violation type referenced by the violation identified in the advisory.


Description:
The date recorded in state_period_begin_date for the violation identified in the advisory.


Description:
The date recorded in state_period_end_date for the violation identified in the advisory.


Description:
The system-generated identifier for the record.


Description:
The state code of the installed SDWIS STATE application site.


Description:
The timestamp of when CDS Setup was launched.


Description:
The timestamp of when the CDS Setup run ended under system control.


Description:
Records the date recorded in the CDS History Date field (table D_PWS_RULE_TABLE - TINPRT) at the time CDS Setup was launched.


Description:
Records the name of the CDS Setup Time Processing report, a text file created in folder c:\sdwis\cds\setup.


Description:
The purpose or reason for the water purchase.


Description:
Narrative information about the water system.


Description:
A system-generated value which uniquely identifies the sampling point subschedule.


Description:
A system-generated value that represents the calendar date and time on which this record was initially posted to the data base, when a subsequent modification was made, or when the record was deleted.


Description:
A coded value that identifies the specific person making changes to the data.


Description:
The minimum number of times that a sample must be drawn at a specific sampling point.


Description:
A system-generated value which uniquely identifies the sampling point schedule group subschedule.


Description:
The minimum number of times that a sample must be drawn at a specific Sampling Point Schedule Group Subschedule.


Description:
A system-generated value that indicates when the record was posted to the data base.


Description:
The violation period begin date used for federal reporting.


Description:
The violation period end date used for federal reporting.


Description:
The date on which the Water System was notified that ????


Description:
Highest level of deficieny for the Site Visit


Description:
A coded value which specifies the unit of measure for the approved design capacity measure.


Description:
Place to store comments about the deficiency.


Description:
Auto-generated number to identify the Violation Package


Description:
Provides a place to record free text information about the sample.


Description:
Date that the MDBP Summary is reported to ???


Description:
Number of samples required for specified analyte and water system facility.


Description:
Number of samples collected for specified analyte and water system facility.


Description:
Indicates status of M&R compliance for specified analyte and water system facility.


Description:
The total number of outlier samples, that is, samples that exceed the   Max ,Min, or 95P Measure Level.


Description:
The percentage of outlier samples, that is, samples that exceed the  Max ,Min, or 95P Measure Level, stored as a number.


Description:
The percentage of outlier samples, that is, samples that exceed the  Max ,Min, or 95P Measure Level, stored as text in order to preserve the trailing zeros ( which indicate the precision of the measure).


Description:
A coded value that indicates the type of legal entity.


Description:
The highest measure during the specified monitoring period.


Description:
The average measure for the specified analyte during the specified monitoring period.


Description:
The average measure for the specified analyte during the specified monitoring period stored as text in order to preserve the trailing zeros ( which indicate the precision of the measure).


Description:
The running annual average measure for the specified analyte.


Description:
The running annual average measure for the specified analyte  stored as text in order to preserve the trailing zeros ( which indicate the precision of the measure).


Description:
Individual Filtered Turbidity Monitored Indicator - to specify whether or not each filter was monitored continuously.


Description:
Individual Filtered Turbidity Recorded Indicator - to specify whether or not each filter was recorded every 15 minutes.


Description:
Individual Filtered Turbidity Equipment Indicator - to specify whether or not there was a failure of the continuously monitoring equipment.


Description:
The system-generated date that the treatment objective and treatment process were associated.

Source:  IBS Team


Description:
Individual Filtered Turbidity Greater Than 1.0  Indicator - to specify that individual filter turbidity (IFT) level was greater than 1.0 NTU in two consecutive measurements.


Description:
A system-generated value that represents the calendar date and time on which this geographic area was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
Individual Filtered Turbidity Greater Than 0.5  Indicator - to specify that individual filter turbidity (IFT) level was greater than 0.5 NTU in two consecutive measurements after on line for more than four hours.


Description:
User may indicate in this field that the seller water system's source was treated.   This field should only be valued for water system facilities of type "CC" (consecutive connection).  This information is reported to EPA via Migration to SDWIS/FED.
This indicator is applicable to purchased sources only 
                  and indicates whether the seller is or is not treating 
                  the source or whether the seller treatment status is 
                  unknown.  Applies only to source facilities.


Description:
A system-generated value that indicates the date on which a treatment process was assigned to a treatment objective.


Description:
Individual Filtered Turbidity Greater Than 1.0 during 3 consecutive months indicator - to specify that individual filter turbidity (IFT) level was greater than  1.0 NTU in two consecutive measurements in three consecutive months.


Description:
A coded value that categorizes the treatment objective.


Description:
A coded value that categorizes the treatment process.


Description:
Individual Filtered Turbidity Greater Than 2.0 during 2 consecutive months indicator - to specify that individual filter turbidity (IFT) level was greater than  2.0 NTU in two consecutive measurements in two consecutive months.


Description:
The highest measure during the specified monitoring period stored as text in order to preserve the trailing zeros ( which indicate the precision of the measure).


Description:
The unique code for identifying a water system facility sample point.


Description:
The date that the legal entity was associated with the water system.


Description:
The coded value that represents the location type of a sampling point.  E.g. Unit Process, Water System Facility, and/or Distribution System.


Description:
The date that the legal entity was disassociated from the water system.


Description:
A coded value which indicates whether the relationship between the water system and the government agency is active or inactive.


Description:
A coded value to indicate whether the relationship between the water system and the legal entity is active or inactive.


Description:
The date that the legal entity was assigned to the water system.


Description:
The date that the legal entity was unassigned from the water system.


Description:
The alias, common name, or acronym for a legal entity.


Description:
The unit of measurement for the quantity of water.

Source:  DMJRP, IBS Team


Description:
A coded value which categorizes the non-piped facility.


Description:
The date when a water system no longer meets the criteria which caused it to report a "DONE" milestone.


Description:
A coded value that indicates if a cadastral legal description is available for this water system facility.


Description:
Two- character alphabetic code representing a country 
 of the world.  Valid, federally-accepted values are stored in the Permitted Values table in the System Administration component.  Note that if value in this field is CA (Canada) and you supply a St_Code, it must be one of the valid two-character St_Codes for Canada.


Description:
All codes for all postal zones for all countries except the U.S.


Description:
Flag set by CDS Setup component  when the schedule has been processed to determine if it has any Sampling Point Sub-Schedules for which Sampling Point Sub-SSMPA records need to be created.  Once CDS Setup has set  this flag is set to Y, the user cannot modify or delete any of the Sampling Point Sub- Schedules.


Description:
Individual Filter Monitoring Required Flag -- either Yes/No


Description:
Last date/time that CDS Setup Increased/Decreased Assessment processes evaluated the schedule.


Description:
A system-generated value that represents the calendar date and time on which this well was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
Contact Time in minutes--the number of minutes the water was in contact with the disinfectant in order to be properly disinfected.


Description:
Disinfection Benchmark Giardia Inactivation in Logs


Description:
Date the Disinfection Benchmark was determined


Description:
Giardia Removal Granted for Filtration in Logs


Description:
Giardia inactivation needed based on what was granted from filtration, in Logs


Description:
Giardia inactivation achieved based on CT value, in Logs


Description:
Cryptosporidium Inactivation achieved based on CT value, in Logs


Description:
Virus Inactivation achieved based on CT value, in Logs


Description:
(Unfiltered (UF), Conventional Filtration (CF), Direct Filtration (DF), Diatomaecious Earth (DE), Other(OT), and other permitted values that the System Administrator may add)


Description:
Text description associated with the Contact Time


Description:
Text description associated with the Disinfection Benchmark Reason


Description:
The first date a faciltiy analyte level was made effective.


Description:
The last date a faciltiy analyte level was effective.


Description:
The measure of facility analyte  level.   This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.  The value in this field needs to be convertable to a number of 15 (9).


Description:
Value that represents the unit of measure associated with the CONCENTRATION_MEASURE.


Description:
The type ( minimum or maximum) of facility analyte  level that may be set.


Description:
The actual reported measure of a non-TCR summary result.  This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.  The text value is  converted to a number and stored in the Sample Summary Result Measure attribute.


Description:
A system-generated value which, along with TMNSAMSC_ST_CODE, uniquely identifies the sample schedule.

Source:  TCR Team


Description:
A designed attribute which identifies the associated state.  Used with TMNSAMSC_IS_NUMBER, it uniquely identifies the deviation.


Description:
The effective begin date for the schedule.  This means that the monitoring requirement associated to the schedule was applied to the water system facility on this date.


Description:
The effective end date for the schedule.  This means that the monitoring requirement associated to the schedule no longer applies to the water system facility as of this date.


Description:
Part of the Seasonal Collection Period range, which signifies that the water system collects the samples within this period. This field in combination with the Start Month stores the Beginning Date of the Collection Period


Description:
Part of the Seasonal Collection Period range, which signifies that the water system collects the samples within this period. This field in combination with the Start Day stores the Beginning Date of the Collection Period


Description:
Part of the Seasonal Collection Period range, which signifies that the water system collects the samples within this period. This field in combination with theEnd Month stores the End Date of the Collection Period


Description:
Part of the Seasonal Collection Period range, which signifies that the water system collects the samples within this period. This field in combination with theEnd Day stores the End Date of the Collection Period


Description:
Start date of the initial Monitoring Period. This date will be used to determine future Monitoring Periods that satisfy the Schedule Group based on the periodicity of the Schedule Group's Monitoring Requirement.


Description:
A computed value that represents the calendar date on which a monitoring requirement schedule assignment record was initially posted to the data base.


Description:
Part of the State Assigned Collection Period range, which signifies  that the water system collects samples within this period. This is similar to the Seasonal Collection Period except that the States designate the water systems to collect samples within a given date range and a specific year within the Monitoring Period ( e.g. Collect Samples between January and March in the second year of a tri-annual Monitoring Period).  This field in combination with the State_Start_Month stores  the Beginning Date of the State Assigned Collection Period.  SDWIS/STATE does not consider the five values in  State Assigned Collection Period for purposes of determining M&R compliance.


Description:
Part of the State Assigned Collection Period range, which signifies  that the water system collects samples within this period. This is similar to the Seasonal Collection Period except that the States designate the water systems to collect samples within a given date range and a specific year within the Monitoring Period ( e.g. Collect Samples between January and March in the second year of a tri-annual Monitoring Period).  This field in combination with the State_Start_Day stores  the Beginning Date of the State Assigned Collection Period.  SDWIS/STATE does not consider the five values in  State Assigned Collection Period for purposes of determining M&R compliance.


Description:
Part of the State Assigned Collection Period range, which signifies  that the water system collects samples within this period. This is similar to the Seasonal Collection Period except that the States designate the water systems to collect samples within a given date range and a specific year within the Monitoring Period ( e.g. Collect Samples between January and March in the second year of a tri-annual Monitoring Period).  This field in combination with the State_End_Month stores  the End Date of the State Assigned Collection Period.  SDWIS/STATE does not consider the five values in  State Assigned Collection Period for purposes of determining M&R compliance.


Description:
Part of the State Assigned Collection Period range, which signifies  that the water system collects samples within this period. This is similar to the Seasonal Collection Period except that the States designate the water systems to collect samples within a given date range and a specific year within the Monitoring Period ( e.g. Collect Samples between January and March in the second year of a tri-annual Monitoring Period).  This field in combination with the State_End_Day stores  the End Date of the State Assigned Collection Period.  SDWIS/STATE does not consider the five values in  State Assigned Collection Period for purposes of determining M&R compliance.


Description:
The date that user identifies the analyte (and indirectly the hidden schedule)  in the Schedule Group which should cease to be monitored according to the common requirement imposed on all other analytes in the Schedule Group.  This analyte now becomes an "exception analyte",  and its hidden schedule will be closed; that is, its Effective Period End Date will be the same date as Exception Analyte Effective Date.


Description:
This field stores the year as a number (0-9) and specifies which year within the State Assigned Collection Period to collect samples for compliance.   SDWIS/STATE does not consider the five values in  State Assigned Collection Period for purposes of determining M&R compliance.


Description:
This field stores the year as a number (0-9) and specifies which year within the State Assigned Collection Period to collect "for compliance" samples.   SDWIS/STATE does not consider the five values in  State Assigned Collection Period for purposes of determining M&R compliance.


Description:
The first date that applies for monitoring period average calculations  based on the Sample Schedule Effective Period Begin Date plus the  Sample Schedule Start Month/Day (the annual operating period start month/day).


Description:
The last date that applies for monitoring period average calculations  based on the Sample Schedule Effective Period End Date plus the  Sample Schedule End Month/Day (the annual operating period end month/day).


Description:
Describes how the MCL compliance method for a particular analyte should be calculated:  RAA (running annual average) or MPA  (monitoring period average)


Description:
The last date that applies for monitoring period average calculations  based on the Sample Schedule Effective Period End Date plus the  Sample Schedule End Month/Day (the annual operating period end month/day).  Contains same date as Applicable Period End Date in Sample Schedule Monitoring Period Asgmt (table TMNSSMPA)


Description:
The first date that applies for monitoring period average calculations  based on the Sample Schedule Effective Period Begin Date plus the  Sample Schedule Start Month/Day (the annual operating period start month/day).   Contains same date as Applicable Period Begin  Date in Sample Schedule Monitoring Period Asgmt (table TMNSSMPA)


Description:
Describes how the MCL for a particular analyte should be calculated:  RAA (running annual average) or MPA  (monitoring period average)


Description:
The unrounded  numeric value that is the monitoring period average for a set of routine sample  results and confirmation sample results (that may be linked to the routine results) that are for a given monitoring period,collected in response to a given sampling schedule for a specific analyte and water system facility.


Description:
The measurement units used to expressed the measure or value


Description:
APPLICABLE_PERIOD_END_DATE - APPLICABLE_PERIOD_BEGIN_DATE (inclusive of both days).  This field may be useful when creating reports.


Description:
The value for a given analyte, sampling location and period of time that is compared against an MCL to determined compliance.  This value can be based on a single result or the average of two or more results and can be based on the result(s) collected in a single monitoring period (e.g., for nitrate) or multiple monitoring periods (when compliance for an analyte is based on a running annual average and monitoring is quarterly or more frequent).  It should be rounded to the same significant digits as the corresponding MCL.  

 

If corresponding sample schedules and initial monitoring periods have been entered, this value will be calculated by SDWIS/STATE.  SDWIS/STATE uses Monitoring Period Average(s) when calculating MCL Values.  A user can overwrite a value determined by SDWIS/STATE using the Results Averages Maintenance component.  Note that, if a corresponding sample schedule or initial monitoring period has not been entered, users are not able to enter MCL Values.


Description:
The type of material used to cover/seal the well, such as 4" concrete slab, etc.


Description:
The business FAX number of an individual.

Format:  (AAA)-EEE-NNNN  

Where:   AAA = the telephone area code
         EEE = the telephone exchange
         NNNN = the telephone number


Description:
A coded value that indicates whether or not the service area is the primary area served by the water system.


Description:
A coded value which provides a broad categorization of the service area.


Description:
A system-generated value that represents the calendar date and time on which this water system service area assignment was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
Text field that represents the numeric value stored in Calculated Value


Description:
A coded value that indicates whether or not the geographic area is one of the primary areas for a water system.  Usually there is only one primary area for a water system, but there are exceptions where there may be several primary areas.

)


Description:
The name of the unit process for the treatment plant facility.

Source:  OGWDW


Description:
A coded value which categorizes the connection between the treatment plant facilities.  

Source:  OGWDW (amended)


Description:
A designed attribute which identifies the associated state and is used in conjuction with the IS_NUMBER to uniquely identify this entity/table.


Description:
Comments associated with the reason the request was denied by the primacy agency.


Description:
The effective start date of the monitoring waiver.


Description:
The effective end date of the monitoring waiver.


Description:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

Source:  IBS Team


Description:
Identifies the organization of the individual.


Description:
An state-supplied optional identifying number for the waiver.


Description:
The status of the waiver -- either Proposed,  Granted, Under review, or Denied


Description:
The date the water system applied for the monitoring waiver.


Description:
A value which classifies the water system according to state requirements.  A state user may override the system classification result.


Description:
A system-generated coded value which classifies the water system according to federal requirements.


Description:
A coded value that represents the user identification needed to log onto the system.


Description:
The date the Primacy Agency responded to the water system's application for the monitoring waiver.


Description:
A coded value which indicates the access category.


Description:
This attribute is a copy of the MCL value for a particular analyte.  It has been added to the Monitoring Period Average entity to speed the calculations that reside in the Calculated MCL Value entity.


Description:
The number of results used in the calculation of a given Monitoring Period Average.


Description:
The code for the government agency that establishes the rule.


Description:
The number of results used in the calculation of a given MCL Value.  This value will be used by CDS to determine if a candidate MCL violation should be type 01 or type 02.   This value can be different from the value in the attribute of the same name in Monitoring Period Average, because it may take the running annual average (not just the monitoring period average) into account.


Description:
The minimum number of service connections required for a system to be considered a public water system.


Description:
The Start Date  of the period or  gap that may occur when the  Seasonal Schdule Period ends after the Monitoring Period Begin Date and that same seasonal schedule period begins before the monitoring  period end date.  Sample Results whose Sample Collection Date fallsduring this gap will not be associated to the Sample Schedule Monitoring Period Asgmt and ultimately will not be counted for purposes of monitoring compliance.  Recording when a gap exists also supports the calculation of the Monitoring Period AverageTotal Days.


Description:
The minimum count for a transient population served to satisfy the rule.


Description:
The End Date  of the period or gap that may occur when the  Seasonal Schdule Period ends after the Monitoring Period Begin Date and that same seasonal schedule period begins before the monitoring  period end date.  Sample Results whose Sample Collection Date fallsduring this gap will not be associated to the Sample Schedule Monitoring Period Asgmt and ultimately will not be counted for purposes of monitoring compliance.  Recording when a gap exists also supports the calculation of the Monitoring Period AverageTotal Days.


Description:
The minimum count in days for a operating period to satisfy the rule.


Description:
When valued with Y, indicates that a user explicitly associated a monitoring period to a result via online Sampling (one of the Sample Result Maintenance windows).  This means that the SSMPA (belonging to the user-selected monitoring period)  which is associated to the result at the same time should not be deleted by CDS Setup.


Description:
Indicates whether the schedule has been assessed for increased, decreased, or same monitoring and the result of the assessment as  I(Increased), D(Decreased), S(Same), or N(not assessible).
.


Description:
The minimum count for a non-transient population served to satisfy the rule.


Description:
A coded value that categorizes the activity of the sampling point.


Description:
The date that thesampling point activity status was last changed.


Description:
Indicates if a water system facility can be powered by an emergency source of power under the control of the water system.


Description:
The reason the sampling point status was changed.


Description:
The first of three text fields where user may store additional address or other information about the sampling point.


Description:
The second of three text fields where user may store additional address or other information about the sampling point.


Description:
The third of three text fields where user may store additional address or other information about the sampling point.


Description:
Indicates if this treatment objective process assignment is the primary treatment.  The first treatment objective process assignment entered will default to the primary treatment for that process.


Description:
The depth below the measuring point to the top of the screen.  The measuring point is recorded as the water system facility altitude measure.  The unit of measurement is in feet.


Description:
The depth below the measuring point to the bottom of the screen.  The measuring point is recorded as the water system facility altitude measure.  The unit of measurement is feet.


Description:
Describes the type of screen.

Examples include slotted, sand point, etc.

Source:  DMJRP, IBS Team


Description:
A coded value which uniquely identifies an aquifer.  This coding scheme is assigned by the state or responsible organization and varies by state.

Source: DMJRP


Description:
A coded value which categorizes the aquifer.


Description:
A coded value which contains the U.S. Geological Survey's identification code for the aquifer.


Description:
The standard aquifer name assigned by USGS.

This standardization effort is still in development.


Description:
The description of the geologic material within the aquifer.  Examples include limestone, gravel, sand, sandstone.


Description:
The depth to the top of the water bearing formation that the well draws from.  The measurement unit is feet.


Description:
A value that specifies the estimated thickness of the aquifer.  The measurement unit is in feet.


Description:
A coded value which indicates whether or not the aquifer is confined.


Description:
This attribute is populated from the Code attribute of the Analyte that is associated to the Schedule that is violated in case it is an M & R violation or the Analyte that is associated to the Schedule that is associated to the SSMPA which is associated to the  Calculated MCL value in case it is an MCL violation


Description:
This attribute in conjunction with the ALRA_TMNALRA_ST_CODE is a virtual foreign key to the ALRA entity type. This attribute will be used by the users to link to the ALRA record corresponding to this exceedence if they need to look up any attribute of the ALRA that is not de-normalised in this table.

This attribute will be populated with the TMNALRA_IS_NUMBER column from the ALRA table whose values were exceeded by this exceedence.

This attribute will be blank if the exceedence is referencing a facility analyte level record.


Description:
The coded value for a type of analyte level measurement. These levels include limits of laboratory methods, etc. ex mcl, mclg, TRL

This attribute is populated from the threshold_level_type or msr_level_type columns of the ALRA record or the level type of the facility analyte level record.

Refer to the ALRA_TMNALRA_IS_NUMBER attribute description to determine which ALRA record to get this value from.


Description:
Type of MDBP Summary.  (This is the value that is stored in the Code Value and Permitted Value tables maintained in the System Administration component.)


Description:
The numerical value for a particular analyte level that has been established in rule, policy, or guidance as a health-based/nonhealth-based level.   This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.

This attribute will be populated from the Measure text comlumn of the ALRA record or the measure text column of the fanl record.

Refer to the ALRA_TMNALRA_IS_NUMBER or FANL_TMNFANL_IS_NUMBER attribute description to determine which ALRA record to get this value from.


Description:
Describes the status of the Site Visit as either Completed or Planned.


Description:
The measurement units used to expressed the MCL, MCLG, or other level

This attribute would be populated from the UOM CODE column of the ALRA table or the FANL table.

Refer to the ALRA_TMNALRA_IS_NUMBER or FANL_TMNFANL_IS_NUMBER attribute description to determine which ALRA record to get this value from.


Description:
A coded value that identifies the U.S. Geological Survey's Hydrologic Unit Code.

Format:  RRPPAACC 
 
Where:   RR = a U.S. Water Resources Council (WRC) region
         RRPP = a WRC planning subregion
         RRPPAA = an accounting unit of the National Water Data Network
         RRPPAACC = a cataloging unit of the USGS Catalog of Information on Water Data.

Each part of the river reach code (e.g., rr, pp) delineates a hydrologic drainage basin that defines (from left to right) a progressively smaller basin size.  The water resources region (i.e., rr) being the largest area, and the river reach (i.e., rr pp aa cc sss) being the smallest area.  When coupled with the river reach miles, a specific physical location along a river reach can be established.  Acceptable Hydrologic unit codes are defined in Federal Information Processing Standard Publication (FIPS PUB) 103, which is entitled, "Codes for the Identification of Hydrologic Units in the United States and the Caribbean Outlying Areas."  This FIPS PUB is also known as, "Geological Survey Circular 878-A."


Description:
A coded value that identifies the U.S. EPA Storet system's Hydrologic Unit Code extension (the segment).

Format:  SSS 

Acceptable river reach codes are defined by the U.S. EPA's STORET Office for use in their Water Quality System Reach File.


Description:
Source -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
Treatment -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
A code for the organization (state or federal) that approved the pairing of a treatment objective and treatment process.  Permitted values include state postal abbreviation codes for states and "HQ" for EPA.


Description:
Distribution System -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
The Federal employer identification number (EIN) assigned by the IRS.


Description:
Finished Water Storage -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
Pumps (facilities, controls, etc.) -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
This is the CODE value corresponding to an analyte EX: 3100 for TCR 1022 for lead etc., 

This attribute would be populated from the Code attribute of the Analyte entity type.

The analyte will be the one selected by the user when executing the alert report.


Description:
Monitoring and Reporting (M&R) and Data Verification (DV) -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
This field would contain the begin date of the monitoring period associated with the SAR or SSR that caused this exceedence. This field is optional.

This would be populated with the value in the Begin date attribute of the monitoring period entity type.


Description:
This field would contain the end date of the monitoring period associated with the SAR or SSR that caused thius exceedence. This field is optional.

This would be populated with the value in the End date attribute of the monitoring period entity type.


Description:
This field would contain the duration type code of the monitoring period associated with the SAR or SSR that caused thius exceedence. This field is optional.

This would be populated with the value in the type code attribute of the monitoring period entity type.


Description:
This field would contain the name of the monitoring period associated with the SAR or SSR that caused thius exceedence. This field is optional.

This would be populated with the name in the Begin date attribute of the monitoring period entity type.


Description:
This would be populated from the number attribute of the water system entity type. 

Please refer to the PWS_TINWSYS_IS_NUMBER attribute description on how to deteremine the water system record  to obtain this value from.
Source attribute description:
Uniquely identifies the water system within a specific state.

Format:  SSXXXXXXXXXX  

Where:   SS = the FIPS Pub 5-2 State abbreviation in which the water system is located, or the region number of the EPA region responsible for an Indian reservation
         XXXXXXXXXX = the water system identification code assigned by the State


Description:
This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_IS_NUMBER column from the water system that is associated to the SAR that caused this exceedence.


Description:
Water System Management and Operations -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_ST_CODE column from the water system that is associated to the SAR that caused this exceedence.


Description:
This would be populated from the name attribute of the water system entity type. 

Please refer to the PWS_TINWSYS_IS_NUMBER attribute description on how to deteremine the water system record  to obtain this value from.

Source attribute description:
The name of the water system. The name can be the formal, legal, or common name that is used most generally in referring to the water system.

When multiple facilities exist for the water system at different physical locations, the name identifies the means by which the system, as a whole, is generally known.


Description:
This would be populated from the ACTIVITY_STATUS_CODE attribute of the water system entity type. 

Please refer to the PWS_TINWSYS_IS_NUMBER attribute description on how to deteremine the water system record  to obtain this value from.

Source attribute Description.

A coded value that categorizes the activity of the water system Example A( Active) I (Inactive) etc.,.


Description:
Operator Compliance Evaluation -- one of the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.


Description:
This would be populated from the ACTIVITY_DATE attribute of the water system entity type. 

Please refer to the PWS_TINWSYS_IS_NUMBER attribute description on how to deteremine the water system record  to obtain this value from.

Source attribute Description.
The date that the water system activity indicator code was last changed.


Description:
This would be populated from the FED_PRIMARY_SOURCE_CODE  attribute of the water system entity type. 

Please refer to the PWS_TINWSYS_IS_NUMBER attribute description on how to deteremine the water system record  to obtain this value from.

Source attribute description:
A system-generated value that categorizes the primary water source for the water system. Examples are Ground water( GW), Surface water(SW)  etc.,


Description:
Other -- value that can be set in addition to the eight elements set out in EPA/State Joint Guidance on Sanitary Surveys.  Default is Not Evaluated.


Description:
This would be populated from the FEDERAL_TYPE_CODE attribute of the water system entity type. 

Please refer to the PWS_TINWSYS_IS_NUMBER attribute description on how to deteremine the water system record  to obtain this value from.

Source attribute description:
A system-generated coded value which classifies the water system according to federal requirements.  Examples are CWS(Community), NTNC (Non Transient Non Community) etc.,


Description:
A value that is set equal to the calendar date and time on which any inventory related record in the water system was posted or updated in the data base.


Description:
The calendar day on which the water system's season of operation commences.


Description:
The calendar month on which the water system's season of operation commences.


Description:
This would be populated from the POPULATION_COUNT attribute of the water system entity type. 

Please refer to the PWS_TINWSYS_IS_NUMBER attribute description on how to deteremine the water system record  to obtain this value from.

Source attribute Description.
A system-generated count of the total population served by a water system.  Previously, the population count was represented by a population range ("A" for under 101 persons served, "B" for 101 to 500 persons served, etc).

Note:  May need to re-evaluate population categories for less than 25 persons served code and for 25 to 100 persons served.  SDCJRP


Description:
The calendar day on which the water system's season of operation ends.


Description:
This attribute in conjunction with the WSF_TINWSF_ST_CODE is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_IS_NUMBER column from the water system facility that is associated to the SAR or SSR that caused this exceedence.


Description:
The calendar month on which the water system's season of operation ends.


Description:
This would be populated from the name attribute of the water system facility entity type. 

Please refer to the WSF_TINWSF_IS_NUMBER attribute description on how to deteremine the water system facility record  to obtain this value from

Source attribute description:

The name of the water system facility.


Description:
This would be populated from the type code attribute of the water system facility entity type. 

Please refer to the WSF_TINWSF_IS_NUMBER attribute description on how to deteremine the water system facility record  to obtain this value from

Source attribute description:

A coded value which categorizes the water facility.
	
Every water system must include at least one WATER_SYSTEM_FACILITY occurrence.


Description:
This would be populated from the STATE_ASGN_ID attribute of the water system facility entity type. 

Please refer to the WSF_TINWSF_IS_NUMBER attribute description on how to deteremine the water system facility record  to obtain this value from
Source attribute description:

A state-assigned value which identifies the water system facility.


Description:
This would be populated from the activity date attribute of the water system facility entity type. 

Please refer to the WSF_TINWSF_IS_NUMBER attribute description on how to deteremine the water system facility record  to obtain this value from

Source attribute description:

The date on which the water system facility 
became proposed, active, or inactive.


Description:
This would be populated from the water type code attribute of the water system facility entity type. 

Please refer to the WSF_TINWSF_IS_NUMBER attribute description on how to deteremine the water system facility record  to obtain this value from

Source attribute description:
A coded value which categorizes the source water that is utilized by a water system.


Description:
This would be populated from the availability code attribute of the water system facility entity type. 

Please refer to the WSF_TINWSF_IS_NUMBER attribute description on how to deteremine the water system facility record  to obtain this value from

Source attribute description:
A coded value that categorizes the circumstances under which a source of water is utilized by a water system.


Description:
This would be populated from the external sytem number attribute of the water system facility entity type. 

Please refer to the WSF_TINWSF_IS_NUMBER attribute description on how to determine the water system facility record to obtain this value from

Source attribute description:
Identifies the source water system facility record being uploaded to SDWIS/FED.


Description:
This attribute in conjunction with the WSF_ TINWSF_IS_NUMBER is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_ST_CODE column from the water system facility that is associated to the SAR or SSR that caused this exceedence.


Description:
This attribute in conjunction with the SP_TSASMPPT_ST_CODE is a virtual foreign key to the Sampling Point entity type. This attribute will be used by the users to link to the Sampling Point  record corresponding to this exceedence, if they need to look up any attribute of the Sampling Point that is not de-normalised in this table.

This attribute will be populated with the TSASMPPT_IS_NUMBER column from the sampling point that is associated to the SAR or SSR that caused this exceedence.


Description:
This attribute in conjunction with the SP_TSASMPPT_IS_NUMBER is a virtual foreign key to the Sampling Point entity type. This attribute will be used by the users to link to the Sampling Point  record corresponding to this exceedence, if they need to look up any attribute of the Sampling Point that is not de-normalised in this table.

This attribute will be populated with the TSASMPPT_ST_CODE column from the sampling point that is associated to the SAR or SSR that caused this exceedence.


Description:
This would be populated from the Type code attribute of the sampling point entity type. 

Please refer to the SP_TSASMPPT_IS_NUMBER attribute description on how to deteremine the sampling point record  to obtain this value from.

Source attribute description:
The coded value that represents the location type of a sampling point.  E.g. Unit Process, Water System Facility, and/or Distribution System.


Description:
This would be populated from the Identification code attribute of the sampling point entity type. 

Please refer to the SP_TSASMPPT_IS_NUMBER attribute description on how to deteremine the sampling point record  to obtain this value from.

Source attribute description:
The unique code for identifying a water system facility sample point.


Description:
This would be populated from the Description attribute of the sampling point entity type. 

Please refer to the SP_TSASMPPT_IS_NUMBER attribute description on how to deteremine the sampling point record  to obtain this value from.

Source attribute description:
A description of the sampling point in English.


Description:
This would be populated from the Source type code attribute of the sampling point entity type. 

Please refer to the SP_TSASMPPT_IS_NUMBER attribute description on how to deteremine the sampling point record  to obtain this value from.

Source attribute description:
The type of water source, based on whether treatment has taken place.


Description:
This would be populated from the Post Disinfection Indicator code attribute of the sampling point entity type. 

Please refer to the SP_TSASMPPT_IS_NUMBER attribute description on how to deteremine the sampling point record  to obtain this value from.

Source attribute description:
Indicates if the sample was collected after a disinfection process has been applied.


Description:
This would be populated from the Process phase Indicator code attribute of the sampling point entity type. 

Please refer to the SP_TSASMPPT_IS_NUMBER attribute description on how to deteremine the sampling point record  to obtain this value from.

Source attribute description:
Indicates the location of the sample with respect to the unit process.  Eg. after (sample is drawn at the outtake of the unit process), before (sample is drawn at the intake of the unit process), and during (sample is drawn within the unit process).


Description:
The calendar day on which a facility's season of operation commences.

Source:  SDCJRP, MINJAD


Description:
The calendar day on which a facility's season of operation ceases.


Description:
The beginning calendar month, day, and year for which the water system facility's season of operation is in effect.


Description:
The ending calendar month, day, and year for which the water system facility's season of operation is in effect.


Description:
The type of deficiency (e.g. SIG, MIN, etc.)


Description:
This field categorizes the deficiency into one of the ten category evaluation summaries during the Site Visit: the eight sanitary survey elements identified by the EPA/State Joint Guidance on Sanitary Surveys (i.e., Source, Treatment, Distribution System, Finished Water Storage, Pump/Pumping Facility & Control, M&R/Data Verification, System Management & Operation, Operator Compliance with State Requirements), plus the two elements required by the Public Health Security and Bioterrorism Preparedness and Response Act of 2002, and the SDWA Amendments of 1996 (i.e., Security and Financial).  An eleventh category, Other, will be a catch-all category.  A category of "Unknown" and spaces are also included.  "Unknown" is included to enable the migration and storage of historical deficiencies as well as new ones which have not yet been classified.  Spaces is included as the default, thereby forcing the user to pick one of the eleven appropriate categories.


Description:
The calendar date on which the deficiency was determined  during the site visit for the public water system.


Description:
The date on which the Water System was notified of the existence of the deficiency.


Description:
Identifies the specific deficiency incurred by a public water system.  Deficiency data is not required by federal reporting requirements, the routine use for data in a field by this name.  However, this serves as a good identifying field, and will be used for that reason.


Description:
Type may be either Violation or  Deficiency.  This field controls the type of standard response window that is displayed, depending on whether you are invoking a standard response from the Violation or the Site Visit area.


Description:
Number that will be added to the  Deficiency Water System Notification Date to calculate the Deficiency Scheduled Activity Projected Date.


Description:
Indicates if a log exists for a given well that shows a graphical representation of the transit of an acoustical pulse through a length of material.


Description:
Indicates if a log exists for a given well that shows a graphical record of the diameter of an uncased borehole at various depths.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
Indicates if a log exists for a given well that shows a graphical representation of the resistivity to the flow of electric current or electrical potentials (voltages) through subsurface geologic formations.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.

The sample identification number assigned by the laboratory for tracking the sample within the lab.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.
 
A numeric value assigned by a state to uniquely identify a specific sampling occurrence.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 The type of sample.


Description:
Indicates if a log exists for a given well that shows a record prepared by a geologist or engineer that presents a description of the lithology of each formation penetrated by the well (e.g., sand, shale).


Description:
Indicates if a log exists for a given well that shows a graphical representation of the 
 natural, induced, or isotope injection radioactivity of subsurface geologic formations.


Description:
Indicates if a log exists for a given well that shows a continuous record of temperature in the borehole taken at various depths.


Description:
Indicates if a log exists for a given well that shows a video tape record of the features of a well created by lowering a video camera into the well.


Description:
Indicates if a log exists for a given well that provides a description of the material penetrated during drilling, prepared by the drilling crew.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 Used in most cases as the Sample Collection Date.  This field appears on all Sample Maintenance windows and is used as the Sample Collection Date in Sampling via EDI.   Sometimes a sample is collected over a period of time (e.g. protozoa). In such cases, this is the date the sample collection event ended.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.


The limit established by the laboratory below which scientifically reliable results cannot be achieved.  In many cases, if the computed detection limit is below the Method Detection Limit, then the Method Detection Limit is used as the detection limit; if the computed detection limit is above the Method Detection Limit, then the detection limit is used.


Description:
The identification number that can be used by the state to classify the government agency.  This may be a Region or District number or the FIPS code for that government agency.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

The unit of measure associated with the detection limit.


Description:
The extension for the business telephone number of an individual.

Format:  NNNN  

Where:   NNNN = the extension number


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

Binary indication of whether the result is "less than" the Lab Reporting Limit or "less than" the Regulatory Minimum Reporting Limit.
For example, the user may select Regulatory Minimum Reprting Limit (which sets the Limit attribute to the RMDL Measure in ANALYTE RULE ASGMT) and check/activate the "less than indicator" to indicate result is less than the RMDL.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

The actual reported measure of a chemical/rad/water quality result.  This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.  The text value is also converted to a number and stored in the SBS_SAR Concentration_Measure attribute.

Source:  SBS Team


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

The counting error estimated by the laboratory due to turbidity in the sample or other analytical anomalies. Usually expressed as a value "plus or minus" the picocuries per liter measure.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

Value that represents the unit of measure associated with the CONCENTRATION_MEASURE.


Description:
The common name of a contaminant as used by states and EPA in the rules and other documents. 

This attribute would be populated from the Name attribute of the Analyte entity type.

The analyte will be the one selected by the user when executing the alert report.


Description:
This attribute corresponds to the Analyte that is associated to the  SBS Sample analytical result that is the basis of this record.


Description:
This attribute corresponds to the Analyte that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 The common name of a contaminant as used by states and EPA in the rules and other documents.


Description:
This attribute corresponds to the Monitoring Period that is associated to the  SBS Sample analytical result that is the basis of this record.


Description:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

In this case the identifier is a composite of this attribute and the TCDSEX_ST_CODE


Description:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

This attribute + the TCDSEX_IS_NUMBER form the composite identifier for this table.

These columns have no business relevance.


Description:
This attribute corresponds to the Sample Summary that is associated to the Sample Summary result that is the basis of this record.
 
 The start date of the collection time period during which the sample summary should be taken.


Description:
This attribute corresponds to the Sample Summary that is associated to the Sample Summary result that is the basis of this record.
 
 The end date of the collection time period during which the sample summary should be taken.


Description:
This attribute corresponds to the Sample Summary that is associated to the Sample Summary result that is the basis of this record.
 
 Date that the sample was received at the laboratory.


Description:
This attribute corresponds to the Sample Summary that is associated to the Sample Summary result that is the basis of this record.
 
 Provides a place to record free text information about the sample summary.


Description:
This attribute corresponds to the Analyte that is associated to the Sample Summary result that is the basis of this record.


Description:
This attribute corresponds to the Analyte that is associated to the Sample Summary result that is the basis of this record.
 
 The common name of a contaminant as used by states and EPA in the rules and other documents.


Description:
This attribute corresponds to the Monitoring Period that is associated to the Sample Summary result that is the basis of this record.


Description:
This attribute corresponds to the Sample Summary result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the Sample Summary result that is the basis of this record.
 
 The description of a sample summary by a count of its attributes.


Description:
This attribute corresponds to the Sample Summary result that is the basis of this record.
 
 Number of occurrences of each specific Typecode in a specific Sample Analysis Summary.


Description:
This attribute corresponds to the Sample Summary result that is the basis of this record.
 
 A numeric value that represents the result obtained from a sample analysis.


Description:
This attribute corresponds to the Sample Summary result that is the basis of this record.
 
 Value that represents the unit of measure associated with the SAMPLE_SUMMARY_RESULT Measure.


Description:
This attribute is populated from the Name attribute of the Analyte that is associated to the Schedule that is violated in case it is an M & R violation or the Analyte that is associated to the Schedule that is associated to the SSMPA which is associated to the  Calculated MCL value in case it is an MCL violation


Description:
The violation period begin date assumed to reflect the date the primacy agency would assign.  This usually is equivalent to the begin date of the monitoring period involved in the candidate violation determination.  When the candidate violation is migrated into the violation table in SDWIS/STATE, this will populate the state_period_begin_date, which is the violation period begin date assigned by the state and is not reported to fed.


Description:
The violation period end date assumed to reflect the date the primacy agency would assign.  This usually is equivalent to the end date of the monitoring period involved in the candidate violation determination.  When the candidate violation is migrated into the violation table in SDWIS/STATE, this will populate the state_period_end_date, which is the violation period end date assigned by the state and is not reported to fed.


Description:
This attribute is populated from theType attribute of  the Monitoring period that would be associated to the violation, this would be populated from the Monitoring period associated to the SSMPA that was cause of this violation if it is a < & R violation or that is associated to the Calculated MCL value in case of an MCL violation.


Description:
This attribute is populated from the Name attribute of  the Monitoring period that would be associated to the violation, this would be populated from the Monitoring period associated to the SSMPA that was cause of this violation if it is a < & R violation or that is associated to the Calculated MCL value in case of an MCL violation.


Description:
This value will be populated by the create CDS candidate violation process based on the violation that is determined. 

A coded value which categorizes a violation.


Description:
This attribute is populated from the Code attribute of the Analyte group that is associated to the Schedule Group that is violated in case it is an M & R violation or tblank in case it is an MCL violation

 Each analyte goup has a unique code assigned.  This code is unique not only within the analyte groups in the database but also within the analytes in the database.  This code is part of the uniqueness criteria.


Description:
This attribute is populated from the Name attribute of the Analyte group that is associated to the Schedule Group that is violated in case it is an M & R violation or tblank in case it is an MCL violation

The name assigned to the Group of analytes.


Description:
This attribute will contain the Calculated MCL Value for MCL violations and blank for M & R violations.

The concentration value or averaged concentration value of one or more results with which the violation is associated and whose values have caused the violation  to be created.  Value is reported in text format to preserve precision (i.e., leading and trailing zeroes).  Needs to conform to a number of size 15(9).  (The sixteenth character is for the decimal place.)


Description:
This attribute will contain the UOM of the Calculated MCL Value for MCL violations and blank for M & R violations.

The unit of measure associated with the ANALYSIS_RESULT_MEASURE.  This value will default to MG/L for all chemical analytes and PCI/L for all radionuclide analytes.


Description:
Will have a value of S for all violations determined by CDS.

A coded value that represents the source or origin of the violation (e.g. the state, the region, or EPA).  S (State) is the defualt value for SDWIS/STATE.


Description:
This attribute will be populated with a Y for all M&R violations created for a schedule group.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

When valued, indicates that the analytical result (concentration) was below the Regulatory Minimum Reporting Level or below the Laboratory Reporting Level (which in turn must be at or below the regulated MCL for the analyte).


Description:
This attribute will contain the number of results from the calculated MCL value in case of MCL Violations and will be blank for M & R Violations


Description:
This attribute corresponds to the Sample Summary result that is the basis of this record.
 
 Code indicating whether or not the sample summary result meets established data quality acceptance criteria.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

Code indicating whether or not the sample anlytical result meets established data quality acceptance criteria.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 When selected in the sample record, the sample and its results will be used (by any automated software) in the determination of compliance for that sample.  Samples not selected will not be used in any compliance determination.


Description:
This attribute corresponds to the Sample Summary that is associated to the Sample Summary result that is the basis of this record.
 
 Indicates whether or not the sample summary was taken for purposes of compliances.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 Indicates the sample is a replacement for a previously drawn routine, repeat, or other type of sample.  (For example, the sample may be of type RP (repeat) and also be a replacement.)


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 The name of the Collector if a Collector is supplied who is not an Individual who is a legally designated Collector in the  Individual table.


Description:
This attribute corresponds to theSBS Sample that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 The end time of the collection in local standard time.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 Start date of the initial Monitoring Period. This date will be used to determine future Monitoring Periods that satisfy the Schedule Group based on the periodicity of the Schedule Group's Monitoring Requirement.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 This field stores the year as a number (0-9) and specifies which year within the State Assigned Collection Period to collect "for compliance" samples.   SDWIS/STATE does not consider the five values in  State Assigned Collection Period for purposes of determining M&R compliance.


Description:
This attribute corresponds to the Analyte that is associated to the Sample_Schedule record that forms the basis of this record.

 The common name of a contaminant as used by states and EPA in the rules and other documents.


Description:
This attribute corresponds to the Analyte that is associated to the Sample_Schedule record that forms the basis of this record.

 The standard code used by EPA and the states to represent analytes in the national database.  Each analyte has a unique code assigned to it for reference in compliance determination.


Description:
This attribute corresponds to the Analyte group  that is associated to the Sample_Schedule record that forms the basis of this record.

  Each analyte goup has a unique code assigned.  This code is unique not only within the analyte groups in the database but also within the analytes in the database.  This code is part of the uniqueness criteria.


Description:
This attribute corresponds to the Analyte group  that is associated to the Sample_Schedule record that forms the basis of this record.

 The name assigned to the Group of analytes.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 The effective start date of the monitoring requirement.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 The effective end date of the monitoring requirement.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record. Represents DD/MM.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.   Represents DD/MM.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 A system-generated value which, along with TMNSAMSC_ST_CODE, uniquely identifies the sample schedule.

Source:  TCR Team


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 A designed attribute which identifies the associated state.  Used with TMNSAMSC_IS_NUMBER, it uniquely identifies the deviation.


Description:
This attribute corresponds to the Monitoring_Requirement that is associated to the Sample_Schedule record that forms the basis of this record.

 A system-generated value which, along with TMNmnr_ST_CODE, uniquely identifies the monitoring requirement.


Description:
Compliance Schedule Activity type code.    (This is the value that is stored in the Code Value and Permitted Value tables maintained in the System Administration component.)  This value will be used to populate the Activity Type Code of the Compliance Schedule that is associated to the Site Visit.


Description:
This attribute corresponds to the Monitoring_Requirement that is associated to the Sample_Schedule record that forms the basis of this record.

 A designed attribute which identifies the associated state.  Used with TMNMNR_IS_NUMBER, it uniquely identifies the monitoring requirement.


Description:
(F)inal, (P)roposed, (S)uperceded. This value will be used to populate the Status of the Compliance Schedule that is associated to the Site Visit.


Description:
This attribute corresponds to the Monitoring_Requirement that is associated to the Sample_Schedule record that forms the basis of this record.

 Indicates if the monitoring requirement is routine, a special study, re-analysis of existing sample(s) for the same analyte or another analyte, or repeat.

Example:  a positive for TC will require re-analysis for fecal coliform (routine, special, re-analysis, repeat)


Description:
The number of days after the Deficiency WS Notification Date that will be used to calculate the Compliance Schedule Effective Date that is associated to the site visit.  If the Site Visit has a WS Notification Date, the software will use that date, otherwise it will use the WS Notification Date from the first selected Deficiency (first by WS Notification Date) even if the Deficiency has a WS Notification Date from an earlier Site Visit.  If the user wants to change the calculated date, then the user would need to change the Begin Date in the Compliance Schedule.


Description:
This attribute corresponds to the Monitoring_Requirement that is associated to the Sample_Schedule record that forms the basis of this record.

 The minimum number of times that a sample must be drawn.  This number is used in conjuction with Sample Count Unit Code.


Description:
This attribute corresponds to the Monitoring_Requirement that is associated to the Sample_Schedule record that forms the basis of this record.

 The frequency at which the sample must be drawn.  The number is captured in the attribute Sample Count.

(i.e. Monthly, Yearly, Daily)


Description:
Period associated with the specified frequency number.


Description:
Four- character alphabetic code representing descriptions of the deficiency that may be controlled by the System Administrator.  Values are stored in the Permitted Values table in the System Administration component.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 The reason for the monitoring requirement sample schedule assignment.


Description:
This attribute in conjunction with the ALRA_TMNALRA_IS_NUMBER is a virtual foreign key to the ALRA entity type. This attribute will be used by the users to link to the ALRA record corresponding to this exceedence if they need to look up any attribute of the ALRA that is not de-normalised in this table.

This attribute will be populated with the TMNALRA_ST_CODE column from the ALRA table whose values were exceeded by this exceedence.


Description:
This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this schedule if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_IS_NUMBER column from the water system that is associated to the Schedule that was not satisfied and caused this exceedence


Description:
This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_ST_CODE column from the water system that is associated to this Schedule.


Description:
This attribute in conjunction with the WSF_TINWSF_ST_CODE is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_IS_NUMBER column from the water system facility that is associated to the Sampling point that is associated to this schedule.


Description:
This attribute in conjunction with the WSF_TINWSF_IS_NUMBER is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_ST_CODE column from the water system facility that is associated to the Sampling point that is associated to this schedule.


Description:
Uniquely identifies the water system within a specific state.

Format:  SSXXXXXXXXXX  

Where:   SS = the FIPS Pub 5-2 State abbreviation in which the water system is located, or the region number of the EPA region responsible for an Indian reservation
         XXXXXXXXXX = the water system identification code assigned by the State


Description:
The name of the water system. The name can be the formal, legal, or common name that is used most generally in referring to the water system.

When multiple facilities exist for the water system at different physical locations, the name identifies the means by which the system, as a whole, is generally known.


Description:
A system-generated value that categorizes the primary water source for the water system. Determination of primary source is based upon two factors: the type of water system facilities (WSF) and the availability of the WSF  (e.g., used on a permanent, seasonal, interim, emergency basis).  A specific hierarchy is followed in calculating the primary source:
 1)  Initially, only permanently available WSFs are examined;   2)  If a non-purchased surfacewater  WSF is encountered, the water system is considered to be a surface water system, and the determination is complete;       3)  If a purchased surfacewater  WSF is encountered (i.e. a Consecutive Connection with Water Type = 'Surface Water' , the water system is considered to be a purchased surface water system, and the determination is complete;   4)  If a non-purchased ground water (UDI) WSF is encountered, the water system is considered to be a ground water (UDI) system, and the determination is complete;    5)  If a purchased ground water (UDI) source is found (i.e. a Consecutive Connection with Water Type = 'Ground water under direct influence of surface water'), the water system is considered to be a purchased ground water (UDI) system, and the determination is complete;    6)  If a non-purchased ground water WSF is encountered, the water system is considered to be a ground water system, and the determination is complete;   7)  If a purchased ground water WSF is found  (i.e. a Consecutive Connection with Water Type = 'Ground Water), the water system is considered to be a purchased ground water system, and the determination is complete;   8)  If there are no permanently available WSFs, WSFs with Availability Status = ( 'Seasonal' or 'Interim') are examined next, following steps 2 through 7.   9)  If there are no WSFs with any of  these three availability codes, SDWIS checks WSFs with ¿Emergency¿ availability; 10)  If no WSFs with any of these four availability codes, SDWIS leaves this attribute blank.


Description:
A system-generated count of the total population served by a water system.  Previously, the population count was represented by a population range ("A" for under 101 persons served, "B" for 101 to 500 persons served, etc).



Note:  May need to re-evaluate population categories for less than 25 persons served code and for 25 to 100 persons served.  SDCJRP


Description:
A coded value that categorizes the activity of the water system.


Description:
The date that the water system activity indicator code was last changed.


Description:
A state-assigned value which identifies the water system facility.


Description:
A coded value which categorizes the water facility.
	
Every water system must include at least one WATER_SYSTEM_FACILITY occurrence.


Description:
The date on which the water system facility 
became proposed, active, or inactive.


Description:
A coded value which categorizes the source water that is utilized by a water system.


Description:
A coded value that categorizes the circumstances under which a source of water is utilized by a water system.


Description:
Identifies the source water system facility record being uploaded to SDWIS/FED.


Description:
This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this violation if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_IS_NUMBER column from i.)  the water system that is associated to the SAR that caused this violation in case this is an MCL violation or ii.) the water system that is associated to the Schedule  that was not satisfied causing this violation in case this is an M&R violation.


Description:
This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_ST_CODE column from i.)  the water system that is associated to the SAR that caused this violation in case this is an MCL violation or ii.) the water system that is associated to the Schedule  that was not satisfied causing this violation in case this is an M&R violation.


Description:
This attribute in conjunction with the WSF_TINWSF_ST_CODE is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_IS_NUMBER column from the water system facility that is associated i.) to the SAR that caused this violation if this is an MCL violation or ii.) to the Sampling point that is associatred to the schedule that caused this violation  if this is an M&R violation.


Description:
This attribute in conjunction with the WSF_TINWSF_IS_NUMBER is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_ST_CODE column from the water system facility that is associated i.) to the SAR that caused this violation if this is an MCL violation or ii.) to the Sampling point that is associatred to the schedule that caused this violation  if this is an M&R violation.


Description:
This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_IS_NUMBER column from the water system that is associated to this SAR.


Description:
This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_ST_CODE column from the water system that is associated to this SAR.


Description:
This attribute in conjunction with the WSF_TINWSF_ST_CODE is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_IS_NUMBER column from the water system facility that is associated to the sampling point that is associated to this SAR.


Description:
This attribute in conjunction with the WSF_TINWSF_IS_NUMBER is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_ST_CODE column from the water system facility that is associated to the sampling point that is associated to this SAR.


Description:
This attribute in conjunction with the SP_TSASMPPT_ST_CODE is a virtual foreign key to the Sampling Point entity type. This attribute will be used by the users to link to the Sampling Point  record corresponding to this SAR, if they need to look up any attribute of the Sampling Point that is not de-normalised in this table.

This attribute will be populated with the TSASMPPT_IS_NUMBER column from the sampling point that is associated to this SAR.


Description:
This attribute in conjunction with the SP_TSASMPPT_IS_NUMBER is a virtual foreign key to the Sampling Point entity type. This attribute will be used by the users to link to the Sampling Point  record corresponding to this SAR, if they need to look up any attribute of the Sampling Point that is not de-normalised in this table.

This attribute will be populated with the TSASMPPT_ST_CODE column from the sampling point that is associated to this SAR.


Description:
Indicates whether MDBP Summaries will be used in checking for compliance at the Facility Analye Level.


Description:
A description of the sampling point in English.


Description:
The type of water source, based on whether treatment has taken place.


Description:
Indicates if the sample was collected after a disinfection process has been applied.


Description:
Indicates the location of the sample with respect to the unit process.  Eg. after (sample is drawn at the outtake of the unit process), before (sample is drawn at the intake of the unit process), and during (sample is drawn within the unit process).


Description:
This attribute corresponds to the Sample Summary that is associated to the Sample Summary result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the Sample Summary result that is the basis of this record.
 
 The actual reported measure of a non-TCR summary result.  This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.  The text value is  converted to a number and stored in the Sample Summary Result Measure attribute.


Description:
This attribute corresponds to the SBS Sample analytical result that is the basis of this record.

A numeric value that represents the result obtained from a sample analysis. 

Note: Currently unable to support largest/smallest capacity.  When IEF toolset is fixed, this needs to be addressed.
Set new size to 16.9


Description:
This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_IS_NUMBER column from the water system that is associated to this SSR.


Description:
This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_ST_CODE column from the water system that is associated to this SSR.


Description:
Unique primary identifier for each  CDS Setup  process.  Each process should be identified such that it has a unique driver entity type and number during the design of CDS Setup.  CDS Setup will have these ID's hardcoded for each process/sub-process, and the values in this field should not be changed. .


Description:
Name of  each  CDS Setup  process.  For example, "Update Sample Schedules Due to  Water System Changes"  is a CDS Setup process name.


Description:
This field contains the Timestamp of the last record committed to the database that was processed by a CDS Setup process. This field would form the highest order key for the checkpoint.


Description:
This field is used in cases where the identifier for the driver entity  of the CDS Setup process has more than one sequence number (such as with SSMPA). It stores the second  IS number of the last record of the driver entity (for the CDS Setup process) that was committed to the database.. This attribute is the third part ( in some cases the final part) of the record key used during check pointing.This attribute will not be used for most records.


Description:
This field stores the IS number of the last record of the driver entity (for the CDS Setup process) that was committed to the database. This attribute is the second part ( in most cases the final part) of the record key used during check pointing.


Description:
The MCL value (in table TMNALRA)  that is effective for the violation's analyte  based on the violation's Compliance Period.   The  analyte's violation  Compliance Start/End dates (in TMNVIOL)  must fall inside the analyte's MCL Begin/End dates (in TMNALRA).   The user may change the default value of this field.  (User-entered values will be compared with the value in Violation Analysis Result Measure to ensure that the value in Violation Analysis Result Measure is greater than the value in MCL Violated.


Description:
The unit of measure associated with the MCL_Violated Measure.


Description:
This is the value of the MCL from the ALRA that was exceeded causing this MCL violation. This attribute is blank for all M & R violations.


Description:
This is the UOM of the MCL from the ALRA that was exceeded causing this MCL violation. This attribute is blank for all M & R violations.
The unit of measure associated with the MCL_Violated Measure.


Description:
Indicates status of Level compliance for specified analyte and water system facility.


Description:
The St_Code to which the data belongs and  which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute stores the value of the timestamp when the report was run.


Description:
This attribute contains the USERID of the user who executes this occurrence of the report.

A coded value that identifies the specific person making changes to the data.


Description:
The name of the analyte that was selected when the report was run.

The common name of a contaminant as used by states and EPA in the rules and other documents.


Description:
The code of the analyte that was selected when the report was run.

The standard code used by EPA and the states to represent analytes in the national database.  Each analyte has a unique code assigned to it for reference in compliance determination.


Description:
The code of the analyte group that was selected when the report was run.
 
Each analyte goup has a unique code assigned.  This code is unique not only within the analyte groups in the database but also within the analytes in the database.  This code is part of the uniqueness criteria.


Description:
The name of the analyte group that was selected when the report was run.

The name assigned to the Group of analytes.


Description:
This attribute will indicate if the ACL option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the MCL option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the MCLG option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the URTH option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the Trigger Level option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the WSF MAX option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the WSF Min option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the  RMDL option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the PQL option was selected if this Log record corresponds to the Alert report.


Description:
This attribute will indicate if the PLR option was selected if this Log record corresponds to the Alert report.


Description:
This attribute stores the government agency that was selected when the report was executed.


Description:
This attribute stores the name of the government agency that was selected when the report was executed.


Description:
This attribute stores the unique internal system number of the Monitoring period that was selected when the report was executed.


Description:
This attribute  stores the State_Cd of  the  Monitoring period that was selected when the report was executed.


Description:
This attribute corresponds to the Monitoring period that was selected when the report was executed.

User-selected name for the monitoring period.


Description:
This attribute corresponds to the Monitoring period that was selected when the report was executed.

The type code of the monitoring period, i.e., monthly, quarterly, annually.


Description:
This attribute corresponds to the Monitoring period that was selected when the report was executed.

The date of the first day for the monitoring period.


Description:
This attribute corresponds to the Monitoring period that was selected when the report was executed.

The last day of the monitoring period.


Description:
This attribute will have the begin date of the Sample Collection  date range if that option was chosen when the report was executed.


Description:
This attribute will have the end date of the Sample Collection  date range if that option was chosen when the report was executed.


Description:
This attribute will have the begin date of the data entry date range if that option was chosen when the report was executed.

The Data Entry Date Range begin date selected when a user launched the Results Alert Report.

The Activity Due Date Range begin date selected when a user launched the Schedule Activity Compliance Report.

The Next Due Date Range begin date selected when a user launched the Site Visit Compliance Report.


Description:
This attribute will have the end date of the data entry date range if that option was chosen when the report was executed.

The Data Entry Date Range end date selected when a user launched the Results Alert Report.

The Activity Due Date Range end date selected when a user launched the Schedule Activity Compliance Report.

The Next Due Date Range end date selected when a user launched the Site Visit Compliance Report.


Description:
This attribute defines the type of the report that was executed like Alert report, M&R compliance check, MCL Compliance check etc.,


Description:
Indicates that user selected Tap M&R Compliance Check on the Lead and Copper Rule Compliance Report Selection window.


Description:
Y (checked) means that the user selected the Confirmation Schedule option for the Chemical/Radionuclide M&R  Compliance Report.


Description:
Coded value that  uniquely identifies an error message generated during the execution of either the alert report, or compliance checks, or the Monitoring assessment reports.


Description:
Error message explanation text that corresponds to the code value that  uniquely identifies an error message generated during the execution of either the alert report, or compliance checks, or the Monitoring assessment reports.


Description:
This attribute corresponds to the Labaratory that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
The commonly used name of the Laboratory.


Description:
A code uniquely identifing the lab that is assigned by the state certifying authority.


Description:
A code uniquely identifying the laboratory that is assigned by EPA headquarters.  

Note: Discuss at MN JRP


Description:
This attribute corresponds to the Labaratory that is associated to the Sample Summary result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This is the Monitoring period that would be associated to the violation, this would be populated from the Monitoring period associated to the SSMPA that was cause of this violation if it is a < & R violation or that is associated to the Calculated MCL value in case of an MCL violation.
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This field would contain the TMNMPRD_IS_NUMBER of the monitoring period associated with the SAR or SSR that caused this exceedence. This field is optional.

Source attribute description:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This field would contain the TMNMPRD_ST_CODE of the monitoring period associated with the SAR or SSR that caused this exceedence. This field is optional.

Source attribute description:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute is a virtual foreign key to the Facility Analyte Level(FANL)  entity type. This attribute will be used by the users to link to the FANL record corresponding to this exceedence if they need to look up any attribute of the FANL that is not de-normalised in this table.

This attribute will be populated with the TMNFANL_IS_NUMBER column from the FANL table whose values were exceeded by this exceedence.

This attribute will be blank if the exceedence is referencing a Analyte level rule assignment record


Description:
The Severity Level will also be determined by the Create CDS Candidate Violations process based on the violation that was determined.


Description:
A coded value that represents the source or origin of thesampling point (e.g. the state, the region, or EPA).  S (State) is the defualt value for SDWIS/STATE.


Description:
This field is intended to enable a primacy agency to record the Sampling Point Identification Number they have assigned to a sampling point and reported to EPA's SDWARS database under the Unregulated Contaminant Monitoring Rule (UCMR).


Description:
The Sampling Point Type Code prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
The Sampling Point Identification Code prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
The Sampling Point Description Text (Location) prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
The Sampling Point Lead&Copper Tier Level Text prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
The Sampling Point Lead&Copper TierType Text prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
The Sampling Point Activity Status Code prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
The Sampling Point Activity Status Date prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
The Sampling Point Activity Status Reason prior to a change of value for one or more of the following Sampling Point attributes/fields:

 	Activity Status
 	Status Date
 	Activity Reason
 	Type Code
 	Identification Code
 	Description Text
 	Lead Copper Tier Level Text
 	Lead Copper Tier Type Text


Description:
Flag set by CDS Setup component  when the Schedule Group has been processed to determine if any of its hidden schedules have any Sampling Point Sub-Schedules for which Sampling Point Sub-SSMPA records need to be created.  Once CDS Setup has set  this flag is set to Y, the user cannot modify or delete any of the Schedule Group's Sampling Point Subschedules.


Description:
The tier level most often assigned to this violation type as 
listed in the Revised Public Notification Rule.  The type(s) of notification, delivery method(s), time limitation and frequency of repeat notification delivery are determined by the tier level.


Description:
The date of the last completed sanitary survey for the water system.


Description:
In Release 8.0, this attribute indicated whether the violation's Compliance Period (Begin and End Dates) or the Violation Period Begin Date should be reported to SDWIS/FED. It is obsolute in SSWr1.


Description:
The user sets this flag to Y (yes) when the packaged violaton should be reported to FED.


Description:
Enables a user to indicate whether TCR NCD should determine compliance with the upstream, downstream, or original repeat sampling requirements for a given TCR repeat schedule.


Description:
A system-generated coded value which identifies the state that maintains information about the PWS Rule Table.


Description:
A system-generated value that represents the calendar date and time on which this PWS Rule Table was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated coded value which identifies the state that maintains information about the service area type.


Description:
Designed Percent of Filter Backwash Returned to Influent -- Percentage of filter backwash returned to the influent of the treatment plant as determined by the primacy agency after review of the plant schematic.

Tthis attribute supports the Filter Backwash Rule which sets a limit of 10% of the influent for the plant that can be backwashed from filters.  (Water supply operators need to do something with  this backwash water.  Generally it is "wasted" to the sewer system or back to  the water source ( which requires a NPDES permit) or goes back to the head
 of  the plant and is re-treated.  One of the problems with returning it to the  head of the plant is the concern that after a while you are concentrating the undesired elements at the influent.  Hence the new 10% limit on return of backwash.


Description:
A system-generated value that represents the calendar date and time on which this service area type was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
Under the Filter Backwash Rule, a water system is required to submit a schematic of this treatment plant to the primacy agency for review to demonstrate the percentage of filter backwash that is returned to the treatment plant influent.


Description:
A system-generated value that represents the calendar date and time on which this population served was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated value that represents the calendar date and time on which this service connection category was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
Date primacy agency received treatment plant schematic to 
demonstrate the percentage of filter backwash that is returned to the treatment plant influent.


Description:
Date primacy agency completes review of treatment plant 
schematic and determines the percentage of filter backwash that is returned to the treatment plant influent.


Description:
A system-generated coded value which identifies the state that maintains information about the treatment objective.


Description:
A system-generated value that represents the calendar date and time on which this treatment objective was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated coded value which identifies the state that maintains information about the treatment process.


Description:
A system-generated value that represents the calendar date and time on which this treatment process was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated coded value which identifies the state that maintains information about the valid treatment objective process assignment.


Description:
A system-generated value that represents the calendar date and time on which this valid treatment objective process assignment was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated value that represents the calendar date and time on which the water system facility flow was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated value that represents the calendar date and time on which the water purchase was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated value that represents the calendar date and time on which this treatment facility unit flow was initially posted to the data base or when a subsequent state-supplied inventory modification was made. 

Source:  IBS Team


Description:
A system-generated value that represents the calendar date and time on which this treatment facility unit was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated value that represents the calendar date and time on which this treatment objective process assignment was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A value that represents the state FIPS code.


Description:
A system-generated value that represents the calendar date and time on which this water system geographic area assignment was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated value that represents the calendar date and time on which this water system regulating agency assignment was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A system-generated value that represents the calendar date and time on which this water system legal entity assignment was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
A value that represents the code of the service area name.


Description:
A coded value which categorizes the most recent activity for the water system facility.


Description:
The number of sample results collected during the monitoring period (which are compared with the number of sample results required by the schedule).  Where the value in this field is 0 or less than the number required in the schedule, this causes the violation.


Description:
Y (checked) means that the criteria selected for the Chemical/Radionuclide M&R  Compliance Check resulted in routine schedule compliance being run.


Description:
Activity type code.    (This is the value that is stored in the Code Value and Permitted Value tables maintained in the System Administration component.)


Description:
the name of the table using the external system number.


Description:
Value is CCYY.  Value must be greater than 1998 and less than 2100.


Description:
Date that the fully completed CCR is due to the State/Regional primacy agency.


Description:
Date by which the community water system completed the distribution of the CCR to the consumers.


Description:
Date by which the primacy agency received the CCR from the community water system.


Description:
Defines the adequacy of the CCR submitted by the community water system to the primacy agency.  (A-adequate, N-not adequate, E-not evaluated)


Description:
Free text comments pertaining to the CCR


Description:
Indicates that user selected Source Water M&R and TT Compliance Check on the Lead and Copper Rule Compliance Report Selection window.


Description:
Indicates that user selected WQP Entry Point and Tap M&R and TT Compliance Check on the Lead and Copper Rule Compliance Report Selection window.


Description:
Indicates that user selected the Turbidity sub-report from the Surface Water Treatment Compliance Report window.


Description:
Indicates that user selected the Entry Point RDC (Federal) sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the Entry Point RDC (State) sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the Distribution RDC (Federal) sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the Distribution RDC (Statel) sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the DBP Precursors sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the Bromate/Bromide sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the Chlorine/Chloramine MRDL sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the Chlorine Dioxide/Chlorite Entry Point sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
Indicates that user selected the Chlorine Dioxide/Chlorite Distribution System sub-report from either the Surface Water Treatment Compliance Report window or the D/DBP Compliance Report window.


Description:
A system-generated value that represents the calendar date and time on which this water system facility legal entity assignment was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
The date the water system reports the Monitoring Period Average to the primacy agency.


Description:
A system-generated value that represents the calendar date and time on which this screen was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
The date the water system reports the Running Annual Average to the primacy agency.


Description:
A coded value that represents the User ID that is logged on to the system.


Description:
This code will be used for determining which rules apply for calculating the Federal and State Types of water systems, This attribute will be populated when the system is installed to identify which rules are the state specific rules for the installation.  

The number "1" will be used to designate that the rule applies to the installation site.


Description:
The number of days per month during the annual operation period for which this water system facility is normally in operation and/or must monitor for the analyte specified in this FANL.  The number 31 is meant to signify each day.


Description:
The number of samples that must be collected during a twenty-four hour period from midnight to midnight for which this water system facility must monitor for the analye specified in this FANL.  The number 24 is meant to signify continuous.


Description:
This attribute corresponds to the Sample_Schedule record that forms the basis of this record.

 Indicates whether the schedule has been assessed for increased, decreased, or same monitoring and the result of the assessment as  I(Increased), D(Decreased) or S(Same).


Description:
A designed attribute which identifies the associated state and is used in conjuction with the IS_NUMBER to uniquely identify this entity/table.  This column has no business relevance.


Description:
This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this Monitoring Assessment, if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_IS_NUMBER column from the water system that is associated to the Schedule that was assessed.


Description:
This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a virtual foreign key to the Water system entity type. This attribute will be used by the users to link to the water system record corresponding to this exceedence if they need to look up any attribute of the water system that is not de-normalised in this table.

This attribute will be populated with the TINWSYS_ST_CODE column from the water system that is associated to the schedule that was assessed.


Description:
This attribute in conjunction with the WSF_TINWSF_ST_CODE is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_IS_NUMBER column from the water system facility that is associated to theSchedule that was assessed.


Description:
This attribute in conjunction with the WSF_ TINWSF_IS_NUMBER is a virtual foreign key to the Water system Facility entity type. This attribute will be used by the users to link to the water system facility  record corresponding to this exceedence, if they need to look up any attribute of the water system facility that is not de-normalised in this table.

This attribute will be populated with the TINWSF_ST_CODE column from the water system facility that is associated to the Schedule that was assessed.


Description:
The numerical value for a particular analyte level that has been established in rule, policy, or guidance as a health-based/nonhealth-based level.   This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.

This attribute will be populated from the Measure text comlumn of the ALRA record or the measure text column of the fanl record.

Refer to the ALRA_TMNALRA_IS_NUMBER or FANL_TSAFANL_IS_NUMBER attribute description to determine which ALRA record to get this value from.


Description:
The measurement units used to expressed the MCL, MCLG, or other level

This attribute would be populated from the UOM CODE column of the ALRA table 

Refer to the ALRA_TMNALRA_IS_NUMBER  attribute description to determine which ALRA record to get this value from.


Description:
When user checks the checkbox (Yes) in answer to the question "Send All ? " which is beside the PB90 prompt, this action sets this field to yes, and the software understands it should report all PB90 summary results, not just those that would normally meet federal reporting criteria.


Description:
Precursor Achvd Removal Ratio Number -- Used by the Calculate MCL Value Process to determine the RAA for Precursor Achieved Removal  Ratio.  This stores the number.


Description:
Precursor Achvd Removal Ratio Text -- Used by the Calculate MCL Value Process to determine the RAA for Precursor Achieved Removal  Ratio.  This stores the text value that is displayed on the Results Averages Maintenance window.


Description:
Ratio used by the Precursor Compliance Check Process in SWTR or D/DBP Compliance Report to determine whether or not to assess a violation.


Description:
Ratio used by the Precursor Compliance Check Process in SWTR or D/DBP Compliance Report to determine whether or not to assess a violation.  This field captures the value in text and is the field that is displayed on the Results Averages Maintenance window.


Description:
This is the CODE value corresponding to an analyte EX: 3100 for TCR 1022 for lead etc., 

This attribute would be populated from the Code attribute of the Analyte entity type.

The analyte will be the one associated to the schedule that is assessed


Description:
The common name of a contaminant as used by states and EPA in the rules and other documents. 

This attribute would be populated from the Name attribute of the Analyte entity type.

The analyte will be the one assoiated to the schedule that is assessed


Description:
Date by which the PWS must make notification to the public in the method specified in the activity record.


Description:
Date on which the PWS actually made public notification by the method prescribed.


Description:
Date by which the PWS is required to submit proof to the primacy agency that the public notification has been accomplished.


Description:
Date on which the PWS actually submitted proof to the primacy agency that the public notification has been accomplished.


Description:
Person/party who is responsible for accomplishing the PN activity;  can be generic (e.g. PWS Owner) or specific (person's name).


Description:
For violations that will be reported to FED, the Analyte that will eventually get reported will either be the 'reportable' Analyte referenced by the Violation Type or the Analyte referenced by the violation if the Violation Type is not associated to one.


Description:
Indicates whether an enforcement follow up action was taken by a federal or state agency.


Description:
Indicates whether the enforcement action was formal, informal, or other.


Description:
Specifies the enforcement action sub-category.


Description:
Indicates whether the schedule has been assessed for increased, decreased, or same monitoring and the result of the assessment as  I(Increased), D(Decreased) or S(Same).


Description:
This attribute will store the primary key of the Sample Schedule which was assessed as candidate for increased monitoring or decresed monitoring. This attribute will  be used by the Clear CDS candidate monitoring assessment process.

A system-generated value which, along with TMNSASCH_ST_CODE, uniquely identifies the sample schedule.

Source:  TCR Team


Description:
This attribute will store the primary key of the Sample Schedule which was assessed as candidate for increased monitoring or decresed monitoring. This attribute will  be used by the Clear CDS candidate monitoring assessment process.

A designed attribute which identifies the associated state.  Used with TMNSASCH_IS_NUMBER, it uniquely identifies the schedule.


Description:
This attribute in conjunction with the SAR TSASAR_ST_CODE is used to store the foreign key of the SAR that caused this exceedence. This attribute will be used mainly to determine if this exccedence is a candidate to be deleted by the Clear candidate exceedence process when the same SAR is being reevaluated for a similar exceedence.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute in conjunction with the SAR TSASAR_IS_NUMBER is used to store the foreign key of the SAR that caused this exceedence. This attribute will be used mainly to determine if this exccedence is a candidate to be deleted by the Clear candidate exceedence process when the same SAR is being reevaluated for a similar exceedence.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute in conjunction with the SSR TSASSR_ST_CODE is used to store the foreign key of the SSR that caused this exceedence. This attribute will be used mainly to determine if this exccedence is a candidate to be deleted by the Clear candidate exceedence process when the same SSR is being reevaluated for a similar exceedence.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute in conjunction with the SSR TSASSR_IS_NUMBER is used to store the foreign key of the SSR that caused this exceedence. This attribute will be used mainly to determine if this exccedence is a candidate to be deleted by the Clear candidate exceedence process when the same SSR is being reevaluated for a similar exceedence.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the Analyte that is associated to the Sample_Schedule record that forms the basis of this record.

 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
The name of the water system facility prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID.
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The measure of facility analyte  level.   This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.


Description:
The State Assgn ID of the water system facility prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The Activity Status of the water system facility prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The Activity Status Date of the water system facility prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The Activity Status Reason of the water system facility prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The Water Type of the water system facility prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The Availability Code of the water system facility prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The value in WSF Seller Treatment Indicator prior to a change in one of the following WSF attributes/fields:
 	
 	Activity Status
 	Activity Date
 	Activity Reason
 	Facility Name
 	State Asgn ID
 	Water Type
 	Availability
 	Seller Treatment
 	No Treatment


Description:
The treatment status of the water flowing through the water system facility record being captured in history.


Description:
The name of the historical  water system prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
The activity status of the water system prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
The date of the water system's  activity status prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
The reason for the activity status prior to a change being made to one of the following  water system attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
The  water system's Federal Primary Source Code prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
The  water system's population count  prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
The value in the water system's  history indicator prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
The  water system's Federal Primary Type Code prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
A system-generated value that represents the calendar date and time on which the water system was initially posted to the data base, when a subsequent state-supplied inventory modification was made, or when the water system was deleted.


Description:
A coded value which categorizes a violation.


Description:
The  water system's Owner Type Code prior to a change being made to one of the following attributes/fields:

 	-               Activity Date
	- 	Activity Status Code
	- 	Activity Reason Code
	- 	Name
	- 	D Fed Primary Source Code
	- 	D History Indicator Code
	- 	D PWS Federal Type Code
	- 	Owner Type Code
	- 	D Population


Description:
Indicates if a TCR monitoring violation is major or minor.  Per TCR guidance, a "Major" routine monitoring violation occurs when a system fails to take any of the required samples per compliance period.  A "Minor" routine monitoring violation occurs when a system takes some (but not all) of the required routine samples in a compliance period.  Similiarly, this holds for TCR repeat monitoring.  A "Major" repeat monitoring violation occurs when a system does not sample (i.e. takes no repeat samples at all OR conducts no speciation for fecal/E.coli after a repeat sample tests positive for total coliform).  A "Minor" repeat monitoring violation occurs when a system takes some (but not all) of the required repeat samples.


Description:
This attribute corresponds to the Monitoring Period that is associated to the Sample Summary result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the Monitoring Period that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute would be populated from the TSAANALYT_IS_NUMBER  attribute of the Analyte entity type.

The analyte will be the one associated to the schedule that is assessed 

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute would be populated from the tsaanalyt_st_code attribute of the Analyte entity type.

The analyte will be the one associated to the schedule that is assessed

 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute is populated from the TSAANLYT_IS_NUMBER attribute of the Analyte that is associated to the Schedule that is violated in case it is an M & R violation or the Analyte that is associated to the Schedule that is associated to the SSMPA which is associated to the  Calculated MCL value in case it is an MCL violation

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute is populated from the TSAANLYT_ST_CODE attribute of the Analyte that is associated to the Schedule that is violated in case it is an M & R violation or the Analyte that is associated to the Schedule that is associated to the SSMPA which is associated to the  Calculated MCL value in case it is an MCL violation

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute is populated from the TSAANLGP_IS_NUMBER attribute of the Analyte group that is associated to the Schedule Group that is violated in case it is an M & R violation or blank in case it is an MCL violation

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute is populated from the TSAANLGP_ST_CODE attribute of the Analyte group that is associated to the Schedule Group that is violated in case it is an M & R violation or tblank in case it is an MCL violation

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
The TSAANLYT_IS_NUMBER of the analyte that was selected when the report was run.

A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
The TSAANLYT_ST_CODE of the analyte that was selected when the report was run.


A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
The TSAANLGP_IS_NUMBER of the analyte group that was selected when the report was run.
 
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
The TSAANLGP_ST_CODE of the analyte group that was selected when the report was run.
 
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the Analyte that is associated to the  SBS Sample analytical result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the Analyte that is associated to the Sample Summary result that is the basis of this record.
 
 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
Activities are grouped by category.  This value represents the value that is stored in the code value table.


Description:
This attribute corresponds to the Analyte group that is associated to the Sample_Schedule record that forms the basis of this record.

 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
This attribute corresponds to the Analyte group  that is associated to the Sample_Schedule record that forms the basis of this record.

 A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


Description:
Narrative information about the violation.


Description:
The date of the last status code update.


Description:
An identifying number for the assistance action            created by the primacy agency.


Description:
The status of the assistance action (i.e., proposed, offered but rejected, completed)


Description:
The name given to the standard response and the set of actions it performs for a given violation condition.


Description:
Number that will be added to the Violation Determination Date to calculate the Enforcement Action Status Date.


Description:
An identifying alphanumeric field for the compliance schedule that may be assigned by the state.


Description:
Narrative information about the PN activity.


Description:
Number that will be added to the Violation Determination Date to calculate the Proof of PN Due Date.


Description:
For a Standard Response of type Violation, this is the  number that will be added to the Violation Determination Date to calculate the PN Required Due Date. For a Standard Response of type Deficiency,  this is the  number that will be added to the Deficiency Water System Notification Date to calculate the Deficiency Scheduled Activity Due Date.


Description:
The code that represents the place for which geographic coordinates were established.


Description:
The code that represents the reference datum used in determining latitude and longitude coordinates.


Description:
Date when the latitude and longitude coordinates were determined.


Description:
A textual description of the entity to which the latitude and longitude coordinate refers.   Latitude/longitude coordinates are often collected to represent an entity but are actually a particular point or portion within the entity.  Secondary users need to know exactly what the latitude/longitude coordinates define.  Therefore, as required by the EPA Locational Data Policy, a description of the entity (exact place where the coordinates are collected) must be indicated.

The format of this field is a free-format, text field. There should be, however, two components documented for this attribute:

 -    Whether the coordinate describes a point, line or area.
 -    The specific and exact description of the point, line, or area that the latitude/longitude coordinate is of and not a general description of what the latitude/longitude represents.  For example, the description should indicate that the latitude/longitude is of a specific well site within a well field rather than of the well field in general.

It is very important that data collectors be consistent in their use of the description field.  The exact place used to represent the location of the entity should be selected when planning the data collection process.

For example:

Spring - The lat/long coordinate of spring X at the point where it flows into surface water Y.

Well - The lat/long coordinate is the point where the well is located within a well field.  The well identifier is ALD98060001.


Description:
The measure of the accuracy (in meters) of the latitude and longitude coordinates.


Description:
The measure of elevation (i.e., the altitude), in meters, above or below a reference datum.


Description:
A coded value that represents the source or origin of the information for the water system facility.  Examples of origins include State reported, reported by an EPA region, generated by the system during its normal course of operation, etc.  This value is not input directly by the State and cannot be modified.


Description:
A system-generated value that represents the calendar date and time on which this water system facility was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
Coordinate representation indicating a location on the surface of the earth, using earth's equator as the origin, reported in degrees, minutes, and seconds.


Description:
The measure of the angular distance on a meridian north or south of the equator.


Description:
Coordinate representation indicating a location on the surface of the earth, using the Prime Meridian (Greenwich, England) as the origin, reported in degrees,  minutes, and seconds.


Description:
The measure of the angular distance on a meridian east or west of the prime meridian.


Description:
The code that represents the method used to determine the latitude and longitude coordinates for a point on the earth.


Description:
Scale of the map used to determine the latitude and longitude coordinates.


Description:
The code that represents the geometric entity represented by one point or a sequence of latitude and longitude points.


Description:
Party responsible for collecting or otherwise providing the latitude and longitude.


Description:
The code that represents the process used to verify the latitude and longitude coordinates.


Description:
The code that represents the method used to collect the vertical measure (i.e., the altitude) of a reference point.


Description:
The measure of the accuracy (in meters) of the vertical measure (i.e., the altitude) of a reference point.


Description:
The code that represents the reference datum used to determine the vertical measure (i.e., the altitude).


Description:
A system-generated value that indicates when the water system was posted to the data base.


Description:
Free text information about the Monitroing Period Average


Description:
Free text information about the MCL Value


Description:
Indicates that the number of missing samples should or should not be reported to SDWIS/Fed.


Description:
Indicates that the number of exceedences should or should not be reported to SDWIS/Fed.


Description:
It formerly identified the address of the water system legal contact being uploaded to SDWIS/FED. This field is no longer reported to SDWIS/FED.


Description:
Identifies the specific treatment applied to a source of water for a public water system being uploaded to SDWIS/FED.


Description:
This attribute will indicate if the MRDL option was selected if this Log record corresponds to the Results Alert report.


Description:
This attribute will indicate if the MRDLG option was selected if this Log record corresponds to the Results Alert report.


Description:
Provides an identification number for each association between a Water System and a Geographic Area.  This field used to be reported to SDWIS/FED as Data Element C501 but is no longer reported to SDWIS/FED.


Description:
Identifies the specific site visit served by a public water system being uploaded to SDWIS/FED.  This field is synonymous with the attribute State_Asgn_Identification_Number/field ST_ASGN_IDENT_NUM in SDWIS/FED's Site Visit table.


Description:
The  date on which the Site Visit was made to the water system.


Description:
Code that represents the reason for which a Site Visit was made to a public water system.


Description:
Additional information that the Inspector wishes to record about the site visit.


Description:
A designed attribute which identifies the associated state.  Used with TMNDEVIA_IS_NUMBER, it uniquely identifies the deviation.


Description:
An alternate monitoring frequency for a given contaminant required to be monitored by the public water system.  This represents an allowance to monitor at a frequency differing from the prevailing frequency, and is reported in the permissible number of months between samples.


Description:
A value that represents the calendar date on which a variance, exemption, or other event became, or will become, effective.


Description:
A value that represents the calendar date on which a variance, exemption, or other event expired, or will expire.


Description:
A numeric value that represents a modified maximum contaminant level that has been approved as a condition to a variance or an exemption granted to a public water system by the State.


Description:
A code value that represents the reason for which a variance, exemption, or turbidity waiver was issued by the State, or a filtration requirement event was triggered for a public water system.  (Examples:  source water coliform, residual disinfectant, MCL-TTHM, unable to afford treatment, cannot comply after treatment, etc.)


Description:
A code value that represents the current status of a variance, exemption, or other event applicable to a public water system.


Description:
An alphanumeric value used to uniquely identify a specific variance, exemption, or other event that is applicable to a public water system.  It is unique for each public water system within the Federal fiscal year for which the variance, exemption or other event was reported.

VE-ID is of the form ... yy nnnnn  (space inserted for clarity only)

Where ... yy = the Federal fiscal year in which the variance, exemption, or other event was granted or became effective.
          nnnnn = an identification number assigned by the State or generated by the FRDS-II computer system (the first position consists of the letter "X" if the ID was generated)


Description:
A code value that represents whether the VARIANCE-EXEMPTION-DATA data base record is a variance,exemption, or other event applicable to a public water system.


Description:
C3001 (VE-ID):
An alphanumeric value used to uniquely identify a specific variance, exemption, or other event that is applicable to a public water system.  It is unique for each public water system within the Federal fiscal year for which the variance, exemption or other event was reported.

VE-ID is of the form ... yy nnnnn  (space inserted for clarity only)

Where ... yy = the Federal fiscal year in which the variance, exemption, or other event was granted or became effective.
          nnnnn = an identification number assigned by the State or generated by the FRDS-II computer system (the first position consists of the letter "X" if the ID was generated)


C3023 (VE-FY):
A computed numeric value that represents the Federal fiscal year in which a variance, exemption, or other event was initiated or granted.  The term computed, as used here, implies that this value is not reported by the State.  VE-FY is determined automatically by the FRDS-II computer system during its normal course of operation.


Description:
A computed value that represents the calendar date on which a variance, exemption, or other event base record was initially posted to the FRDS-II Data Base.

The term computed, as used here, implies that this date is not reported by the State.  VE-INSERT-DATE is determined automatically by the FRDS-II computer system during its normal course of operation when a new variance, exemption, or other event data base record is initially inserted into the FRDS-II Data Base.


Description:
A designed attribute which identifies the associated state.

Source:  IBS Team


Description:
A code value that represents a specific action that is to be taken by the State or the public water system (or was taken by the State or the public water system) relating to a variance, exemption, or other event applicable to a public water system.


Description:
A value that represents the calendar date on which a specific action relating to a variance, exemption, or other event was accomplished, if completed.


Description:
A value that represents the calendar date on which a specific action relating to a variance,emption, or other event is scheduled (or was scheduled) to occur.


Description:
An alphanumeric value used to uniquely identify a specific violation of a primary drinking water regulation incurred by a public water system. 

It is unique for each public water system within the Federal fiscal year in which the State became aware of the violation.


Description:
A code value that represents a specific milestone occurrence for a public water system.


Description:
An alphanumeric value that represents any description, characteristic, or attribute that the State or EPA region wants to record for the associated milestone data base record


Description:
A value that represents the calendar date associated with a certain milestone occurrence for a public water system.


Description:
A numeric value that represents the 90th percentile lead or copper level exceedance, or Lead Service Line Replacement (LSLR) rates when reporting lead and copper milestones.


Description:
An alphanumeric value used to identify a specific milestone for a public water system.


Description:
C801 (PWS-MILESTONE-ID):
An alphanumeric value used to uniquely identify a specific milestone for a public water system.

MILESTONE-ID is of the form ... nnnn

Where ...  nnnn = a milestone identification number assigned by the State or generated by the FRDS-II computer system (the first position consists of the letter "M" if the ID was generated)


Description:
A system-generated value that represents the calendar date and time on which this annual operating period was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
In order to prevent undesired processing, the SDWIS/STATE Administrator enters a "CDS History Date" prior to executing CDS Setup for the first time. CDS Setup will use this date to limit the data it considers to:

-  Results from samples collected on or after that date.
-  Sample schedules with effective begin dates on or after that date.
-  Monitoring periods with a begin date on or after that date.

Users should carefully consider the date they desire by first thinking through all the monitoring requirements they enforce against water systems. The CDS History Date will be used by all CDS Setup processes to exclude data that precede that date. 
Though users will be able to change this date to an earlier date, they will not be able change it to a later date. 

If the user tries to execute CDS Setup before setting this date, an exit state error message will appear: [CDS History Date must be set before running CDS Setup. Check your documentation.] 

 The CDS History Date will be stored in the TINPRT  record where "WHERE_INSTLD_IND" field = 1.


Description:
Maintains the current count for each record that is written to the CDS Setup Processing Report.


Description:
Name of the most current CDS Processing Report that the CDS Setup window will launch at the conclusion of CDS Setup (or at any time the user needs to see the report.)


Description:
Indicates whether the Significant Non-Complier is preliminary.


Description:
The fiscal year in which the water system was determined to be a significant non-complier.


Description:
The fiscal year quarter in which the water system was determined to be a significant non-complier.


Description:
A coded value which indicates whether this is a Tier 1 or Tier 2 Significant Non-Complier.


Description:
An alphanumeric data element that contains a two character code describing, for TCR SNC's, the specific monitoring frequency criteria upon which the SNC was generated.  The monitoring frequency is generated based upon the duration of the most recent violation qualifying a public water system as a TCR SNC.


Description:
Indicates the category of the Candidtate CDS Violation (e.g., MCL, monitoring, public notification, treatment technique, sanitary survey etc.).


Description:
The Last_Update_Timestamp value of the SAR that caused the exceedence at the time the exceedence was created.


Description:
The Last_Update_Timestamp value of the SSR (Sample Summary Result)  that caused the exceedence at the time the exceedence was created.


Description:
The violation period end date that reflects the compliance period end date as defined by EPA.  When the candidate violation is migrated into the violation table in SDWIS/STATE, this will populate the fed_period_end_date, which is the violation period end date that will be reported to EPA.


Description:
Indicates that user selected the TTHM/HAA5 M&R sub-report from the D/DBP Compliance Report window.


Description:
Indicates that user selected the Create Chlorine/Chloramine MRDL Summaries option on the D/DBP Compliance Report window.


Description:
Indicates that user selected a User Defined Summary and what type of summary was selected.


Description:
Indicates that user elected to run Public Notification Compliance Report.


Description:
A coded value which indicates the EPA region to which this Goverment Agency belongs.


Description:
Last date/time that CDS Setup processes evaluated the SSMPA.


Description:
A code value that represents the reason for which a variance, exemption, or turbidity waiver was issued by the State, or a filtration requirement event was triggered for a public water system.


Description:
Last date/time that CDS Setup processes evaluated the Sample.


Description:
Last date/time that CDS Setup processes evaluated the Sample Analytical Result.


Description:
Last date/time that CDS Setup processes evaluated the Sample Summary.


Description:
Indicates that user selected the Action Level Compliance Check on the Lead and Copper Rule Compliance Report Selection window.


Description:
The violation period begin date that reflects the compliance period begin date as defined by EPA.  When the candidate violation is migrated into the violation table in SDWIS/STATE, this will populate the fed_period_begin_date, which is the violation period begin date that will be reported to EPA.


Description:
A system-generated value which uniquely identifies the sampling point subschedule.  This field is used to record information needed to create a hidden violation when Migrate CDS Candidate Violation is creating a Violation Group as well as hidden violations.  In this case, this field would contain the internal system number to the Sampling Point Subschedule whose monitoring requirement was not met and for which a hidden violation that is linked to one or more sampling point(s) is to be created.


Description:
A code value established by a state to classify a water system.  Used for operator license, operator type requirements.


Description:
A value that represents the maximum daily  amount of water that may be purchased. The unit of measurement is specified by MAX_DAILY_PURCHASE_RATE_UNIT.


Description:
A coded value which specifies the unit of measurement for the quantity of water purchased.


Description:
Water finish is the status of treatment of the purchased water, such as raw, partial, or finished.


Description:
A coded value which indicates that a seller has applied treatment to water being delivered to a buyer.


Description:
The date a water purchase contract ended.  Note:  the actual delivery of water may vary during the period from the active date to the inactive date.


Description:
A coded value which indicates whether the relationship between the water system facility and the legal entity is active or inactive.


Description:
The type of storage facility.

Source: Nashville IBS JAD


Description:
The effective volume of a storage facility (also called the usable volume).  The unit of measurement is specified by the EFFECTIVE VOLUME MEASURE UNIT.

Source: Nashville IBS JAD


Description:
The unit of measure for the EFFECTIVE VOLUME MEASURE.


Description:
The elevation (in feet) above sea level of the overflow of a storage facility.


Description:
The principal structural material used to construct the water storage facility.


Description:
A coded value for the type of coating applied to the interior of a storage facility.


Description:
Indicates whether the storage facility is covered.


Description:
Indicates whether the storage facility is equipped with a valve that controls the height of the water within the storage facility.


Description:
Indicates whether the storage facility is pressurized.


Description:
The number of days a Water System was out of compliance for one or more water quality parameters during the 6-month monitoring period.


Description:
The pressure produced by a pump measured in feet of water.


Description:
A narrative description of a unit process within a treatment plant water system facility.


Description:
The distinct type of unit process used in the treatment process.  Examples include: chemical feed, filter, and sedimentation.


Description:
Format should be CCYY.  Reflects the Fiscal Year to which the violation should be attributed.


Description:
The type of aerator used in the treatment process.  Examples:
		PA - Paddle
		DI - Diffused Air


Description:
The type of sludge removing equipment used in the treatment process.


Description:
A system-generated value which uniquely identifies the entity occurrence.


Description:
Attribute of Schedule Package Role  used by CDS Setup during the Increased/Decreased Monitoring Assessment subprocess.  Indicates whether a given TOC schedule that is part of a Schedule Package is either  raw or finished.  For other (non-TOC) schedule packages, indicates whether the schedule is the principal or a supporting schedule within the package.


Description:
The type of continuous disinfectant monitor used in the treatment process.


Description:
The code indicating whether washwater is recycled through the process.


Description:
Denormalized field to store whether the Schedule Package Role is related to a Sample Schedule (SS) or a Schedule Group (SG).


Description:
Filter media type is the type of media used in the treatment process, such as green sand, anthracite, sand, and gravel.


Description:
Filter media depth is the actual depth in inches of filter media in the process unit, as measured from the bottom of the media to the top.


Description:
The design flow of a single water system facility (in gallons per day).


Description:
The average flow through an individual unit, taking into account the million gallons per day flowing over the design area of the unit. (in mgd/ft2)


Description:
The rate water flows over a weir, expressed in gallons per minute per foot (length of weir).  (in gal/min/ft)


Description:
The solids loading rate for a single unit process.  The design value of the amount of solids the unit can effectively handle under normal operating conditions. (in lbs/ft2)


Description:
Paddle speed rate is the rate at which the paddles in a mixer or mixing basin turn, measured in revolutions per minute (rpm).


Description:
The amounts of chemical added per volume of water treated.   (in lbs/mg)


Description:
The rate at which particles settle in a liquid.  Also known as settling velocity or "g". (ft/min)


Description:
The coded value that indicates the capability of the treatment.


Description:
The length of time (in minutes) that a given volume of water remains in a single unit of a unit process.  This measure is used to estimate treatment dosages and resulting treatment efficiencies.


Description:
Contact time is the length of time the water is in contact with a chemical in an individual process unit (e.g., a chlorination contact tank), measured in minutes.


Description:
Basin count is the actual number of basins (units) in a treatment process.


Description:
Subunit count is the number of subunits within the unit process.


Description:
CT value is the concentration time (CT) value for the disinfectant contact basin, expressed as a measure of the time water is exposed and at what concentration of disinfectant (minutes X million gallons / 1).


Description:
Diameter is the diameter in feet of a tank or vessel used in the treatment or storage of water.


Description:
Width is the width in feet of a tank or vessel used in the treatment or storage of water.


Description:
Depth is the depth in feet of a tank or vessel used in the treatment or storage of water.


Description:
The name of the river, stream, or water body for the river reach.


Description:
Indicates if this treatment objective process assignment is the primary treatment.  The first treatment objective process assignment entered will default to the primary treatment for that process.

Source:  IBS Team


Description:
A system-generated coded value that categorizes the primary water source for the water system.

Determination of primary source is based upon two factors, the type of the source and the availability of the source (e.g., used on a permanent, seasonal, interim, emergency basis).  A specific hierarchy is followed in calculating the primary source.  It is as follows:
     1)  Initially, only permanently available sources are examined;
     2)  If a non-purchased surface source is encountered, the water system is considered to be a surface water system, and the determination process is complete;
     3)  If a purchased surface source is encountered, the water system is considered to be a purchased surface water system, and the determination process is complete;
     4)  If a non-purchased ground water (UDI) source is encountered, the water system is considered to be a ground water (UDI) system, and the determination process is complete;
     5)  If a purchased ground water (UDI) source is encountered, the water system is considered to be a purchased ground water (UDI) system, and the determination process is complete;
     6)  If a non-purchased ground water source is encountered, the water system is considered to be a ground water system, and the determination process is complete;
     7)  If a purchased ground water source is encountered, the water system is considered to be a purchased ground water system, and the determination process is complete;
     8)  If there are no permanently available sources, all sources are treated equally, regardless of their individual availability, and steps 2 through 7 are repeated.


Description:
The first date that applies for monitoring period average calculations  based on the TCR Sample Schedule Effective Period Begin Date plus the  TCR Sample Schedule Start Month/Day (the annual operating period start month/day).


Description:
The last date that applies for monitoring period average calculations  based on the TCR Sample Schedule Effective Period Begin Date plus the  TCR Sample Schedule Start Month/Day (the annual operating period start month/day).


Description:
MPA_APP_END_DATE - MPA_APP_BEGIN_DATE (inclusive of both days).  This field may be useful when creating reports.


Description:
The numerical value for a particular analyte level that has been established in rule, policy, or guidance as a health-based/nonhealth-based level.   This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.


Description:
This attribute stores the water system that was selected when the report was executed.


Description:
This attribute stores the water system number that was selected when the report was executed.


Description:
This attribute stores the water system name that was selected when the report was executed.


Description:
Presence of a Y in this field indicates the water system facility has a Locational Data record.


Description:
Enables user to specify whether the vertical measuring point is above (+) the Vertical Datum or below (-) the Vertical Datum.  Always precedes Vertical Measure.


Description:
A system-generated value which defines whether the Analyte Method Pairing is established and maintained by EPA (value is "HQ") or by a state (value is the two-letter state designator).


Description:
The Federal Enforcement Action Type that would be equivalent to this non-federal action type and that will represent the action type in SDWIS/FED if the state reports it.


Description:
The violation period end date assigned by the state. This date is not reported to fed.


Description:
The violation period begin date assigned by the state. This date is not reported to fed.


Description:
Identifies the violation being uploaded to SDWIS/FED.  On the Violation Maintenance Window, this field is referred to as Violation Number.   Along with Water System Number and Fiscal Year, External System Number (Violation Number)  forms the uniqueness criteria for a SDWIS/STATE violation.


Description:
Format should be CCYY.  Reflects the Fiscal Year to which the violation should be attributed.   Along with Water System Number and Violation Number (External System Number), Fiscal Year forms the uniqueness criteria for a SDWIS/STATE violation.


Description:
Each analyte goup has a unique code assigned.  This code is unique not only within the analyte groups in the database but also within the analytes in the database.  This code is part of the uniqueness criteria.


Description:
Indicates that the enforcement action(s) that may be linked to a violation of this type are federally reportable.


Description:
The measure of facility analyte control  level captured as a number.


Description:
Start Date of the date range the user specified on the PN Compliance Report for the PN Activity Required Date (the date by which the PWS must have notified the public in the method specified in the activity record).


Description:
End Date of the date range the user specified on the PN Compliance Report for the PN Activity Required Date (the date by which the PWS must have notified the public in the method specified in the activity record).


Description:
Start Date of the date range the user specified on the PN Compliance Report for the Proof of PN Required Date.


Description:
End Date of the date range the user specified on the PN Compliance Report for the Proof of PN Required Date.


Description:
This attribute is populated from the Begin Date attribute of  the Monitoring period that would be associated to the violation, this would be populated from the Monitoring period associated to the SSMPA that was cause of this violation if it is a < & R violation or that is associated to the Calculated MCL value in case of an MCL violation.


Description:
This attribute is populated from the End Date attribute of  the Monitoring period that would be associated to the violation, this would be populated from the Monitoring period associated to the SSMPA that was cause of this violation if it is a < & R violation or that is associated to the Calculated MCL value in case of an MCL violation.


Description:
For violations that will be reported to FED, the Analyte that will eventually get reported will either be the ¿reportable' Analyte referenced by the Violation Type or the Analyte referenced by the violation if the Violation Type is not associated to one.


Description:
This attribute will contain the UOM of the Calculated MCL Value for MCL violations and blank for M & R violations.

The unit of measure associated with the ANALYSIS_RESULT_MEASURE.  This value will default to MG/L for all chemical analytes and PIC/L for all radionuclide analytes.


Description:
The violation period begin date to be federally reported.


Description:
The violation period end date to be federally reported.


Description:
This field is valued for PN violations only. It is the  IS Number of the originating violation that triggered the PN violation.


Description:
This field is valued for PN violations only. It is the  ST Code of the originating violation that triggered the PN violation.


Description:
This field is valued for PN violations only. It is the  IS Number of the  violation type of the originating violation that triggered the PN violation.


Description:
This field is valued for PN violations only. It is the  ST Code of the  violation type of the originating violation that triggered the PN violation.


Description:
Provides a place to record free text information about the MDBP Summary.


Description:
Provides a place to record free text information about the Facility Analyte Level.


Description:
A code value that identifies the type of owner for a public water system.


Description:
The date that the water system intends to implement the milestone event requirement.


Description:
The difference in feet between the altitude of the water in a storage facility íaltitude measureù and the altitude of the base of the facility or other reference point íaltitude reference datum codeù.


Description:
Provides an identification number for each association between a Water System and a Service Area.  This field used to be reported to SDWIS/FED as Data Element C601 but is no longer reported to SDWIS/FED.


Description:
Provides an identification number for each association between a Water System and a Regulating Agency. This field used to be reported to SDWIS/FED as Data Element C501 but is no longer reported to SDWIS/FED.


Description:
It formerly identified the milestone event being uploaded to SDWIS/FED.  It used to be reported to SDWIS/FED as Data Element C481 but is no longer reported to SDWIS/FED. The value in this field is generated internally by the SDWIS/STATE application unless the milestone was migrated into SDWIS/STATE in which case SDWIS/STATE can accept a value.


Description:
The number assigned by the state to identify a milestone event.


Description:
Specifies the begin date for the range of violations to be included in the Enforcement-to-Violation association.


Description:
Specifies the ending date for the range of violations to be included in the Enforcement-to-Violation association.


Description:
Categorizes the enforcement to violation criterion.


Description:
A coded value that indicates whether or not the geographic area is the principal city or county served by the water system.  A water system may only have one principal area associated with it.  This occurrence is dependent on the area also being a primary geographic area for the water system.


Description:
The date of the first day for the monitoring period.


Description:
In the host system VIEW materialization of the parent entity, this will represent the current system timestamp as derived from the database server.


Description:
A value that identifies a license number, certification number, or other number used by a regulating program other than the drinking water program.


Description:
The purpose or reason for which a government agency regulates the laboratory.


Description:
User-selected name for the monitoring period.


Description:
Indicates if the Enforcement Package is pending further action.


Description:
Date that the tickler indicator code was last updated.


Description:
An identifying number for the enforcement action             created by the enforcement agency.


Description:
The status of the enforcement action (i.e., potential, validated, rejected)


Description:
Indicates whether or not the enforcement action is open or closed.


Description:
The date that the enforcement action open indicator was last set.


Description:
Free text remarks where the user may record              remarks about the enforcement action.


Description:
A system-generated value that indicates when the enforcement action was posted to the data base.


Description:
Provides a textual description of the enforcement follow up action.


Description:
Provides supplementary information about the enforcement follow up action.


Description:
Indicates if the violation is potential (identified by SDWIS), rejected, or valid (validated by compliance official).  

Source:  TCRNCDS JRP


Description:
Indicates whether or not the violation is open (pending) or closed.


Description:
The date that the open indicator (tickler indicator) was last set.


Description:
Indicates the tier level of the violation, e.g., Tier Level 1, Tier Level 2.


Description:
A system-generated value that indicates when the violation was posted to the data base.


Description:
Indicates the category of the violation (e.g., MCL, monitoring, public notification, treatment technique, sanitary survey etc.


Description:
The violation sample type (e.g., routine, repeat).


Description:
The date that the rule was associated with the government agency.


Description:
The date that the rule was disassociated with the government agency.


Description:
A system-generated value that represents the calendar date and time on which this water system legal entity assignment was initially posted to the data base or when a subsequent state-supplied modification was made.


Description:
Indicates the date that the violation was assigned to the code of regulation.


Description:
Indicates if the violation is potential (identified by SDWIS), rejected, or valid (validated by compliance official).

Source:  TCRNCDS JRP


Description:
Code Characteristic refers to the collection of possible values for this Code.  Valid values for Code Characteristic  are Text, Numeric and Date.


Description:
This is the identifier for a SDWIS CODE. This code name should be determined at the time of data modelling for any attribute that would use the SDWIS CODES permitted values. It is suggested that a meaningful abbreviation of the Code be used as a Code Name.


Description:
This attribute will contain the timestamp of thelast update to this Code.


Description:
This attribute will contain the USERID of the user who created this Code or the User who last Modified it.


Description:
This defines the decimal length for any numeric code. This attribute is not applicable for text and date domains. This can be zero for numeric domains also. The maximum decimal length can be 9.


Description:
This attribute defines the delete property for the code. It has possible value of 'C' for allowing Cascade delete of the Code and all the permitted values of the Code, 'A' for allowing delete of an individual permitted Value, and 'D' for Disallow delete of any kind. The default value is D and for all the Codes supplied by the SDC the value will be D.


Description:
This attribute can be used to capture information about the Code and its uses and any special feature related to this code.


Description:
This attribute is used to differentiate between codes that can have values that may be added by the state and codes whose values may only be added by the EPA. All the Codes whose permitted values can only be added by the EPA will have a Ownership Code of "HQ" and all the codes for which Values may be added by the state will have a Ownership Code of "ST". Examples of Codes with "HQ" Ownership Code are Codes used in the Location Table etc., because these codes will contain values supplied by EPA and the states would not be able to add values to these Codes.


Description:
This attribute is used to capture the name of the referencing attribute.


Description:
This defines the maximum length of the code values for this Code. Typically this will be equal to the length of the attribute that references the permitted values for this code.

This value is always 8 for date domains and cannot exceed 15 for numeric domains and cannot exceed 40 for text domains.


Description:
This attribute contians the timestamp of when the permitted value was created or when it was last modified.


Description:
This attribute contains the userid of the person who created the permitted value or who last modified this permitted value.


Description:
This attribute is used to contain the permitted value in case the Characteristic of the code is DATE.


Description:
This field Contains the description of the permitted Value.


Description:
This attribute is used to contain the permitted value in case the Characteristic of the code is NUMERIC.


Description:
This attribute is used to Identify the origin of a permitted value. All Permitted values supplied by the EPA with the releases will have a value of "HQ" in the state code and all the permitted values added by the state will have a value of "ST" in the ownership Code.
The states will not be able to change any permitted value that has a STATE_CODE of HQ even if it is not referenced yet.


Description:
This attribute Can have values of blank or Y. Any time a permitted Value is referenced and used in the attribute of a application table this value will be set to Y. Any permitted value that has a refernced_indicator value of Y cannot be modified using the maintainance window.


Description:
This attribute is the identifying attribute for the permitted value table in conjuction with the relationship to the SDWIS CODE table. This is a 1 up number for each SDWIS_CODE.


Description:
This attribute is used to contain the permitted value in case the Characteristic of the code is TEXT.


Description:
The open text description of the reason for the deviation.


Description:
Indicates if all groundwater sources are disinfected.


Description:
Indicates that a change has been made in inventory data (e.g., population, water system facility status, primary water type, etc.) since the last time a sample schedule was computed for the water system.


Description:
Indicates if all groundwater sources are protected for a water system.


Description:
Indicates if all surface water or groundwater under direct influence of surface water sources are filtered.


Description:
The total number of miles of pipe within the distribution systems of a water supply.


Description:
A system-generated value which, along with TMNCOR_ST_CODE, uniquely identifies the code of regulation.


Description:
A designed attribute which identifies the associated state.  Used with TMNCOR_IS_NUMBER, it uniquely identifies the code of regulation.


Description:
The title of the code of regulation,as listed in the regulatory register.  An example is, "Title 4D, of the Code of Federal Regulations."


Description:
The name of the code of regulation.  An example is, "Code of Federal Regulations."


Description:
The number of the code of regulation.  An example is, "Part 141.21, Title Code 40, Code of Federal Regulations."


Description:
An open text description of the code of regulation.


Description:
The effective begin date of the code of regulation.


Description:
The effective end date of the code of regulation.


Description:
A system-generated value which uniquely identifies the deviation event.

Source:  TCR Team


Description:
A coded value which identifies the state in which the deviation event is valid.

Source:  TCR Team


Description:
The status of deviation events for a water system.


Description:
An open text description of a deviation event.


Description:
A system-generated value which uniquely identifies the enforcement package.


Description:
A coded value which identifies the state in which the enforcement package is valid.


Description:
The date the enforcement case was activated or initiated.


Description:
Open text remarks describing the enforcement case.


Description:
The date that the government agency begins funding the program.


Description:
The date that the government agency stops funding the program.


Description:
A system-generated value that represents the calendar date and time on which the government agency program assignment was initially posted to the data base or when a subsequent state-supplied modification was made.


Description:
The upper limit measure of the water quality parameter.


Description:
The lower limit measure of the water quality parameter.


Description:
The effective start date of the water quality parameter for a particular water system.


Description:
The effective end date of the water quality parameter for a particular water system.


Description:
A system-generated value which, along with TMNMNCON_ST_CODE, uniquely identifies the monitoring condition.

Source:  TCR Team


Description:
A designed attribute which identifies the associated state.  Used with TMNMNCON_IS_NUMBER, it uniquely identifies the monitoring condition.

Source:  TCR Team


Description:
The name of the Entity Type whose attribute must meet a specific value for the condition to be true.

Source:  TCR Team


Description:
The name of the attribute that must meet a specific value for the condition to be true.

Source:  TCR Team


Description:
The relationship that must exist between the attribute and the specified value for the condition to be true. (e.g., EQ, LT, GT, LE, GE)

Source:  TCR Team


Description:
The value that must be met by the specified attribute for the condition to be true.


Description:
A system-generated value which, along with TMNMPDESC_ST_CODE, uniquely identifies the deviation.


Description:
A designed attribute which identifies the associated state.  Used with TMNMPDESC_IS_NUMBER, it uniquely identifies the deviation.


Description:
The day when the monitoring period is scheduled to begin.


Description:
The month when the monitoring period is scheduled to begin.


Description:
The date that the monitoring condition was assigned to the monitoring requirement.

Source:  TCR Team


Description:
The date that the monitoring condition was unassigned from a monitoring requirement.

Source:  TCR Team


Description:
A number that represents the cardinal order in which the associated condition should be checked relative to the other conditions assigned to the monitoring condition.

Source:  TCR Team


Description:
The description of how the related monitoring condition should be combined with the previous monitoring condition, when all monitoring conditions for a monitoring requirement are processed sequentially.

Source:  TCR Team


Description:
An indicator that describes whether or not an open parenthesis immediately preceeds the related monitoring condition.  This information is used when sequentially processing all monitoring conditions that qualify a monitoring requirement.


Description:
A component of the boolean logic that is used in the software to develop TCR sampling schedules.


Description:
A system-generated value that represents the calendar date and time on which the monitoring requirement condition assignment was initially posted to the data base.


Description:
A system-generated value that represents the calendar date and time on which this monitoring requirement condition assignment was initially posted to the data base or when a subsequent modification was made.


Description:
A designed attribute which, along with TMNMNLOC_ST_CODE, uniquely identifies the monitoring requirement location.


Description:
A designed attribute which identifies the associated state.  Used with TMNMNLOC_IS_NUMBER, it uniquely identifies the monitoring requirement location.


Description:
A code value for the type of location for requirements.  

Examples:  upstream, downstream, original, other, near 1st connection, entry point, distribution, source.


Description:
The description for the location of the monitoring requirement.


Description:
A system-generated value which, along with TMNmnr_ST_CODE, uniquely identifies the monitoring requirement.


Description:
A designed attribute which identifies the associated state.  Used with TMNMNR_IS_NUMBER, it uniquely identifies the monitoring requirement.


Description:
The date on which the monitoring requirement was no longer effective.


Description:
The date that the monitoring requirement took effect.


Description:
Indicates if the monitoring requirement is routine, a special study, re-analysis of existing sample(s) for the same analyte or another analyte, or repeat.

Example:  a positive for TC will require re-analysis for fecal coliform (routine, special, re-analysis, repeat)


Description:
The minimum number of times that a sample must be drawn.  This number is used in conjuction with Sample Count Unit Code.


Description:
The frequency at which the sample must be drawn.  The number is captured in the attribute Sample Count.

(i.e. Monthly, Yearly, Daily)


Description:
The period which is used to count the samples.  The number of samples required to be collected within a monitoring period.


Description:
The minimum number of non-detect samples (samples with negative results), that are required to be drawn.


Description:
The code for the period which is used to count the non-detect samples (samples with negative results).


Description:
A coded value that indicates when a sample schedule should go into effect (e.g., 24 hours, months).


Description:
A description of the monitoring requirement.


Description:
A system-generated value which, along with TMNPROG_ST_CODE, uniquely identifies the program.


Description:
A designed attribute which identifies the associated state.  Used with TMNPROG_IS_NUMBER, it uniquely identifies the program.


Description:
Indicates the type of program, e.g., lab certification program, research program, waiver program, regulatory program, fiscal program, Wellhead Protection program .


Description:
The date in which the program became effective.


Description:
The last date a drinking water program was effective.


Description:
The purpose of a drinking water program.


Description:
A system-generated value that represents the calendar date and time that the legal entity  was initially associated with the program.


Description:
A coded value which categorizes the reason for associating a legal entity with a program.


Description:
A coded value which indicates whether the relationship between the program and the legal entity is active or inactive.


Description:
The date that the legal entity was associated with the program.


Description:
The date that the legal entity was disassociated from the program.


Description:
The effective begin date of the program project assignment.


Description:
The effective end date of the program project assignment.


Description:
A system-generated value which, along with TMNPROJ_ST_CODE, uniquely identifies the project.


Description:
A designed attribute which identifies the associated state.  Used with TMNPROJ_IS_NUMBER, it uniquely identifies the project.


Description:
Indicates the type of project, e.g., federal, state, or special.


Description:
The date in which the project became effective.


Description:
The last date a drinking water project was effective.


Description:
The scientific or regulatory objectives of a project.


Description:
A system-generated value that represents the calendar date and time that the legal entity  was initially associated with the project.


Description:
A coded value which categorizes the reason for associating a legal entity with a project.


Description:
A coded value which indicates whether the relationship between the project and the legal entity is active or inactive.


Description:
The date that the legal entity was associated with the project.


Description:
The date that the legal entity was disassociated from the project.


Description:
The date that the rule was implemented by the primary rule.


Description:
The date that the rule was dropped from the primary rule.


Description:
A system-generated value that represents the calendar date and time on which this rule assignment was initially posted to the data base or when a subsequent state-supplied modification was made.


Description:
The reason for the monitoring requirement sample schedule assignment.


Description:
The effective end date for the schedule.  This means that the monitoring requirement associated to the schedule no longer applies to the water system facility as of this date


Description:
The day which (when combined with begin month) the sample schedule will go into effect.


Description:
The month for which the sample schedule will go into effect.


Description:
The day which (when combined with the end month) the sample schedule will no longer be in effect.


Description:
The month when the sample schedule will no longer be in effect.


Description:
Indicates if corrective action has been taken since the activation of the temporary monitoring requirement for a specific water system.  For example, a result exceeds the MCL.  In order to discontinue the temporary monitoring, a specified number of negative samples must be received and the water system must report taking some type of corrective action such as tightening a loose nut.


Description:
Indicates if a deviation exists for the sample schedule.


Description:
The system-generated value that represents the calendar date on which the Water System was notified that a sample was found to be Total Coliform positive.


Description:
Indicates if the sample schedule was generated by the system or the user.


Description:
A system-generated value which, along with TMNSASCD_ST_CODE, uniquely identifies the sample schedule date.

Source:  TCR Team


Description:
A designed attribute which identifies the associated state.  Used with TMNSASCD_IS_NUMBER, it uniquely identifies the sample schedule date.

Source:  TCR Team


Description:
A value that represents the date on which a sample is planned to be taken.  This date is initially system-generated, and can subsequently be modified or deleted.

Source:  TCR Team


Description:
A system-generated value which, along with TMNSMPLN_ST_CODE, uniquely identifies the sampling plan.

Source:  TCR Team


Description:
A designed attribute which identifies the associated state.  Used with TMNSMPLN_IS_NUMBER, it uniquely identifies the sampling plan.

Source:  TCR Team


Description:
The date in which the sampling plan is approved.

Source:  SDWIS Team


Description:
The date in which the sampling plan is placed into effect.


Description:
The date in which the sampling plan is no longer in effect.


Description:
Information describing the sample plan for a water system.


Description:
Code indcating if existing sample point information should be used in determining compliance.


Description:
A computed value that represents the calendar date on which a sampling plan sampling point assignment was initially posted to the data base.


Description:
Indicates if the sampling point is primary or secondary for a sample plan.


Description:
The date that the sampling point was identified in the sampling plan.

Source:  TCR Team


Description:
The date that the sampling point was dropped from the sampling plan.


Description:
A system-generated value that represents the calendar date and time on which this sampling plan sampling point assignment was initially posted to the data base or when a subsequent state-supplied modification was made.


Description:
A system-generated value which, along with TMNSTAT_ST_CODE, uniquely identifies the statute.


Description:
A designed attribute which identifies the associated state.  Used with TMNSTAT_IS_NUMBER, it uniquely identifies the statute.


Description:
The number assigned by the legislative body.  Example:  PL99-339 (Safe Drinking Water Act Amendment June 1986)


Description:
The purpose of a drinking water statute.


Description:
The first date a drinking water statute became effective.


Description:
The last date a drinking water statute was effective.


Description:
The date that the statute amended the other statute.


Description:
A system-generated value that represents the calendar date and time on which the statute assignment was initially posted to the data base or when a subsequent state-supplied modification was made.


Description:
The date that the status was determined.

Source:  TCRNCDS JRP


Description:
A system-generated value which uniquely identifies the vulnerability assessment analyte assignment.


Description:
A system-generated value which uniquely identifies the vulnerability assessment geographic area assignment.


Description:
The common name of a contaminant as used by states and EPA in the rules and other documents.


Description:
A text string representing the scientific name of the analyte.


Description:
User selected mutually exclusive type of analyte: CH, WQ, RA, OR.

TYPE_CODE: CH
Organic and inorganic compounds that may contaminate water. Examples include the following:

Inorganic Chemicals:
Arsenic, Barium, Cadium, Chromium, Fluoride, Lead, Mercury, Nitrate, Selenium, Silver, Chloride, Copper, Iron, Manganese, Sodium, Sulfate, Zinc;

Organic Chemicals:
Chlorinated Hydrocarbon Insecticides (Endrin, Lindane, Methoxcychlor, Toxaphene); Chlorophenoxy Herbicides (2, 4-Dichlorophenoxyacetic Acid (2,4-D), 2,4,5-Trichlorophenoxypropionic Acid (2,4,5-TP);
 
Volatile Organic Chemicals (VOC):
Benzene
Vinyl chloride,
Carbon tetrachloride
1, 2-Dichlorethane
Trichloroethylene (TCE)
1, 1-Dichloroethylene
1,1,1-Trichloroethane
para-Dichlorobenzene;

Disinfection By-Products:
 Total Trihalomethanes.


TYPE_CODE: OR
Organism:
A code value representing the organism.
Ecoli
Fcoli
Tcoli
Giard
Crypto

Chemical element that undergoes spontaneous nuclear decay, thereby emitting various forms of radiation energy. Radionuclides originate from both natural and man-made sources.

TYPE_CODE: RA
The four radionuclide contaminants are Radium-226, Radium-228, Radon-222, and Uranium.

The two categories of radionuclides are adjusted gross alpha emitters and beta and photon emitters.
  - The category of adjusted gross alpha emitters regulates alpha emitters and is gross alpha measurement less Uranium and less Radium-226.
  - The category of beta and photon emitters regulates total beta and photon emitters (mostly manmade).




TYPE_CODE: WQ
Characteristics include quality and variability of suspended and disolved solids, turbidity, alkalinity, hardness, and presence of significant color levels.

Permitted values: Color, Odor, pH, Total Dissolved Solids (TDS), Turbidity


Description:
The standard code used by EPA and the states to represent analytes in the national database.  Each analyte has a unique code assigned to it for reference in compliance determination.


Description:
A computed alphanumeric value that identifies the CAS Registry Number.  The CAS Registry Number is a unique identifier, assigned by the Chemical Abstract Service (CAS) for a specific chemical compound (e.g., an unregulated contaminant).  CAS Registry Numbers are used internationally in chemical indices and computer systems for unique identification.

This data element does not apply to lead (i.e., PB90) sample data.

The term computed, as used here, implies that this value is not reported by the State.  SAMPLE-CAS-ID is determined automatically by the FRDS-II computer system during its normal course of operation when an unregulated contaminant monitoring sample is inserted into the FRDS-II Data Base.


Description:
CODE OF FEDERAL REGULATIONS SECTION REFERENCE CODE

A coded value which provides a reference to the Code of Federal Regulations Section.


Description:
A system-generated value which uniquely identifies the vulnerability assessment.


Description:
Indicates whether this contaminant is monitored.


Description:
A coded value which identifies the state in which the vulnerability assessment is valid.


Description:
Provides a textual comment about this analyte.


Description:
The date that a water system (or water system ffacility), "vulnerable" status was placed into effect by a regulatory agency.  Some water systems or facilities are considered to be "vulnerable" to contamination due to environmental conditions, like a spill near a well, or problems with the infrastructure, like cross-connections.


Description:
Indicates whether this analyte has an established numerical value for regulatory use (e.g. MCL, action level, performance level).


Description:
The date that a water system (or water system facility) "vulnerable" status was changed to "not vulnerable" by a regulatory agency.


Description:
The type of vulnerability assessment specific to a drinking water rule.  Examples include: Phase 2/5, VOC, pesticide, coliform, etc.


Description:
An open text description of the type of vulnerability assessment and its results or findings.


Description:
The date the requirements for a vulnerability assessment was published by a regulating agency.


Description:
A narrative description of the purpose of water system group.


Description:
The first date a WATER SYSTEM GROUP ASSIGNMENT was made effective by a regulatory agency (such as USEPA) or a primacy agency (such as a state).


Description:
The last date a contaminant level was considered effective by a regulatory agency (such as USEPA) or a primacy agency (such as a state).


Description:
A system-generated value that represents the calendar date and time on which the water system was initially posted to the data base, when a subsequent state-supplied inventory modification was made, or when the water system was deleted. 

Source:  FRDS-II Data Element Dictionary (amended) SDCJRP


Description:
The name assigned to the Group of analytes.


Description:
The sequence number in which the analyte falls within the Analyte Group.


Description:
The coded value for a type of analyte level. If thresholds are exceeded the sample analytical results are reviewed to determine the appropriate action. These levels include regulatory compliance levels, that when exceeded in water, indicate violations of standards and other levels that indicate warnings, or that trigger additional monitoring by a water system.


Description:
The coded value for a type of analyte level measurement. These levels include Regulated Minimum Detection Limits  (RMDL), Minimum Residual Disinfectant Levels (MRDL),  Minimum Residual Disinfectant Level Goals (MRDLG), etc.


Description:
The numerical value for a particular analyte that has been established in rule, policy, or guidance as a health-based/nonhealth-based level.


Description:
The measurement units used to expressed the MCL, MCLG, or other level


Description:
The first date a contaminant level was made effective by a regulatory agency (such as USEPA) or a primacy agency (such as a state).


Description:
The name of the person that collected the sample.


Description:
The identification number of the collector. Sometimes is the number of the water operator's certification.

Minn JRP


Description:
Represents the date that an analytical method was approved for a laboratory.


Description:
Represents the date that approval for an analytical method was removed for a laboratory.


Description:
A coded value which categorizes the reason for associating a legal entity with a laboratory.

Note:  only one administrative contact should be identified for each laboratory.


Description:
A coded value which indicates whether the relationship between the laboratory and a legal entity is active or inactive.


Description:
The date that the legal entity was associated with the laboratory.


Description:
The date that the legal entity was disassociated from the laboratory.


Description:
The units of measure for microbiological analysis.


Description:
The number of organisms counted or estimated in a microbiological sample. Usually expressed as "# of colonies per 100 milliliter sample".


Description:
Type of microgiological unit that is being counted per specified count unit.  Count type varies with the microbiological organism where count has been recorded.


Description:
The units of measure associated with the microbial analytical result count.


Description:
Indicates whether results of an analysis were positive (P-Presence) or negative (A-Absence). Indication of presence or absence creates an analytical result for a specific analyte.


Description:
List of possible comments that a lab might make regarding the analytical result.

Examples: Too numerous to count without coliform
Chlorine present in the sample when it arrived at the lab
Confluent Growth
                  

****
Permitted Values:
      TNTC  Too numerous to count
      CNFG  Confluent growth
      CL2   Chlorine was present in sample
      VOL   Insufficient Volume in sample container
   Properties:    Optional Basic Text


Description:
Designates a result as either 'Presumptive' or 'Confirmed'.


Description:
The measure of free and available chlorine in milligrams per liter (mg/L).


Description:
The amount of residual disinfectant found in the water after disinfection has been applied.


Description:
The temperature of the water being sampled at the time and place of sample collection (Degrees Centrigrade).  The user can enter either F or C, the system will convert the measure into C.


Description:
Enables selection of "C" for centrigrade or "F" for fahrenheit degrees.


Description:
The turbidity of the water being sampled at the time and place of sample collection in Nephelometric Turbidity Units (NTU).


Description:
The pH of the water being sampled at the time and place of sample collection (pH units).


Description:
The flow rate of a sample collection device in gallons per minute (GPM).


Description:
The name of the federal regulation, state regulation, or special study.


Description:
This is an abbreviation of the full rule name.


Description:
The status of the rule.  

Examples:  draft rule, advance notice, proposed, and final rule.


Description:
The date a rule was published or promulgated.


Description:
The effective begin date of the regulation.


Description:
The effective end date of the regulation.


Description:
The description of the federal or state rule.


Description:
The description of a sample summary by a count of its attributes.


Description:
Number of occurrences of each specific Typecode in a specific Sample Analysis Summary.


Description:
The unique code for identifying a water system facility sample point..  This value must be unique within the Water System Facility. This field is one of two Sampling Point fields referenced in the Sampling via EDI Sample Structure Set.  In that structure set,, it is called " B_Sampling_Point".  Whenever this field is referenced in an online SDWIS/STATE window, it is generally called "Sampling Point".


Description:
A description of the sampling point.  This field is one of two Sampling Point fields referenced in the Sampling via EDI Sample Structure Set.  In that structure set, it is called " B_Sampling_Location".  Whenever this field is referenced in an online SDWIS/STATE window, it is generally called "Sampling Location".


Description:
The point in a distribution system where samples are collected. The point is considered to be representative of the water
throughout the distribution system.


Description:
The lead and copper rules establish "tiers" for sampling sites by water systems.

Tier 1: Single family residences that contain copper pipe and lead solder installed after 1982 and/or served by a lead service line

Tier 2: Same as above but multi-family buildings

Tier 3: Single family residence with copper pipe and lead solder installed before 1983


Description:
Tier 1:
 LSL - Lead service line
 CU>82 - Copper plumbing with lead solder        installed after 1982
 PbP - Interior Lead Plumbing

Tier 2:
 All Tier 1 + SEE ABE Siegel on this! SDC action item!

Tier 3:
 Residential homes with copper plumbing with Lead solder installed before 1983.

Random


Description:
The sample identification number assigned by the laboratory for tracking the sample within the lab.


Description:
A numeric value assigned by a state to uniquely identify a specific sampling occurrence.


Description:
The month and year of the compliance period.  (defaulted to current month, for repeat samples it is the month that the original sample was taken.)


Description:
The location of the repeat/check/confirmation sample with respect to the location of the original routine sample.  Example: Original (the same location as the original sample),   Upstream (within 5 service connections upstream from the location of the original sample), Downstream (within 5 service connections downstream from the location of the original sample), Other (one site elsewhere at the supplier's discretion).


Description:
Indicates whether or not a sample belongs to a larger composite group.

May only be "Yes" for chemical and radionuclide sample categories.


Description:
The quarter number assigned by the State to reflect the three month period of the year in which the radionuclide composite member sample was collected.

This data element does not apply to lead (i.e., PB90) sample data.


Description:
The date the lab composited the individual samples into one sample.


Description:
The start date of the sample collection. Sometimes a sample is collected over a period of time (e.g. protozoa). In such cases, this is the date the sample collection event began.  This field appears on some but not all Sample Maintenance windows.  It is not used in Sampling via EDI.


Description:
The start time of the collection in local standard time.


Description:
Used in most cases as the Sample Collection Date.  This field appears on all Sample Maintenance windows and is used as the Sample Collection Date in Sampling via EDI.   Sometimes a sample is collected over a period of time (e.g. protozoa). In such cases, this is the date the sample collection event ended.


Description:
The end time of the collection in local standard time.


Description:
Date that the sample was received at the laboratory.


Description:
The type of sample for purposes of lead and copper rule compliance.


Description:
Indicates whether sample is a microbiological sample.


Description:
When selected in the sample record, the sample and its results will be used (by any automated software) in the determination of compliance for that sample.  Samples not selected will not be used in any compliance determination.


Description:
The reason a lab rejects a sample for further analysis.


Description:
A designer added attribute that allows the developer to implement the flows between  tailored sample windows.


Description:
A computed numeric value that represents the Federal fiscal year in which the sample was taken.

The term computed, as used here, implies that this value is not reported by the State.  SAMPLE-FY is determined automatically by the FRDS-II computer system during its normal course of operation.


Description:
C2101 (SAMPLE_ID):
A numeric value used to uniquely identify a specific sampling occurrence for lead as required under the Lead and Copper Rule or an unregulated contaminant analyzed per the Unregulated Contaminant Monitoring requirements.

SAMPLE-ID is of the form:  nnnnn

Where : nnnnn = a sample identification number assigned by the State or generated by the FRDS-II computer system (the first position consists of the leter "S" if the ID was generated).


C2121 (SAMPLE_ORIGINAL_ID):
A numeric value used to associate a confirmation sample with a previously reported routine sample for which it was taken.  If the original Sample ID was generated by FRDS-II, it will have an "S" prefix.

This data element does not apply to lead (i.e., PB90) sample data.


Description:
A system-generated value that indicates when the record  was first posted to the database.


Description:
Time that extraction was performed on the Chemical sample.


Description:
Date that extraction was performed for Chemical samples.


Description:
The limit established by the laboratory below which scientifically reliable results cannot be achieved.  In many cases, if the computed detection limit is below the Method Detection Limit, then the Method Detection Limit is used as the detection limit; if the computed detection limit is above the Method Detection Limit, then the detection limit is used.


Description:
The unit of measure associated with the detection limit.


Description:
Indicates Result is Microbiological--used for samples of type TCR and General Microbiological.


Description:
The date the laboratory began the analysis of a sample. In the case of microbiological and other types of samples, analysis can take more than one day.


Description:
The time the laboratory began the analysis of a sample.


Description:
The date the laboratory completed the analysis of a sample.


Description:
The time the laboratory completed the analysis of a sample.


Description:
The date that the sample analytical result is received by the state.


Description:
The date the laboratory notified the water system of the analytical result.


Description:
When valued, indicates that the analytical result (concentration) was below the Regulatory Minimum Reporting Level or below the Laboratory Reporting Level (which in turn must be at or below the regulated MCL for the analyte).


Description:
Binary indication of whether the result is "less than" the Lab Reporting Limit or "less than" the Regulatory Minimum Reporting Limit.
For example, the user may select Regulatory Minimum Reprting Limit (which sets the Limit attribute to the RMDL Measure in ANALYTE RULE ASGMT) and check/activate the "less than indicator" to indicate result is less than the RMDL.


Description:
Code indicating whether or not the sample anlytical result meets established data quality acceptance criteria.


Description:
The reason the sample analytical result was rejected (e.g., failed DBP QA check, failed micro QA check, etc.).


Description:
Indicates the reason that the result was rejected by the Lab.

Examples:
Lab error
Canceled by requestor
Instrument failure
Rejected


Description:
The actual reported measure of a chemical/rad/water quality result.  This measure is captured as text in order to preserve the trailing zeros which indicate the precision of the measure.  The text value is also converted to a number and stored in the SBS_SAR Concentration_Measure attribute.

Source:  SBS Team


Description:
The counting error estimated by the laboratory due to turbidity in the sample or other analytical anomalies. Usually expressed as a value "plus or minus" the picocuries per liter measure.


Description:
A numeric value that represents the result obtained from a sample analysis. 

Note: Currently unable to support largest/smallest capacity.  When IEF toolset is fixed, this needs to be addressed.
Set new size to 16.9


Description:
The purpose of the standard technique or procedure.


Description:
The minimum time in hours required to perform an analysis for a given method.


Description:
The maximum time in hours between the start and end of analysis for a given method.


Description:
The maximum length of time in hours between the collection of a sample and the start of  analysis.


Description:
The Method Detection Limit is the minimum concentration of a substance that can be measured and reported according to the method.

Note: Currently unable to support largest/smallest capacity.  When IEF toolset is fixed, this needs to be addressed.
Set new size to 16.9


Description:
A code value which represents the unit of measure (UM) that is associated with the value reported.


Description:
A code value that represents the method that was used to analyze the sample (e.g., EPA assigned method code). Ex. EPA 525.1

SOURCE: SBS JRP1


Description:
The date the Standard Technique or Procedure was put into effect by a federal or state regulatory agency.


Description:
The date the Standard Technique or Procedure was taken out of effect by a federal or state regulatory agency.


Description:
The two main types of groups are static and dynamic.  Static groups are fixed lists of specific water systems.  Dynamic groups are determined by water system inventory criteria and periodically recalculated to update the list based on new information.


Description:
The SDWIS/STATE user's 8-character UserID.


Description:
When valued, identifies the Water System Group that the user has selected to be current.


Description:
Represents the date that an Individual legal entity was assigned to the Government Agency legal entity.


Description:
Dynamic groups are periodically recalculated to update the list, based on new information.  This is the date on which a group was last recalculated.
  
Prior to SSWr1 release the last updated timestamp was set for static groups also.  SSWr1 implemented it as an optional attribute as originally designed and static groups will not contain a value for this attribute.


Description:
A numeric value that represents the result obtained from a sample analysis.


Description:
The week when the monitoring period is scheduled to begin.


Description:
The date an assignment between a water system and monitoring period began.


Description:
The date an assignment between a water system and monitoring period ended.


Description:
Value that represents the unit of measure associated with the SAMPLE_SUMMARY_RESULT Measure.


Description:
The type code of the monitoring period for which the description applies, i.e., monthly, quarterly, annually.

Source:  TCR Team


Description:
The type code of the monitoring period, i.e., monthly, quarterly, annually.


Description:
The date on which the association between the water system and the monitoring period became effective.

Source:  TCR Team


Description:
The date when the assocation between the water system and the monitoring period ended.


Description:
The date on which the association between the water system and the monitoring period became effective.


Description:
An indicator that compliance has been run for a water system, rule, and monitoring period.  Once the code is valued, compliance can no longer be run for that combination.


Description:
A system-generated low count of the total population served by a water system.


Description:
A binary value that defines the Water System Group as either Public or Private.


This attribute become obsolete with the SSWr1 release due to security concerns with sharing water system groups.


Description:
Indicates if the standard method is for the purpose of collecting samples.


Description:
Indicates if the violation was generated by the system or the user.


Description:
The date that the violation was determined or created.


Description:
The logical owner or, promulgator of the assignment.  In most cases, this will be HQ (Headquarters), but could be a state abbreviation.


Description:
A code to indicate assignment type.  Current permitted values include "V" (a valid assignment) and blank.


Description:
The concentration value or averaged concentration value of one or more results with which the violation is associated and whose values have caused the violation  to be created.  Value is reported in text format to preserve precision (i.e., leading and trailing zeroes).  Needs to conform to a number of size 15(9).  (The sixteenth character is for the decimal place.)


Description:
The concentration value or averaged concentration value  of one or more results with which the violation is associated and whose values have caused the violation to be created.  This value will be calculated based upon the value entered in Analysis Result Text and will  be the value that is reported to SDWIS/FED.


Description:
The unit of measure associated with the ANALYSIS_RESULT_MEASURE.  This value will default to MG/L for all chemical analytes and PIC/L for all radionuclide analytes.


Description:
A value which identifies which one of four quadrants of the quarter-quarter-quarter section in which a water system facility is located.

Must be one of the following codes:
       "NE"  -  Northeast Quarter
       "NW"  -  Northwest Quarter
       "SE"  -  Southeast Quarter
       "SW"  -  Southwest Quarter


Description:
Identifies the violation being uploaded to SDWIS/FED.  On the Violation Maintenance Window, this field is referred to as Violation Number.  Along with Water System Number, External System Number (Violation Number) forms the uniqueness criteria for a SDWIS/STATE violation.


Description:
Identifies the enforcement being uploaded to SDWIS/FED.  Along with Water System Number and Fiscal Year, Enforcement Action External System Number forms the uniqueness criteria for a SDWIS/STATE enforcement action.  External System Number is referred to on the Enforcement Action Maintenance window as the Enforcement Action No.


Description:
It formerly identified the sample analytical result (and by default the sample) or sample summary result (and by default the sample summary) being uploaded to SDWIS/FED. This field used to be reported to SDWIS/FED as Data Element C2101 but is no longer reported to SDWIS/FED.


Description:
Designates that the Government Agency has Primacy.


Description:
A system-generated value which uniquely identifies the table row to SDWIS/STATE, and SDWIS/FED.


Description:
When valued, identifies the Government Agency that the user has selected to be current.


Description:
This field will allow the user to capture the treatment status of the water flowing through the Water System Facility.


Description:
Provides an identification number for each association between a Water System and a Legal Entity. This field is no longer reported to SDWIS/FED.


Description:
Natural identifier for Screen to uniquely  identify the many screens that may belong to a well.


Description:
Indicates whether or not the Individual is also considered a Collector.


Description:
A system-generated count of the high population served by a water system.


Description:
The date that the Milestone Event Status is determined.


Description:
Information about the status of a milestone event.


Description:
Indicates the date on which the analyte was added to CFR 141.40 Special monitoring for inorganic and organic contaminants (i.e., the date it became an unregulated contaminant monitoring - UCM analyte).


Description:
Indicates the date on which the analyte was removed from CFR 141.40 Special monitoring for inorganic and organic contaminants (i.e., the date it was removed as an unregulated contaminant monitoring - UCM analyte).


Description:
The date timestamp that the most recent DTF H1 file was created that included this sample analytical result or sample summary result.  Value should match the date and time shown in the DTF Creation Date and DTF Creation Time fields of the batch run record in the Post SDWIS/FED Batch Selection list that represents the batch run that included this sample analytical result or sample summary result.


Description:
The transaction type that SDWIS/FED uses, either I (insert) or M (modify), to interpret whether or not the incoming sample should be inserted or instead, should first be referenced and then modified.


Description:
The number of the most recent DTF H1 file created that included this sample analytical result or sample summary result.


Description:
Status of the sample analytical result or sample summary result relative to SDWIS/FED.


Description:
The last number generated and passed to the table to value the table's External System Number attribute/ External Sys Num field.


Description:
The number that uniquely identifies a given instance of executing Migration to SDWIS/FED: Sampling (batch run) for the purpose of generating a DTF H1 file.


Description:
The number of sample results (UCM) or summary results (PB90 or CU90)  processed and successfully written to the DTF H1 file for an instance of executing Migration to SDWIS/FED: Sampling (batch run).


Description:
Code indicating whether or not the sample summary result meets established data quality acceptance criteria.


Description:
The lower collection date range that the user specified on the Migration to SDWIS/FED: Sampling window


Description:
The upper collection date range that the user specified on the Migration to SDWIS/FED: Sampling window


Description:
The date timestamp of this instance of executing Migration to SDWIS/FED: Sampling (batch run).  This value is shown  in the DTF Creation Date and DTF Creation Time fields of the batch run record in the Post SDWIS/FED Batch Selection List .


Description:
Indicates whether or not the instance of executing Migration to SDWIS/FED: Sampling (batch run) was for (P) PB90, (U) UCM, or reflected both (B) PB90 and UCM.


Description:
Stutus of the instance of executing Migration to SDWIS/FED: Sampling (batch run).  Possible values include F (failed - default status prior to successful completion); P (pending-successfully completed execution); D (dry run-previously run instance/batch run that the user did not accept and chose to reexecute; A (accepted-the sample results included in the instance/batch run were accepted by SDWIS/FED and flagged as such in SDWIS/STATE.


Description:
The Internal System Number of the last Sample Result or last Sample Summary Result that was written to the DTF during processing.  This field lets the program know where to "restart" in the case of abnormal termination of Migration to SDWIS/FED: Sampling (e.g. a power outage).


Description:
The start date of the collection time period during which the sample summary should be taken.


Description:
The end date of the collection time period during which the sample summary should be taken.


Description:
Indicates whether or not the sample summary was taken for purposes of compliances.


Description:
Provides a place to record free text information about the sample summary.


Description:
Total number of UCM Samples  (Number of Samples for UCM) considered for inclusion in the DTF for a given instance of executing Migration to SDWIS/FED: Sampling (batch run).  (The number of samples considered for inclusion may change based on the date range that the user enters on the Migration to SDWIS/FED: Sampling window).


Description:
Total IOC UCM/Pb90 Insert Sample Results                (Number of Inorganic UCM/Pb90 for Insert).


Description:
Total IOC UCM/Pb90 Modify Sample Results                (Number of Inorganic UCM/Pb90 for Modify).

Total Inorganic Chemical (IOC) UCM Modify Sample Results written to the DTF.  This value is displayed in the SDWIS/STATE Migration to SDWIS/FED Sampling Results Summary Report beside the "UCM Organic" row under the "Modify"  column.


Description:
Total IOC UCM/Pb90 High Value Sample Results                (Number of Inorganic UCM >5 ug/L OR Number of /Pb90 Samples > .015 mg/L).

Total Organic Chemical (OC) UCM Above Detection Limit Sample Results written to the DTF.  This value is displayed in the SDWIS/STATE Migration to SDWIS/FED Sampling Results Summary Report with the "No. of Organic UCM Results > detection limit"  prompt


Description:
Total Inorganic Chemical (IOC) UCM Above Detection Limit Sample Results written to the DTF.  This value is displayed in the SDWIS/STATE Migration to SDWIS/FED Sampling Results Summary Report with the "No. of Inorganic UCM Results > detection limit"  prompt.


Description:
Total Organic Chemical (OC) UCM Insert Sample Results written to the DTF.  This value is displayed in the SDWIS/STATE Migration to SDWIS/FED Sampling Results Summary Report beside the "UCM Organic" row under the "Insert"  column.


Description:
Total Organic Chemical (OC) UCM Modify Sample Results written to the DTF.  This value is displayed in the SDWIS/STATE Migration to SDWIS/FED Sampling Results Summary Report beside the "UCM Organic" row under the "Modify"  column.


Description:
Total Organic Chemical (OC) UCM High Value Sample Results written to the DTF.  This value is displayed in the SDWIS/STATE Migration to SDWIS/FED Sampling Results Summary Report with the "No. of Organic UCM Results > 5 ug/L"  prompt.


Description:
Total Organic Chemical (OC) UCM Above Detection Limit Sample Results written to the DTF.  This value is displayed in the SDWIS/STATE Migration to SDWIS/FED Sampling Results Summary Report with the "No. of Organic UCM Results > detection limit"  prompt.


Description:
Total number of DTF Lines (records) in a given H1 DTF (either PB90, CU90, or UCM).


Description:
Indicates the sample is a replacement for a previously drawn routine, repeat, or other type of sample.  (For example, the sample may be of type RP (repeat) and also be a replacement.)


Description:
A coded value that represents the source or origin of the violation (e.g. the state, the region, or EPA).  S (State) is the defualt value for SDWIS/STATE.


Description:
The name of the Collector if a Collector is supplied who is not an Individual who is a legally designated Collector in the  Individual table.


Description:
A coded value that represents the source or origin of the enforcement action (e.g. the state, the region, or EPA).  
S (State) is the default value for SDWIS/STATE.


Description:
Format should be CCYY.  Reflects the Federal Fiscal Year to which the enforcement action should be attributed.  Along with Water System Number and Enforcement Action External System Number, Fiscal Year forms the uniqueness criteria for a SDWIS/STATE enforcement action.


Description:
Narrative information about the compliance schedule.


Description:
This external system number is system generated and is stored in anticipation of the possibility that schedules may be reported to FED.


Description:
The effective date of the compliance schedule.


Description:
Date the compliance schedule was closed.


Description:
The date that activity completion was reported by the PWS to the primacy agency.


Description:
Narrative information about the schedule activity.


Description:
The date that the activity was actually completed.


Description:
Person/party who is responsible for accomplishing the scheduled activity;  can be generic (e.g. PWS Owner) or specific (person's name).


Description:
Narrative information about the activity type.


Description:
Uniquely identifies the water system within a specific state.

Format:  SSXXXXXXXXXX  

Where:   SS = the FIPS Pub 5-2 State abbreviation in which the water system is located, or the region number of the EPA region responsible for an Indian reservation
         XXXXXXXXXX = the water system identification code assigned by the StatE


Description:
A system-generated coded value that categorizes whether a water system is considered to be in the "current" or "historical" inventory.

The categorization of "current" inventory is influenced by whether or not a state submitted a "Total Replacement" to its public water system inventory in the most recent reporting period.

If a state submitted a total replacement, then only those water systems which were reported in that most recent period are considered to be "current".  Those water systems that existed in the current inventory prior to the update, and for which a replacement was not submitted, would become part of the "historical" inventory.

If a state submitted "updates only" to its inventory in the most recent reporting period, those water systems that existed in the current inventory prior to the update, plus any new water systems which were reported in that most recent period, are considered to be "current".  The term "historical inventory" refers to those water systems that were in the current inventory at one time, but were assigned to the historical.  A water system that has been inactive for a substantial period of time may be assigned to the historical inventory, at the discretion of the Data Base Administrator.  Any update provided by the state for a water system in the historical inventory will cause the system to be transferred to the current inventory.


Description:
A system-generated value that categorizes the primary water source for the water system. Refer to the SDWIS/State User's Guide for details on the factors used for determination of primary source.


Description:
The common name, secondary name, and/or alias for the water system facility.


Description:
The activity reason for a water system facility.

Examples include new construction, activated, capped, abandoned, condemned, or physically disconnected.


Description:
The ending calendar month, day, and year for which the water system's season of operation is in effect.


Description:
The beginning calendar month, day, and year for which the water system's season of operation is in effect.


Description:
The average daily quantity of water that was produced by a water system in the most recent year.  The unit of measurement is gallons per day.

The quantity is calculated by adding together the total gallons of water produced in a year by each treatment or pumping facility, and dividing that sum by the total number of days that at least one treatment or pumping facility was in operation.


Description:
The total quantity of water that a water system was designed and approved to produce.

The unit of measurement is gallons per day.

The quantity is calculated by adding together the approved design capacity of each treatment plant.


Description:
The total quantity of water that can be produced by a water system using emergency power generation equipment under its control.

The unit of measurement is gallons per day. 

The quantity is calculated by adding together the production capacity of each treatment or pumping facility connected to emergency power.


Description:
The total quantity of water that can be stored by a water system.

The unit of measurement is gallons.

The quantity is calculated by adding together the capacity of each water storage facility.


Description:
Categorizes the type of legal entity contact for a water system facility.


Description:
The number used by the EPA Facility Index System (FINDS) to identify the facility.


Description:
A value that represents the number of gallons of water purchased.  The unit of measurement  is specified by WATER_QUANTITY_MEASURE_UNIT.


Description:
The name of a North-South line from which an exact measurement of longitude may be made in order to locate a specific township.  When coupled with the associated baseline, it identifies the starting point from which township, range, section, quarter-section, and quarter-quarter section may be used to pinpoint the location of a source or entity.

The meridian name is of particular importance when more than one principal meridian exists within the state.  If more than one principal meridian exists for the state, the meridian name should be specified.


Description:
A value that identifies the physical location of an area of land (i.e., a township) in relationship to a known base line.

In conjunction with the range number, this value identifies the township in which a source of water utilized by, or an entity related to, a water system is located.

Format:  TTTD 

Where:   TTT = a number which represents the physical location of a township in relation to a known base line
         D = the direction (N for North, or S for South) from a known base line.


Description:
The principal current use of the well, or if the well is not currently in use, then the original or principal purpose for its construction.  The purpose of this field is to assist data users in distinguishing between the various uses of wells.  Knowing the use of a well is particularly important when data users interpret ground water quality data.

Wells may have many different uses that will vary depending on several factors such as geographic location and the structure of the regional economy.  For example, agricultural states may have a need to include a number of specific well uses in their data base (e.g., irrigation wells, livestock wells, irrigation return flow wells, agricultural drainage wells) that a regional authority whose jurisdiction is dominated by heavy industry would probably not include in their data base.

Examples include irrigation well, disposal well, industrial supply well, Superfund monitoring well, public water supply well, community supply well, non-community supply well, recharge well, and piezometer well.


Description:
The total depth in feet of the well at completion (also called total depth).  The purpose of this field is to provide well construction data that is useful in interpreting water quality data.  The depth of the well at completion may indicate whether the well fully penetrates the aquifer. The measuring point used as a reference point to determine the depth of the well at completion is specified under the Altitude attribute.  If the measuring point is not level (e.g., the plastic well casing was cut unevenly), the measurement is usually taken from the lowest point on the measuring point.  Because there are different margins of error associated with the various devices used to measure the depth of a well, data base managers may consider requesting that data providers indicate the measurement devices used.  Note that this element is not referring necessarily to the depth of the original wellbore.  In addition, note that this element is not applicable to springs.


Description:
The diameter of the well shaft in inches. Also called "borehole diameter."


Description:
A coded value indicating the type of drilling method.  This may include horizontal gallery, open-end, sand point, walled, open hole, or other.


Description:
Describes the type of area being served by a water system.


Description:
An alphanumeric value that represents the physical location of an area of land (i.e., a township) in relationship to a known Principal Meridian. RANGE_NUMBER in conjunction with the attribute TOWNSHIP, which identifies the township in which a source of water utilized by, or an entity related to, a water system is located.  RANGE_NUMBER is of the form:  tttd; Where:   ttt = a number which represents the physical location of a township in relationship to a known Principal meridian;  d = the direction (E for East, or W for West) from a known Principal meridian.


Description:
A value which identifies which one of 36 sections of the township in which a source of water utilized by, or an entity related to, the water system is located.

The 36 sections are numbered in a zigzag fashion beginning with 01 in the northeast corner of a township, and ending with a 36 in the southeast corner of a township.


Description:
A value which identifies which of the four quadrants of the section in which a water system facility is located.  Must be one of the following codes: "NE"  -  Northeast Quarter; "NW"  -  Northwest Quarter; "SE"  -  Southeast Quarter; "SW"  -  Southwest Quarter.


Description:
A value which identifies which one of four quadrants of the quarter-section in which a water system facility is located.

Must be one of the following codes: "NE"  -  Northeast Quarter; "NW"  -  Northwest Quarter; "SE"  -  Southeast Quarter; "SW"  -  Southwest Quarter.


Description:
A coded value that represents whether a source of water utilized by a water system is "on" or "off" a defined river reach.  "On" implies that a surface source intake is located on a defined river reach.  "Off" implies that the source of water (or surface source intake) is not located on a defined river reach, but instead, is located within the area drained by the river reach.  If a surface source intake is "on" the river reach, the number of river reach miles defines an exact physical location of the intake.  Reach miles are measured from the downstream end of the river reach.


Description:
The exact physical location of a surface source intake in relationship to the downstream end of the river reach, given that the source is "on" a defined river reach.


Description:
The static water level depth of the well in feet.


Description:
The date that the static water level was determined.


Description:
The average yield of water in gallons per minute for the well.


Description:
A system-generated value that represents the calendar date and time on which this cadastral legal description was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
The month, day, and year that a water contract was established between a buyer and seller.  Note:  the actual delivery of water to a buyer may vary during the period from the active date to the inactive date.


Description:
A coded value which categorizes the reason for associating a legal entity with a water system.

Note:  only one administrative contact should be identified for each water system.


Description:
The name of a legal entity associated with a water system.


Description:
The first line of an address for a  legal entity.  This can be a street address, rural route, PO Box, etc.


Description:
The second line of an address applicable to  legal entity.  This field is the street address, rural route, etc.


Description:
The city in which a legal entity is located.


Description:
A coded value that represents the U.S. Postal Service (USPS) State abbreviation in which a legal entity is located.

Must be one of the USPS Postal State Codes.


Description:
The U.S. Postal Service (USPS) ZIP code in which a legal entity is located.  Format: ZZZZZEEEE; Where: ZZZZZ = the ZIP code; EEEE  = the optional ZIP+4 extension


Description:
The telephone number of a water system or the system's primary contact.  Format: (AAA)-EEE-NNNN; Where: AAA = the telephone area code; EEE = the telephone exchange; NNNN = the telephone number; Where multiple facilities exist for a water system at different physical locations, phone number identifies the telephone number which is applicable to the primary facility of, or the principal contact for, the system.


Description:
A system-generated value that represents the calendar date and time on which this legal entity was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
The reason the water system facility was deactivated.  Examples include capping, abandonment, condemned.  A reason must be provided when the facility is deactivated.


Description:
The calendar month on which a facility's season of operation commences.

Source:  SDCJRP, MINJAD


Description:
The calendar month on which a facility's season of operation ceases.


Description:
A system-generated value that represents the calendar date and time on which this facility annual operating period was initially posted to the data base or when a subsequent state-supplied inventory modification was made.


Description:
Describes locational directions to the water system facility.


Description:
Categorizes the type of connection between the water system facilities.


Description:
The amount of water that flows through this water system facility connection.

Source:  SDCJRP, IBS Team


Description:
The date of the connection of the water system facility to another water system facility.


Description:
The date of the disconnection of the water system facility from another water system facility.


Description:
The commonly-used name for the water system.


Description:
A coded value that represents the Federal Information Processing Standard (FIPS) county code.  A State may report either FIPS county codes, or county codes which are assigned by that State.  If the county codes reported by a State are not identified as FIPS codes, a one-for-one State county code to FIPS county code conversion list MUST be provided.  A county is considered to be the "first order subdivision" of each State regardless of its local designation (e.g, county, parish, borough, etc.).  All of the following are considered to be county equivalents:  the census areas and boroughs of Alaska;  the District of Columbia;  the parishes of Louisiana;  the independent cities of the States of Maryland, Missouri, Nevada, and Virginia;  that part of Yellowstone National Park located in Montana;  the municipios of the Commonwealth of Puerto Rico;  the islands of the U.S. Virgin Islands; the districts/islands of American Samoa;  the States of the Federated States of Micronesia;  the island of Guam;  the municipalities/islands/atolls of the Marshall Islands; the municipalities of the Northern Mariana Islands;  the States of the Republic of Palau;  the islands of the U.S. Minor Outlying Islands.  Must be one of the FIPS PUB 6-3,County Codes.


Description:
An individual's first name and may include the middle initial.


Description:
The salutation or greeting for an individual.


Description:
Characterizes the professional qualification of an individual.  Examples include CPA, PE, and PHD.


Description:
The professional job title of an individual.  Examples include General Manager, Engineer, and Accountant.


Description:
The business telephone number of an individual.

Format:  (AAA)-EEE-NNNN  

Where:   AAA = the telephone area code
         EEE = the telephone exchange
         NNNN = the telephone number


Description:
The emergency telephone number of an individual.

Format:  (AAA)-EEE-NNNN  

Where:   AAA = the telephone area code
         EEE = the telephone exchange
         NNNN = the telephone number


Description:
The mail stop or location for an individual.


Description:
A coded value that identifies the type of a government agency.


Description:
A coded value that denotes the type of population.


Description:
A value that indicates the estimated average daily population count for a given type of population served.


Description:
A coded value that indicates the type of service connection for a water system.


Description:
A coded value that characterizes the type of meter used in the service connection for a water system.


Description:
A value that indicates the commercial size of the meter in inches.


Description:
A value that indicates the number of service connections for a water system for a particular type of service connection.


Description:
A value which specifies the capacity of a water system facility.  The unit of measurement is specified by the approved design capacity measurement unit code.


Description:
A value which identifies which one of four quadrants of the quarter-quarter-section in which a water system facility is located.

Must be one of the following codes:
       "NE"  -  Northeast Quarter
       "NW"  -  Northwest Quarter
       "SE"  -  Southeast Quarter
       "SW"  -  Southwest Quarter


Description:
The depth in feet to the draw down water.


Description:
The type of pump that is used at the well.  Examples include vertical turbine, handpump, submersible, and jet pump.


Description:
The rated capacity of the pump in gallons per minute.


Description:
The identification number assigned to a well by a state or the responsible organization.  The purpose of this attribute is to (1) provide a means of uniquely identifying each well and (2) provide a means of linking all data associated with each well.  If there are multiple wells (casings) in a single borehole (frequently used for monitoring ground water at different depths), then each well (casing) should have its own identification number.  A variety of conventions exist for uniquely identifying wells. In fact, most states have developed their own well identification systems.  As such, data providers may report numbers using these existing systems or in any format that they feel is most appropriate for their circumstances.  The only requirements are that the identification number must be associated with a particular known well, be unique, and follow and incorporate EPA's FINDS number if the well is part of a facility regulated by EPA.


Description:
The date that the water system facility construction was completed.


Description:
The name of the principal City served by the water system. This area must be a City that is a documented Geographic Area.

This value will be automatically updated whenever any of the WATER SYSTEM GEOGRAPHIC AREA ASSIGNMENT PRINCIPAL INDICATOR CODEs for a water system are modified.


Description:
The name of the principal county served by the water system.

This value will be automatically updated whenever any of the WATER SYSTEM GEOGRAPHIC AREA ASSIGNMENT PRINCIPAL INDICATOR CODEs for a water system are modified.


Description:
The Federal Information Processing Standard (FIPS) Code that identifies the geographic area.  This code may also refer to the Indian Reservation Code, the FIPS County Code, City Served Code, Congressional District Code, Metropolitan Statistical Area (MSA) and possibly other types
of codes.


Description:
A coded value assigned by the state to the geographic area.


Description:
A coded value that categorizes the geographic area based upon geopolitical boundaries.


Description:
The purpose or reason for which a government agency regulates the water system.


Description:
A value that identifies a license number, certificate number, or other number used by a regulating program other than the drinking water program.  Source:  DMJRP


Description:
An account number used within selected state programs to uniquely identify the water system.


Description:
A coded value that categorizes the water purchased.


Description:
The ratio of surface water volume to the total water volume that the water system utilizes.


Description:
The ratio of surface water volume that is purchased from another water system to the total water volume utilized by the water system.


Description:
The ratio of ground water volume to the total water volume that the water system utilizes.


Description:
The ratio of ground water volume that is purchased from another water system to the total volume that the water system utilizes.


Description:
The ratio of the volume of ground water under the direct influence of surface water to the total water volume that the water system utilizes.


Description:
The ratio of the volume of ground water under the direct influence of surface water that is purchased from another water system to the volume that the water system utilizes.


Description:
The USPS State Code where the geographic area resides.  Necessary to identify the state where a city exists.


Description:
The role that has specific authorities associated to it.


Description:
The first date that the user has the authority granted by the role.


Description:
The last date that the user has the authority granted by the role.


Description:
The timestamp when the record is created.


Description:
The User ID of the person that granted the authority.


Description:
The User ID of the person who last modified the record.


Description:
Receive permitted values from the permitted value table.  CODE table name of "SMPSTCLASS."

The federally owned values (HQ rows) in TINPVALS table will be:
IOC - Inorganic Chemicals
WQP - Water Quality Parameters
VOC - Volatile Organic Chemicals
SOC - Synthetic Organic Chemicals
RAD - Radionuclides
DBP - Disinfection By-Products
MOR - Microbial
TC - Total Coliform
LC - Lead and Coppe


Description:
This field is used to describe the reporting relationship between a violation of this type and a contaminant.  (This field only applies to "HQ" rows and will not be placed on the maintenance page.


Description:
A system-generated value which, along with TMNSCHTM_ST_CODE, uniquely identifies the schedule template. (Will require a new row in the TINEISN table.)


Description:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

This attribute + the TMNSCHTM_IS_NUMBER form the composite identifier for this table.

The state code of the primacy agency


Description:
The initial timestamp when the record was created.


Description:
The User ID of the person that created the record.


Description:
The timestamp of the person that last updated the record.


Description:
The User ID of the person that last updated the record.


Description:
The internally generated system number used to identify the record.  Numbers sequentially within the relationship to Schedule Template.


Description:
Describes the role of the individual in Site Visit as either Primary or blank/spaces.


Description:
Security -- a coded value that describes in summary, the outcome of evaluating this category during the Site Visit.  The "Public Health Security and Bioterrorism Preparedness and Response Act of 2002" requires primacy agencies to review the security and preparedness of water system to respond to emergencies.


Description:
Financial -- a coded value that describes in summary, the outcome of evaluating this category during the Site Visit.  The Safe Drinking Water Act (SDWA) Amendments of 1996 requires primacy agencies to assist small water systems through Capacity Development.  This category represents the review of the financial capabilities of the water system.


Description:
This field will store the AOP criterion used for a dynamic water system group.


Description:
Place to store comments about the legal entity.


Description:
The operator certification class that the individual has achieved.


Description:
Generated sequentially as max number within LEGAL ENTITY Tinlgent_Is_Number and Tinlgent_St_Code.


Description:
Receives permitted values from the permitted values table code_name 'FONPURPOSE' (which is controlled by the System Administrator) for phone numbers or 'ELCPURPOSE' for electronic addresses.


Description:
The phone number including area code and hyphens.


Description:
The extension of the phone number beyond the standard telephone number.


Description:
An account used to send electronic correspondence


Description:
Indicates whether or not the Government Agency is also considered a Regulating Agency.


Description:
Indicates that user selected M&R Compliance Check option on the TCR Compliance Report window.


Description:
Indicates that user selected Non-acute MCL Compliance Check option on the TCR Compliance Report window.


Description:
This attribute stores the unique internal system number of the Water System Group that was selected when the TCR Compliance Report was executed.


Description:
This attribute  stores the State Code of the Water Systesm Group that was selected when the TCR Compliance Report was executed.


Description:
This attribute stores the water system group name that was selected when the TCR Compliance Report was executed.


Description:
This attribute stores the schedule type that was selected when the user launched the Schedule Activity Compliance Report.


Description:
This attribute corresponds to the unique internal system number of the Compliance Officer that was selected when the Schedule Activity Compliance Report was executed.


Description:
This attribute corresponds to the state code of the Compliance Officer that was selected when the Schedule Activity Compliance Report was executed.


Description:
This attribute stores the name of the Compliance Officer that was selected when the Schedule Activity Compliance Report was executed.


Description:
This attribute corresponds to the name of the Activity Type that was selected when the Schedule Activity Compliance Report was executed.


Description:
This attribute corresponds to the unique internal system number of the Activity Type that was selected when the Schedule Activity Compliance Report was executed.


Description:
This attribute corresponds to the state code of the Activity Type that was selected when the Schedule Activity Compliance Report was executed.


Description:
Indicates that user selected Check Compliance with Projected Date option on the Schedule Activity Compliance Report window.


Description:
The Primary Reason code selected when a user launched the Site Visit Compliance Report.


Description:
Indicates whether the user, when launching the Site Visit Compliance Report, wanted the compliance report to verify that all eight elements, which are considered part of a complete sanitary survey, were evaluated as part of a scheduled Site Visit.


Description:
Indicates whether the user, when launching the Site Visit Compliance Report, wanted the compliance report to verify that a water system's security was evaluated as part of a scheduled Site Visit.


Description:
Indicates whether the user, when launching the Site Visit Compliance Report, wanted the compliance report to verify that a water system owner's financial capabilities were evaluated as part of a scheduled Site Visit.


Description:
Indicates whether the user, when launching the Site Visit Compliance Report, wanted the compliance report to verify that elements other than those explicitly listed were evaluated as part of a scheduled Site Visit.


Description:
A field where CDS Compliance Report processes can record any additional information that may be useful when a user is determining what action to take relative to the candidate violation.


Description:
The violation period begin date defined by the state.


Description:
The violation period end date defined by the state.


Description:
Generated sequentially as max number within table TCDCSACT.


Description:
Valued with the state code retrieved from TINPRT.


Description:
This attribute will be populated with the IS number from TINWSYS.


Description:
This attribute will be populated with the state code from TINWSYS.


Description:
This attribute will be populated with Number from TINWSYS.


Description:
This attribute will be populated with Name from TINWSYS.


Description:
This attribute will be populated with D_Fed_Primary_Source_Code from TINWSYS.


Description:
This attribute will be populated with D_Pws_Federal_Type_Code from TINWSYS.


Description:
This attribute will be populated with D_Population_Count from TINWSYS.


Description:
This attribute will be populated with Activity_Status_Code from TINWSYS.


Description:
This attribute will be populated with Activity_Date from TINWSYS.


Description:
This attribute will be populated with the Tenshcd_IS_Number from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with the Tenschd_St_Code from COMPLIANCE SCHEDULE.


Description:
This attribute will be populated with the Sequence_Number from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with Type_Code_CV from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with the first 40 characters of PERMITTED_VALUE Description corresponding to the Type_Code_CV from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with Effective_Date from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with Status_Code from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with Status_Date from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with Closed_Date from COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with the Tenschat_IS_Number from SCHEDULE_ACTIVITY.


Description:
This attribute will be populated with the Tenschat_St_Code from SCHEDULE_ACTIVITY.


Description:
This attribute will be populated with Due_Date from SCHEDULE_ACTIVITY.


Description:
This attribute will be populated with Projected_Date from SCHEDULE_ACTIVITY.


Description:
This attribute will be populated with Achieved_Date from SCHEDULE_ACTIVITY.


Description:
This attribute will be populated with Reported_Date from SCHEDULE_ACTIVITY.


Description:
This attribute will be populated with Responsible_Party from SCHEDULE_ACTIVITY.


Description:
Generated sequentially as max number within table TCDVISIT.


Description:
This attribute in conjunction with the VISIT_TINVISIT_ST_CODE is a foreign key to the Site Visit entity.  This attribute will be used by the users to link to the site visit record corresponding to this candidate site visit if they need to look up any attribute of the site visit that is not de-normalized in this table.  This attribute will be populated with the TINVISIT_IS_NUMBER from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute in conjunction with the VISIT_TINVISIT_IS_NUMBER s a foreign key to the Site Visit entity.  This attribute will be used by the users to link to the site visit record corresponding to this candidate site visit if they need to look up any attribute of the site visit that is not de-normalized in this table.  This attribute will be populated with the TINVISIT_ST_CODE from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the EXTERNAL_SYS_NUM from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the STATUS from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the VISIT_DATE from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the REASON_CD from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the WATER_SYSTEM_NOTIFIED_DATE from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the FREQUENCY_NUMBER from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the FREQUENCY_PERIOD from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the NEXT_DUE_DATE from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_SOURCE from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_TREATMENT from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEM_DISTRIB_SYSTEM from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEM_FIN_WATER_STORAG from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_PUMPS from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_MR_AND_DV from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_WS_MGT_OPS from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEM_OPTR_COMP_EVAL from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_SECURITY from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_FINANCIAL from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the SAN_SURVEY_ELEMENT_OTHER from the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the Tinlgent_Is_Number of the Compliance Officer associated to the COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with the Tinlgent_St_Code of the Compliance Officer associated to the COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with the TINLGENT Name of the Compliance Officer administering the COMPLIANCE_SCHEDULE.


Description:
This attribute will be populated with the Tenactiv_Is_Number from Schedule Activity's ACTIVITY_TYPE.


Description:
This attribute will be populated with the Tenactiv_St_Code from Schedule Activity's ACTIVITY_TYPE.


Description:
This attribute will be populated with Name from Schedule Activity's ACTIVITY_TYPE.


Description:
This attribute in conjunction with the PWS_TINWSYS_ST_CODE is a foreign key to the Water system entity. This attribute will be used by the users to link to the water system record corresponding to this site visit if they need to look up any attribute of the water system that is not de-normalized in this table.  This attribute will be populated with the TINWSYS_IS_NUMBER column from the water system that is associated to the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute in conjunction with the PWS_TINWSYS_IS_NUMBER is a foreign key to the Water system entity. This attribute will be used by the users to link to the water system record corresponding to this site visit if they need to look up any attribute of the water system that is not de-normalized in this table.  This attribute will be populated with the TINWSYS_IS_NUMBER column from the water system that is associated to the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the NUMBER attribute from the water system that is associated to the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
This attribute will be populated with the NAME from the water system that is associated to the Site Visit that was either the basis for the compliance check or the Site Visit that partially but not fully satisfied the compliance check.


Description:
A timestamp when valued or updated will indicate that a Water System needs to be processed by CDS Setup.


Description:
User id whose update to the Water System requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a Water System Facility needs to be processed by CDS Setup.


Description:
User id whose update to the Water System Facility requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a Sampling Point needs to be processed by CDS Setup.


Description:
User id whose update to the Sampling Point requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a Sampling Plan Sampling Point Asgmt needs to be processed by CDS Setup.


Description:
User id whose update to the Sampling Plan Sampling Point Asgmt requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a Sample Schedule needs to be processed by CDS Setup.


Description:
User id whose update to the Sample Schedule requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a Monitoring Period needs to be processed by CDS Setup.


Description:
User id whose update to the Monitoring Period requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that an ALRA needs to be processed by CDS Setup.


Description:
User id whose update to the ALRA requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a FANL needs to be processed by CDS Setup.


Description:
User id whose update to the FANL requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a Sample needs to be processed by CDS Setup.


Description:
User id whose update to the Sample requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that a Sample Result needs to be processed by CDS Setup.


Description:
User id whose update to the Sample Result requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A system-generated value that indicates when the MCL Value is initially created in the database.


Description:
A timestamp when valued or updated will indicate that an MCL Value needs to be processed by CDS Setup.


Description:
User id whose indirect update to the MCL Value requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A timestamp when valued or updated will indicate that an Sample Summary needs to be processed by CDS Setup.


Description:
User id whose indirect update to the Sample Summary requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
A system-generated value that indicates when the Monitoring Period Average is initially created in the database.


Description:
A timestamp when valued or updated will indicate that a Monitoring Period Average needs to be processed by CDS Setup.


Description:
User id whose indirect update to the Monitoring Period Average requires processing by CDS Setup and is indicated by the valuing or updating of D_CDS_TRIGGER_TS.


Description:
This attribute is a copy of the compliance value.  It has been added to the compliance value table to be able to determine significant digits.


# Entity Type

Description:
Well Casings are the internal structure of a Well.


Description:
The recording of flow rates for a Water System Facility.


Description:
The recording of a measure for a Water System Facility.


Description:
The recording of an indicator for a Water System Facility.


Description:
Water System Facility is assessed for security one or more times.


Description:
This table logs the calculation or evaluation processes triggered by some inventory data changes in a water system. It will served as the trigger for Generate Derived Water System Values and Evaluate TCR Sample Schedule modules and will not be shown on any SDWIS/STATE windows/pages.


Description:
The date on which the sampling plan intends to collect samples at a specific SAMPLING_POINT.


Description:
Contains information used to edit violations of specific types and sometimes analyte for the existence of violation data elements.


Description:
Contains information used by the system to derive the violation period begin and end dates.


Description:
A look-up table used to control and sort the presentation of permitted values for a result. The selected unit of measure will be stored in the UOM_CODE attribute in SAMPLE_ANALYTICAL_RESULT (TSASAR).


Description:
Records an association between an analytical result and a sample schedule for a given monitoring period and records a value, derived from the result (and usually equal to the result), that will be used for compliance determination.


Description:
Records an association between an analytical result and a sampling point referenced by a sample schedule for a given monitoring period that will be used for compliance determination.


Description:
The recordings of measurement details about a collected sample.


Description:
A look-up table of sample measure types used to control selection and population of values in the OTHER SAMPLE MEASURE table Name field.


Description:
The recordings of measurement details about a sample analytical result.


Description:
A look-up table of SAMPLE ANALYSIS MEASURE TYPEs used to control selection and population of values in the OTHER SAMPLE ANALYSIS MEASURE table Name field.


Description:
The allowed units in which a particular sample measure be recorded.


Description:
The allowed units in which a particular sample analysis measure may be recorded.


Description:
An associative table to resolve a many-to-many relationship between treatment plant and analyte.  This relationship allows a user to indicate that an analyte is removed/inactivated by a treatment plant and is intended to record the removal and/or inactivation information relative to microbial contaminants.  It is populated from the Microbial Removal Maintenance page.


Description:
The recording of flow rates for a treatment unit.


Description:
The recording of a measure for a treatment unit.


Description:
The recording of an indicator for a treatment unit.


Description:
Describes the removal or addition of an analyte by an association between a treatment objective and treatment process for a treatment unit and an analyte.


Description:
The recording of flow rates for a Water System.


Description:
The recording of a measure for a Water System.


Description:
The recording of an indicator for a Water System.


Description:
The Log Detail documents the start and end date/time of the individual steps for each processing request.  Each Log Detail record is associated to a Log Header record.

Both the Log Header and Log Detail tables provide status information for each request processed by SDWIS/STATE ToGo.  Both tables are populated on the Central Database.


Description:
The Log Header documents the overall status of the processing request.  

Both the Log Header and Log Detail tables provide status information for each request processed by SDWIS/STATE ToGo.  Both tables are populated on the Central Database.


Description:
The synchronization table contains the metadata for each table in which modifications or insertions are detected.  It is populated on the Distributed Database.


Description:
This table will contain each unique message/advisory that CDS Setup delivers.


Description:
This table will include fields that replicate several fields in the Water System, Water System Facility, Sampling Point, Sample, Sample Analytical Results and others in order to record the key information about the data to which the advisory applies.


Description:
Used to record each time CDS Setup is launched.  The detailed information about when each process in CDS Setup starts and stops will continue to be recorded in the CDS Setup Processing log (a text file).  Only the time that CDS Setup began and ended processing will be stored in this new table along with a Log ID.


Description:
When M&R compliance needs to be done at the entry point (sampling point) level, these schedules enable scheduling of sampling requirements at a precise sampling point.


Description:
A specific monitoring period required by a specific sampling point subschedule to which a non-TCR sample analytical result  may be linked in order to show that the result was taken in direct compliance with a specific sampling point subschedule during a specific monitoring period.


Description:
When user creates a Schedule Group and wishes to specify that  M&R compliance needs to be done at the entry point (sampling point) level, these Sampling Point Schedule Group Subschedules capture and store  the precise sampling points and subcounts at which sampling should take place.  Information in these Sampling Point Schedule Group Subschedules is resolved into Sampling Point Subschedules for actual M&R compliance determination.


Description:
This entity enables the linkage of a violation to the precise sampling point(s) where  a failure to sample contributed to the M&R violation.  A given sampling point may be cited in many violations.


Description:
This entity links Individuals who particpate in one or more Site Visits--it allows multiple individuals to record participation in multiple site visits.


Description:
Entity that links a given Deficiency to one or  more Site Visits.  Needed because a deficiency that is cited during an initial Sanitary Survey may not be resolved and may be cited again at subsequent (follow-up) sanitary surveys.


Description:
A defect, flaw, inadequacy, or shortcoming that may hinder the capability of a drinking water system to consistently and reliably deliver an adequate quality and quantity of safe drinking water to the consumer.


Description:
Summary used to enter sampling requirements and collection information in support of the SWTR/IESWTR and DBP rules.


Description:
Contains information pertaining to the treatment processes.


Description:
Contains information pertaining to the treatment objectives.


Description:
Contains the valid combinations of treatment objectives to treatment processes.


Description:
This entity type is used to store denormalised information related to the Sampling Point Subschedule.  It stores the sampling point information that is used by both CDS Schedule and CDS Candidate Violation.


Description:
Deficiency Scheduled Activity Asgmt -- The specification that a particular scheduled activity (possibly one of many for a compliance schedule) is to address a particular Deficiency, (that is, a deficiency recorded for a Water System at a specific Water System Facility  during one or more Site Visits)


Description:
Characterizes a WATER_SYSTEM_FACILITY that is a treatment plant.  These are treatment plantl-specific attributes.


Description:
An entity that allows the primacy agency to specify and maintain M&R and level compliance values for an analyte at a water system facility.    For example, the primacy agency could set a maximum permissible level for lead in a source water sytem facility or could set a maximum and mimimum water quality control parameter under the lead and copper rule.  This entity also specifies the M&R and Level violation types that are appropriate when the water system facility is found not to be in compliance with the M&R or Level values specified for the analyte.


Description:
A specific monitoring period required by a specific sampling schedule to which a non-TCR sample analytical result or non-TCR sample summary may be linked in order to show that the result/summary was taken in direct compliance with a specific sampling schedule during a specific monitoring period.


Description:
Describes sampling schedule for each sampling point in the  water system when all the analytes in an Analyte Group share the same monitoring requirement.  When a Sample Schedule Group is created, an individual "hidden" sampling schedule is created for each analyte in the selected analyte group.


Description:
An analyte that belongs to the analyte group( for which the Schedule Group was created) and for which a hidden schedule was created, but  for which the user has specified should cease to be monitored according to the schedule of the other analytes in the analyte group.


Description:
The value that CDS Setup initially calculates and stores in Monitoring Period Average (table TMNMPAVG) for a given set of analytical results but that is now  rounded to the same significant digits as the MCL value stored for that anlayte in Analyte Level Rule Asgmt (table TMNALRA).  Field values in this table may be updated by users after the record has been created by CDS Setup.


Description:
Stores the unrounded  monitoring period average for routine sample  results and confirmation sample results linked to the routine results that are for a given monitoring period, collected in response to a given sampling schedule for a specific analyte and sampling point/water system facility.


Description:
Associative entity that allows a direct linkage between an unrounded  Monitoring Period Average Measure and its comparable rounded Calculated MCL Value.   When the Running Annual Average is calculated and stored in  Calculated MCL Value  (table TMNCMCLV), this value is linked to all Monitoring Period Average (table TMNMPAVG) Measure records that were used to calculate it through this associative entity.


Description:
Describes the relationship (i.e., connection) between the different treatment plant facilities of a water system.


Description:
Records details about a waiver and/or a waiver application.  the waivers in view are waivers from required monitoring under federal and state drinking water regulations.  Waivers are not considered by SDWIS/STATE during the compliance determination process.


Description:
Describes rules required to determine whether a water system is a public water system and if so, which category.


Description:
A mesh or grid-like device which covers an intake in a well casing that allows only water to pass through.


Description:
Records the association of a waiver to a specific water system to indicate that all the sampling points for that water system have been waived or proposed to be waived from the specified monitoring requirement.


Description:
Records the association of a waiver to a specific sampling point to indicate that the sampling point has been waived or has been proposed to be waived from the specified monitoring requirement.


Description:
CDS Setup Execution Log tracks the initiation and execution of each of the discrete CDS Setup processes. The records in this table will be used in checkpointing and restarting CDS Setup.  This table is not a business object and exists exclusively to support CDS Setup. The records in this table will be delivered with SDWIS/STATE Release 7.0, will not be maintainable with  SDWIS/STATE software,  and should not changed by users.


Description:
This table is used to temporarily store Candidate Violation information in order to print them in an access report for the users to review and take necessary action or to Migrate them into the SDWIS application Violation Table as potential violations. This entity type will have all the violation attributes and denormalised   information related to the Violation like information about the water system, facility,  sampling point, analyte etc.,.  This table has SARs associated for MCL violations. This Table has Schedules associated in case of M/R Violations. This table will have SSRs associated in case of Lead and Copper M & R violations.


Description:
This table is used to temporarily store exceedence information so that users may review and print this information in an MS Access report. This entity stores denormalised data related to the exceedence, such as information about its water system, water system facility,  sampling point, analyte and analyte level (TMNALRA - the value against which the result value is compared to determine the exceedence.) The exceedence  is related to the SAR or Summary Result that was determined to be an exceedence.


Description:
Allows the grouping of TOC and other types of schedules.  A schedule package must always contain at least one principal schedule as well as at least one supporting schedule.


Description:
This entity type is used to store denormalised information related to the Sample Analytical Result and Sample that either caused an Exceedence or that caused a violation or are in support of a monitoring assessment. This table is used to produce detailed access reports for users to review and take action on Exceedences, Violations and Monitoring Assessments.


Description:
This table is used to store De-normalized Schedule information associated to candidate violations and Candidate Monitoring assessments. When a Candidate M & R violation is created the Schedule which was not complied is de-normalized and stored in this table and if a monitoring assessment is determined a few records are created in this table to supoort the Monitoring increase or decrease decision.


Description:
This entity type is used to store denormalised information related to the Sample Summary Result and Sample Summary that  either caused an Exceedence or that caused a violation or are in support of a monitoring assessment. This table is used to produce detailed access reports for users to review and take action on Exceedences, Violations and Monitoring Assessments.


Description:
This table is used to store the parameters chosen by the users when the alert report or compliance check or assessment report were run. For every execution of any of the reports one record is created in this table. Any Candidate Exceedence, Violation, or Monitoring Assesment created by the report processes is associated to this Report Log record. Also any Report execution error records created during the report process are associated to this report log record.


Description:
This table is used to store the errors generated during the execution of either the alert report, or compliance checks, or the Monitoring assessment reports. These errors can be printed at any time using the CDS Report Log Maintenace List window.


Description:
Records the original values of significant fields if user changes one or more of them (e.g., Activity Status, Status Date, Activity Reason, Type Code, Identification Code, Description Text, Lead Copper Tier Level Text, Lead Copper Tier Type Text).  Prior to making the change, the software will create a record in Sampling Point History that reflects the values for each of these fields as they were prior to one or more of them being changed.


Description:
This entity type is used to store denormalised information related to the CDS MDBP Summary.


Description:
This entity type was added to the model in order to obtain the User ID  that is logged onto the system while executing under the OS/2 operating system or the ORACLE based server system. In addition to the User ID, current timestamp and schema name are also retrieved.  It is characterized by a VIEW materialization in the host system.  The VIEW DDL is as follows:

OS/2 VERSION:

  CREATE OR REPLACE VIEW TINOUSER
    (TINOUSER_CODE,
     DATABASE_TIMESTAMP,
     SCHEMA_NAME )
      AS SELECT USER, CURRENT TIMESTAMP, "XXR10"
  FROM TINPRT
  WHERE 
    TINPRT_GOVT_CODE = 'HQ' AND
    TINPRT_RULE_CODE = 'P';

ORACLE VERSION:

  CREATE OR REPLACE VIEW TINOUSER_TEST
    (TINOUSER_CODE,
     DATABASE_TIMESTAMP,
     SCHEMA_NAME )
      AS SELECT 
      USER, 
      TO_CHAR(SYSDATE,'YYYY-MM-DDHH24.MI.SS'),
	"XXR10"
  FROM TINPRT
  WHERE 
    TINPRT_GOVT_CODE = 'HQ' AND
    TINPRT_RULE_CODE = 'P';


Description:
This table is used to temporarily store Monitoring Assessments in order to print them in an MS Access report for review and action by users. This entity has denormalised information related to the Monitoring Assessment such as information about the water system, facility,  sampling point, analyte and assessment indicator.  It also stores inidvidual results, summary results, and schedules whose data is used to decide on increasing or decreasing the monitoring.


Description:
This entity type is used to store denormalised information related to the PN Activities.


Description:
This entity type is used to store denormalised information related to the Facility Analyte Levels that may have been referenced by CDS MDBP Summary.


Description:
Records the original values of significant  Water System Facility fields if user changes one or more of them (e.g., Activity Status; Activity Date; Activity Reason; Facility Name; State Asgn No.; Water Type; Availability; Seller Treatment; No Treatment).  Prior to making the change, the software will create a record in Water System Facility History that reflects the values for each of these fields as they were prior to one or more of them being changed.


Description:
Records the original values of the following Water System fields if user changes one or more of them (including related inventory changes that automatically recalculate fields).  Prior to making the change, the software will create a record in Water System  History that reflects the values for each of these fields as they were prior to one or more of them being changed.


Description:
Actions taken by a primacy agency to assist water systems in complying with drinking water regulations.


Description:
The association of one or more assistance actions to one or more water systems.   This enables a water system to have many assistance actions.


Description:
A standard response applies a pre-defined set of actions in response to a violation.  It automates the creation of the enforcement actions taken in standard situations.  Where appropriate, a standard response may also generate a public notification schedule.


Description:
Associates a given standard response with one or more action types.   Stores the number of days to be used to calculate the Enforcement Action Status Date and the Status to be applied to the Enforcement Action (e.g. Potential or Taken).


Description:
Public notification activities and their presribed due dates as required in the Public Notification Rule.


Description:
Associates a given standard response with one or more activity types.   Stores the number of days to be used to calculate the PN Required Due Date and the Proof of PN Due Date to be applied to the Public Notification Activity.


Description:
Characterizes a physical location on the surface of the earth using latitude/longitude and altitude coordinates.


Description:
This entity enables the linkage of a violation to the precise sample analytical results(s) whose exceedence(s) contributed to the violation.  A given analytical result may be cited in more than one violation.


Description:
A site visit is conducted by a representative of a regulatory agency for the purpose of compliance inspection, technical support, or complaint investigation.  The results of the site visit are documented and can result in violations.


Description:
Provisions for an EPA or primacy State 
official to grant a public water system a 
deviation from one or more requirements.  Deviations may be granted if, for some 
compelling reason, a public water system is unable or not required to comply with one or more mandated requirements (e.g., maximum contaminant level, treatment technique, or technology requirement).  Deviations must not result in unreasonable health risks to the consumers.  Deviations are granted for a prescribed period of time.  A public hearing or public notice may be required.  Examples:variances and exemptions (SDWA), waivers, and exceptions.  Example descriptors:  type, date issued, purpose, schedule, conditions, and duration.


Description:
Characterizes a schedule of specific actions that are related to a deviation.


Description:
Events related to the enforcement of various U.S. Environmental Protection Agency rules (e.g., for lead and copper) identified for the selected public water system.


Description:
Significant Non-Compliance (SNC) status is assigned to a public water system when certain types of violations have been incurred over a specific period of time.  The types of violations which result in the SNC designation are based upon the contaminant (e.g., coliform) or rule (e.g., Lead and Copper) in question.


Description:
Consumer Confidence Report Schedule - Tracks the completion of the Consumer Confidence Report (CCR) that EPA annually requires each community water system to submit.


Description:
Characterizes a WATER_SYSTEM_FACILITY that is a storage facility.


Description:
Stores the role for any given Schedule Package (e.g. whether it relates to a Sample Schedule (SS) or a Schedule Group (SG).  A schedule Package Role must have its type specified (either finished/principal or raw/supporting), must be for a specific Schedule Package, and must be associated either with a Sample Schedule or a Schedule Group.


Description:
A Violation Group links many violations at one time, based on the analyte group.  For each Violation Group, there is a linked violation for each analyte in the selected analyte group.  Violation Groups may appear as a single violation.


Description:
Establishes a relationship between violation type and analyte based on direction given by EPA to the primacy agencies.


Description:
Captures the fact that one PN violation may be associated with many Originating Violations; and that one Originating Violation may be associated to many PN violations.


Description:
Captures the fact that one Candidate PN violation may be associated with one or more Originating Violations (which already exist in Violation/TMNVIOL but are replaced in this table for ease of reporting); and that one Originating Violation may be associated to one or more Candidate PN violations.


Description:
This table functions as a 'number server'.  It is the source of the internal system number/identifier/primary key for those tables that SDWIS/STATE provides a maintenance capability.  It is also the source for the External System Numbers for those tables that have them, with the exception of entities (tables) SBS_Sample Analytical Result (TSASAR),  Sample Summary Result (TSASSR), Violation (TMNVIOL), Violation Group (TMNVGRP), Enforcement Action (TENENACT), Milestone Event (TFRMEVNT), and Site Visit (TINVISIT).


Description:
Documents the rationale for linking an enforcement with a violation.


Description:
The period, with begin and end date, during which by rule, a given number of samples must be taken.


Description:
Documents actions taken against a water system. May include requirements that must be met in order to rectify a failure to perform under the PWSS Program.  Enforcement actions are informal and formal.  They are typically issued by the primacy agency but may be issued by its representative or the EPA.  Examples:  administrative and civil/criminal legal actions, warning notices, citations,  temporary injunctions, 
restraining orders, and penalties.


Description:
Houses the list of available actions, some of which are federal enforcement actions.


Description:
Documents a breach of a requirement.  
Violations are detected by assessment of sample results or reviews (including on site visits).  Violations may lead to legal actions or compliance orders.  Violations are publicized, when required, by public notification.  Violations may be remedied 
by compliance/enforcement remedies, such as 
improved filtration techniques or changes in 
procedures.

Examples:  MCL violations, failure to replace 
lead service lines, monitoring and reporting 
violations, treatment technique violations, 
and procedural violations.

Example descriptors:  type, date, 
description, severity, and recommended 
corrective action(s) to include milestones.


Description:
Describes the association between a violation and an enforcement action.


Description:
Describes the association between a rule and a government agency.


Description:
Describes the association between a violation and a code of regulation.


Description:
This entity type is used to store some of the Codes needed for the application. The permitted values corresponding to each one of these codes are stored in the permitted value table associated to the code.  (Permitted values for the majority of fields continue to be maintained in the SDWIS/STATE data model/central encyclopedia.)


Description:
This entity type is used to store some of the permitted value records for some codes needed for the application.  Initially, this table primarily supports SDWIS/FED  locational data permitted values as well as some EBS-related permitted values.  The expectation is that in the future, this table will grow as states/regions wish to add their own permitted values for fields where this this is a designated capability.  The permitted value records in this entity each correspond to a code record in the Code entity. (Permitted values for the majority of fields continue to be maintained in the SDWIS/STATE data model/central encyclopedia.)


Description:
A codified set of state or federal regulations.

Example:  CFR, Penn Code


Description:
A grouping of possibly several enforcement actions and related violations taken over time against a water system.


Description:
Describes the association between a government agency and a program.


Description:
Water Quality Parameter assigned to a specific entry point or distribution system.  Relates to the Lead and Copper Rule.


Description:
Describes the parameters that must be met by a water system for the monitoring requirement to be imposed.


Description:
Establishes the possible types/periodicities of monitoring period that could be appropriate for a water system.


Description:
Associates a specific set of parameters (number, type, and frequency of samples)  that must be met by a water system (to comply with monitoring requirements) with a specific monitoring requirement.


Description:
The type location that a sample must be drawn from.  Example:  upstream, downstream, near 1st service connection.


Description:
Describes the adjustments to the monitoring requirement.


Description:
Documents information on a component of an environmental program.  Includes federal, state, and special programs.

Examples:  laboratory certification program, reclamation and recharge program, ground water permitting program, water treatment device certification program, interstate carrier program, bottled water program, wellhead protection program, primacy program, and grant and loan programs.


Description:
Describes the association between a program and a legal entity.


Description:
Describes the association between a program and a project.


Description:
A group of related activities, resources, and management mechanisms to accomplish specific objectives of one or more programs.

Examples:  NORS, NIRS, NPS (national pesticide survey), Well GPS, Radon survey, needs survey


Description:
Describes the association between a project and a legal entity.


Description:
Describes sampling schedule for each water system.


Description:
A planned calendar date established for collecting a sample.


Description:
Describes the monitoring plan for a particular water system.


Description:
The association of a Sampling Plan to a Sampling Point.


Description:
Water systems have annual operating periods that define when they are serving water to the public. Each sample schedule must have an annual operating period assigned to it. This establishes the appropriate schedule for a water system, based on it's current annual operating period(s)


Description:
A law enacted by a federal or state legislative body.   

Examples: Safe Drinking Water Act, Clean Water Act


Description:
The association of a Statute to a Statute.


Description:
Information about the status and changes to status of a violation.


Description:
Vulnerabilty assessments are conducted to identify water systems and facilities that meet certain criteria for reduced chemical monitoring. The assessment and approval for reduced monitoring is assigned to one (or more) analytes.


Description:
Any physical, chemical, biological, or radiological substance, parasitic/pathogenic organism, or matter in water that is of interest.  Analytes may result in a health risk to the consumer or may be aesthetically objectionable.  Maximum contaminant level goals and maximum contaminant levels (MCLs) are established for regulated analytes identified by Federal and State Primary Drinking Water Regulations.  Other analytes are identified in Federal and State Secondary Drinking Water Regulations.   Examples of regulated analytes include: inorganics (e.g., arsenic, barium, and cadmium); organics (e.g., endrin, lindane, methoxychlor, and trihalothanes); microbials (e.g., coliform bacteria), and radionuclides (e.g., gross alpha and gross beta).


Description:
Vulnerability assessments identify water systems (and facilities) that meet critiera for reduced chemical monitoring. The assessments focus on specific geographic areas surrounding water systems. This entity establishes the assigment of vulnerability assessments to geographic areas


Description:
States may reduce monitoring requirements for chemicals in water systems that meet certain criteria. The criteria determine which water systems (and facilities) are vulnerable to contamination, and should therefore not be approved for any reduced monitoring. State representatives conduct vulnerability assessments to identify systems that can be approved for reduced monitoring.


Description:
States organize water systems into groups for the purpose of streamlining and expediting work scheduling, data management, and other drinking water program activities. Groups can be created as "static" (a specific list of systems), or "dynamic" (based on some criteria). Groups are maintained by the creator (user), or the administrator.


Description:
Water systems may be organized into groups by the users.  This organization requires assignment of specific water systems into "static" or "dynamic" groups. This entity establishes the assignment.


Description:
Water Systems are assigned specific monitoring periods to meet monitoring requirements based on the rules. These monitoring periods can be monthly, quarterly, or any other span of time, as establsihed by the SDWIS Administrator.


Description:
States organize analytes into groups to expedite data entry, and to evaluate compliance with a rule. Groups may be created to coincide with the analytes that are reported from a lab as a result of one sampling event. The same groups can be used for many water systems' sampling.  Analyte Groups may also be linked to a Violation Group and used to determine violations that are to be created.


Description:
Represents the relationship between analyte group and analyte.


Description:
The association of Analyte Level to a Regulation.


Description:
The individual who collects sample(s) during a station visit.


Description:
Associates standard analytical methods with specific laboratories to support the maintenance of a laboratory certification program.  State agencies, as a requirement of primacy, must evaluate a laboratory's performance using specific standard analytical methods.


Description:
Associates a specific Laboratory to a specific Legal Entity.


Description:
A facility where samples are received, analyzed, and results are documented under strictly controlled conditions. Results are used for scientific research or compliance determination purposes. A laboratory used for drinking water analytical purposes is usually certified,licensed, or approved by a state or federal agency which is charged with ensuring data quality.  Laboratory may by a facility within the Water System that performs analysis, e.g., for water quality parameters.
         


Note: the occurrences are for total labs in the U.S.  Figure is based on approximately 10,000 private labs plus approximately twenty-five percent of US water systems having their own labs.


Description:
The quantitative expression of the density of bacteria, protozoa, or viruses in a water sample. The result is qualified by including sample type code, accuracy measure (95% confidence boundary), and volume tested measures.


Description:
The physical and temporal attributes associated with the unique sample collection event, including time, temperature, turbidity, pH, and volume conditions. These attributes describe the specific chemical and physical conditions at the time and place of sample collection, which will help qualify the analytical results.


Description:
Implements a federal or state statute.  Provides programmatic identity and characterizes a group of related requirements.  Examples:  Total coliform rule, Phase 2 rule.


Description:
Quantity of each different type of sample (e.g. total samples collected, or number of repeat samples) and the result (e.g. total positive samples, total negative samples) of SAMPLE_ANALYSIS_SUMMARY reported for a analyte.


Description:
Summary of sample summary details for one or more analyte as reported to the state for a given monitoring period submitted by the water system or the laboratory.  Ocurrences are estimates for one year, based on the number of Water Systems.


Description:
Water systems typically collect samples of water system facilities at a specific location within the facility. Samples are collected according to a sampling plan which specifies the sampling location and conditions.  Occurrence numbers are for all U.S.--and are based on an average and approximate 1:7 ratio between Water System Facilities and Sampling Points.


Description:
Physical description of a water specimen taken for the purpose of analyzing water quality.  Samples may be taken from either raw (untreated) or treated water sources.  Samples are typically taken at representative points within the distribution system or at entry points to the distribution system, but 
may be taken at the consumer's tap, or at the 
water source (Surface Water Treatment Rule 
íSWTRù). 

Some samples may be combined (in a 
laboratory) to form a composite sample.  
Samples may be rejected (e.g., due to 
improper handling or time lapse).  Examples: raw water sample and treated water sample.  Example descriptors:  volume, date and time collected, purpose, date reported, sample type (e.g., routine, special, repeat), preservative/preservation techniques, chain of custody.  Note: Occurrence info based on Avg No of Max Samples for one large state for one year.


Description:
Result of sample analysis by laboratory and field equipment.  Typically identifies analytes and the level of contamination.  A sample that exceeds the maximum contaminant level may result in an MCL violation, and a sample that exceeds the method detection limit may result in a detection.

The sample analytical result may be rejected 
and/or invalidated -- the reason for the 
rejection will be noted.

Example descriptors:  results (measurements), date analysis completed, date results reported.  Note: Ocurrence information based on average max number for one large state for one year.


Description:
Identifies the name and purpose of standards to follow in a scientific method or procedure, data flow procedure, data formats, or operational procedure.  Examples: analytical method, treatment technique, preservation technique, and sampling procedure.  Example descriptors:  title, effective date, purpose, method detection limit, and approving authority, BAT status, certification, etc.


Description:
Describes the association between standard method, analyte, and sample analysis summary.


Description:
Identifies the specific code/number for each standard that is followed in a scientific method or procedure, data flow procedure, data formats, or operational procedure for collecting samples and analyzing results.


Description:
Characterizes the affiliation of an individual to a specific government agency.   Shows, for example, that an individual works for a specific government agency and therefore has authority to maintain information about the water systems over which the specified government agency has jurisdiction.


Description:
Associates a specific type/periodicity of monitoring period with a specific water system.


Description:
Water systems are required to monitor for contaminants during certain monitoring periods (Jan96, Feb96, Mar96, or 1stQuarter96)  in accordance with specific rules (eg TCR). This entity assigns the rule, the water system and the monitoring period.


Description:
Associates a valid VIOLATION_TYPE to a valid RULE.


Description:
Characterizes valid pairings of service area names and classifications potentially served by water systems.


Description:
Describes a person, corporation, government agency, private commission, etc.


Description:
Characterizes a government agency, including the staff, organizational structure, and operating mission.  

Example:  Federal agencies, State agencies, State Legislature, Federal Court, local governments, and Indian tribes or other governments (e.g., foreign).


Description:
Information describing why a legal entity is important to a water system.


Description:
Describes the purchase of water between water systems.


Description:
Describes the association between a water system and a geographic area.


Description:
Describes the association between a service area and a water system.


Description:
Indicates annual operating period(s) (i.e., seasons) for a water system.


Description:
Information describing why a legal is important to a water system facility.


Description:
Characterizes a WATER_SYSTEM_FACILITY that is a well.  These are well-specific attributes.


Description:
Describes the legal location description of a water system facility. (Also known as Cadastral)  Note:  Generally does not exist east of the Mississippi River.


Description:
Characterizes the facilities for a water system.  A WATER_SYSTEM_FACILITY can be any location or facility related to the water system.  Examples include distribution systems, treatment plants, pumping facilities, water storage facilities, and the like.


Description:
The single number server for the External System Number field for SBS_Sample Analytical Result (TSASAR),  Sample Summary Result (TSASSR), Violation (TMNVIOL), Violation Group (TMNVGRP), Enforcement Action (TENENACT), Milestone Event (TFRMEVNT),  Site Visit (TINVISIT) and Deficiency (TINDEFCY) .  This allows each Water System in SDWIS/FED to have up to 99,999 samples, violations, enforcement actions, milestoness, or violation groups.  A single record serves both TSASAR and TSASSR because both tables are the source of sample result data that is maintained in only one SDWIS/FED table.


Description:
This entity captures information about each instance of the execution of the Migration to SDWIS/FED: Sampling program which creates either a UCM (unregulated contaminant monitoring) or PB90 (Lead 90th Percentile) DTF.  (Information from this entity/table is displayed in the Post SDWIS/FED Batch Selection List that may be viewed by selecting one of the menu items from the Migration to SDWIS/FED Main Menu.)


Description:
Primacy agencies put water systems on compliance schedules for a variety of reasons including recurrent/multiple violations, exceedances of action levels, and identification of significant sanitary deficiencies.   Compliance schedules consist of one or more activities that the water system owner must achieve usually on a prescribed timetable.


Description:
An activity that is part of a compliance schedule that the water system owner must accomplish usually on a timetable prescribed by the primacy agency in order to return to compliance or correct one or more deficiencies.


Description:
Defines the type of activities that are part of a compliance or  public notice schedule.  Examples include "Publish a notice in newspaper" or "Recommend optimal corrosion control treatment".


Description:
Specifies the annual operating period(s) (i.e., seasons) for a water system facility.


Description:
Describes the relationship or connection between the different water system facilities of a water system.


Description:
Defines the type of population served and the estimated population count served for a given annual operating period for a water system.


Description:
Characterizes the type of service connections for a water system.


Description:
Describes the association between a treatment objective and treatment process for a treatment unit.


Description:
Describes the relationship between a water system and a regulating agency.


Description:
A USER_ROLE assigns an individual user authority to functions within SDWIS/STATE for a specified period of time.


Description:
A schedule template is a group of monitoring requirements that can be selected when creating sample schedules by prompting through the membership monitoring requirements.


Description:
A membership of a monitoring requirement into a schedule template.


Description:
This entity will enable one or more geographic areas to be used as criterion for a Dynamic Water System Group.


Description:
Communication methods and information for a legal entity (e.g., voice, electronic, and/or fax).


Description:
Denormalized information for Schedule Activity used for compliance determination and reporting.


Description:
Records a copy of information about the Site Visit that either was the basis for a Site Visit compliance check or was identified as a Site Visit that partially fulfilled the requirements to perform a site visit.  The information will be denormalized.


# Foreign Key

TEXT:
A designed attribute which identifies the associated state and is used in conjuction with the IS_NUMBER to uniquely identify this entity/table.


TEXT:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


TEXT:
A designed attribute which identifies the associated state and is used in conjuction with the IS_NUMBER to uniquely identify this entity/table.  This column has no business relevance.


TEXT:
A system-generated value which, along with TMNMNCON_ST_CODE, uniquely identifies the monitoring condition.

Source:  TCR Team


TEXT:
A designed attribute which identifies the associated state.  Used with TMNMNCON_IS_NUMBER, it uniquely identifies the monitoring condition.

Source:  TCR Team


TEXT:
A system-generated value which uniquely identifies the vulnerability assessment.


TEXT:
Source table is TSASAMPL, represents a sample that links to one or more samples. For example,  a 'repeat' sample contains the IS_NUMBER value in this field of the original sample to which the repeat should be linked.


TEXT:
Source table is TSASAMPL, represents a sample that links to one or  more samples. For example, a 'repeat' sample contains the ST_CODE value in this field of the original sample to which the repeat should be linked.


TEXT:
Source table is TMNRULE.  This key would be used to join TMNMNR TO TMNRULE.  (Do not use TMNRULE_IS_NUMBER to join TMNMNR and TMNRULE.)


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNRULE_IS_NUMBER. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
A system-generated value which, along with TMNPROJ_ST_CODE, uniquely identifies the project.


TEXT:
The St_Code to which the data belongs and  which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


TEXT:
A system-generated coded value which identifies the state that maintains information about the service area type.


TEXT:
A value that represents the code of the service area name.


TEXT:
Source table is TINUNPRO. TINUNPRO is identified by TINWSF_ST_CODE. This represents the water system facility that identifies the supplying unit process and is used in the relationship UNIT_PROCESS_FLOW always is supplied by one UNIT_PROCESS.


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_ST_CODE. This is used in the relationship WATER_SYS_FACILITY_FLOW always is supplied by one WATER_SYSTEM_FACILITY. This represents the supplying water system facility.


TEXT:
A coded value which identifies the state in which the vulnerability assessment is valid.


TEXT:
Source table is TMNRWSMA, which is identified by TINWSYS.  This key would not be used to join TMNVIOL to TINWSYS.


TEXT:
Source table is TINWSF, which is identified by TINWSYS.  This key would not be used to join TSASMPSM to TINWSYS.  To join TSASMPSM and TINWSF, use TINWSF_IS_NUMBER in table TSASMPSM for the join


TEXT:
Source table is TINWSYS. TINWSYS is identified by TINWSYS_IS_NUMBER. This represents the seller water system. This is used in the relationship WATER_PURCHASE always is supplied by one WATER_SYSTEM.


TEXT:
Source table is TINWSF, which is identified by TINWSYS.  This key would not be used to join TSASMPSM to TINWSYS.


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNRULE_ST_CODE.. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
Source table is TMNRULE.  This key would used to join TMNVOIL and TMNRULE.  (Do not use TMNRULE_IS_NUMBER to join TMNVOIL and TMNRULE.)


TEXT:
Source table is TMNRULE.  This key would be used to join TMNMNR to TMNRULE.  (Do not use TMNRULE_ ST_CODE to join TMNMNR and TMNRULE.)


TEXT:
A system-generated value which, along with TMNSTAT_ST_CODE, uniquely identifies the statute.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNSTAT_IS_NUMBER, it uniquely identifies the statute.


TEXT:
A system-generated value which uniquely identifies the enforcement package.


TEXT:
A coded value which identifies the state in which the enforcement package is valid.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNPROJ_IS_NUMBER, it uniquely identifies the project.


TEXT:
A system-generated value which, along with TMNSAMSC_ST_CODE, uniquely identifies the sample schedule.

Source:  TCR Team


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_ST_CODE. This represents the seller water system facility. This is used in the relationship WATER_PURCHASE sometimes is supplied to one WATER_SYSTEM_FACILITY.


TEXT:
Source table is TININDIV.   TININDIV is identified by TINLGENT_IS_NUMBER.


TEXT:
A system-generated value which, along with TMNmnr_ST_CODE, uniquely identifies the monitoring requirement.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNMNR_IS_NUMBER, it uniquely identifies the monitoring requirement.


TEXT:
Source table is TMNVTYPE for a Level Violation Type.  Use when determining if the TMNFANL record has a Level - type violation type associated with it (that is, where Violation Type category is MCL, TT, etc.) .


TEXT:
A system-generated value which, along with TMNPROG_ST_CODE, uniquely identifies the program.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNPROG_IS_NUMBER, it uniquely identifies the program.


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNCOR_IS_NUMBER. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
A system-generated value which, along with TMNCOR_ST_CODE, uniquely identifies the code of regulation.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNCOR_IS_NUMBER, it uniquely identifies the code of regulation.


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNCOR_ST_CODE. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
A system-generated value which, along with TMNMPDESC_ST_CODE, uniquely identifies the deviation.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNMPDESC_IS_NUMBER, it uniquely identifies the deviation.


TEXT:
A computed value that represents the calendar date on which a sampling plan sampling point assignment was initially posted to the data base.


TEXT:
A system-generated value which, along with TMNSMPLN_ST_CODE, uniquely identifies the sampling plan.

Source:  TCR Team


TEXT:
A designed attribute which identifies the associated state.  Used with TMNSMPLN_IS_NUMBER, it uniquely identifies the sampling plan.

Source:  TCR Team


TEXT:
Sequential number assigned to the request.


TEXT:
This is the identifier for a SDWIS CODE. This code name should be determined at the time of data modelling for any attribute that would use the SDWIS CODES permitted values. It is suggested that a meaningful abbreviation of the Code be used as a Code Name.


TEXT:
Source table is TMNMPRD.  This key would be used to join TMNVIOL and TMNMPRD.  (Do not use TMNMPRD_IS_NUMBER to join TMNVIOL and TMNMPRD.)


TEXT:
Source table is TMNMPRD.  This key would be used to join TMNVIOL and TMNMPRD.  (Do not use TMNMPRD_ST_CODE to join TMNVIOL and TMNMPRD.)


TEXT:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

This attribute + the TCDSEX_IS_NUMBER form the composite identifier for this table.

These columns have no business relevance.


TEXT:
A system-generated value which uniquely identifies the entity occurrence.


TEXT:
Source table is TINWSF. To join  TSASMPPT and TINWSF,  use TINWSF0IS_NUMBER in table TSASMPPT for the join.


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_IS_NUMBER. This represents the seller water system facility. This is used in the relationship WATER_PURCHASE sometimes is supplied to one WATER_SYSTEM_FACILITY.


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_IS_NUMBER. This is used in the relationship WATER_SYS_FACILITY_FLOW always is supplied by one WATER_SYSTEM_FACILITY. This represents the supplying water system facility.


TEXT:
Source table is TINUNPRO. TINUNPRO is identified by TINWSF_IS_NUMBER. This represents the water system facility that identifies the supplying unit process and is used in the relationship UNIT_PROCESS_FLOW always is supplied by one UNIT_PROCESS.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNDEVIA_IS_NUMBER, it uniquely identifies the deviation.


TEXT:
A system-generated value which uniquely identifies the sampling point subschedule.


TEXT:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

Source:  IBS Team


TEXT:
Source table is TINUNPRO. TINUNPRO is identified by TINUNPRO_IS_NUMBER. This represents the supplying unit process and is used in the relationship UNIT_PROCESS_FLOW always is supplied by one UNIT_PROCESS.


TEXT:
Source table is TINGEOAR, represents a geographic area that links to one or more geographic areas. For example, this field might contain the IS_NUMBER value of a geographic area of type 'CN' (county) to which a geographic area of type 'CT' (city) is linked.  The user may wish to designate that the city (TINGEOAR_IS_NUMBER) has a principle county (TINGEOAR0IS_NUMBER).


TEXT:
Source table is TINGEOAR, represents a geographic area that links to one or more geographic areas. For example, this field might contain the ST_CODE value of a geographic area of type 'CN' (county) to which a geographic area of type 'CT' (city) is linked.  The user may wish to designate that the city (TINGEOAR_ ST_CODE) has a principle county (TINGEOAR0ST_CODE).


TEXT:
A coded value that categorizes the treatment objective.


TEXT:
A coded value that categorizes the treatment process.


TEXT:
Source table is TINTRPRO. TINTRPRO is identified by TINTRPRO_CODE. This is used in the relationship that DEVIATION sometimes substitutes one D_TREATMENT_PROCESS.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNSAMSC_IS_NUMBER, it uniquely identifies the deviation.


TEXT:
A coded value which provides a broad categorization of the service area.


TEXT:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

In this case the identifier is a composite of this attribute and the TCDSEX_ST_CODE


TEXT:
A system-generated value which, along with TMNSCHTM_ST_CODE, uniquely identifies the schedule template. (Will require a new row in the TINEISN table.)


TEXT:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.

This attribute + the TMNSCHTM_IS_NUMBER form the composite identifier for this table.

The state code of the primacy agency.


TEXT:
The system-generated internal system identifier.


TEXT:
The state code of the data owner. For federal ownership value will be 'HQ'.


TEXT:
The system generated internal system number used to identify the data row.


TEXT:
The state code used to identify ownership of the data. For federally owned data the value will be 'HQ'.


TEXT:
The system-generated identifier for the record.


TEXT:
The state code of the installed SDWIS STATE application site.


TEXT:
Generated sequentially as max number within table TCDVISIT.


TEXT:
Valued with the state code retrieved from TINPRT.


# Foreign Key Exceptions

TEXT:
Source table is TSASAMPL, represents a sample that links to one or more samples. For example,  a 'repeat' sample contains the IS_NUMBER value in this field of the original sample to which the repeat should be linked.


TEXT:
Source table is TSASAMPL, represents a sample that links to one or  more samples. For example, a 'repeat' sample contains the ST_CODE value in this field of the original sample to which the repeat should be linked.


TEXT:
A system-generated value which, in conjunction with at least one other attribute or relationship, uniquely identifies the entity occurrence.


TEXT:
Source table is TMNRULE.  This key would be used to join TMNMNR TO TMNRULE.  (Do not use TMNRULE_IS_NUMBER to join TMNMNR and TMNRULE.)


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNRULE_IS_NUMBER. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNRULE_ST_CODE.. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
Source table is TMNRULE.  This key would used to join TMNVOIL and TMNRULE.  (Do not use TMNRULE_IS_NUMBER to join TMNVOIL and TMNRULE.)


TEXT:
Source table is TMNRULE.  This key would be used to join TMNMNR to TMNRULE.  (Do not use TMNRULE_ ST_CODE to join TMNMNR and TMNRULE.)


TEXT:
A system-generated value which, along with TMNSTAT_ST_CODE, uniquely identifies the statute.


TEXT:
A designed attribute which identifies the associated state.  Used with TMNSTAT_IS_NUMBER, it uniquely identifies the statute.


TEXT:
Source table is TMNRWSMA, which is identified by TINWSYS.  This key would not be used to join TMNVIOL to TINWSYS.


TEXT:
Source table is TINWSF, which is identified by TINWSYS.  This key would not be used to join TSASMPSM to TINWSYS.  To join TSASMPSM and TINWSF, use TINWSF_IS_NUMBER in table TSASMPSM for the join


TEXT:
Source table is TINWSYS. TINWSYS is identified by TINWSYS_IS_NUMBER. This represents the seller water system. This is used in the relationship WATER_PURCHASE always is supplied by one WATER_SYSTEM.


TEXT:
Source table is TINWSF, which is identified by TINWSYS.  This key would not be used to join TSASMPSM to TINWSYS.


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_ST_CODE. This represents the seller water system facility. This is used in the relationship WATER_PURCHASE sometimes is supplied to one WATER_SYSTEM_FACILITY.


TEXT:
Source table is TINUNPRO. TINUNPRO is identified by TINWSF_ST_CODE. This represents the water system facility that identifies the supplying unit process and is used in the relationship UNIT_PROCESS_FLOW always is supplied by one UNIT_PROCESS.


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_ST_CODE. This is used in the relationship WATER_SYS_FACILITY_FLOW always is supplied by one WATER_SYSTEM_FACILITY. This represents the supplying water system facility.


TEXT:
Source table is TININDIV.   TININDIV is identified by TINLGENT_IS_NUMBER.


TEXT:
Source table is TMNVTYPE for a Level Violation Type.  Use when determining if the TMNFANL record has a Level - type violation type associated with it (that is, where Violation Type category is MCL, TT, etc.) .


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNCOR_IS_NUMBER. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
Source table is TMNCOR. TMNCOR is identified by TMNCOR_ST_CODE. This is used in the relationship CODE_OF_REGULATION sometimes is contained in one CODE_OF_REGULATION. Represents a CODE OF REGULATION that links to one or more CODE OF REGULATIONS. This relationship has not been implemented in SDWIS/STATE and therefore, this field is empty.


TEXT:
Source table is TMNMPRD.  This key would be used to join TMNVIOL and TMNMPRD.  (Do not use TMNMPRD_IS_NUMBER to join TMNVIOL and TMNMPRD.)


TEXT:
Source table is TMNMPRD.  This key would be used to join TMNVIOL and TMNMPRD.  (Do not use TMNMPRD_ST_CODE to join TMNVIOL and TMNMPRD.)


TEXT:
Source table is TINWSF. To join  TSASMPPT and TINWSF,  use TINWSF0IS_NUMBER in table TSASMPPT for the join.


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_IS_NUMBER. This represents the seller water system facility. This is used in the relationship WATER_PURCHASE sometimes is supplied to one WATER_SYSTEM_FACILITY.


TEXT:
Source table is TINWSF. TINWSF is identified by TINWSF_IS_NUMBER. This is used in the relationship WATER_SYS_FACILITY_FLOW always is supplied by one WATER_SYSTEM_FACILITY. This represents the supplying water system facility.


TEXT:
Source table is TINUNPRO. TINUNPRO is identified by TINWSF_IS_NUMBER. This represents the water system facility that identifies the supplying unit process and is used in the relationship UNIT_PROCESS_FLOW always is supplied by one UNIT_PROCESS.


TEXT:
Source table is TINUNPRO. TINUNPRO is identified by TINUNPRO_IS_NUMBER. This represents the supplying unit process and is used in the relationship UNIT_PROCESS_FLOW always is supplied by one UNIT_PROCESS.


TEXT:
Source table is TINGEOAR, represents a geographic area that links to one or more geographic areas. For example, this field might contain the IS_NUMBER value of a geographic area of type 'CN' (county) to which a geographic area of type 'CT' (city) is linked.  The user may wish to designate that the city (TINGEOAR_IS_NUMBER) has a principle county (TINGEOAR0IS_NUMBER).


TEXT:
Source table is TINGEOAR, represents a geographic area that links to one or more geographic areas. For example, this field might contain the ST_CODE value of a geographic area of type 'CN' (county) to which a geographic area of type 'CT' (city) is linked.  The user may wish to designate that the city (TINGEOAR_ ST_CODE) has a principle county (TINGEOAR0ST_CODE).


TEXT:
Source table is TINTRPRO. TINTRPRO is identified by TINTRPRO_CODE. This is used in the relationship that DEVIATION sometimes substitutes one D_TREATMENT_PROCESS.


# Permit Value

Code Description:
Yes, indicating the Water System has only the minimum data valued in TINWSYS.


Code Description:
No, indicating the Water System has more than the minimum data valued in TINWSYS.


Code Description:
Reliably and Consistently Below the MCL - a level that supercedes a Trigger level - recorded as an Analyte Level, for a site and analyte that have been determined to be reliably and consistently below the MCL.


Code Description:
Screening level - a level above which an analyte used as a screen triggers either a different frequency of monitoring for that analyte or monitoring for a different analyte.


Code Description:
Decrease to every 3 years - Sample schedule was evaluated and was determined to be a candidate to be decreased to a once every 3 years monitoring frequency.


Code Description:
Decrease to every 6 years - Sample schedule was evaluated and was determined to be a candidate to be decreased to a once every 6 years monitoring frequency.


Code Description:
Decrease to every 9 years - Sample schedule was evaluated and was determined to be a candidate to be decreased to a once every 9 years monitoring frequency.


Code Description:
Always - A substitute result can always be used to satisfy the schedule even if a matching result also is used.


Code Description:
Optionally - A substitute result can optionally be used to satisfy the schedule, i.e., when a matching result is not available.


Code Description:
Never - A substitute result can never be used to satisfy the schedule even if no matching result exists.


Code Description:
Non-Community Transient and Non-Community Non-transient water systems


Code Description:
Community and Non-Community Non-transient water systems


Code Description:
Community and Non-community transient water systems


Code Description:
Community, Non-community transient and Non-Community Non-transient water systems


Code Description:
Generate Derived Principal City Served Name


Code Description:
Generate Derived Principal County Served Name


Code Description:
Generate Derived Total Storage Capacity Measure


Code Description:
First and last dates of monitoring period.


Code Description:
First and last dates of the calendar quarter for the monitoring period.


Code Description:
First and last dates of the calendar month for the monitoring period.


Code Description:
Next Monitoring period begin and end dates.


Code Description:
Number of samples taken above the action level.


Code Description:
The first customer after the entry point into the distribution system.  While, this site is specifically needed for chlorite and chlorine dioxide distribution system samples, it may have other uses.


Code Description:
No - M&R compliance not met resulting in a Major violation


Code Description:
No - M&R compliance not met resulting in a Minor violation


Code Description:
Yes - Each filter was monitored continuously


Code Description:
No - Each filter was not monitored continuously


Code Description:
No - Each filter was not recorded every 15 minutes


Code Description:
Yes - Each filter was recorded every 15 minutes


Code Description:
Yes - there was a failure of the continuously monitoring equipment.


Code Description:
No - there was no failure of the continuously monitoring equipment.


Code Description:
No -  IFT level was not greater than 1.0 NTU in two consecutive measurements.


Code Description:
Yes -  IFT level was greater than 1.0 NTU in two consecutive measurements.


Code Description:
Yes -  IFT level was greater than 0.5 NTU in two consecutive measurements after on line for more than four hours.


Code Description:
No -  IFT level was not greater than 0.5 NTU in two consecutive measurements after on line for more than four hours.


Code Description:
No -  IFT level was not greater than   1.0 NTU in two consecutive measurements in three consecutive months.


Code Description:
Yes -  IFT level was greater than  1.0 NTU in two consecutive measurements in three consecutive months.


Code Description:
Yes -  IFT level was greater than 2.0 NTU in two consecutive measurements in two consecutive months.


Code Description:
No -  IFT level was not greater than 2.0 NTU in two consecutive measurements in two consecutive months.


Code Description:
Ground water under direct influence of surface water


Code Description:
Maximum Residual Disinfectant Level Goal


Code Description:
Schedule has been assessed and is a candidate for Increased/Decreased monitoring, but the user has elected for it not to show on future reports.  If any circumstances change that trigger reassessment, (i.e.
 modified results, sample schedules, or monitoring periods) the schedule will be reassessed the next time that CDS Setup is run.


Code Description:
Schedule has been assessed and user has elected for it not to show on future reports.  If the user has marked the Schedule's Monitoring Assessment Flag with X, the schedule  will not be reassessed when CDS Setup executes.


Code Description:
Serving fewer than 50,000; met action level


Code Description:
Serving greater than 50,000; met action level


Code Description:
Total absorbance for ultraviolet light (a disinfectant)


Code Description:
Milligrams per liter; AKA Parts Per Million (ppm).  Also a measure of disinfectant concentration.


Code Description:
Micrograms per liter; AKA Parts per Billion (ppb)


Code Description:
Nanograms per liter; AKA Parts per trillion (ppt)


Code Description:
Flavor Threshold Units (FTU) (for measuring Taste and Odor)


Code Description:
Nanometers -- to measure color wave length


Code Description:
Percent of luminance--(for measuring color)


Code Description:
Percent of purity--(for measuring color)


Code Description:
American Dye Manufacturers Institute units -- (for measuring color)


Code Description:
Langelier Index (for measuring Corrosivity)


Code Description:
Pounds per gallon (for measuring density)


Code Description:
Pounds per cubic foot (for measuring density)


Code Description:
Millions of fibers per liter (MFL) (for measuring asbestos)


Code Description:
Measurement unit for measuring Conductivity


Code Description:
Specification of which year within the State Assigned Collection Period to collect "for compliance" samples (year is specificed as 0, 1, 2, 3, etc. to 9.


Code Description:
Micrograms per liter; AKA parts per billion (ppb).


Code Description:
Milligrams per liter; AKA Parts per million (ppm).  Also a measure of disinfectant concentration.


Code Description:
Nanograms per liter; AKA parts per trillion (ppt)


Code Description:
Flavor Threshold Units (for measuring Taste and Odor)


Code Description:
Nanometers (to measure color wave length)


Code Description:
American Dye Manufacturers Institute units -- (fro measuring color)


Code Description:
Millions of fibers per liter (for measuring asbestos)


Code Description:
Means for representing the magnitude (for pH or Color)


Code Description:
Organisms observed in a 1 mL aliquot (used for measuring heterotrophic bacteria (hpc or viruses))


Code Description:
Residential (For example, residential area, mobile home park, municipality)


Code Description:
Transient (For example, recreation area, highway rest area, hotel/motel)


Code Description:
Non-Transient (For example, industrial/agricultural, medical facility, school)


Code Description:
Other (For example, interstate carrier, water bottler)


Code Description:
Single Sample Exceeds a Maximum Level - (for example,  combined filter effluent turbidity level).


Code Description:
95% of all samples during Monitoring Period should be within a desired level- for instance combined filter effluent turbidity level


Code Description:
Monitoring  assessment not yet determined - Sample schedule has never been assessed by the Sample Schedule Monitoring Assessment Process.  This will be the value for newly created Sample Schedules and all Sample Schedules prior to the first time CDS Setup is run.


Code Description:
Increased - Sample Schedule was evaluated and was determined to be a candidate for increased monitoring.


Code Description:
Decreased - Sample Schedule was evaluated and was determined to be a candidate for decreased monitoring with an unspecified frequency.


Code Description:
Same - Sample Schedule has been evaluated and does not qualify as a candidate for either increased or decreased monitoring


Code Description:
Inactive sampling point.  Refers to a samplig point that has discontinued operation or has closed temporarily, but for a substantial period of time.  This decision depends upon State specific policy regarding such systems.


Code Description:
Active refers to a sampling point where sampling is occurring on a regular basis.


Code Description:
User explicitly selected/changed the associated monitoring period.  CDS Setup should not change it.


Code Description:
User explicitly selected/changed the associated monitoring period; however, the SSMPA record was then deleted (due to a schedule or monitoring period being deleted).  Prior to deleting the associated SSMPA from a sample result where this field is set to Y, CDS Setup will change value to N.


Code Description:
Direct - a direct physical connection between two water system facilities.


Code Description:
Indirect - an indirect connection between two water system facilities (eg. water is trucked from one water system facility to another).


Code Description:
Monitoring and Requirements (M&R)/Data Verification


Code Description:
Operator Compliance with State Requirements


Code Description:
Standard Response used with Violations and Enforcement Actions


Code Description:
Standard Response used with Site Visits and Deficiencies


Code Description:
Lowest Disinfectant Residual - the location where the disinfectant residual is the lowest. This type of sampling point comes directly out of the Revisions to the UCMR (September 17, 1999) where the preamble explains: "Some public commenters suggested that sampling for microbiological contaminants not occur at the maximum residence time in the distribution system, but at the point of lowest disinfectant residual, since the monitoring of concern is for effectiveness of treatment and booster disinfection stations that  may be in use in long distribution lines. In response, EPA added another sampling point at the ¿¿lowest disinfectant residual¿¿ in the distribution system for trihalomethane (THM) (Disinfectant By-Product (DPB) Rule) and/or Total Coliform Sampling.


Code Description:
Midpoint in the Distribution System - the Unregulated Contaminant Monitoring Rule location at which the chlorine residual would be expected to be typical for the system. This could also be used to designate those sampling points that are considered "representative points in the distribution system" under the Disinfection By-Products Rules.


Code Description:
Source Water Point - defined in the Unregulated Contaminant Monitoring Rule as the location at which untreated water is collected at the source.


Code Description:
Duplicate - Sample collected for QA or enforcement purpose (i.e. two bottles are collected from a given flow, one is a "duplicate")


Code Description:
Continuous - A reading from an on-site analyzer collected for water quality parameter measurements typically with SWTR compliance/turbidity.


Code Description:
Split - A sample collected for QA or enforcement purposes (i.e. two bottles are decanted from a single bottle each called a "split".)


Code Description:
Grab - A single sample collected for water Quality parameter measurement (i.e. a four hour turbidity sample/SWTR.


Code Description:
Source -The location at which untreated water is collected at the source


Code Description:
Midpoint in the distribution system - The location at which the chlorine residual would be expected to be typical for the system, such as the location for Total Coliform sampling as described in 40 CFR 141.21, Chapter 1 (7-1-99 edition).


Code Description:
Lowest disinfectant residual - The location where the disinfectant residual is the lowest as approved by the State for THM (DPB) and/or Total Coliform Sampling


Code Description:
Entry Point - The location at which raw (untreated) or finished (treated) water enters the distribution system of a PWS


Code Description:
Point of Maximum Retention - the UCMR location furthest from the entry point to the distribution system as approved by the State for THM (DPB) and/or Total Coliform Sampling.


Code Description:
Raw Water Source - Associated with high turbidity due to runoff events.  Raw water monitoring is triggered (in the rules) by such events or by coliform presence.  RW sampling points are normally associated with intake or well water system facilities.


Code Description:
Process Control - This sampling point type is used to demonstrate compliance with CT or other disinfectant or treatment requirements.  These points would normally be associated with treatment plants or storate water system facilities.


Code Description:
Single family structures served by a lead service line.


Code Description:
Single family structures that contain copper pipes with lead solder installed after 1982.


Code Description:
Single family structures containing lead pipes.


Code Description:
Single family structures that contain copper pipes with lead solder installed before 1983.


Code Description:
Multiple family structures that contain copper pipes with lead solder installed after 1982.


Code Description:
Multiple family structures served by a lead service line.


Code Description:
Multiple family structures containing lead pipes.


Code Description:
Lack of redundant disinfection equipment


Code Description:
Sample Schedule cannot be assessed because no RCB, TRL, MCL and/or ACL is defined for the analyte referenced by the Sample Schedule (through Monitoring Requirement).


Code Description:
Public notification of potential health effects due to failure to 
monitor.  Notice must be delivered within 30 days.


Code Description:
Public notification of most serious health effects from acute 
contamination of microbials and nitrate.  Notice must be delivered within twenty-four hours via electronic media or by hand.


Code Description:
Public notification of chronic health effects from MCL exceedance.  Notice must be delivered within 30 days.


Code Description:
The Compliance Period Begin and End Date should be reported to the SDWIS/FED for any violation using this violation type.


Code Description:
The Violation Period Beign Date should be preported to SDWIS/FED for any violation using this Violation Type.


Code Description:
Wholesale (For example, seller of water)


Code Description:
Y - Compliance Officer has indicated that  Streamness must be considered when the TCR schedule is evalutated by TCR NCD -- (i.e. if repeat samples do not indicate streamness of upstream, downstream, and original site, TCR NCD will determine a candidate minor M&R violation.)


Code Description:
N - Compliance Officer has explicitly indicated that streamness should not be considered when the TCR schedule is evalutated by TCR NCD.


Code Description:
Yes - A filter backwash schematic is required.


Code Description:
No -  A filter backwash schematic is not required.


Code Description:
The user has explicitly set this flag to Y (yes) to indicate  the packaged violaton should be reported to FED.


Code Description:
The user has explicitly set this flag to N (no) to indicate  the packaged violaton should not be reported to FED.


Code Description:
Inactive refers to a water system that is not an Active water system.  Such systems have discontinued operation.  A water system that has closed permanently is an obvious example of a system that would be an Inactive system.

A water system that has closed temporarily, but for a substantial period of time, could be designated as Inactive by the State, but not necessarily so.  This decision depends upon State specific policy regarding such systems.


Code Description:
Active refers to a water system that is producing water on a regular basis (obtaining, treating, pumping, storing, or distributing).


Code Description:
Proposed refers to a water system that is considered a potential future water system to be regulated.


Code Description:
Merged refers to a water system that has been merged with another water system.


Code Description:
Yes -- Migration to SDWIS/FED should create a transaction that reports the number of missing samples with the violation (as part of the D1 record).


Code Description:
No -- Migration to SDWIS/FED should not create a transaction that reports the number of missing samples with the violation (as part of the D1 record).


Code Description:
Field does not apply to state-owned violation types so should not be valued.


Code Description:
No -- Migration to SDWIS/FED should not create a transaction that reports the number of exceedences with the violation (as part of the D1 record).


Code Description:
Yes -- Migration to SDWIS/FED should create a transaction that reports the number of exceedences with the violation (as part of the D1 record).


Code Description:
Hearing scheduled on compliance schedule


Code Description:
Not subject to surface water treatment rule


Code Description:
Copper 90th percentile action level exceedence


Code Description:
Maximum permissible levels in source water


Code Description:
Optimal Corrosion Control Treatment designated and approved


Code Description:
Optimal Corrosion Control Treatment installed


Code Description:
Lead 90th percentile action level exceedence


Code Description:
Source Water Treatment designated and approved


Code Description:
Chlorite/Chlorine Dioxide Exceedence Check by CDS Setup


Code Description:
Surface Water Treatment Compliance Report


Code Description:
Finished Schedule (within a TOC Schedule Package).


Code Description:
Raw supporting Schedule (within a TOC Schedule Package).


Code Description:
Principal Schedule (within a Schedule Package).


Code Description:
Supporting Schedule (within a Schedule Package)


Code Description:
Related to an individual Sample Schedule


Code Description:
This WSF has an associated Locational Data record (record in table TINLOC).


Code Description:
This WSF does not have an associated Locational Data record (record in table TINLOC).


Code Description:
System deemed optimized without Optimal Corrosion Control Treatment


Code Description:
System done with Optimal Corrosion Control Treatment


Code Description:
System Administrator has indicated that the enforcement action(s) that may be linked to a violation of this type are federally reportable.


Code Description:
System Administrator has explicitly indicated that the enforcement action(s) that may be linked to a violation of this type are not federally reportable.


Code Description:
System generated or user specified Treatment ID


Code Description:
Specifies that the violation compliance period begin date must fall within the BEGIN_DATE and END_DATE of this entity type.


Code Description:
Specifies the violation type, violation compliance period BEGIN_DATE and contaminant
of the relevant violation.


Code Description:
An open parenthesis immediately preceeds the related monitoring condition, when sequentially processing all monitoring conditions that qualify a monitoring requirement.


Code Description:
A close parenthesis immediately follows the related monitoring condition, when sequentially processing all monitoring conditions that qualify a monitoring requirement.


Code Description:
Routine - A regularly scheduled sample which is collected to satisfy a monitoring requirement.


Code Description:
Repeat or Check - Sample collected following an exceedance in routine a sample.


Code Description:
Special - Sample collected for purposes other than compliance determination or to satisfy a monitoring requirement.


Code Description:
Confirmation - Sample taken to confirm a previous sample analytical result.  The sample is taken at the same location as the earlier sample. This is sometimes known as a "check sample".


Code Description:
Re-analysis of sample for same or different analyte.


Code Description:
Primary Contact - An individual or other legal entity that is most often contacted in a water system.


Code Description:
Administrative Contact - Identifies a legal entity as a contact of interest to the water system for potential notification of activities related to a specific water system.  An example is identifying an individual that may receive copies of correspondence.


Code Description:
Legal Contact - An individual or other legal entity that is designated by the water system contact by regulatory agencies regarding legal or enforcement issues.


Code Description:
Regulatory Contact - An individual or other legal entity that is designated by the water system for contact regarding implementation or interpretation of regulations.


Code Description:
Regulatory Contact - Identifies an individual or other legal entity as the primary contact for the interprtation or implementation of regulations.


Code Description:
Primary Contact - Identifies an individual or other legal entity as the first person to contact regarding any issue relative to a water system.


Code Description:
Legal Contact - Identifies the individual or other legal entity designated by the water system as the primary contact for any legal or enforcement actions.


Code Description:
Action level - level that when exceeded requires a water supply to take a specific action.  The level may not be indicative of a public health threat. For example, lead and copper action level.


Code Description:
Unreasonable risk to health measure - Measure established in policy or guidance that reflects a level that is typically two times the Maximum Contaminant Level.  The basis for URTH levels is a 70-year life span during which an individual consumes approximately two liters of water per day, the result of which is an anticipated carcinogenic risk.


Code Description:
Trigger Level - Level that when exceeded requires increased monitoring.   Established by rule or regulation.


Code Description:
Practical Quantitative Level - Nationally established measuring level that represents the lowest level laboratories can consistently and reliably resolve for a given analyte.

Source: SBS JAD


Code Description:
Regulated Minimum Detection Limit -- the limit established by a Rule for an analyte.


Code Description:
Performance Level Requirement, also known as Treatment Technique level, performance standard, quasi-mcl.  This is the minimum or maximum acceptable range of a particular chemical, e.g. minimum chlorine residual.  SWTR


Code Description:
Observations (for measuring other organisms such as Protozoa, Algae, Nematodes, Rotifers, Crustaceans, Insects).


Code Description:
Field at 100 Power (used in conjunction with measuring numbers of Observations)


Code Description:
Count of Routine samples with negative results taken from the distribution system.


Code Description:
Count of number of positive sample analytical results


Code Description:
Count of negative sample analytical results


Code Description:
Count of negative finished water samples


Code Description:
Count of negative sample analytical results from distribution system samples


Code Description:
Distribution System - the location is in the distribution system of the water system. Examples of this type of sampling point include sampling points for total coliform, lead and copper, and perhaps disinfection by-products (see several of the types below for more precise ways to define disinfection  by-products sampling points).


Code Description:
Unit Process - a sampling point used to evaluate the effectiveness of a unit process. This type might be used, for instance, to determine the contact time under the SWTR for a single unit process.


Code Description:
Routine - Routine samples are typically collected for compliance with monitoring rules and used in maximum contaminant level (MCL) compliance calculations.


Code Description:
Repeat - Repeat samples are collected when a routine sample exceeds trigger, action, or maximum contaminant levels. Additional sampling is required to further identify and define potential water quality problems.


Code Description:
Special - Special samples are usually collected for reasons other than compliance determination and are typically used for process control or quality checks following maintenance or new construction in the treatment or distribution system.


Code Description:
Shipping Blank - Several types of blank samples are used for quality control of laboratory processes.


Code Description:
Field Blank - Several types of blank samples are used for quality control of laboratory processes.


Code Description:
Batch Blank - Several types of blank samples are used for quality control of laboratory processes.


Code Description:
Performance Evaluation - Performance evaluation samples are used for quality control of laboratory processes. The labs receive samples for analysis from the U.S. Environmental Protection Agency or other certifying agency. Results are compared against standards to determine if labs follow accurate and consistent analysis procedures.


Code Description:
Upstream within 5 connections of original sample location


Code Description:
Downstream within 5 connections of original sample location


Code Description:
The Rad result may apply to quarter 1, 2, 3, or 4.  0 is included since this is an optional field.


Code Description:
No means sample taken for other than compliance purposes (e.g. Lab Performance)


Code Description:
The lab reported the analytical result was less than the MINIMUM REPORTING LEVEL.


Code Description:
The lab reported the analytical result was less than the METHOD DETECTION LIMIT.


Code Description:
The result  is "less than" the Lab Reporting Limit or "less than" the Regulatory Minimum Reporting Limit.


Code Description:
Validated.   The sample analytical result is validated by the primacy agent.  Validation means that the sample analytical result meets the established data quality acceptance criteria.  In addition, the Water System received, evaluated, and accepted the sample analytical result and approved the result as valid data for use by the state or federal agencies.


Code Description:
Accepted.  The sample analytical result met the established QA acceptance criteria.


Code Description:
Rejected. The sample analytical result did not meet the EPA QA acceptance criteria.


Code Description:
Preliminary-- (or provisional) the sample result has been reported to a state agency informally (e.g. telephone report of Bacti positive result).

States have expressed requirements to not forward a preliminary result to EPA until the result is validated by the lab and state regulatory agency. Note that telephone reporting to the EPA regional offices would continue as per current practice.


Code Description:
Water System rejected the sample analytical result.


Code Description:
Yes.  This Monitoring_Period_Definition is to be used as the default.

TCR Team


Code Description:
No, this Monitoring_Period_Definition is not to be used as the default.

TCR Team


Code Description:
Mean (average) result for period (measure)


Code Description:
Replacement for Invalid - A sample that is taken to replace a sample previously taken and analyzed by the lab as "Invalid" (usually because of TNTC or Confluent Growth).


Code Description:
Total Number of Disinfectant Residual Measurements (count).


Code Description:
Total Number of Disinfectant Residual Measurements
below 0.2 mg/L (count).


Code Description:
Count of required Repeats per Federal regulation


Code Description:
Count of required Repeats per State regulation


Code Description:
Count of days in Federal Violation period


Code Description:
Count of Replacements Samples for Invalid


Code Description:
Indicates a collection method rather than an analysis method


Code Description:
Indicates an analysis method rather than a collection method


Code Description:
MCL violation type - An MCL violation means a contaminant has been detected above maximum contaminant level consistently in drinking water.  MCL is the highest level of contamination that the U.S. Environmental Protection Agency (EPA) allows in drinking water.  MCLs ensure that drinking water does not pose a short-term or long-term health risk.


Code Description:
Monitoring & Reporting violation type - A MON violation is a violation of a monitoring requirement or a reporting requirement associated with the monitoring.  A monitoring violation occurs when a public water system owner does not collect a required sample.  A reporting violation occurs when a public water system owner does not report the result(s) to the state from a sample that was collected.  When a public water system's owner does not collect a required sample, the violation is often referred to as a monitoring and reporting violation.


Code Description:
Sanitary Survey - An SS violation occurs when a public water system owner does not complete a sanitary survey by a required date.


Code Description:
Public Notice - A PN violation occurs when a public water system owner does not notify the public about another violation in a timely or appropriate fashion.


Code Description:
Treatment Technique - A TT violation occurs when a public water system owner fails to apply a prescribed treatment technique by the allotted time.  Actions that are classified as treatment techniques are broad.  Examples of TT violations include: failure to employ a certified operator, inadequate removal of organic materials from raw water.


Code Description:
Variance/Exemption - A V/E violation is issued when a public water system owner has been granted a variance or an exemption with a schedule of activities and the PWS owner fails to carry out one or more of the scheduled activities on time.


Code Description:
Reporting - A RPT violation occurs when public water system owners fail to report certain information. The RPT category does not include the failure to report analytical results, which falls under the MON category.


Code Description:
Valid assignment between MBS_VIOLATION_TYPE and RULE


Code Description:
Maximum Residence Time - Maximum Residence Time samples measure trihalomethanes present in a water system's distribution system. These samples are collected at a point representing the longest time between treatment, storage, and use. Formation of trihalomethanes over time results from disinfectant residual, organic content, and residence time.


Code Description:
Water systems report, in summary fashion, the "90th percentile" value to the states for compliance determination.  90th% is calculated by rank-ordering all of the results from required samples, and reporting the concentration that represents the 90th %.


Code Description:
Entry Point - location at which water enters the distribution system of a public water system. This is intended to correspond to the regulatory definition of an entry point to the distribution system representative of one or more sources of water. These should not be associated to Distribution System facilities but rather to the facility from which the water is flowing (e.g., a treatment plant, a well (if not treated prior to distribution), a common header).


Code Description:
Point of Maximum Retention - the location that represents the maximum residence time of disinfectants within the distribution system under the Disinfection By-Products Rules. This can also be used as the Unregulated Contaminant Monitoring Rule location in the distribution system that is furthest from the entry point to the distribution.


Code Description:
Raw Water Source - locations normally associated with intake or well water system facilities. Raw water monitoring is triggered by the detection of a contaminant at an entry point to the distribution system. This Sampling Point type can also be used to designate the raw water sampling point for precursor removal.


Code Description:
Process Control - locations normally associated with treatment plants or storage water system facilities.  This sampling point type is used to demonstrate compliance with contact time or other disinfectant or treatment requirements.


Code Description:
Modify sample already existing in SDWIS/FED


Code Description:
DTF Created  - the Sample Analytical Result or Sample Summary Result has been included in a generated H1 file.  The status of the result relative to SDWIS/FED is unknown at this point.


Code Description:
Accepted by SDWIS/FED - The sample analytical result or sample summary was included in a generated H1 file that was sent to SDWIS/FED; according to feedback from SDWIS/FED, the result has been accepted into SDWIS/FED.


Code Description:
Rejected by SDWIS/FED -  - The sample analytical result or sample summary was included in a generated H1 file that was sent to SDWIS/FED; according to the error report from SDWIS/FED, the result has been rejected by SDWIS/FED.


Code Description:
Batch run included PB90 sample summaries and summary results


Code Description:
Batch run included UCM sample and sample results


Code Description:
Batch run included CU90 sample summaries and summary results


Code Description:
Accepted into SDWIS/FED -  the stutus of a successfully executed instance of Migration to SDWIS/FED: Sampling (batch run) after the user has selected the record that represents the instance/batch run in the Post SDWIS/FED Batch Selection List and pressed the Accept pushbutton.  (Only batch runs of status P, that is, those that have successfully completed execution, are candidates for doing this.)  By "accepting" the batch run record, the user indicates to SDWIS/STATE that the sample results that were included in the "accepted" batch run have been accepted by SDWIS/FED.  This action sets the SDWIS/FED Status of those SDWIS/STATE sample results to A (Accepted).


Code Description:
Dry Run - the new status of a previously executed instance of Migration to SDWIS/FED: Sampling (batch run) that was set to P (pending) but has not subsequently been set to A (accepted) and has now automatically been set to D (dry run) as the result of a new instance/batch run of the execution of Migration to SDWIS/FED: Sampling.  When the instance/batch run record is set to D, the DTF file that was created as a result of that batch run is deleted.


Code Description:
Failed - The default status of a currently executing instance of Migration to SDWIS/FED: Sampling (batch run) which remains F until the instance/batch run has successfully completed execution at which time it is reset to P (pending).  If the instance/batch run terminates prior to completion, its status remains F (failed), thereby informing the user that the instance/batch run did not successfully complete execution. A failed batch run can be reexecuted.


Code Description:
Pending Acceptance -  The status of a successfully completed instance of the execution of Migration to SDWIS/FED: Sampling (batch run).   Only batch runs of status P, that is, those that have successfully completed execution, are candidates for indicating that the SDWIS/STATE Sample Results that were included in the batch run have been accepted by SDWIS/FED (selecting the record in the Post SDWIS/FED Batch Selection List and pressing the Accept pushbutton).


Code Description:
Sample is a replacement of another original sample.


Code Description:
Implies that a surface source intake is located on a defined river reach.


Code Description:
Implies that the source of water (or surface source intake) is not located on a defined river reach, but instead, is located within the area drained by the river reach.


Code Description:
The Violation Period Begin Date should be reported to SDWIS/FED for any violation using this Violation Type.


Code Description:
May have a contaminant code reported to EPA, but is not required.  If the violation type is associated to specific analytes, the list of optional analytes is restricted to those assigned.  If none is associated, there is no restriction.


Code Description:
Must have a contaminant code reported to EPA.  If the violation type is associated to specific analytes, the list is restricted to one of those assigned.  If none are assigned there is no restriction to the specific analyte that must be reported.


Code Description:
Must not have a contaminant code reported to EPA.


Code Description:
(Subpart H) - Surface Water or Groundwater UDI Surface Water or Purchased Surface Water, or Purchased Surface Water or Purchased Groundwater UDI Surface Water.


Code Description:
(All Groundwater) - Groundwater or Purchased Groundwater.


Code Description:
(All Surface Water) - Surface Water or Purchased Surface Water.


Code Description:
(All Groundwater) UDI Surface Water - Groundwater UDI Surface Water or Purchased Groundwater UDI Surface Water.


Code Description:
(Source Subpart H) - Surface Water or Groundwater UDI Surface Water.


Code Description:
(Purchased Subpart H) - Purchased Surface Water or Purchased Groundwater UDI Surface Water.


Code Description:
(Year Long) - Entered or calculated number of days operating equals 365.


Code Description:
(Seasonal) - Entered or calculated number of days operating is >0 and <365.


Code Description:
(Long season, i.e., 180 days to 364 days) - Entered or calculated number of days operating is >179 and <365.


Code Description:
(Short season, i.e., 60 days to 179 days) - Entered or calculated number of days operating is >59 or <180.


Code Description:
(0 to 59 days) - Entered or calculated number of days in operation is 0 to 59.


# Subject area

Description:
Identifies the treatment objectives and processes for treating water intended for public consumption.


Description:
Identifies the actions taken to enforce drinking water regulations.


Description:
Results of an examination process of a regulated entity or regulating community activity.  Review findings could result in a formal audit or the scheduling of additional on-site follow-up visits to support or correct the situation.  SDWIS/STATE has only incorporated site visit-related entities under this subject area (such as are needed to support capturing information about on-site visits to conduct a PWS sanitary survey, on-site inspections of new PWSs, and reviews of state drinking water programs.)


Description:
Documents a violation of a requirement.  Violations are detected by assessment of sample results or reviews (including on site visits).  Violations may lead to legal actions or compliance orders.  Violations are 
publicized, when required, by public notification.  Violations may be remedied by compliance/enforcement remedies, such as improved filtration techniques or changes in 
procedures.  Examples:  MCL violations, failure to replace lead service lines, monitoring and reporting violations, treatment technique violations, and procedural violations.  Example descriptors:  type, date, description, severity, and recommended corrective action(s) to include milestones.


Description:
Supports the extraction and conversion of SDWIS/LAN data elements to SDWIS/FED DTF format.


Description:
Identifies actions that may be used to support assistance actions and enforcement actions.


Description:
Information describing the reference or lookup tables.


Description:
This subject area identifies and describes information supporting the compliance determination.  Compliances information is used to evaluate implementation of PWS program requirements, oversight efforts, violations, and actions to return systems to compliance.


Description:
Information concerning statutes, regulations, policies, guidance, agreements, standards, and schedules for regulatory implementation.


Description:
This subject area identifies and describes information associated with monitoring of water quality by taking a sample from a source of water.  Included are sampling events, sampling points (location from which the sample was drawn), and collector of the sample.


Description:
This subject area identifies and describes techniques, researches, and equipment.


Description:
Information associated with the collection and analysis of water samples taken to evaluate the quality of drinking water or the efficacy of treatment or analysis techniques.


Description:
This subject area identifies and describes information associated with laboratories, their associations with legal entities, and the certification of a laboratory to analyze according to a specific method.


Description:
This subject area identifies and describes information associated with analytes (contaminants) and the grouping of those analytes into categories or groupings defined by the user.


Description:
This subject area identifies and describes information associated with monitoring of
water quality by performing a laboratory analysis of the sample taken from a source of water.  Included are sample analytical results (including microbiological  analytical results), sample summaries, and sample summary results.


