Ancillary Data

Ancillary File Components

Ancillary Data is Dependent on the NWIS Site File and SWUDS Water-Use Site File. The template has 23 attributes (5 mandatory, 14 conditionally mandatory, 4 non-mandatory).

---

Important Links:

• Ancillary template
• NWIS User Manual

Mandatory Information*	Non-Mandatory Data	Conditional Mandatory Data**

---

Ancillary Variables

Agency Code (C4)*	Site Number (C1)*	Year*	Delete Record Indicator (Modify)	Ancillary Type Code*	Ancillary NAICS Code*	Ancillary SIC Code	Data Source Code	Annual Value**	Reporting Unit Name**	Ancillary Comment	January Value**	February Value**	March Value**	April Value**	May Value**	June Value**	July Value**	August Value**	September Value**	October Value**	November Value**	December Value**

Ancillary Attribute Dictionary

Variable	Description	Data Entry Rule
Agency Code (C4)*	3-5 characters. Example: "USGS". The agency or organization that is the source of the SITE data. Enter, left justified. The code must exist in reference list AGENCY.	A site must exist in the NWIS site file and the SWUDS water-use site file before ancillary data can be entered. The site can be any site type.
Site Number (C1)*	8 - 15 characters. Unique site identification number. For ground-water sites, this is a 15-digit identification number assigned to the site, and contains no blanks or alphabetic characters. For surface-water sites, an 8- to 14-digit downstream order number is usually used for sites. Downstream order numbers also may be assigned to Spring, Outfall, and Surface-Water Diversion sites where water-use data are collected. For aggregate ground water, aggregate surface water, and facility site types, use a 10 to 15- digit number. The identifier should begin with the number ‘9’, followed by the state numeric FIPS code, plus 7 to 12 digits that constitute a unique ID.	A site must exist in the NWIS site file and the SWUDS water-use site file before ancillary data can be entered. The site can be any site type.
Year*	4 numeric characters. Enter a four-digit year.	Enter the 4-digit calendar year that the ancillary data was collected or reported. This is a mandatory field. The year must be valid year (equal to or less than the current year).
Delete Record Indicator (Modify)	Non-mandatory (black text). 1 character. Entering a $ will delete the data associated with this record.	Enter site number, site agency code, ancillary type code, NAICS code, year, and a value of '$' or '*' for delete record indicator. All data (annual and monthly values) associated with this record will be deleted.
Ancillary Type Code*	2 characters. The codes are: NE - Number of employees, AC - Acres irrigated, PP - Power production, PR - Production.	The user must enter an ancillary code for an ancillary transaction. The ancillary code is part of the logical key and describes the type of data being stored. The ancillary codes are NE-number of employees, AC-acres irrigate, PP--power production, PR-production
Ancillary NAICS Code*	2-6 digits. The North American Industry Classification System, 2000, (NAICS) is a new system for classifying industries and business establishments. Enter NAICS code for current production. For more information see http://www.census.gov/epcd/www/naics.html (Accessed 08/29/2002). Do not enter leading zeros when entering NAICS codes.	The North American Industry Classification System (NAICS) code is verified against a reference list that was obtained from the U.S. Census Bureau, The reference list is stored in table NAICS. On add the NAICS code is mandatory. The system does not check for consistancy in the use of NAICS codes entered in the the water-use site view with NAICS codes entered in the ancillary data view.
Ancillary SIC Code	4 characters. The Standard Industrial Classification Code, 1987, (SIC) is an industry classification system. NAICS codes have replaced SIC code, but the SIC code field is provided for backward compatability. Append 0 to SIC codes to make the codes a full 4 digits long;for example, a 3-digit SIC code such as 201 must be changed to 2010 if the full 4-digit SIC is not known.	The Standard Industrial Classification Code, 1987 (SIC) is verified against a reference list that was obtained from the U.S. Census Bureau. The system does not check for consistancy in the use of SIC codes entered in the the water-use site view with SIC codes entered in the ancillary data view.
Data Source Code	3-5 numeric characters. Example: "USGS". The agency or organization that is the source of the ANCILLARY data. Enter, left justified. The code must exist in reference list AGENCY. Email for assistance: GS-W HELP GWSI. Can be set as User Preference (Click Tools, then Preferences).	Enter the agency code of the data source that provided the data. The system validates that the agency code is in the NWIS reference list AGENCY.
Annual Value**	1-12 numeric characters of a yearly value. The annual value represents the quantity for a calendar year. It is expressed in the units of the original measurement.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
Reporting Unit Name**	1-20 characters. Enter the report unit abbreviation, for example GWh for gigawatts per hour. Or Count for the number of livestock.	Enter the standard abbreviation. The reference list ANCILLARY_UNIT contains a master list of units that can be used with ancillary data.
Ancillary Comment	1-255 characters.	The comment cannot exceed 255 characters.
January Value**	1-12 numeric characters for the month of January.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
February Value**	1-12 numeric characters for the month of February.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
March Value**	1-12 numeric characters for the month of March.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
April Value**	1-12 numeric characters for the month of April.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
May Value**	1-12 numeric characters for the month of May.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
June Value**	1-12 numeric characters for the month of June.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
July Value**	1-12 numeric characters for the month of July.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
August Value**	1-12 numeric characters for the month of August.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
September Value**	1-12 numeric characters for the month of September.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
October Value**	1-12 numeric characters for the month of October.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
November Value**	1-12 numeric characters for the month of November.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.
December Value**	1-12 numeric characters for the month of December.	The user must enter at least one monthly value or an annual value or the ancillary transaction will be rejected.