![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif){kind=logo}
Column Name: D_HISTORY_IND_CD
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 system s which were reported in that most recent period are considered to be "current". Those water systems that existed in the cu rrent inventory prior to the update, and for which a replacement was not submitted, would become part of the "historical" i nventory. If a state submitted "updates only" to its inventory in the most recen t reporting period, those water systems that existed in the current inventory prior to the update, plus any new water systems whic h 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.
Envirofacts Table Name: SDW_WATER_SYSTEM
Data Source:
- DB2 Table Name: TINWSYS
- DB2 Column Name: D_HISTORY_IND_CD
- Type: Character
- Length: 1
- Optional
Return To: