Owner

Owner File Components

The owner file is a logical group (aka view) under SWUDS and GWSI.

---

Important Links:

• Owner template
• NWIS User Manual

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

---

Site Owner Variables

Agency Code (C4)*	Site Number (C1)*	Delete Record Indicator (Modify)	Site Owner Alias Name*	Site Owner Type Code*	Site Owner Contact Alias Name	Site Owner Start Date*	Site Owner End Date	Edit Site Owner Alias Name (Modify)**	Edit Site Owner Start Date (Modify)**

Owner Variables

Owner Alias Name*	Owner Name*	Owner Phone	Owner Address Line 1	Owner Address Line 2	Owner City	Owner Postal Code	Owner Zip	Owner Country

Mandatory Information

Site Owner

Agency Code (C4)*	Site Number (C1)*	Site Owner Alias Name*	Site Owner Type Code*	Site Owner Start Date*

Owner

Owner Alias Name*	Owner Name*

---

Site Owner Attribute Dictionary

Variable	Definition	Data Entry Rule
Agency Code (C4)*	A code that references the agency or organization that is the source of the site data.	The site (site number and agency code) must exist in the site file prior to associating owner records to sites.
Site Number (C1)*	The site identification number.	The site (site number and agency code) must exist in the site and water-use site files prior to associating owner records to sites.
Delete Record Indicator (Modify)	The delete record indicator is used in modify transactions to indicate which records should be deleted from the database.On a modify operation the delete record indicator can be set to the value '$' or '*' to indicate that the site owner association should be deleted. One needs to specify the site number, agency code, site owner alias name, and site owner start date. On the delete of a site owner record the system only removes the association of the site to a given party. The system does not delete party records.
Site Owner Alias Name*	The site owner is the legal responsible party that owns a site. The site owner alias name is the unique party alias name of the owner. The site owner view can not be used to enter or modify owner address information. Use the owner view to modify the owner's address/phone number. Use the owner contact view to modify the owner contact's address/phone number.	Agency code, site number, and site owner alias name are required to enter a new site owner record. The site must exist in the NWIS site and water-use site files and the owner must exist in the owner table before site owner records can be entered. A site can have many site owners. One owner can be associated to one or more sites. Site owner records are unique based on agency code, site number, site owner alias name and site owner start date.
Site Owner Type Code*	Type of site owner code.The site owner type code can be used to categorize owners. A frequently used categorization is water supplier. A water supplier is a public or private entity that provides water for a variety of uses, such as domestic, commercial, thermoelectric power, industrial, irrigation, and public water use. The geographic extent of a water supply may be implied by the location of all sites owned by a water suppier. The owner type code of "WS" is used to identify an owner as a water supplier.	On add the type of site owner code (site_owner_cd) is mandatory. The site owner code is not mandatory to modify site owner records. Site owner codes are verified against the reference list SITE_OWNER_CD. Valid site owner type codes are individual (IN), water supplier (WS), corporation (CP), government (GV), military (MI), tribal government (TG), and other (OT).
Site Owner Contact Alias Name	The site owner contact alias name is the unique owner contact alias name of the owner contact. Site owner and site owner contact are two separate pieces of information. Site owner is the owner of the site. Site owner contact is the contact associated with the owner.	The site owner contact must already exist in the database. It is possible that the site owner and site owner contact can be the same entity. To change the site owner contact for a given site owner record, use a modify transaction that includes the site identifier, agency code, site owner alias name, site owner start date, and the "new" site owner contact alias name. A $ can be entered, for the site owner contact alias name, in an modify transaction to remove an association to an owner contact.
Site Owner Start Date*	Site owner start date. The first year, month, or day a site was owned by an owner.	Site owner start date can be null, not entered. Partial dates are allowed. If one only knows the year, then enter the 4-digit year (1999). If one knows the year and month, then enter (199908). Otherwise enter the full date (yyyymmdd). If both starting and ending owner dates are entered then the end date must be more recent than the start date.
Site Owner End Date	Site owner end date. The last year, month, or day a site was owned by an owner. If an end date is not entered, it implies that the site currently owners the site.	Site owner end date can be null, not entered. If both start and ending owner dates are entered then the end date must be more recent than the start date. Partial dates are allowed. If one only knows the year, then enter the 4-digit year (1999). If one knows the year and month, then enter (199908). Otherwise enter the full date (yyyymmdd). A $ can be entered in an modify transaction to remove the ending date.
Edit Site Owner Alias Name (Modify)**	Used to assign a different site owner alias name to the indicated site owner record. If the wrong owner was assigned to a site owner record use a modify transaction with the edit site owner alias name to assign a different site owner alias name.	Agency code, site number, site owner alias name, and site owner start date are required for the system to find the record to be modified. The edit site owner alias name must exist in the database before the site owner record can be modified.
Edit Site Owner Start Date (Modify)**	Used to assign a different site owner start date in the indicated site owner record. If the wrong start date was assigned to a site owner record use a modify transaction with the edit site owner start date to assign a different site owner start date.	Agency code, site number, site owner alias name, and site owner start date are required for the system to find the record to be modified.

Owner Attribute Dictionary

Variable	Definition	Data Entry Rule
Owner Alias Name*	Owner alias name. The alias name is used to uniquely identify an owner when more than one owner record has the same owner name. If the owner is an agency then the owner alias name should be entered with the code used to identify the agency. Agencies should be created in the master NWIS AGENCY reference list. Please contact NWIS support if you have new agencies to add as owners. For any owner that is not an agency, it is recommended that the owner alias name be based on the owner name. Create owner alias name from owner name by left justifying, uppercasing, owner name with all extra white space removed (i.e. ' aa bb' would be 'AA BB'). If two different owners have the same owner name, then sequence numbers can be used to uniquely identify the owners. It is recommended that sequence numbers start with '2'. The first owner alias name should be entered with no sequence number (the sequence number is implied to be 1).	The owner alias name is used to uniquely identify an individual or group of individuals. The minimal amount of information allowed for an add is the owner name and the owner alias name. An error is raised if one adds an owner record where the owner alias name has already been used for another owner, contact, owner contact, agency (data source), or assigner of a permit. An error is also raised if one enters a unique owner alias name where the owner name, address, and phone number combination is not unique. On modify an error is raised if a record does not exist for the owner alias name entered. The system allows the user to enter what ever they want for a owner alias name as long as the values are unique. No leading white space is allowed in the owner alias name. The system will auto-left justify owner alias names. Use the PARTYALIAS view to change an existing owner alias name (party alias name).
Owner Name*	Owner name. The name assigned to an individual or group of individuals. An owner record can be associated with one or more sites with the Site Owner view. The Owner view is a master list of names and addresses that can be associsted to sites as owner records.	Owner name and address can be entered in mixed case. No leading white space is allowed in the owner name. Owner names are left justified. Owner names are not unique. Owner alias name is unique. The owner alias name is used as the key to retrieve the owner/address data. The owner name can be modified. The minimal amount of information needed for a modify is the owner alias name and one other attribute. The modified owner/address information must remain unique for the modify to be successful. If not unique, the system will raise an error. The system also stores a search index based on the owner name (party name index, party_nm_idx). The index consists of the uppercase owner name with all white space, punctuation, and non-printable characters removed. The system uses the index in retrieval programs as a key to find records by owner name. For example, for the owner name John T. Smith the system will retrieve a list of owners where the party name index = “JOHNTSMITH”.
Owner Phone	The owner's phone number. The phone number of the phone at the address.	The user may enter a phone number when entering address information. The phone number cannot be greater than 24 characters or the transaction will be rejected. A $ can be entered on an modify transaction to blank out any entered value.
Owner Address Line 1	The first line of the owner's mailing address.	Any text can be entered for the mailing address. To blank out, remove, the first line of the address enter the value $ in a modify transaction.
Owner Address Line 2	The second line of the owner's mailing address.	Any text can be entered for the mailing address. To blank out, remove, the second line of the address enter the value $ in a modify transaction.
Owner City	The city name component of a postal address.	Any text string can be entered. The city name is not validated for spelling, capitalization, or typographical errors. To blank out, remove, the city names enter the value $ in a modify transaction.
Owner Postal Code	U.S. Postal Service zip code. A zip code can be either a five digit zip code or a nine digit extended zip code. The zip code is usually a length of five or nine. Enter a hyphen in the sixth character position for a nine digit zip code.	The system does not validate U.S. Postal Service (USPS) postal abbreviations. However, see http://www.usps.gov/ncsc/lookups/usps_abbreviations.htm for a list of valid USPS postal abbreviations. To blank out, remove, a postal abbreviation enter the value $ in a modify transaction.
Owner Zip	U.S. Postal Service zip code. A zip code can be either a five digit zip code or a nine digit extended zip code. The zip code is usually a length of five or nine. Enter a hyphen in the sixth character position for a nine digit zip code.	The system performs no formatting checks for zip code. To blank out, remove, a zip code enter the value $ in a modify transaction.
Owner Country	Address country name.	The system does not validate country names against a list of valid country names. To blank out, remove, the country names enter the value $ in a modify transaction. The length of the country name cannot exceed 48 characters.