CONTENTS

[2.0 ONLINE SDWIS/STATE LEGAL ENTITY
2-1](#online-sdwisstate-legal-entity)

[2.1 Model Changes for Legal Entity
2-3](#model-changes-for-legal-entity)

[2.1.1 Legal Entity Maintenance Page Flow
2-6](#legal-entity-maintenance-page-flow)

[2.2 Collector 2-47](#collector)

[2.2.1 Model Changes for Collector 2-47](#model-changes-for-collector)

[2.2.2 Collector Maintenance Page Flow
2-47](#collector-maintenance-page-flow)

[2.3 Laboratory (Lab) 2-47](#laboratory-lab)

[2.3.1 Model Changes for Laboratory 2-47](#model-changes-for-laboratory)

[2.3.2 Laboratory Maintenance Page Flow
2-47](#laboratory-maintenance-page-flow)

**EXHIBITS**

[**Exhibit 2-1.** SDWIS/STATE Home Page
2-1](#__RefHeading___Toc86484606)

[**Exhibit 2-2.** Legal Entity Search 2-7](#__RefHeading___Toc86484607)

[**Exhibit 2-3.** Legal Entity Maintenance List
2-10](#__RefHeading___Toc86484608)

[**Exhibit 2-4.** Legal Entity Assignment List
2-13](#__RefHeading___Toc86484609)

[**Exhibit 2-5.** Delete Legal Entity 2-14](#__RefHeading___Toc86484610)

[**Exhibit 2-6.** Individual Maintenance
2-17](#__RefHeading___Toc86484611)

[**Exhibit 2-7.** Cancel Confirm 2-25](#__RefHeading___Toc86484612)

[**Exhibit 2-8.** Government Agency Maintenance
2-26](#__RefHeading___Toc86484613)

[**Exhibit 2-9.** Legal Entity Maintenance
2-35](#__RefHeading___Toc86484614)

[**Exhibit 2-10.** Communication Maintenance Page
2-43](#__RefHeading___Toc86484615)

[**Exhibit 2-11.** Point of Contact Assignments List
2-45](#__RefHeading___Toc86484616)

[**Exhibit 2-12.** Laboratory Search 2-48](#__RefHeading___Toc86484617)

[**Exhibit 2-13.** Laboratory Maintenance List
2-51](#__RefHeading___Toc86484618)

[**Exhibit 2-14.** Delete Laboratory 2-53](#__RefHeading___Toc86484619)

[**Exhibit 2-15.** Laboratory Maintenance
2-55](#__RefHeading___Toc86484620)

[**Exhibit 2-16.** Laboratory Point of Contact Maintenance List
2-65](#__RefHeading___Toc86484621)

[**Exhibit 2-17.** Delete Laboratory Contact
2-67](#__RefHeading___Toc86484622)

[**Exhibit 2-18.** Laboratory Point of Contact Maintenance
2-69](#__RefHeading___Toc86484623)

[**Exhibit 2-19.** Lab Contact Duplicate Found
2-74](#__RefHeading___Toc86484624)

[**Exhibit 2-20.** More POCs Types 2-77](#__RefHeading___Toc86484625)

#  {#section .unnumbered}

# ONLINE SDWIS/STATE LEGAL ENTITY

The Legal Entities component of SDWIS/STATE Web Release 1.0 (SSWr1) is
the part of SDWIS/STATE that allows users to maintain the organizations,
people and places associated with the primacy agency's Safe Drinking
Water Program (Exhibit 2-1). This component includes information about
laboratories such as name, address, phone numbers, and points of contact
as well as data about sample collectors. The application uses the term
*legal entity* to define any individual, government agency, or other
group (e.g., corporation) associated with a water system. The data on
legal entities includes names, addresses, phone numbers, and e-mail
addresses. To link information about a legal entity to data in other
areas of the application, the legal entity must first be added using
this area of the application.

  ---------------------------------------------------- ---------------------------------------------------
  ![](media/image1.png){width="1.8472222222222223in"   ![](media/image2.png){width="3.995138888888889in"
  height="4.248611111111111in"}                        height="3.053472222222222in"}

  ---------------------------------------------------- ---------------------------------------------------

[]{#__RefHeading___Toc86484606 .anchor}**Exhibit 2-1.** SDWIS/STATE Home
Page

The following types of legal entities will be supported:

**Company (CM)** An entity registered with a state, county, city,
township, or other body that licenses businesses to perform services and
charge fees. Companies are generally owned and operated by an individual
or a corporation.

**Cooperative (CP)** An entity owned by water system users. Cooperatives
are often owned, managed, and operated by members who pay dues for
services on a scheduled basis.

**Corporation (CR)** An entity registered with a state, country, city,
township, or other body that licenses businesses to perform services and
charge fees. In general, a corporation is a group of people who obtain a
charter granting them, as a body, certain legal powers, rights,
privileges, and liabilities of an individual. A corporation can buy,
sell, and inherit property.

**Government**

**Agency (GA)** In SDWIS/STATE, the classification Government Agency is
intended to be limited to agencies such as federal, state, county, city,
or township agencies that *regulate* water system owners. In the real
world, of course, government agencies also own water systems as well as
laboratories, but the classification of Government Agency in SDWIS/STATE
was *not* designed for this purpose. A government agency that only owns
a water system or laboratory should not be entered as a government
agency. The water system it owns, however, should be designated as
government-owned in the Owner Type field in *Inventory*.

**Homeowners'**

**Association (HA)** An entity owned by the users of the water system
that is similar to a cooperative, but with membership limited to
individuals who own property within a subdivision or other local
residential development. Homeowners' associations are often owned,
managed, and operated by members that pay scheduled dues for services.

**Individual (IN)** A person who has legal status within the definition
of individual in a given law, rule, ordinance, or other legal document.
Individuals often own companies and water systems. SDWIS/STATE users are
also *Legal Entity---Individuals*. Each user is assigned specific
privileges to use given SDWIS/STATE component(s) by the SDWIS/STATE
Administrator and Database Administrator.

**Non-Profit (NP)** Typically a corporation that provides a service but
does not make an intentional profit. Non-profits are often funded by
donations, sliding scale rates, or other fees that are sufficient
sources of income for the corporation to pay its operating expenses, but
not enough to make a profit. They are typically registered with a
corporation commission much like a typical for-profit corporation or a
rate-set utility would be, and rates are controlled accordingly.

**Other (OT)** Because the above types are not all inclusive, a type of
other is used to categorize an entity that does not fit any of the other
categories.

**Rate-Set**

**Utility (RU)** Typically a corporation that provides a service for a
profit. Rate-set utilities are funded by payment of fees set at specific
rates by a government agency such as a corporation commission. Rates
that are considered fair to the customer are set by the agency and are
also sufficient for the utility to remain financially viable, thereby
providing continuous and adequate service. They are typically registered
with a corporation commission much as is a for-profit corporation.

**Treatment Plant**

**(TP)** An entity intended to be used when the user enters a physical
address for a treatment plant (EPA guidance indicates that users must
either report the latitude and longitude for a treatment plant
\[including supporting data\] depending on the type of Public Water
System, or the physical address).

**Trust (TR)** An entity funded by sources that contributed before the
entity's inception. These funds can be donations or endowments and are
often maintained by dividends from investments of the original funds.

**Water System**

**(WS)** An entity intended to be used when the user enters a physical
address for a water system. (A.2.0.a)

## Model Changes for Legal Entity

Changes to Legal Entity (TINLGENT):

-   Add permitted value of 'WS' described as Water System to the
    Type_Code attribute. (A.2.1.a)

-   Schema migrate the contents of the Phone_Number attribute to the
    phone_number attribute of the new LEGAL_ENTITY_COMMUNICATION
    (TINLGCOM) entity type when the Phone_Number attribute contains a
    value. Set the Type_Code to 'BUS.' This will generate a new row in
    this table. (A.2.1.b)

-   Add field Comment_Text (text, 2000, optional). (A.2.1.c)

-   Add field Operator_Class (text, 5, optional). Description: The
    operator certification class that the individual has achieved.
    Default value will be spaces. (A.2.1.d)

Create new Entity LEGAL_ENTITY_COMMUNICATION (A.2.1.e).

-   Description: Communication methods and information for a legal
    entity (e.g., voice, electronic, and/or fax).

-   Physical name: TINLGCOM

-   Attributes:

```{=html}
<!-- -->
```
-   Tinlgcom_IS_Number (numeric, 3, mandatory). Generated sequentially
    as max number within LEGAL_ENTITY Tinlgent\_ IS_Number and
    Tinlgent_St_Code.

> \- Purpose_Code: (text, 10, mandatory). 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. Initial values for schema migration into
> FONPURPOSE will be: (C.2.1.a)
>
> \-- BUS -- business
>
> \-- FAX -- facsimile
>
> \-- MOB -- mobile
>
> \-- EMERG -- emergency
>
> Initial values for schema migration into ELCPURPOSE will be: (C.2.1.b)
>
> \-- EMAIL -- email
>
> \-- URL -- web address
>
> \- Phone_Number: (text, 15, optional). The phone number including area
> code and hyphens.
>
> \- Phone_Number_Extension: (text, 5, optional). The extension of the
> phone number beyond the standard telephone number.
>
> \- Electronic_Address: (text, 100, optional). An account used to send
> electronic correspondence.

-   Relationships:

> \- Each LEGAL_ENTITY can sometimes record one or more communication
> methods in LEGAL_ENTITY_COMMUNICATION (non transferable, 90%,
> reference, cascade delete).
>
> \- Each LEGAL_ENTITY_COMMUNICATION is always a communication method
> for one and only one LEGAL_ENTITY (non transferable, disassociate).

-   Identifier: Tinlgcom_is_number and the relationship (foreign keys)
    from LEGAL_ENTITY (TINLGENT).

Changes to INDIVIDUAL (TININDIV):

-   Expand the size of TININDIV - SALUTATION_CODE to 15. (A.2.1.f)

> Remove permitted values and schema migrate existing values to the new
> CODE table entry. CODE code_name = ' LESAL', cod_characteristic = 'T',
> value_length = 15, ownership_code = 'ST', ref_attribute_name =
> 'SALUTATION', description_of_code = "The Individual legal entities
> salutation values. (A.2.1.g)

-   Schema migrate the contents of the Business_Phone_Number attribute
    to the phone_number attribute and Business_phone_number_extension to
    the phone_number_extension attribute of the new
    LEGAL_ENTITY_COMMUNICATION (TINLGCOM) entity type when the
    Business_Phone_Number attribute contains a value. Set the Type_Code
    to 'BUS'. This will generate a new row in this table. (A.2.1.h)

-   Schema migrate the contents of the Fax_Number attribute to the
    phone_number attribute of the new LEGAL_ENTITY_COMMUNICATION
    (TINLGCOM) entity type when the Fax_Number attribute contains a
    value. Set the Type_Code to 'FAX'. This will generate a new row in
    this table. (A.2.1.i)

-   Schema migrate the contents of the Emergency_Phone_Number attribute
    to the phone_number attribute of the new LEGAL_ENTITY_COMMUNICATION
    (TINLGCOM) entity type when the Emergency_Phone_Number attribute
    contains a value. Set the Type_Code to 'EMERG'. This will generate a
    new row in this table. (A.2.1.j)

-   Schema migrate the contents of the Electronic_address attribute to
    the Electronic_address attribute of the new
    LEGAL_ENTITY_COMMUNICATION (TINLGCOM) entity type when the
    Electronic_address attribute contains a value. Set the Type_Code to
    'EMAIL'. This will generate a new row in this table. (A.2.1.k)

Changes to GOVERNMENT_AGENCY (TINLGENT) (A.2.1.l)

-   Schema migrate the contents of the Phone_Number attribute to the
    phone_number attribute of the new LEGAL_ENTITY_COMMUNICATION
    (TINLGCOM) entity type when the Phone_Number attribute contains a
    value. Set the Type_Code to 'BUS.' This will generate a new row in
    this table.

-   New attribute regulating_agency_indicator (text, 1, opt, permitted
    values of 'Y', spaces) (B.2.1.a) Schema migration script would
    perform the following:

> \- Set to 'Y' for government agency with primacy_indicator_code =
> 'Y'.(B.2.1.b)
>
> \- Set to 'Y' for government agency with type_code equal to any of the
> following values (ST, SA, SR). (B.2.1.c)

Changes to LAB_LEGAL_ENTITY_ASGMT (TSALLEA) (B.2.1.d)

-   Rename attribute establishment_number to obs_establishment_number.

-   Rename attribute purpose_text to obs_purpose_text.

-   Remove permitted values from the type_code field.

Schema Migration for new Code table permitted values replacing the
permitted values of the type_code field: (B.2.1.e)

-   New CODE table row (TINCODE) for Point of Contact (POC) type.

> \- Code_name = 'POCTYPE'
>
> \- Cod_characteristic = 'T'
>
> \- Value_length = 3
>
> \- Delete_flag = 'A'
>
> \- Ownership_code = 'ST'
>
> \- D_userid_code = 'SSWR1'
>
> \- D_last_updt_ts = 2005-01-01
>
> \- Description_of_code = 'The user-defined list of Point of Contact
> type codes.'

-   New PERMITTED VALUES table rows (TINPVALS)

> \- Sequence_number = increment by +1 for each text_value.
>
> \- Numeric_value = zero
>
> \- Date_value = '0001-01-01'
>
> \- Ref_indicator = spaces
>
> \- Ownership_code = 'HQ'
>
> \- D_userid_code = 'SSWR1'
>
> \- D_last_updt_ts = '2005-01-01'
>
> \- Table of Text_values and Descriptions:

+-------------------+--------------------------------------------------+
| Text_value        | Description                                      |
+-------------------+--------------------------------------------------+
| AC                | Administrative Contact                           |
+-------------------+--------------------------------------------------+
| EC                | Emergency Contact                                |
+-------------------+--------------------------------------------------+
| FC                | Financial Contact                                |
+-------------------+--------------------------------------------------+
| LC                | Legal Contact                                    |
+-------------------+--------------------------------------------------+
| OP                | Operator                                         |
+-------------------+--------------------------------------------------+
| OW                | Owner                                            |
+-------------------+--------------------------------------------------+
| SA                | Sampler                                          |
+-------------------+--------------------------------------------------+
| PL                | Physical Location                                |
+-------------------+--------------------------------------------------+
| BI                | Bureau of Indian Affairs                         |
+-------------------+--------------------------------------------------+
| DO                | Designated Operator                              |
+-------------------+--------------------------------------------------+
| HC                | Health Clinic Representative                     |
+-------------------+--------------------------------------------------+
| IE                | Indian Health Services Engineer                  |
+-------------------+--------------------------------------------------+
| IS                | Indian Health Services Sanitarian                |
+-------------------+--------------------------------------------------+
| LE                | Lead Engineer                                    |
+-------------------+--------------------------------------------------+
| OT                | Other                                            |
+-------------------+--------------------------------------------------+
| TC                | Tribal Chairman                                  |
+-------------------+--------------------------------------------------+
| TE                | Tribal Environmental Department                  |
|                   |                                                  |
|                   | Representative                                   |
+-------------------+--------------------------------------------------+
| TG                | Tribal Government Representative                 |
+-------------------+--------------------------------------------------+
| TH                | Tribal Health Department                         |
|                   |                                                  |
|                   | Representative                                   |
+-------------------+--------------------------------------------------+
| UN                | Utility Representative -- Non Tribal             |
+-------------------+--------------------------------------------------+
| UT                | Utility Representative -- Tribal                 |
+-------------------+--------------------------------------------------+

### Legal Entity Maintenance Page Flow 

From the *SDWIS Home Page* the user selects **Legal Entities/Legal
Entity** to invoke the Legal Entity Search page (Exhibit 2-2), where the
user may specify any search criteria.

[Entry Fields:]{.underline}

Starting Criteria Group Box:

*\[Legal Entity\] Name* The name of the legal entity that will be used
for a search equal to, starting with, and greater than this value. If
the name is for an individual, enter in the format: last name, first
name. Example: Public, John Q.

> The Name field will be optional.

**2.1.1.1 Legal Entity Search**

  ---------------------------------------------------- ----------------------------------------------------
  ![](media/image3.png){width="1.7666666666666666in"   ![](media/image4.png){width="4.0472222222222225in"
  height="4.476388888888889in"}                        height="3.6659722222222224in"}

  ---------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484607 .anchor}**Exhibit 2-2.** Legal Entity
Search

Filtering Criteria Group Box:

*Legal Entity Type* The Legal Entity Type can be used to display only
legal entities of the type indicated in this field. The selections
available via the dropdown list are:

> \* Display All Types \*
>
> CM = Company
>
> CP = Cooperative
>
> CR = Corporation
>
> GA = Government Agency
>
> HA = Homeowner's Association
>
> IN = individual
>
> NP = non profit
>
> OT = Other
>
> RU = Rate Set Utility
>
> TP = Treatment Plant
>
> TR = Trust
>
> WS = Water System (A.2.1.1.1.a)

When invoked from the Legal Entity function, \*Display All Types\* will
be the default value.

> Permitted values will be selected by entering the first letter of the
> desired value. If there is more than one permitted value starting with
> the same letter, entering the first letter the first time will bring
> up the first value (alphabetically), entering the letter a second time
> will bring up the second value (alphabetically) and so on.
>
> When invoked for the selection of a Collector, Individual will be the
> default value and will be protected. (A.2.1.1.1.b)
>
> When invoked for the selection of a regulating agency, Government
> Agency will be the default value and will be protected. (A.2.1.1.1.c)

[Tab Sequence:]{.underline}

\[Legal Entity\] Name, Legal Entity Type (when invoked from the Legal
Entity function), **Search**, **Cancel**, and **Help**.

[Buttons:]{.underline}

**Search** Will pass the provided search criteria and filter information
to the Legal Entity Maintenance List (Exhibit 2-3) for display of search
results.

> When invoked for the purpose of Collector selection list, only apply
> search to Individuals where Collector Indicator Code is equal to "Y."
> If only a single collector is found in the search, it will be
> displayed on the Individual Maintenance page and the Legal Entity
> Maintenance List will not be presented. (A.2.1.1.1.d)
>
> Search Options:

-   
-   
-   
-   

If only Name is provided, will search for LEGAL_ENTITIES with names
equal to or greater than the supplied value.If only Type Code is
provided, will search for LEGAL_ENTITIES with type codes equal to the
selected value. (Display All will list all values.)If Name and Type Code
are provided, will search for LEGAL_ENTITIES with type codes equal to
the selected value and names equal to and greater than the supplied
value.If neither are provided, will list all LEGAL_ENTITIES.

**Cancel** Will close the Search page and return the user to the page
from where the Search was called.

**Help** Will invoke online Help for this page.

**2.1.1.2 Legal Entity Maintenance List**

The Legal Entity Maintenance List (Exhibit 2-3) will display the results
of the Legal Entity Search in ascending Name order. The page can list a
maximum of 1000 legal entities. If more than 1000 show as resulting from
the search criteria, the search will need to be narrowed to view fewer
Legal Entities.

[List Columns:]{.underline}

Name, Type, Organization, Mailstop, Address Line 1, Address Line 2,
City, State, Zip, Phone, and FedRep ID (which consists of
TINLGENT_ST_CODE concatenated to TINLGENT_IS_NUMBER). (A.2.1.1.2.a)

The phone number will list the business phone number from the
LEGAL_ENTITY_COMMUNICATION with a purpose_code = 'BUS'. If there is no
business phone or any other phone number, the phone number will be
blank. If more than one business phone number is present, it will list
the first one found. If there is no business phone, but there is one or
more other phone numbers, it will list the first one found.
(A.2.1.1.2.b)

When the page is functioning as a Regulating Agency Selection List, the
list will contain only Government Agency (GA) type LEGAL_ENTITIES with
their regulating_agency_indicator set to 'Y'. (B.2.1.1.2.a) Under this
condition the Type column will be modified to display the specific
government_agency type_code. (A.2.1.1.2.c)

In all other situations the Type column will display the LEGAL_ENTITY
type_code. (A.2.1.1.2.d)

  --------------------------------------------------- ----------------------------------------------------
  ![](media/image5.png){width="1.742361111111111in"   ![](media/image6.png){width="4.0152777777777775in"
  height="4.497222222222222in"}                       height="3.2444444444444445in"}

  --------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484608 .anchor}**Exhibit 2-3.** Legal Entity
Maintenance List

When the page is functioning as the Collector Maintenance List, the list
will contain only Individual (IN) type LEGAL_ENTITIES that have been
indicated as being collectors. (A.2.1.1.2.e)

[Menu Items:]{.underline}

**File**

*Exit* Will return the user to the requesting page.

**Edit**

*Add* Will be available whether or not legal entity is highlighted in
the list box. (A.2.1.1.2.f)

> *Individual* Will present the Individual Maintenance page in Add mode.

*Government*

> *Agency* Will present the Government Agency Maintenance page in Add
> mode.

*Other* Will present the Legal Entities Maintenance page in Add mode.

*Change* Will invoke the Individual, Government Agency, or Legal
Entities Maintenance page in Change mode as determined by the Type of
the Legal Entity highlighted in the list box.

> This item will be available only if a legal entity is highlighted in
> the list box.

Double-clicking a Legal Entity in the list will react as a change menu
item selection.

> *Select* Will return the selected Legal Entity to the requesting page.
>
> This item will only be available if the list is invoked by a page
> requesting a selection and a selection has been highlighted in the
> list box. (A.2.1.1.2.g)

*Delete* Will be available only if a legal entity is highlighted in the
list box. The following conditions will result in a conflict denial of
the delete request:

> The Legal Entity:

-   

> Is a contact for a Water System, Water System Facility, or Laboratory,
> the Legal Entity Assignment List will be presented.

-   

> HQ Record (a Legal Entity with "HQ" in its State_Code). The following
> error message will be invoked: **This is maintained as a
> federally-owned reference record and cannot be removed.**

-   

Approves Standard Method Number. The following error message will be
invoked: **This is maintained as a federally-owned reference record and
cannot be removed.**

> Additionally for Individuals:

-   

> Collects Samples. The Legal Entity Assignment List will be presented.

-   

> Administers Compliance Schedules. The Legal Entity Assignment List
> will be presented.

-   

> Is responsible for Enforcement Actions. The Legal Entity Assignment
> List will be presented.

-   

> Provides assistance actions. The following error message will be
> invoked: **Legal entity cannot be deleted, association to assistance
> action exists.**
>
> Additionally for Government Agencies:

-   

> Is a Regulating Agency. The Legal Entity Assignment List will be
> presented.

-   

> Associated to violations. The following error message will be invoked:
> **Legal Entity delete disallowed. Legal Entity is a Gov't Agency for a
> Violation.**

-   

> Establishes Rules or Monitoring Requirements. The following error
> messages will be invoked: **Legal Entity delete disallowed. Legal
> Entity is a Gov't Agency for a Rule**; **Legal Entity delete
> disallowed. Legal Entity is a Gov't Agency for a Monitoring Rqmt.**

-   

> Applies Standard Responses. The Legal Entity Assignment List will be
> presented.

-   

> Takes Enforcement Action. The Legal Entity Assignment List will be
> presented.

-   

> Sponsors Site Visits. The Legal Entity Assignment List will be
> presented.

-   

> Establishes Compliance Schedules. The Legal Entity Assignment List
> will be presented.

Exhibit 2-4 depicts the Legal Entity Assignment List.

  ---------------------------------------------------- ---------------------------------------------------
  ![](media/image7.png){width="1.8006944444444444in"   ![](media/image8.png){width="4.041666666666667in"
  height="7.8694444444444445in"}                       height="7.89375in"}

  ---------------------------------------------------- ---------------------------------------------------

[]{#__RefHeading___Toc86484609 .anchor}**Exhibit 2-4.** Legal Entity
Assignment List

> [Legal Entity Assignment List Buttons]{.underline}

**Scroll**

**Buttons** Will scroll the list box in the direction of the arrow
displayed on the button.

> **OK** Will close the page and return to the maintenance list.
>
> **Help** Will invoke the system online Help facility.
>
> If the Legal Entity does not meet any of criteria listed for
> preventing the deletion, will present a confirmation question (Exhibit
> 2-5) requiring selection of **OK** or **Cancel** prior to removing the
> Legal Entity from the Legal Entity Maintenance list.

![](media/image9.png){width="4.103472222222222in"
height="2.1458333333333335in"}

[]{#__RefHeading___Toc86484610 .anchor}**Exhibit 2-5.** Delete Legal
Entity

[Delete Legal Entity Buttons:]{.underline}

> **OK** Will delete the legal entity and the Legal Entity Maintenance
> List will be redisplayed with the deleted Legal Entity removed. It
> cannot be retrieved.
>
> When deleted the following deletions may also occur:

-   
-   
-   

> If the Legal Entity has an associated INDIVIDUAL, the INDIVIDUAL will
> be removed.If the Legal Entity has an associated GOVERNMENT AGENCY,
> the GOVERNMENT AGENCY will be removed.If the Legal Entity is an
> INDIVIDUAL identified as a system user the D_USER will be removed.
>
> \- If the Legal Entity has one or more associated
> LEGAL_ENTITY_COMMUNICATION(s), the LEGAL_ENTITY_COMMUNICATION(s) will
> be removed. (A2.1.1.2.h)
>
> **Cancel** Will abort the delete request and return the user to the
> Legal Entity Maintenance List.

**View**

*Search* Will open the Legal Entity Search page described above.
Previously used search criteria will be present in the page display.
(A.2.1.1.2.i)

If the page is functioning as a Collector Selection list the type will
be pre-selected as 'INDIVIDUAL' and protected. (A.2.1.1.2.j)

If the page is functioning as a Regulating Agency Selection list the
type will be pre-selected as 'Government Agency' and
protected.(A.2.1.1.2.k)

*Sort* Will open the standard sort page where the list may be sorted by
Name, Legal Entity Type, Organization, Mailstop, City, State, Zip and/or
FedRep ID. (A.2.1.1.2.l)

*Filter* Will open the standard filter page where a value may be entered
for Name, Legal Entity Type, Organization, Mailstop, City, State, Zip or
FedRep ID. (A.2.1.1.2.m) This value will be used to display only Legal
Entities matching the filter criteria.

Using the Filter item will remove some Legal Entities from the list box
display. The Number of Rows Displayed will show a count of the Legal
Entities resulting from the filter.

*Refresh* Will remove the Filter parameters and display up to 1000 rows
resulting from the search criteria.

> This menu item will be available only if the list box was previously
> filtered.

[Default Sort Order:]{.underline}

Ascending Legal Entity Name order. Individual legal entities are listed
Last Name first.

[Protected Fields:]{.underline}

*Number of rows*

*resulting from the*

*Search Criteria Used:* This value will indicate the number of Legal
Entities found in the database that matched the search criteria.

*Number of rows*

*Displayed:* This value will indicate the number of Legal Entities
available for viewing in the list box via the vertical scroll bar. The
list will be limited to 1000 legal entities. This value can be reduced
by using the **View/Filter** menu item. To view the legal entities
beyond 1000, more specific search criteria will need to be provided.

[Buttons]{.underline}:

**Menu Items** Will present the standard menu items dialog box.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

**2.1.1.3 Individual Maintenance**

The Individual Maintenance page (Exhibit 2-6) will be invoked from the
Search page or the maintenance list.

  ----------------------------------------------------- ----------------------------------------------------
  ![](media/image10.png){width="1.8965277777777778in"   ![](media/image11.png){width="3.921527777777778in"
  height="4.625694444444444in"}                         height="4.5680555555555555in"}

  ----------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484611 .anchor}**Exhibit 2-6.** Individual
Maintenance

[Protected Items:]{.underline}

*FedRep ID* The FedRep ID represents the LEGAL_ENTITY internal system
number and state code that is used as the unique identifier for federal
reporting. This is the value that SDWIS/FedRep extracts to uniquely
identify the Legal Entity. (A.2.1.1.3.k)

[Entry Fields:]{.underline}

*Salutation* The salutation or greeting for an individual. Values in the
dropdown list will be populated from the CODE PERMITTED_VALUE table
using code_name 'LESAL' that is maintained by the system administrator.
(A.2.1.1.3.a)

> The Salutation field will be optional.

*First Name & Initial* An individual's first name plus a middle initial.

> First Name and Initial will be a required field.

*Last Name* An individual's last name.

> Last Name will be a required field.

*Alias Name* The alias, common name, or acronym for a legal entity.

*(B.2.1.1.3.a)*

> The Alias Name field will be optional.

*Prof Qualification* The professional qualification of an individual,
such as CPA, PE, Rev., MD, RN, Esq., or Ph.D.

> The Prof Qualification field will be optional.

*Collector* When checked, this checkbox will indicate that the
Individual Maintenance information being entered is for a Collector.

> The Collector field will be optional.

*Operator Class* The certification class that an operator has achieved.
(A.2.1.1.3.b)

The operator class field will be optional.

*Organization* Identifies the individual's organization. The
Organization field will not be mandatory on the Individual Maintenance
page. It can be used to allow two or more individuals of the same first
name and last names to exist in the database.

> The Organization field will be optional.

*ID No.* An identification number of the legal entity. May be provided
by an external source such as employer or internal revenue service.
(A.2.1.1.3.d)

> The ID No. field will be optional.

*Job Title* The professional job title of an individual. Examples
include legal owner, general manager, engineer, and accountant.

> The Job Title field will be optional.

*Phone Numbers*

*\[List box\]* This list box displays the phone numbers recorded for the
legal entity in ascending Legal_Entity_Communication IS Number order.
All phone numbers will be optional. Only one selection may be made at a
time. Selection will enable the Modify and Delete buttons. (A.2.1.1.3.e)

> *Purpose* The purpose of the phone number indicates what the phone
> number could be used for. Permitted values for Purpose are maintained
> by the system administrator.
>
> *Phone Number* The phone number including area code in format
> XXX-XXX-XXXX.
>
> *Extension* The office extension of the phone number, expanded to five
> digits.

*Electronic Addresses*

*\[List Box\]* This list box will list the purpose and address of
electronic addresses recorded for the legal entity in ascending
Legal_Entity_Communication IS Number order. All electronic addresses
will be optional. One electronic address may be selected at a time.
Selection will enable the Modify and Delete buttons. (A.2.1.1.3.f)

*Purpose* The purpose of the electronic address indicates what the
address could be used for. Permitted values for Purpose are maintained
by the system administrator.

*Address* The government agency's electronic address.

*Address Line One* The first line of an address for a legal entity. This
line should be specified only as needed. If a responsible person or
agency is unavailable and the street address consists of only a single
line, the user may use only Address Line Two. The user may use this line
for the street address, rural route, P.O. Box, etc.

> The Address Line One field will be optional.

*Address Line Two* The second line of an address for the individual.
This line contains the street address, rural route, etc.

> The Address Line Two field will be optional.

*City* The city in which the legal entity is located.

> The City field will be optional.

*State* The two‑letter U.S. Postal Service (USPS) state abbreviation for
the legal entity's state when country is United States, the province
code when country is Canada (CA) or any other state or territorial code
for other country designations.

When country is United States and a value is supplied, the state code
must be one of the valid USPS state code abbreviations. (A.2.1.1.3.g)

> When country is CA (Canada) and a value is supplied, one of the
> following Canadian province codes must be entered in the State field:
>
> **Province Name Code Province Name Code**
>
> Alberta AL Nova Scotia NS
>
> British Columbia BC Nunavut NU
>
> (A2.1.1.3.h)
>
> Manitoba MB Ontario ON
>
> New Brunswick NB Prince Edward Island PE
>
> Newfoundland NF Quebec PQ
>
> Northwest Territories NT Saskatchewan SK
>
> Yukon Territory YT
>
> The State field will be optional.

*Zip* The U.S. Postal Service (USPS) zip code for the legal entity plus
the optional Zip+4 extension.

> This field will be unavailable if the value of the Country field is
> other than United States.
>
> The Zip field will be optional.

*Mail Stop* The mail stop or location for an individual. The Mail Stop
field will not be mandatory on the Individual Maintenance page but can
be used to allow two or more individuals of the same first name and last
names to exist in the database.

> The Mail Stop field will be optional.

*Country* A dropdown list where values from the CODE PERMITTED_VALUES
will be listed using code_name value 'TINLGENT1'. The default for
Country will be United States. (A.2.1.1.3.i)

> If the Country is United States, the Zip field will be made available
> and the International Postal Code field will be grayed out and
> protected. If the Country is other than United States, the Zip field
> will be grayed out and protected, and the International Postal Code
> will be made available. If the Country field contains spaces, the Zip
> field will be blanked out and made available, and the International
> Postal Code field will be grayed out and protected.
>
> The Country field will be optional.

*International Postal*

*Code* The postal zone for any selected country in the Country field
other than the US.

> This field will be available only if the Country field has a value
> other than United States or spaces.
>
> The International Postal Code field will be optional.

*Comments* A text field where free-form comments can be recorded about
the individual. (A.2.1.1.3.j)

The Comments field will be optional.

When tabbing through the fields, the cursor should stop only once in the
comments field and not create word-processing tabs within the field.

Text should word-wrap within the comments.

[Tab Sequence:]{.underline}

Salutation, First Name & Initial, Last Name, Alias Name (B.2.1.1.3.b),
Prof Qualification, Collector, Operator Class, Organization, ID No., Job
Title, Phone Numbers List Box, **Add, Modify, Delete,** Electronic
Addresses**, Add, Modify, Delete, Email/Url Launch,** Address Line One,
Address Line Two, City, State, Zip, Mail Stop, Country, International
Postal Code, Comments, **List POC, OK**, **Cancel**, and **Help**.
(A.2.1.1.3.l)

[Buttons:]{.underline}

**Add *\[New Phone***

***Number\]*** Will present the Communication Maintenance Page in add
mode where a new phone number can be entered for the individual. The new
number will not actually be committed to the database until the **OK**
button is selected on the Individual Maintenance page. (A.2.1.1.3.m)

**Modify *\[Phone ***

***Number\]*** Will present the Communication Maintenance Page in change
mode where the selected phone number can be modified for the individual.
The change will not actually be committed to the database until the
**OK** button is selected on the Individual Maintenance page.
(A.2.1.1.3.n)

This button will be enabled when a phone number is selected in the list
box.

**Delete *\[Phone***

***Number\]*** Will present the standard delete confirmation page prior
to deleting the LEGAL_ENTITY_COMMUNICATION row. The phone number will be
marked for delete, removed from the list box, and committed when the
**OK** button is selected on the Individual Maintenance page. If
**CANCEL** is selected the phone number will not be deleted.
(A.2.1.1.3.o)

This button will be enabled when a phone number is selected in the list
box.

**Add *\[New Electronic Address\]***

Will present the Communication Maintenance Page in add mode where a new
electronic address can be entered for the individual. The new electronic
address will not actually be committed to the database until the **OK**
button is selected on the Individual Maintenance page. (A.2.1.1.3.p)

**Modify *\[Electronic Address\]***

Will present the Communication Maintenance Page in change mode where the
selected electronic address can be modified for the individual. The
change will not actually be committed to the database until the **OK**
button is selected on the Individual Maintenance page. (A.2.1.1.3.q)

This button will be enabled when an electronic address is selected in
the list box.

**Delete *\[Electronic Address\]***

Will present the standard delete confirmation page prior to deleting the
LEGAL_ENTITY_COMMUNICATION row. The electronic address will be marked
for delete, removed from the list box, and committed when the **OK**
button is selected on the Individual Maintenance page. If **CANCEL** is
selected the electronic will not be deleted. (A.2.1.1.3.r)

This button will be enabled when an electronic address is selected in
the list box.

**Email/URL Launch** Will present the Web Launch page. The page will
display a list of the electronic addresses for the Individual. See
Chapter 1 for further discussion and description of this functionality.
(B.2.1.1.3.c)

This button will be enabled when an electronic address is present in the
list box.

**List POC** Will present the Point of Contact Assignment List
containing the list of water systems and water system facilities for
which the individual is a designated POC. (A.2.1.1.3.s)

**OK** The **OK** button will have the following edits:

-   

> First Name & Initial must have a value. The following error message
> will be invoked: **Individual first name cannot be blank.**

-   

> Last Name must have a value. The following error message will be
> invoked: **Individual last name cannot be blank.**

-   

> If Zip contains a value, it must be numeric and at least five
> characters long. If greater than five, it must be equal to nine. A
> hyphen may be in position six but it not the hyphen will be inserted.
> If these conditions are not satisfied, the following error message
> will be invoked: **Zip Code can only be NNNNN, NNNNNNNNN, or
> NNNNN-NNNN where N is a numeric char.**

-   

> If Country is CA (Canada), then State must contain a valid Canadian
> province code if a value is supplied in the State field. If not, the
> following error message will be invoked: **If country Canada, State CD
> must be valid province abbrev. See online HELP.**

-   

If Country is US (United States), then State must contain a valid USPS
state abbreviation code if a value is supplied in the State field. If
not, the following error message will be invoked: **If country US, State
CD must be valid state abbrev.** (A.2.1.1.3.t)

> The **OK** button will have the following duplicate check:
>
> The proposed Individual must be a Legal Entity where the combination
> of Legal Entity Name, Type Code, and State_Code is unique. For the
> Individual, the combination of First Name, Last Name, Mailstop, and
> Organization must be unique. If neither of these conditions is
> satisfied, the following error message will be invoked: **Duplicate
> Individual found.**
>
> The value in LEGAL_ENTITY Name will be populated by concatenating the
> last name followed by a comma, a space, and the first name and
> initial. Example: Public, John Q.

Add-Mode

Processing Pressing **OK** in Add mode will create a new Legal_Entity
and Individual and tie the two together. An external system number will
be system generated for the Legal_Entity using the
Entity_Internal_System_Number for Table Name TINLGENT.

> Telephone numbers and Electronic addresses will generate a new row in
> LEGAL_ENTITY_COMMUNICATION for each item in the list box. These will
> be system numbered sequentially within the LEGAL_ENTITY number.
> (A.2.1.1.3.u)
>
> Field FedRep ID will be populated using the generated Legal Entity IS
> Number and St Code. (A.2.1.1.3.w)
>
> Upon successful completion, the Legal Entity Maintenance List will be
> presented with previous search criteria. (B.2.1.1.3.d) Note: Addition
> of an Individual that does not meet the previous search criteria used
> will result in the new row being absent from the display.

Change-Mode

Processing: Pressing **OK** in Change mode will update the LEGAL_ENTITY
and INDIVIDUAL tables with the modified information. If the INDIVIDUAL
is also a LABORATORY then the name of the associated LABORATORY will be
updated if the name has been changed.

> When successful, the Individual Maintenance page will close and the
> Legal Entity Maintenance List will be displayed with the new
> information.
>
> Additions, deletions, or modifications to telephone numbers and
> electronic addresses will also commit to the
> LEGAL_ENTITY_COMMUNICATION table at this time. (A.2.1.1.3.v)
>
> When successful, the Individual Maintenance page will close and the
> Legal Entity Maintenance List will be displayed with the information
> using the previous search criteria. (B.2.1.1.3.e) Note: Modification
> of an Individual that does not meet the previous search criteria used
> will result in the new row being absent from the display.

**Cancel** Will close the maintenance page. If changes have been made to
the maintenance information, a confirmation dialog box will be presented
(Exhibit 2-7) requiring selection of **Yes**, **No**, or **Cancel**.

> The Cancel Confirm dialog box will be invoked when the user presses
> the **Cancel** button after making changes on the maintenance window
> with the **No** button selected.

![](media/image12.png){width="3.1972222222222224in"
height="1.6041666666666667in"}

[]{#__RefHeading___Toc86484612 .anchor}**Exhibit 2-7.** Cancel Confirm

[Cancel Confirm Buttons:]{.underline}

**Yes** Pressing **Yes** will initiate processing as if the **OK**
button was pressed from the maintenance page. Refer to documentation for
the maintenance page's **OK** button for details of edit.

**No** Pressing **No** will discard all changes and return the user to
the maintenance list.

**Cancel** Pressing **Cancel** will return the user to the maintenance
page with all data intact. The database will not have been affected by
the information on the maintenance page.

**Help** Will invoke online Help for this page.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

**2.1.1.4 Government Agency Maintenance**

The Government Agency Maintenance page (Exhibit 2-8) will be invoked
from the Legal Entity Maintenance List.

  ----------------------------------------------------- -----------------------------------------------------
  ![](media/image13.png){width="1.7173611111111111in"   ![](media/image14.png){width="3.8944444444444444in"
  height="4.750694444444444in"}                         height="4.747222222222222in"}

  ----------------------------------------------------- -----------------------------------------------------

[]{#__RefHeading___Toc86484613 .anchor}**Exhibit 2-8.** Government
Agency Maintenance

[Protected Fields:]{.underline}

*FedRep ID* The FedRep ID represents the LEGAL_ENTITY internal system
number and state code that is used as the unique identifier for federal
reporting. (A.2.1.1.4.a)

[Entry Fields:]{.underline}

*GA Type* (A.2.1.1.4.b)

A code identifying the type of government agency. If the Primacy
Indicator checkbox is checked, the government agency Type must be
defined as either Regional or State. Permitted entries include the
following (A.2.1.1.4.y):

> AR-Alaskan Remote Village
>
> AT-Authority
>
> BR-Borough
>
> CM-Commission
>
> CN-County
>
> CT-City
>
> DS-District
>
> FD-Federal
>
> MN-Municipality
>
> NA-Native American Tribe
>
> PR-Parish
>
> RG-Region
>
> SA-State Administrative District
>
> SD-School District
>
> SR-State Administrative Region
>
> ST-State
>
> TW-Town
>
> WD-Water District
>
> The Type field will be optional.

*Name* The name of a legal entity associated with a water system. This
is the proper name as it appears on legal or other official documents.

> Name will be a required field.

*Alias Name* The alias, common name, or acronym for a legal entity.

> The Alias Name field will be optional.

*Primacy*

*Indicator* If the government agency has primary enforcement
responsibility for maintenance of water quality, this checkbox should be
checked. Checking this box will automatically check the Regulating
Agency indicator and protect it from modification. (B.2.1.1.4.a)

> The Primacy Indicator field will be optional.

*Regulating Agency*

*Indicator*

*(B.2.1.1.4.b)* Can be checked to indicate that the government agency is
designated as a regulating agency. This field will automatically be
checked and protected if the Primacy Indicator is marked. When the
primacy indicator is unmarked this field will become available for
modification.

The Regulating Agency Indicatory will be optional.

*EPA Region* A number indicating the EPA region to which the government
agency reports or the EPA region in which it is located. Permitted
entries will include the following:

> 1 Region 1 (Boston)
>
> 2 Region 2 (New York)
>
> 3 Region 3 (Philadelphia)
>
> 4 Region 4 (Atlanta)
>
> 5 Region 5 (Chicago)
>
> 6 Region 6 (Dallas)
>
> 7 Region 7 (Kansas City)
>
> 8 Region 8 (Denver)
>
> 9 Region 9 (San Francisco)
>
> 10 Region 10 (Seattle)
>
> EPA Region is only allowed if the Government Agency type is State.

*Administrative*

*ID No.* The identification number used by the primacy agency to
classify the government agency. This number may be a region or district
number or the Federal Information Processing System (FIPS) code for that
government agency.

> Administrative ID No. will be an optional field.

*ID No.* An identification number of the legal entity. May be provided
by an external source such as employer or internal revenue service.
(A.2.1.1.4.c)

> The ID No. field will be optional.

*Phone Numbers*

*\[List box\]* This list box displays the phone numbers recorded for the
legal entity in ascending Legal_Entity_Communication IS Number order.
All phone numbers will be optional. Only one selection may be made at a
time. Selection will enable the Modify and Delete buttons. (A.2.1.1.4.d)

*Purpose* The purpose of the phone number indicates what the phone
number could be used for. Permitted values for Purpose are maintained by
the system administrator.

*Phone Number* The phone number including area code in format
XXX-XXX-XXXX.

*Extension* The office extension of the phone number.

*Electronic Addresses*

*\[List Box\]* This list box will list the purpose and electronic
addresses recorded for the legal entity in ascending
Legal_Entity_Communication IS Number order. All electronics will be
optional. One electronic address may be selected at a time. Selection
will enable the Modify and Delete buttons. (A.2.1.1.4.e)

*Purpose* The purpose of the electronic address indicates what the
address could be used for. Permitted values for Purpose are maintained
by the system administrator.

*Address* The government agency's electronic address.

*Address Line One* The first line of an address for a legal entity. This
line should be specified only as needed. If a responsible person or
agency is unavailable and the street address consists of only a single
line, the user may use only Address Line Two.

> The Address Line One field will be optional.

*Address Line Two* The second line of an address for the individual.
This user may use this line for the street address, rural route, etc.

> The Address Line Two field will be optional.

*City* The city in which the legal entity is located.

> The City field will be optional.

*State* The two‑letter USPS state abbreviation for the legal entity's
state when country is United States, the two-letter province code when
country is CA (Canada) or any other territorial code for all other
countries.

When country is United States and a value is supplied, the state code
must be one of the valid USPS state code abbreviations. (A.2.1.1.4.f)

> When country is CA (Canada) and a value is supplied, one of the
> following Canadian province codes must be entered in the State field:
>
> **Province Name Code Province Name Code**
>
> Alberta AL Nova Scotia NS
>
> British Columbia BC Nunavut NU (A2.1.1.4.g)
>
> Manitoba MB Ontario ON
>
> New Brunswick NB Prince Edward Island PE
>
> Newfoundland NF Quebec PQ
>
> Northwest Territories NT Saskatchewan SK
>
> Yukon Territory YT
>
> The State field will be optional.

*Zip* The USPS zip code for the legal entity plus the optional Zip+4
extension.

> This field will be unavailable if the value of the Country field is
> other than United States.
>
> The Zip field will be optional.

*Country* A dropdown where values from the CODE PERMITTED_VALUES will be
listed using code_value 'TINLGENT1'. The default for Country will be
United States. (A.2.1.1.4.h)

> If the Country is United States, the Zip field will be made available
> and the International Postal Code field will be grayed out and
> protected. If the Country is other than United States, the Zip field
> will be grayed out and protected, and the International Postal Code
> will be made available. If the Country field contains spaces, the Zip
> field will be blanked out and made available, and the International
> Postal Code field will be grayed out and protected.
>
> The Country field will be optional.

*International*

*Postal Code* The postal zone for any selected country in the Country
field other than the US.

> This field will be available only if the Country field has a value
> other than US.
>
> The International Postal Code field will be optional.

*Comments* A text field where free-form comments can be recorded about
the government agency. (A.2.1.1.4.i)

The Comments field will be optional.

When tabbing through the fields, the cursor should stop only once in the
comments field and not create word-processing tabs within the field.
(A.2.1.1.4.j)

Text should word-wrap within the comments. (A.2.1.1.4.k)

[Tab Sequence:]{.underline}

[]{.mark}

Type, Name, Alias Name, Primacy Indicator, Regulating Agency Indicator
(B.2.1.1.4.c), EPA Region, Administrative ID No., ID No., Phone Numbers
List Box, **Add, Modify, Delete**, Electronic Addresses List Box, **Add,
Modify, Delete**, **Email/Url Launch,** Address Line One, Address Line
Two, City, State, Zip, Country, International Postal Code, Comments,
**List POC**, **OK**, **Cancel**, and **Help**. (A.2.1.1.4.l)

[Buttons:]{.underline}

**Add *\[New Phone***

***Number\]*** Will present the Communication Maintenance Page in add
mode where a new phone number can be entered for the individual. The new
number will not actually be committed to the database until the **OK**
button is selected on the Legal Entity/Individual/Government Agency
Maintenance page. (A.2.1.1.4.m)

**Modify *\[Phone ***

***Number\]*** Will present the Communication Maintenance Page in change
mode where the selected phone number can be modified for the individual.
The change will not actually be committed to the database until the
**OK** button is selected on the Legal Entity/Individual/Government
Agency page. (A.2.1.1.4.n)

This button will be enabled when a phone number is selected in the list
box.

**Delete *\[Phone***

***Number\]*** Will present the standard delete confirmation page prior
to deleting the LEGAL_ENTITY_COMMUNICATION row. The phone number will be
marked for delete, removed from the list box, and committed when the
**OK** button is selected on the Legal Entity/Individual/Government
Agency Maintenance page. If **CANCEL** is selected the phone number will
not be deleted. (A.2.1.1.4.o)

This button will be enabled when a phone number is selected in the list
box.

**Add *\[New Electronic Address\]***

Will present the Communication Maintenance Page in add mode where a new
electronic address can be entered for the individual. The new electronic
address will not actually be committed to the database until the **OK**
button is selected on the Legal Entity/Individual/Government Agency
page. (A.2.1.1.4.p)

**Modify *\[Electronic Address\]***

Will present the Communication Maintenance Page in change mode where the
selected electronic address can be modified for the individual. The
change will not actually be committed to the database until the **OK**
button is selected on the Legal Entity/Individual/Government Agency
page. (A.2.1.1.4.q)

This button will be enabled when an electronic address is selected in
the list box.

**Delete *\[Electronic Address\]***

Will present the standard delete confirmation page prior to deleting the
LEGAL_ENTITY_COMMUNICATION row. The electronic will be marked for
delete, removed from the list box, and committed when the **OK** button
is selected on the Legal Entity/Individual/Government Agency Maintenance
page. If **CANCEL** is selected the electronic will not be deleted.
(A.2.1.1.4.r)

> This button will be enabled when an electronic address is selected in
> the list box.

**Email/URL Launch** Will present the Web Launch page. The page will
display a list of the electronic addresses for the Government Agency.
See Chapter 1 for further discussion and description of this
functionality. (B.2.1.1.4.d)

This button will be enabled when an electronic address is present in the
list box.

**List POC** Will present the Point of Contact Assignment List
containing the list of water systems and water system facilities for
which the government agency is a designated POC. (A.2.1.1.4.s)

**OK** The **OK** button will have the following edits:

-   

> Name must have a value. The following error message will be invoked:
> **Name must not be blank.**

-   

> If the Primacy Indicator box is checked, the Type must be either
> Region or State; otherwise, the following error message will be
> invoked: **The Primacy Agency must be defined as Regional (RG) or
> State (ST).**

-   

> If the EPA Region number is provided, the Type must be State;
> otherwise, the following error message will be invoked: **Regional
> Codes should only be specified for states.**

-   

> If Zip contains a value, it must be numeric and at least five
> characters long. If greater than five, it must be equal to nine. A
> hyphen may be in position 6 and if not one will be inserted. If these
> conditions are not satisfied the following error message will be
> invoked: **Zip Code can only be NNNNN, NNNNNNNNN, or NNNNN-NNNN where
> N is a numeric char.**

-   

> If Country is US (United States), then State must contain a valid USPS
> state abbreviation code if a value is supplied in the State field;
> otherwise, the following error message will be invoked: **If country
> US, State CD must be valid state abbrev.** (A.2.1.1.4.t)

-   

> If Country is CA (Canada), then State must contain a valid Canadian
> province code if a value is supplied in the State field; otherwise,
> the he following error message will be invoked: **If country Canada,
> State CD must be a valid province abbrev. See online HELP.**
> (A.2.1.1.4.x)
>
> The **OK** button will have the following duplicate checks:
>
> The proposed Government Agency must be a Legal Entity where the
> combination of Legal Entity Name, Type Code, and State_Code is unique
> ~~and for Government Agency, the combination of Administrative ID No.
> and Government Agency Type is unique~~. If this condition is not
> satisfied, the following error message will be invoked: **Duplicate
> Government Agency found.** C.2.1.1.4.a

-   

If the Primacy Indicator checkbox is checked, there must not exist
another Government Agency in the database that has already been
indicated as having Primacy. If the user checks the Primacy Indicator,
the software will check that no other Government Agency has the Primacy
Indicator checked; if it does, the following error message will be
invoked: **A Primacy Government Agency already exists for this
database.**

Add-Mode

Processing: Pressing **OK** in Add mode will create a new LEGAL_ENTITY
and GOVERNMENT AGENCY and tie the two together. An external system
number will be system generated for the LEGAL_ENTITY using the
ENTITY_INTERNAL_SYSTEM_NUMBER for entity name TINLGENT.

> Telephone numbers and Electronic addresses will generate a new row in
> LEGAL_ENTITY_COMMUNICATION for each item in the list box. These will
> be system numbered sequentially within the LEGAL_ENTITY number.
> (A.2.1.1.4.u)
>
> Field FedRep ID will be populated using the generated Legal Entity IS
> Number and St Code. (A.2.1.1.4.w)
>
> Upon successful completion, the Legal Entity Maintenance List will be
> presented with previous search criteria. (B.2.1.1.4.e) Note: Addition
> of a government agency that does not meet the previous search criteria
> will result in its absence from the resulting display.

Change-Mode

Processing: Pressing **OK** in Change mode will update the LEGAL_ENTITY
and GOVERNMENT_AGENCY tables with the modified information.

> Additions, deletions, or modifications to telephone numbers and
> electronic addresses will also commit to the
> LEGAL_ENTITY_COMMUNICATION table at this time. (A.2.1.1.4.v)
>
> When successful, the Government Agency Maintenance page will close and
> the Legal Entity Maintenance List will be displayed with the
> information using the previous search criteria. (B.2.1.1.4.f) Note:
> Modification of a government agency that does not meet the previous
> search criteria will result in its absence from the resulting display.

**Cancel** Will close the maintenance page. If changes have been made to
the maintenance information, a confirmation dialog box will be presented
(Exhibit 2-8) requiring selection of **Yes**, **No**, or **Cancel**.

The Cancel Confirm dialog box will be invoked when the user presses the
**Cancel** button after making changes on the maintenance. The No button
will be the default.

**Help** Will invoke online Help for this page.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

**2.1.1.5** **Legal Entity Maintenance**

The Legal Entity Maintenance page (Exhibit 2-9) will be invoked from the
Search page or the maintenance list.

[Protected Items:]{.underline}

*FedRep ID* The FedRep ID represents the LEGAL_ENTITY internal system
number and state code that is used as the unique identifier for federal
reporting. (A.2.1.1.5.a)

[Entry Fields:]{.underline}

*Legal Entity Type* The type of legal entity. Permitted entries will be:

> Company
>
> Cooperative
>
> Corporation
>
> Homeowners Association

  ---------------------------------------------------- -----------------------------------------------------
  ![](media/image15.png){width="1.926388888888889in"   ![](media/image16.png){width="3.8652777777777776in"
  height="5.127083333333333in"}                        height="4.78125in"}

  ---------------------------------------------------- -----------------------------------------------------

[]{#__RefHeading___Toc86484614 .anchor}**Exhibit 2-9.** Legal Entity
Maintenance

> Non‑Profit
>
> Rate Set Utility
>
> Trust
>
> Treatment Plant
>
> Other
>
> Water System (A.2.1.1.5.b)
>
> Legal Entity Type will be a required field.

*Name* The name of a legal entity associated with a water system. This
is the proper name as it appears on legal or other official documents.

> Name will be a required field.

*Alias Name* The alias, common name, or acronym for a legal entity.

The Alias Name field will be optional.

*ID No.* An identification number of the legal entity. May be provided
by an external source such as employer or internal revenue service.
(A.2.1.1.5.c)

> The ID No. field will be optional.

*Phone Numbers*

*\[List Box\]* This list box displays the phone numbers recorded for the
legal entity in ascending internal number order. All phone numbers will
be optional. Only one selection may be made at a time. Selection will
enable the Modify and Delete buttons. (A.2.1.1.5.d)

*Purpose* The purpose of the phone number indicates what the phone
number could be used for. The permitted values for purposes are
maintained by the system administrator.

*Phone Number* The Phone Number of the legal entity, including the area
code.

> Example: 999‑999‑9999.

*Extension* The office extension of the phone number.

*Electronic Addresses*

> *\[List Box\]* This list box will list the purpose and electronic
> addresses recorded for the legal entity in ascending internal system
> number order. All electronics will be optional. One electronic may be
> selected at a time. Selection will enable the Modify and Delete
> buttons. (A.2.1.1.5.e)

*Purpose* The purpose of the electronic indicates what the address could
be used for. The permitted values for purposes are maintained by the
system administrator.

*Address* The legal entity's electronic address.

*Address Line One* The first line of an address for a legal entity. This
line should be specified only as needed. If a responsible person or
agency is unavailable and the street address consists of only a single
line, the user may use only Address Line Two. The user may use this line
for the street address, rural route, P.O. Box, etc.

> The Address Line One field will be optional.

*Address Line Two* The second line of an address for the individual.
This line will contain the street address, rural route, etc.

> The Address Line Two field will be optional.

*City* The city in which the legal entity is located.

> The City field will be optional.

*State* The two‑letter USPS state abbreviation for the legal entity's
state when country is United States, the province code when country is
Canada (CA), or any other state or territorial code for other country
designations.

When country is United States and a value is supplied, the state code
must be one of the valid USPS state code abbreviations. (A.2.1.1.5.f)

> When country is CA (Canada) and a value is supplied,
>
> one of the following Canadian province codes must be entered in the
> State field:
>
> **Province Name Code Province Name Code**
>
> Alberta AL Nova Scotia NS
>
> British Columbia BC Nunavut NU
>
> (A.2.1.1.5.g)
>
> Manitoba MB Ontario ON
>
> New Brunswick NB Prince Edward Island PE
>
> Newfoundland NF Quebec PQ
>
> Northwest Territories NT Saskatchewan SK
>
> Yukon Territory YT
>
> The State field will be optional.

*Zip* The USPS zip code for the legal entity plus the optional Zip+4
extension.

> This field will be unavailable if the value of the Country field is
> other than US.
>
> The Zip field will be optional.

*Country* A dropdown where values from the CODE PERMITTED_VALUES will be
listed using code_name 'TINLGENT1'. (A.2.1.1.5.h) The default for
Country will be United States.

> If the Country is United States, the Zip field will be made available
> and the International Postal Code field will be grayed out and
> protected. If the Country is other than United States, the Zip field
> will be grayed out and protected, and the International Postal Code
> will be made available. If the Country field contains spaces, the Zip
> field will be blanked out and made available, and the International
> Postal Code field will be grayed out and protected.
>
> The Country field will be optional.

*International*

*Postal Code* The postal zone for any selected country in the Country
field other than the United States.

> This field will be available only if the Country field has a value
> other than United States.
>
> The International Postal Code field will be optional.

*Comments* A text field where free-form comments can be recorded about
the legal entity. (A.2.1.1.5.i)

The Comments field will be optional.

> When tabbing through the fields, the cursor should stop only once in
> the comments field and not create word-processing tabs within the
> field. (A.2.1.1.5.j)

Text should word-wrap within the comments. (A.2.1.1.5.k)

[Tab Sequence:]{.underline}

[]{.mark}

Legal Entity Type, Name, Employer ID No., Alias Name, Phone Numbers,
**Add, Modify, Delete,** Electronic Addresses, **Add, Modify, Delete**,
**Email/Url Launch**, Address Line One, Address Line Two, City, State,
Country, \[Country\] **Go To**, International Postal Code, Comments,
**List POC, OK**, **Cancel**, and **Help**. (A.2.1.1.5.l)

[Buttons:]{.underline}

**Add *\[New Phone***

***Number\]*** Will present the Communication Maintenance Page in add
mode where a new phone number can be entered for the individual. The new
number will not actually be committed to the database until the **OK**
button is selected on the Legal Entity Maintenance page. (A.2.1.1.5.m)

**Modify *\[Phone ***

***Number\]*** Will present the Communication Maintenance Page in change
mode where the selected phone number can be modified for the individual.
The change will not actually be committed to the database until the
**OK** button is selected on the Legal Entity Maintenance page.
(A.2.1.1.5.n)

This button will be enabled when a phone number is selected in the list
box.

**Delete *\[Phone***

***Number\]*** Will present the standard delete confirmation page prior
to deleting the LEGAL_ENTITY_COMMUNICATION row. The phone number will be
marked for delete, removed from the list box, and committed when the
**OK** button is selected on the Legal Entity Maintenance page. If
**CANCEL** is selected the phone number will not be deleted.
(A.2.1.1.5.o)

This button will be enabled when a phone number is selected in the list
box.

**Add *\[New Electronic Address\] ***

Will present the Communication Maintenance Page in add mode where a new
electronic address can be entered for the legal entity. The new
electronic address will not actually be committed to the database until
the **OK** button is selected on the Legal Entity Maintenance page.
(A.2.1.1.5.p)

**Modify *\[Electronic Address\]***

Will present the Communication Maintenance Page in change mode where the
selected electronic address can be modified for the legal entity. The
change will not actually be committed to the database until the **OK**
button is selected on the Legal Entity Maintenance page. (A.2.1.1.5.q)

This button will be enabled when an electronic address is selected in
the list box.

**Delete *\[Electronic Address\]***

Will present the standard delete confirmation page prior to deleting the
LEGAL_ENTITY_COMMUNICATION row. The electronic will be marked for
delete, removed from the list box, and committed when the **OK** button
is selected on the Legal Entity Maintenance page. If **CANCEL** is
selected the electronic will not be deleted. (A.2.1.1.5.r)

This button will be enabled when an electronic is selected in the list
box.

**Email/Url Launch** Will present the Web Launch page. The page will
display a list of the electronic addresses for the Legal Entity. See
Chapter 1 for further discussion and description of this functionality.
(B.2.1.1.5.a)

This button will be enabled when an electronic address is present in the
list box.

**List POC** Will present the Point of Contact Assignment List
containing the list of water systems and water system facilities for
which the legal entity is a designated POC. (A.2.1.1.5.s)

**OK** The **OK** button will have the following edits:

-   

> Legal Entity Type must have a value. The following error message will
> be invoked: **Legal Entity type must not be blank.**

-   

> Name must have a value. The following error message will be invoked:
> **Name must not be blank.**

-   

> If Zip contains a value, it must be numeric and at least five
> characters long. If greater than five, it must be equal to nine. A
> hyphen may be in position 6 and if not one will be inserted. The
> following error message will be invoked: **Zip Code can only be NNNNN,
> NNNNNNNNN, or NNNNN-NNNN where N is a numeric char.**

-   

> If Country is US (United States), then State must contain a valid USPS
> state abbreviation code if a value is supplied in the State field. The
> following error message will be invoked: **If country US, State CD
> must be valid state abbrev.** (A.2.1.1.5.t)

-   

If Country is CA (Canada), then State must contain a valid Canadian
province code if a value is supplied in the State field. The following
error message will be invoked: **If country Canada, State CD must be
valid province abbrev. See online HELP.**

> The **OK** button will have the following duplicate check:
>
> The proposed Legal Entity must have a unique combination of Legal
> Entity Name, Type Code, and State_Code. If a Legal Entity of the same
> Name, Type Code, and State Code exists in the database the following
> error message will be invoked: **Duplicate Legal Entity Found.**

Add-Mode

Processing Pressing **OK** in Add mode will create a new LEGAL_ENTITY.
An external system number will be system generated for the LEGAL_ENTITY
using the ENTITY_INTERNAL_SYSTEM_NUMBER for entity name TINLGENT.

> Telephone numbers and e-mail addresses will generate a new row in
> LEGAL_ENTITY_COMMUNICATION for each item in the list box. These will
> be system numbered sequentially within the LEGAL_ENTITY number.
> (A.2.1.1.5.u)
>
> Field FedRep ID will be populated using the generated Legal Entity IS
> Number and St Code. (A.2.1.1.5.w)
>
> Upon successful completion, the Legal Entity Maintenance List will be
> presented with previous search criteria. (B.2.1.1.5.b) Note: Addition
> of a Legal Entity that does not meet the previous search criteria will
> result in its absence from the resulting display.

Change-Mode

Processing Will update the LEGAL_ENTITY table with the modified
information.

> Additions, deletions, or modifications to telephone numbers and
> electronic addresses will also commit to the
> LEGAL_ENTITY_COMMUNICATION table at this time. (A.2.1.1.5.v)
>
> When successful, the Legal Entity Maintenance page will close and the
> Legal Entity Maintenance List will be displayed with the new
> information and the previous search criteria. (B.2.1.1.5.c) Note:
> Modification of a Legal Entity that does not meet the previous search
> criteria will result in its absence from the resulting display.

**Cancel** Will close the maintenance page. If changes have been made to
the maintenance information, a confirmation dialog box will be presented
(Exhibit 2-7, Subsection 2.1.1.3), requiring selection of **Yes**,
**No**, or **Cancel**.

> The Cancel Confirm dialog box will be invoked when the user presses
> the **Cancel** button after making changes on the maintenance window.
> The **No** button will be the default.

**Help** Will invoke online Help for this page.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

**2.1.1.6 Communication Maintenance**

##  {#section-1 .Style1 .unnumbered}

Exhibit 2-10 depicts the Communication Maintenance page. (A.2.1.1.6.a)

The Communication Maintenance will be presented as a dialog box in the
foreground of the maintenance page from which it was requested. It will
not be presented with the left pane navigation frame. This page will
allow users to manipulate telephone numbers and e-mail addresses. A
Legal Entity may record a maximum of 999 telephone numbers and e-mail
addresses over the life of the system.

![](media/image17.png){width="6.49375in" height="4.009722222222222in"}

[]{#__RefHeading___Toc86484615 .anchor}**Exhibit 2-10.** Communication
Maintenance Page

[Entry Fields]{.underline}:

*Purpose* The Purpose describes the intended use of the phone number or
electronic address. The permitted values for this field are controlled
by the System Administrator in the 'FONPURPOSE' code_name of the
PERMITTED_VALUES (TINPVALS) table for phone numbers or the 'ELCPURPOSE'
code_name of the PERMITTED_VALUES (TINPVALS) table for electronic
addresses. (C.2.1.1.6.a)

The Purpose will be a required field.

*Phone Number* The phone number including area code. It must be in the
format NNN-NNN-NNNN where N represents a numeric digit.

The Phone Number will be an optional field. This field will be protected
when this page is presented for maintenance of electronic addresses.

When a phone number is provided the extension will be unprotected and
the electronic address will be protected. ~~When the phone number is
removed the electronic address should be unprotected.~~ The Extensions
should be reset to spaces and protected. (C.2.1.1.6.b)

*Ext.* The office extension of a phone number.

The extension will be an optional field.

This field will be protected until a phone number is provided.

*Electronic Address* The electronic address of the communication.

The address will be an optional field. This field will be protected when
this page is presented for maintenance of phone numbers.

~~When an electronic address is provided the phone number and extension
will be protected. When the electronic address is removed the phone
number should be unprotected.~~ (C.2.1.1.6.c)

[**Buttons**:]{.underline}

**OK** Will perform the following edits:

-   

If Purpose is blank the error message will be: **A purpose is required
for a Legal Entity Communication.**

-   

If phone number and electronic address are both blank, the error message
will be: **Communication requires either a phone number or an electronic
address.**

-   

If phone number is provided, it must contain 10 numbers separated by a
hyphen in positions 4 and 8. The following error message will be
invoked: **Please enter the phone number in the specified format
(999-999-9999).** (B.2.1.1.6.a)

> When successful, the dialog will close and the information will be
> presented in the appropriate list box on the maintenance page. The row
> will not be committed to the LEGAL_ENTITY_COMMUNICATION table until
> the **OK** is selected on the Legal Entity/Individual/Government
> Agency maintenance page.

**Cancel** Will close the dialog and return to the maintenance page with
no action taken upon the communication data.

**Help** Will invoke the system online Help facility.

**2.1.1.7 Point of Contact Assignments List**

The Point of Contact Assignments List will present a list of Water
Systems and Water Systems facilities for which the legal entity,
individual, or government agency is the designated contact.
(A.2.1.1.7.a)

The Point of Contact Assignments List page (Exhibit 2-11) is described
below.

[Default Sort Order]{.underline}: The list will be displayed in
ascending Water System No., ascending WSF State Asgn ID, ascending
Status, and ascending Type order. When the POC is for a WSF, the
software selects the Water System No. that is associated to the WSF
(i.e., be sure that when a legal entity is associated to both a Water
System and one or more of its WSFs, the WSF assignments immediately
follow the Water System assignments for the same water system even if
the legal entity is also assigned to other water systems).

  ----------------------------------------------------- -----------------------------------------------------
  ![](media/image18.png){width="1.8736111111111111in"   ![](media/image19.png){width="5.220138888888889in"
  height="5.122222222222222in"}                         height="4.391666666666667in"}

  ----------------------------------------------------- -----------------------------------------------------

[]{#__RefHeading___Toc86484616 .anchor}**Exhibit 2-11.** Point of
Contact Assignments List

[Protected Fields:]{.underline}

*Legal Entity Name* The name of the legal entity. An individual's name
will be displayed last name, first name format.

*Type Code* The legal entity's type code.

*Number of rows*

*Displayed:* The count of rows displayed in the list box area.

[List Items]{.underline}: Lists the water systems and water system
facilities that the legal entity is an assigned POC for.

*Water System No.* The number of the Water System.

*WSF State Asgn ID* The state assign identification number of the Water
System Facility.

*Type* The POC type description from the permitted values table. The
first 12 characters will be presented.

*Status* The status of the POC assignment. Could be Active or Inactive.

*Water System Name* The name of the Water System.

*WSF Name* The name of the Water System Facility.

[Menu Items:]{.underline}

**File**

*Exit* Will close the page and return to the invoking page.

**View**

*Sort* Will present the standard sort page where the list may be sorted
with up to three levels of sorting by Water System No., Water System
Name, WSF State Asgn ID, WSF Name, Type, and Status.

**Help** Will invoke the system online Help facility.

[Buttons]{.underline}:

**Menu Items** Will present the standard menu items dialog box.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

## Collector

Collector maintenance information is optionally available to states that
choose to maintain it. Collectors are maintained as "individual" legal
entities. Individuals may be marked as Collectors or Laboratory/Water
Legal Entity Points of Contact. Collectors can be maintained through
**Legal Entity or Collector** menu items. At the request of users, SSWr1
will eliminate the Collector Search and Maintenance List pages and use
the Legal Entity Search and Maintenance List pages instead. (A.2.2.a)

### Model Changes for Collector 

No model changes will be made to Collector for SSWr1.

### Collector Maintenance Page Flow

On the *SDWIS Home Page* when the user selects **Legal
Entity/Collector**, the Legal Entity Search page (Exhibit 2-2) will be
invoked, where the user may specify any name search criteria. The Type
will be set to Individual and will be protected. (A.2.2.2.a) The Legal
Entity Maintenance List will display those Individuals who meet the
specified criteria (previously described in Legal Entity Search) and
whose Collector Indicator is set to "Y." (A.2.2.2.b)

## Laboratory (Lab)

Laboratories can include testing facilities, such as a treatment plant,
located in a water system facility. POCs will be maintained for each
laboratory. The Administrative contact record is noteworthy because the
address and phone number for the administrative contact will be the main
address and phone number for the laboratory. The administrative contact
should have the same name and address as the laboratory.

### Model Changes for Laboratory 

No model changes will be made to Laboratory for SSWr1.

### Laboratory Maintenance Page Flow

From the *SDWIS Home Page*, the user can select **Legal
Entities/Laboratory**. This will invoke the Laboratory Search dialog box
(Exhibit 2-12), where the user may specify search criteria.

**2.3.2.1 Laboratory Search**

The Laboratory Search page is depicted below.

  ----------------------------------------------------- ----------------------------------------------------
  ![](media/image20.png){width="2.3027777777777776in"   ![](media/image21.png){width="4.895833333333333in"
  height="6.248611111111111in"}                         height="6.251388888888889in"}

  ----------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484617 .anchor}**Exhibit 2-12.** Laboratory
Search

[Entry Fields:]{.underline}

Filtering Criteria

Group Box: All filtering Search criteria will be optional. Only one
value will be used even if multiple values are supplied. The order of
field values used will be:

Laboratory Name

Federal ID No.

State ID No.

*State ID No.* Enter a complete or partial alphanumeric value. The value
will be matched against the laboratory's State ID No. which will be
assigned to the laboratory by the state.

> If an exact match is found, the laboratory will be displayed in the
> Laboratory Maintenance page in change mode.
>
> If more than one value is found, the list will be displayed in the
> Laboratory Maintenance List in order of Federal ID No., ascending
> within State ID No., ascending within Name, ascending where the State
> ID No. is greater than the filtering value supplied.
>
> If no laboratories are found, the Laboratory Maintenance List will
> display with no rows displayed.
>
> State ID No. will be an optional field.

*Federal ID No.* Enter a complete or partial alphanumeric value. The
value will be matched against the laboratory's Federal ID No.

> If an exact match is found, the laboratory will be displayed in the
> Laboratory Maintenance page in Change mode.
>
> If more than one value is found, the list will be displayed in the
> Laboratory Maintenance List in order of Federal ID No. ascending
> within State ID No. ascending within Name ascending where the Federal
> ID No. is greater than the filtering value supplied.
>
> If no laboratories are found, the Laboratory Maintenance List will
> display with no rows displayed.
>
> Federal ID No. will be an optional field.

*Laboratory Name* Enter a complete or partial alphanumeric value. The
value will be matched against the laboratory's name.

> If an exact match is found, the laboratory will be displayed in the
> Laboratory Maintenance page in change mode.
>
> If more than one value is found, the list will be displayed in the
> Laboratory Maintenance List in order of Federal ID No. ascending
> within State ID No. ascending within Name ascending where the name is
> greater than the filtering value supplied.
>
> If no laboratories are found, the Laboratory Maintenance List will
> display with no rows displayed.
>
> Laboratory Name will be an optional field.

[Tab Sequence:]{.underline}

[]{.mark}

State ID No., Federal ID No., Laboratory Name, **Search**, **Cancel**,
and **Help**.

[Buttons:]{.underline}

**Search** Will apply the provided search criteria against the database
and provide a list of laboratories in order of Federal ID No. ascending
within State ID No. ascending within Name ascending on the Laboratory
Maintenance List.

> If only a single laboratory is found in the search, it will be
> displayed on the Laboratory Maintenance page in Change mode and the
> Laboratory Maintenance List will not be presented.
>
> If no laboratories are found, the Laboratory Maintenance List will be
> presented with no records.
>
> Search Options:

-   

> If only Name is provided, will search for LEGAL_ENTITIES with names
> equal to or greater than the supplied value.

-   

> If only State ID No. is provided, will search for LEGAL_ENTITIES with
> State ID Nos. equal to the selected value. (Display All will list all
> values.)

-   

> If Name and State ID No. are provided, will search for LEGAL_ENTITIES
> with State ID Nos. equal to the selected value and names equal to and
> greater than the supplied value.

-   

> If only Federal ID No. is provided, will search for LEGAL_ENTITIES
> with Federal ID Nos. equal to the selected value. (Display All will
> list all values.)

-   

> If Name and Federal ID No. are provided, will search for
> LEGAL_ENTITIES with Federal ID Nos. equal to the selected value and
> names equal to and greater than the supplied value.

-   
-   

If Name, State ID No. and Federal ID No. are provided, will search for
LEGAL_ENTITIES with State ID Nos. equal to the selected value, Federal
ID Nos. equal to the selected value and names equal to and greater than
the supplied value.If none are provided, will list all LEGAL_ENTITIES.

**Cancel** Will close Search and return the user to the previous page.

**Help** Will invoke online Help for this page.

**2.3.2.2 Laboratory Maintenance List**

The Laboratory Maintenance List (Exhibit 2-13) will be invoked from the
Search page.

  ----------------------------------------------------- ----------------------------------------------------
  ![](media/image20.png){width="2.3027777777777776in"   ![](media/image22.png){width="4.118055555555555in"
  height="5.382638888888889in"}                         height="5.258333333333334in"}

  ----------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484618 .anchor}**Exhibit 2-13.** Laboratory
Maintenance List

The Laboratory Maintenance List will display a list of laboratories.

[List Columns:]{.underline}

State ID No., Federal ID No., Name, City, State.

[Menu Items:]{.underline}

**File**

*Exit* Will close the page and return the user to the previous page.

**Edit**

*Add* Will be available regardless of a laboratory having been selected
in the list. (B.2.3.2.2.a)

> Will open the Laboratory Maintenance page in Add mode where a new
> laboratory can be added.

*Change* Will be available when a laboratory row is selected in the
list.

> Will open the Laboratory Maintenance page in Change mode with the
> selected laboratory information displayed.
>
> Double-clicking on a laboratory in the list will perform like this
> menu selection when *Change* is an enabled menu item.
>
> *Select* Will return the selected Laboratory to the invoking page.
>
> This menu item will only be enabled when the maintenance list is
> invoked from a page requesting the selection of a laboratory. This
> function was previously implemented on the Laboratory Selection List
> window. Enabling the *Select* will disable the maintenance functions
> of *Add*, *Change*, and *Delete*. (B.2.3.2.2.b)
>
> Double-clicking on a laboratory in the list will perform the same way
> as choosing a menu selection when *Select* is an enabled menu item.
> (B.2.3.2.2.c)

*Delete* Will be available when a laboratory row is selected in the
list.

> A confirmation question will be presented in the Delete Laboratory
> dialog box (Exhibit 2-14), requiring selection of either the **OK** or
> **Cancel** button.
>
> ![](media/image23.png){width="5.135416666666667in" height="1.71875in"}

[]{#__RefHeading___Toc86484619 .anchor}**Exhibit 2-14.** Delete
Laboratory

[Delete Laboratory Buttons:]{.underline}

**OK** Will delete the selected Laboratory from the database and return
the user to the Laboratory Maintenance List.

> The Laboratory cannot be deleted if the Laboratory:

-   

> Is assigned to a legal entity. The following error message will be
> invoked: **Laboratory has a legal entity assignment. Cannot delete
> this laboratory.**

-   

> Has a sample. The following error message will be invoked: **Lab has a
> sample assigned. Cannot delete this laboratory.**

-   

Has a sample summary. The following error message will be invoked: **Lab
has a sample summary assigned. Cannot delete this laboratory.**

**Cancel** Will cancel the delete request and return the user to the
Laboratory Maintenance List. The laboratory will still exist in the
database.

**View**

> *Search* Will present the Lab Search page presenting the previous
> criteria so that new criteria can be provided. (B.2.3.2.2.d) The
> Search feature is useful for narrowing a search when too many rows are
> returned or to widen a search if too few rows are returned.

*Sort* Will open the standard sort page where the list may be sorted by
State ID No., Federal ID No., Name, City, and State. Three levels of
sorting will be supported.

*Filter* Will open the standard filter page where the list may be
filtered by State ID No., Federal ID No., Name, City, and State.

Use of the Filter item will enable the Refresh item and modify the count
presented in the Number of rows displayed field.

*Refresh* Will remove the filter and represent the original list.

The Refresh menu item will only be enabled when a filter has been
applied to the list.

[Default Sort Order:]{.underline}

> Ascending Name.

[Protected Fields:]{.underline}

*Number of rows*

*resulting from the*

*search criteria*

*used:* Will indicate how many rows exist in the database that matched
the search criteria.

*Number of rows*

*Displayed:* Will indicate how many of the rows that exist in the
database are displayed in the list page via the vertical scroll feature.
The list will be limited to display only 1000 laboratories. If more than
1000 laboratories resulted from the search, use the **View/Search** menu
item to enter search criteria to narrow the search.

[Buttons]{.underline}:

**Menu Items** Will present the standard menu items dialog box.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

**2.3.2.3 Laboratory Maintenance**

The Laboratory Maintenance page (Exhibit 2-15) will be invoked from the
Search page or the maintenance list.

  ----------------------------------------------------- ----------------------------------------------------
  ![](media/image20.png){width="2.3027777777777776in"   ![](media/image24.png){width="4.895833333333333in"
  height="6.248611111111111in"}                         height="6.246527777777778in"}

  ----------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484620 .anchor}**Exhibit 2-15.** Laboratory
Maintenance

[Protected Fields:]{.underline}

*FedRep ID* The FedRep ID represents the LEGAL_ENTITY internal system
number and state code that is used as the unique identifier for federal
reporting. (B.2.3.2.3.a)

*Legal Entity Type* In Change mode this field will be protected.

*Country Name* This will be the name of the country whose code is
entered in the Country field.

[Entry Fields:]{.underline}

*State ID No.* State ID No. will be a number assigned by a state
laboratory licensing, public health, or environmental agency, which
uniquely identifies the laboratory. This number will be used by the
laboratory on correspondence and reporting forms submitted to the
regulatory agency.

> State ID No. will be a required field.

*Federal ID No.* Federal ID No. will be a number assigned by an EPA
licensing authority which uniquely identifies the laboratory. This
number will be used by the laboratory on correspondence and reporting
forms submitted to the regulatory agency. Some states permit third‑party
reciprocity and accreditation by agencies in other states; a federal ID
No. may be used in more than one state.

> The Federal ID No. field will be optional.

*Name* Laboratory Name will be the commonly used name of the laboratory.
This name will be used in reporting analytical results and will be the
name registered with laboratory certification or other authorities.

> Name will be a required field.

*Legal Entity Type* Legal Entity Type will indicate the type of legal
entity. This value is retrieved from the active administrative contact
assigned to the Laboratory. Permitted entries will be:

> Company
>
> Cooperative
>
> Corporation
>
> Government Agency
>
> Homeowners' Association
>
> Non‑Profit
>
> Rate Set Utility
>
> Trust
>
> Treatment Plant
>
> Water System (B.2.3.2.3.b)
>
> Other
>
> Legal Entity Type will be a required field.
>
> This field will not be available for modification in Change mode.

*GA Type* (B.2.3.2.3.w)

A code identifying the type of government agency. Permitted entries
include the following:

> AR - Alaskan Remote Village
>
> AT - Authority
>
> BR - Borough
>
> CM - Commission
>
> CN - County
>
> CT - City
>
> DS - District
>
> FD - Federal
>
> MN - Municipality
>
> NA - Native American Tribe
>
> PR - Parish
>
> RG - Region
>
> SA - State Administrative District
>
> SD - School District
>
> SR - State Administrative Region
>
> ST - State
>
> TW - Town
>
> WD - Water District
>
> It will only be enabled when the legal entity type is selected as
> government agency. If the legal entity type is changed to other than
> government agency, the GA Type selection will be removed.
>
> GA Type is an optional field. (C.2.3.2.3.b)

*ID No.* An identification number of the legal entity. May be provided
by an external source such as employer or internal revenue service. This
value is retrieved from the active administrative contact assigned to
the Laboratory.

> The ID No. field will be optional.

*Alias Name* Alias Name will be the alias, common name, or acronym for a
laboratory. This value is retrieved from the active administrative
contact assigned to the Laboratory.

> The Alias Name field will be optional.

*Phone Numbers*

*\[List Box\]* This list box displays the telephone numbers recorded for
the legal entity designated as the active administrative contact
assigned to the Laboratory in ascending internal number order. All phone
numbers will be optional. Only one selection may be made at a time.
Selection will enable the Modify and Delete buttons and disable the Add
button contained in this group box. (B.2.3.2.3.c)

*Purpose* The purpose of the phone number indicates for what purpose the
phone number could be used. The purposes are maintained by the system
administrator.

*Phone Number* Will be the Phone Number of the laboratory along with
area code.

> Example: 999‑999‑9999.

*Extension* The office extension of the phone number.

The extension will be optional.

*Electronic Addresses*

> *\[List Box\]* This list box will list the purpose and electronic
> addresses recorded for the legal entity designated as the active
> administrative contact assigned to the Laboratory in ascending
> internal system number order. All electronic addresses will be
> optional. One electronic address may be selected at a time. Selection
> will enable the Modify and Delete buttons and disable the Add button
> contained within this group box. (B.2.3.2.3.d)

*Purpose* The purpose of the electronic address indicates for what
purpose the address could be used. The purposes are maintained by the
system administrator.

*Address* The laboratory's electronic address.

*Address Line One* Address Line One will be the first line of an address
for the laboratory. This value is retrieved from the active
administrative contact assigned to the Laboratory. This line should be
specified only as needed. If a responsible person or agency is
unavailable and the street address consists of only a single line, use
only Address Line Two. The user may also use this line for the P.O. box.

> The Address Line One field will be optional.

*Address Line Two* Address Line Two will be the second line of an
address for the laboratory. This value is retrieved from the active
administrative contact assigned to the Laboratory. This line will
contain the street address, rural route, etc.

> The Address Line Two field will be optional.

*City* City will be the city in which the legal entity is located. This
value is retrieved from the active administrative contact assigned to
the Laboratory.

> The City field will be optional.

*State* State will be the two‑letter USPS state abbreviation for the
laboratory's state when country is United States, the province code when
country is Canada (CA), or any other state or territorial code for other
country designations.

When country is United States and a value is supplied, the state code
must be one of the valid USPS state code abbreviations. (B.2.3.2.3.e)

> When country is CA (Canada) and a value is supplied, the user must
> enter one of the following Canadian province codes in the State field:
>
> Province Name Code Province Name Code
>
> Alberta AL Nova Scotia NS
>
> British Columbia BC Ontario ON
>
> Manitoba MB Prince Edward Island PE
>
> New Brunswick NB Quebec PQ
>
> Newfoundland NF Saskatchewan SK
>
> Northwest Territories NT Yukon Territory YT
>
> Nunavut NU
>
> (B.2.3.2.3.f)
>
> This value is retrieved from the active administrative contact
> assigned to the Laboratory.
>
> This State field will be optional.

*Zip* Zip will be the USPS zip code for the laboratory plus the optional
Zip+4 extension. This value is retrieved from the active administrative
contact assigned to the Laboratory.

> The Zip field will be optional.
>
> This field will be available only if the Country code is United
> States. If the Country field contains a country other than United
> States, this field will be spaces.

*Country* This value is retrieved from the active administrative contact
assigned to the Laboratory. A dropdown where values from the CODE
PERMITTED_VALUES will be listed using code_name value 'TINLGENT1'. The
default for Country will be United States. (B.2.3.2.3.g)

> This Country field will be optional.
>
> If the Country code is United States, the Zip field will be made
> available and the International Postal Code field will be grayed out
> and protected. If the Country code is other than United States, the
> Zip field will be grayed out and protected, and the International
> Postal Code will be made available. If the Country code field contains
> spaces, the Zip field will be blanked out and made available, and the
> International Postal Code field will be grayed out and protected.

*International Postal*

*Code* This value is retrieved from the active administrative contact
assigned to the Laboratory. In the International Postal Code field, the
user may enter a postal zone for any selected country in the Country
field other than the United States.

> The International Postal Code field will be optional.
>
> This field is only available if the Country field contains a country
> other than United States. If the Country field contains United States,
> this field will contain spaces.

*Comments* This value is retrieved from the active administrative
contact assigned to the Laboratory. A text field where free-form
comments can be recorded about the laboratory. (B.2.3.2.3.h)

The Comments field will be optional.

> When a user is tabbing through the fields, make sure the user can tab
> through this one as well (i.e., enable the Ignore Tab function). Also
> enable the Word Wrap function.

[Tab Sequence:]{.underline}

[]{.mark}

State ID No., Federal ID No., Name, Legal Entity Type, GA Type, ID No.,
Alias Name, Phone Numbers **Add, Modify, Delete,** Electronic Addresses,
**Add, Modify, Delete**, **Email/URL Launch,** Address Line One, Address
Line Two, City, State, Zip, Country, International Postal Code,
Comments, **Points of Contact**, **OK**, **Cancel**, and **Help**.
(B.2.3.2.3.i)

[Buttons:]{.underline}

**Add *\[New Phone***

***Number\]*** Will present the Communication Maintenance Page in add
mode where a new phone number can be entered for the laboratory. The new
number will not actually be committed to the database until the **OK**
button is selected on the Laboratory Maintenance page. (B.2.3.2.3.j)

**Modify *\[Phone ***

***Number\]*** Will present the Communication Maintenance Page in change
mode where the selected phone number can be modified for the laboratory.
(B.2.3.2.3.k) The change will not actually be committed to the database
until the **OK** button is selected on the Laboratory Maintenance page.

**Delete *\[Phone***

***Number\]*** Will present the standard delete confirmation page prior
to deleting the LEGAL_ENTITY_COMMUNICATION row. The phone number will be
marked for delete, removed from the list box, and committed when the
**OK** button is selected. If **CANCEL** is selected the phone number
will not be deleted. (B.2.3.2.3.l)

This button will be enabled when a phone number is selected in the list
box.

**Add *\[New Electronic Address\] ***

Will present the Communication Maintenance Page in add mode where a new
electronic address can be entered for the laboratory. The new electronic
address will not actually be committed to the database until the **OK**
button is selected on the Laboratory Maintenance page. (B.2.3.2.3.m)

**Modify *\[Electronic Address\]***

Will present the Communication Maintenance Page in change mode where the
selected electronic address can be modified for the laboratory.
(B.2.3.2.3.n) The change will not actually be committed to the database
until the **OK** button is selected on the Laboratory Maintenance page.

This button will be enabled when an electronic address is selected in
the list box.

**Delete**

***\[Electronic Address\]*** Will present the standard delete
confirmation page prior to deleting the LEGAL_ENTITY_COMMUNICATION row.
The electronic address will be marked for delete, removed from the list
box, and committed when the **OK** button is selected. If **CANCEL** is
selected the electronic will not be deleted. (B.2.3.2.3.o)

**Email/URL Launch** Will present the Web Launch page. The page will
display a list of the electronic addresses for the Legal Entity. See
Chapter 1 for further discussion and description of this functionality.
(B.2.3.2.3.t)

This button will be enabled when an electronic address is present in the
list box.

**Points of**

**Contact** Will display a list of contacts for the laboratory in the
Laboratory Points of Contact Maintenance List described below. This
button will be enabled only when the Laboratory Maintenance page is in
Change mode.

**OK** The **OK** button will have the following edits:

-   

> State ID No. must have a value. The following error message will be
> invoked: **State ID No.** **may not be blank.**

-   

> Name must have a value. The following error message will be invoked:
> **Laboratory Name may not be blank.**

-   

> Legal Entity Type must have a value. The following error message will
> be invoked: **Legal Entity Type must not be blank.**

-   

> If Legal Entity Type is a Government Agency, the GA Type field must
> have a value. If not the error message will be **GA Type required for
> government agency. (**B**.**2.3.2.3.x)

-   

> If Zip is supplied, it must be numeric. If more than five characters,
> it must be equal to nine. A hyphen may be in position 6 and if not,
> one will be inserted. The following error message will be invoked:
> **Zip code must be NNNNN, NNNNNNNNN, or NNNNN-NNNN where N is a
> numeric char.**

-   

> If Country is US (United States), then State must contain a valid USPS
> state abbreviation code if a value is supplied in the State field. The
> following error message will be invoked: **If country US, State CD
> must be valid state abbrev. (**B.2.3.2.3.p)

-   

If Country is CA, then State must contain a valid Canadian Province as
documented for the State field. The following error message will be
invoked: **If country Canada, State CD must be valid province abbrev.
See online HELP.**

> The duplicate check for the **OK** button will contain three
> independent tests:

-   

> State ID No. must be unique. The following error message will be
> invoked: **Laboratory State ID No. must be unique.**

-   

> Federal ID No. must be unique. The following error message will be
> invoked: **Laboratory Federal ID No. must be unique.**

-   

Name must be unique. The following error message will be invoked:
**Laboratory Name must be unique.**

Add-Mode

Processing Pressing **OK** in Add mode will:

-   

> Create a laboratory with the information provided on the page.

-   

> If a legal entity is not found with the same name and legal entity
> type, a LEGAL_ENTITY will be created.

-   

> If the legal entity type is selected as government agency, the
> GOVERNMENT_AGENCY will be created.

-   

> The FedRep ID will be populated with the TINLGENT_is_number and
> TINLGENT_st_code. (B.2.3.2.3.q)

-   

> An initial active Administrative Contact assignment will be made
> between the laboratory and the legal entity by creating a
> LAB_LEGAL_ENTITY_ASGMT.

-   

Telephone numbers and Electronic addresses will generate a new row in
LEGAL_ENTITY_COMMUNICATION for each item in the list box. These will be
system numbered sequentially within the LEGAL_ENTITY number.
(B.2.3.2.3.r)

> Upon successful completion, the Laboratory Maintenance List will be
> presented with previous search criteria. (B.2.3.2.3.u) Note: Addition
> of a Laboratory that does not meet the pervious search criteria will
> result in its absence from the resulting display.

Change-Mode

Processing Pressing **OK** in Change mode will perform the following
functions:

If the name or legal entity type are changed, attempt a match for an
existing legal entity of the same name and type. If found, the
laboratory will be associated to that legal entity. If a legal entity
with the same name and type is not found, one will be created. The
administrative contact will be moved from the legal entity of the old
name to the legal entity of the new name. The end date of the contact
will be set to current date minus 1 day. The begin date of the new
contact will be set to the current date. All other contacts will not be
modified. Duplicate and Overlap rules as defined in the Laboratory Point
of Contact Maintenance page are applicable. (C.2.3.2.3.a)

If the legal entity type is changed from government agency to another
selection, the GOVERNMENT_AGENCY row should be deleted. (B.2.3.2.3.y)

> Additions, deletions, or modifications to telephone numbers and
> electronic addresses will also commit to the
> LEGAL_ENTITY_COMMUNICATION table at this time. (B.2.3.2.3.s)
>
> When successful, the Laboratory Maintenance page will close and the
> Laboratory Maintenance List will be displayed with the new information
> and the previous search criteria. (B.2.3.2.3.v) Note: Modification of
> a Laboratory that does not meet the pervious search criteria will
> result in its absence from the resulting display.

**Cancel** Will close the maintenance page. If changes have been made to
the maintenance information, a standard confirmation dialog box will be
presented, requiring selection of **Yes**, **No**, or **Cancel**.

**Help** Will invoke online Help for this page.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

4.  

**Laboratory Points of Contact Maintenance List**

The Laboratory Points of Contact Maintenance List (Exhibit 2-16) will be
invoked from the **Points of Contact** button on Laboratory Maintenance.

  ----------------------------------------------------- ----------------------------------------------------
  ![](media/image20.png){width="2.3027777777777776in"   ![](media/image25.png){width="4.895833333333333in"
  height="6.248611111111111in"}                         height="6.251388888888889in"}

  ----------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484621 .anchor}**Exhibit 2-16.** Laboratory
Point of Contact Maintenance List

The Laboratory Points of Contact Maintenance List will display a list of
contacts for the Laboratory. The Laboratory group box will contain the
Name, State ID No., and Federal ID No. for the laboratory.

[Default Sort Order:]{.underline}

Ascending active_indicator_cd, POC Type in the following order (AC, EC,
DO, OW, OP, remainder ascending), Contact Name ascending, End Date
descending. (B.2.3.2.4.a)

[List Columns:]{.underline}

POC Type, Name, Status, Begin Date, End Date, Organization, Mailstop,
Ext System No., FedRep ID. (B.2.3.2.4.b)

[Menu Items:]{.underline}

**File**

*Exit* Will return the user to the previous page.

**Edit**

> *Add* Will display the Legal Entity Search page where criteria may be
> entered to retrieve a list of Legal Entities. Upon pressing the
> **Search** button, the Legal Entity Maintenance List page will be
> presented in single-select mode for selection of a legal entity to use
> as a Laboratory contact. The *Select* menu item will be made available
> on the Legal Entity Maintenance page when after a selection is
> highlighted in the list box. (B.2.3.2.4.c)
>
> Once a legal entity has been selected, the Laboratory POC Maintenance
> page will be presented. If the selected legal entity had already been
> designated as a POC for the Laboratory and any of those assignments
> are still active, they will be displayed on the Laboratory POC
> Maintenance page. (B.2.3.2.4.d)
>
> This item will be enabled regardless of a selection having been made
> in the list area. (B.2.3.2.4.e)

*Change* Will display the Laboratory POC Maintenance page where the
details about the contact can be viewed and all contact types between
the legal entity and laboratory maintained.

> This option will be available only when a contact is selected in the
> list.

*Delete* Will present a confirmation question (Exhibit 2-17) in the
Delete Laboratory Contact dialog box requiring selection of either the
**OK** or **Cancel** button.

This option will be available only when a contact is selected in the
list.

![](media/image26.png){width="5.040972222222222in"
height="2.0208333333333335in"}

[]{#__RefHeading___Toc86484622 .anchor}**Exhibit 2-17.** Delete
Laboratory Contact

[Delete Laboratory Contact Buttons:]{.underline}

**OK** Will remove the association linking the legal entity to the
laboratory (via the LAB_LEGAL_ENTITY_ASSIGNMENT table).

**Cancel** Will cancel the delete request and return the user to the
Laboratory Points of Contact Maintenance List. The contact will still
exist in the database.

**View**

*Deselect* Will remove highlighting from the selected contact in the
list.

> This option will be available only when a contact is selected in the
> list.

*Select*

*Another*

*Laboratory* Will present the Lab Search page where new criteria can be
entered to choose a different laboratory. Previous search criteria will
be displayed for reference. (B.2.3.2.4.f) The results of this search
will be presented on the Laboratory Maintenance List from which a
Laboratory may be selected and its contacts displayed in the Laboratory
Points of Contact Maintenance List. The only menu item available under
Edit should be Select and double-clicking should react as if
*Edit/Select* was requested. The selection should be returned to the
Laboratory Points of Contact Maintenance List. (B.2.3.2.4.g)

[Protected Fields:]{.underline}

*\[Laboratory\] Name* The name of the laboratory for which contacts are
listed.

[]{.mark}

*State ID No.* The state identification number of the laboratory for
which the contacts are listed.

[]{.mark}

*Federal ID No.* The federal identification number of the laboratory for
which the contacts are listed.

*Number of rows*

*Resulting from search*

*criteria used:* This count indicates how many contacts are in the
database for the laboratory.

*Number of rows*

*Displayed:* This count indicates how many contacts are currently being
displayed in the list area.

[Buttons]{.underline}:

**Menu Items** Will present the standard menu items dialog box.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

####  {#section-2 .unnumbered}

2.3.2.5 Laboratory POC Maintenance (B.2.3.2.5.a)The Laboratory Points of
Contact Maintenance page (Exhibit 2-18) will be invoked from the
Laboratory Points of Contact Maintenance List. From an Edit/Add
selection on the maintenance list, the page flow will be via Legal
Entity Search and Legal Entity Maintenance List where a selection will
be made and brought forward into this page.

Prior to display, the selected legal entity will be used to search for
all existing LAB_LEGAL_ENTITY_ASGMTs (TSALLEA) to the Laboratory. Any
contacts in active status (active_indicator_cd = 'A') will be presented
on the page. The Select Type will be marked and protected, Active
indicator set and both radio buttons unprotected, Begin Date populated
and unprotected, End Date set to null and protected.

  ----------------------------------------------------- ----------------------------------------------------
  ![](media/image20.png){width="2.3027777777777776in"   ![](media/image27.png){width="5.590972222222222in"
  height="7.371527777777778in"}                         height="7.247916666666667in"}

  ----------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484623 .anchor}**Exhibit 2-18.** Laboratory
Point of Contact Maintenance

[Protected Fields:]{.underline}

[Laboratory Group Box:]{.underline}

\[*Laboratory*\]

*Name* The name of the laboratory.

*State ID No.* The state identification number of the laboratory.

*Federal ID No.* The federal identification number of the laboratory.

[\[Legal Entity Identity\] Group Box:]{.underline}

*Salutation* The salutation or greeting for the contact.

*Contact Name* The contact's first and last name.

*Alias Name* The alias, common name, or acronym for the contact.

*Prof Qual* The professional qualification of the contact.

*Job Title* The professional job title of the contact.

*Organization* Identifies the contact's organization.

*Legal Entity Type* The contact's legal entity type code, IN
(individual), CM (company), NP (Non-Profit), etc.

*GA Type* If the Legal Entity type is GA (Government Agency), this field
will display the 'Type' of Government Agency, (i.e., State, Town, City,
County, etc.).

*ID No.* The contact's identification number. May be provided by an
external source such as employer or internal revenue service.

[Address Group Box:]{.underline}

*Address Line One* The first line of the address for the contact.

*Address Line Two* The second line of the address for the contact.

*City* The city in which the contact is located.

*State* The two-letter U.S. Postal Service (USPS) state abbreviation for
the contact's state.

*Zip* The U.S. Postal Service (USPS) zip code for the contact.

*Country* The Country where the contact is located.

*International*

*Postal Code* The postal zone for the country if other than the US.

[Phone Numbers Group Box:]{.underline}

*Purpose* To indicate for what purpose the phone number could be used.

*Phone Number* The phone number including area code.

*Extension* The office extension of the phone number.

[Electronic Addresses Group Box:]{.underline}

*Purpose* The purpose of the electronic address indicates for what
purpose the address could be used.

> *Address* The electronic address for the contact.

[Entry Fields:]{.underline}

*Select Type* This will be a check box to indicate POC Type selection.

> Marking the Select Type with a check will indicate that the legal
> entity is being designated as a new POC for the laboratory. When
> marked, the following actions will occur:

-   

> Active/Inactive radio buttons will become unprotected and Active will
> be set.

-   

> Begin Date will become unprotected and set to the current date.

-   

End Date will remain protected and null.

> If the Select Type is unmarked, all fields on the row will be reset to
> null values and become protected.
>
> If the POC designation already exists and is displayed as active, the
> Select Type will be marked and protected from change. The
> Active/Inactive radio buttons and Begin Date will be unprotected.

*Active/*

*Inactive* Radio buttons to indicate activity status of POC Type.

> When the Select Type is marked, the radio buttons are available for
> change. Choosing Active will set the Begin Date field to current date.
> Choosing Inactive will set the End Date field to current date and
> unprotect it.
>
> Active/Inactive is mandatory when the select type has been marked.

*Type of POC* Along with the *Select Type* checkboxes, these fields
indicate the type of contact the selected legal entity provides for the
laboratory. The first nine choices displayed on the page are displayed
directly on the page for the user, as they are choices delivered with
the software.

[Displayed Contact Types:]{.underline}

Administrator -- Contact who handles administrative matters.

> Owner -- Owner of a water system.
>
> Designated OP In Charge -- Serves as the operator in charge.

Operator -- Operator of the water system.

Emergency Contact -- Person to contact in an emergency.

Sampler -- Contact responsible for sampling information.

Financial -- Contact who handles financial matters.

Legal -- Contact who handles legal matters.

Physical Location -- The Contact at the Physical Location.

> The next two choices allow the user to select the Type of POC using a
> dropdown list. The choices available on the dropdown list are
> controlled by the System Administrator and will be retrieved from the
> PERMITTED VALUES table with code_name of "POCTYPE" and ownership_code
> = 'ST'. (The 'HQ' rows will not be presented in the dropdown list.) If
> no choices are available, the field will display -- None. Listed below
> are descriptions of the preset system choices.
>
> For administrator-defined types, a selection will be required if the
> Select Type is marked. This field will be protected from change on
> displayed, active contacts.
>
> \[Status\] Begin Date The Begin Date for the contact's status. This
> field will be defaulted to the current date when the contact is added.
> The date can be changed to a date prior to the current date. Future
> dates are not allowed.
>
> \[Status\] End Date The date on which the contact's status became
> inactive. This field will be defaulted to the current date when the
> Inactive radio button is selected. The date can be changed to a date
> prior to the current date. Future dates are not allowed. When valued,
> it must be greater than the Begin Date.

[Buttons:]{.underline}

**OK** At least one Select Type must be checked and if not, the error
message will be **A new contact requires a selection.**

Will perform the following edits for each checked Select Type
sequentially on both this page and the **MORE** page. In some cases, the
field in error may be on the **MORE** pages:

Dates:

-   

> If Begin Date is blank, error message will be **Begin Date cannot be
> blank.**

-   

> If Begin Date is greater than current date, the error message will be
> **Begin Date cannot be in the future.**

-   

> If Inactive is selected and End Date is blank, the error message will
> be **End Date cannot be blank.**

-   

> If End Date is greater than current date, the error message will be
> **End Date cannot be in the future.**

-   

> If End Date has a value and is less than the Begin Date, the error
> message will be **End Date cannot be prior to Begin Date.**

-   

> If Active is selected and End Date has a value, it will be ignored and
> set to null.

-   

If Active or Inactive has not been selected, the following error message
will be invoked: **Activity Status cannot be blank**.

*Duplicate Check* For each choice selected, a duplicate check will be
performed to ensure that the legal entity being assigned to the
laboratory to perform the selected contact type does not already exist
in an active status. If a LAB_LEGAL_ENTITY_ASGMT exists for the supplied
laboratory and legal entity with an active_indicator_code = 'A', a
dialog box (Exhibit 6-18) with the following error message will be
invoked: **This Laboratory Point of Contact already exists.** Pressing
**OK** on this error message will close the dialog box and ignore the
request to add the contact of this type. Processing will have been
interrupted. The duplicate situation must be resolved and the **OK**
button pressed again to resume processing.

![](media/image28.png){width="5.75in" height="2.3645833333333335in"}

[]{#__RefHeading___Toc86484624 .anchor}**Exhibit 2-19.** Lab Contact
Duplicate Found

*Overlap Check* For each choice selected, an overlap check will be
performed to ensure that the legal entity being assigned to the
laboratory to perform the selected contact type does not already exist
with Begin and End Dates that overlap the new Begin and End Dates. If a
LAB_LEGAL_ENTITY_ASGMT row exists for the same laboratory and legal
entity, with new begin dates equal to or less than the existing end date
AND new end date either null, or equal to or greater than any existing
begin date the following error message will be invoked: **An overlap
exists with the new contact and an existing contact.** Pressing **OK**
on this error message will close the dialog box and interrupt the
processing. The overlap situation must be resolved and the **OK** button
pressed again to resume processing

> *Add Selected*
>
> *Contact* When editing is complete on a new selection, a
> Lab_Legal_Entity\_ Asgmt row will be added and associated to the
> Laboratory (LEGAL_ENTITY) and the Legal Entity. The type_code will be
> set to the appropriate contact type, active_indicator_cd will be set
> to the 'A' when the Active radio button is selected and to 'I' when
> the Inactive radio button is selected, the Begin Date to the Begin
> Date value, End Date to the value specified or null, d_last_updt_ts to
> current timestamp, d_userid_cd to current User ID, and the
> TSALLEA_is_number to the next sequential number utilizing the TINEISN
> row for table name TSALLEA.
>
> When successful the processing will commit changes to this selection,
> protect the select type and type of POC. If the selection was added as
> inactive, all fields for the selection will be protected. Processing
> will proceed to editing the next selection.
>
> When an Administrative Contact is added in Active status, the name on
> the LAB (TSALAB) and the name on the Legal Entity (TINLEGENT) should
> be the same. This will be accomplished by attempting to change the Lab
> name to the selected administrative contact Legal Entity. If a Lab
> with that name already exists, the error message will be **Laboratory
> Name must be unique** and the designation of the new administrative
> contact will be denied. If no Lab with the same name exists, the Lab
> name will be set to the same value as the name of the selected
> administrative contact. (C.2.3.2.5.a)
>
> *Change Selected*
>
> *Contact* When editing is complete on an existing selection, the
> LAB_LEGAL_ENTITY_ASGMT row is updated with the new values for
> active_indicator_cde, Begin Date, and End Date. The type code cannot
> be changed. The d_last_updt_ts and d_userid_cd will be set to current
> values.
>
> When successful the processing will commit changes to this selection.
> If the selection was changed to inactive, all fields for the selection
> will be protected. Processing will proceed to editing the next
> selection.
>
> After all contact type additions and changes have been processed, the
> page will close and return to the Laboratory Point of Contact
> Maintenance list page with a refreshed list of contacts.

**Cancel** If changes have been made, the standard cancel confirmation
dialog will be presented. If no changes are detected the page will close
the page and return the user to the Laboratory Point of Contact
Maintenance List page. Each selection is fully processed before the next
selection is edited. If Cancel is selected after an error message is
received, selections processed prior to the one receiving the error will
have already been committed and will not be backed out.

**Help** Will invoke online Help for this page.

**Scroll Buttons** Will scroll the list box in the direction of the
arrow displayed on the button.

**\<More\>** Will present the More POC Types page (Exhibit 2-20).

> This page functions just as does the primary page. The first 12
> choices displayed on the page are displayed directly on the page for
> the user; they are choices delivered with the software. If no choices
> are available, the field will display -- None. Listed below are
> descriptions of the preset system choices.
>
> [Displayed Contact Types:]{.underline}

Lead Engineer -- Contact who serves as lead engineer.

Other -- Other contact type.

Bureau of Indian Affairs Representative.

Health Clinic Representative.

> Indian Health Service Engineer.

Indian Health Service Sanitarian.

Tribal Chairman.

Tribal Environment Dept Representative.

Tribal Government Representative.

Tribal Health Dept Representative.

Utility Representative (Non-Tribal).

> Utility Representative (Tribal).

The next four choices allow the user to select the Type of POC using a
dropdown list. The choices available on the dropdown list are controlled
by the System Administrator and will be retrieved from the PERMITTED
VALUES table with code_name of "POCTYPE" and ownership_code = 'ST'. (The
'HQ' permitted values rows will not be presented in the dropdown.)

  ----------------------------------------------------- ----------------------------------------------------
  ![](media/image20.png){width="2.3027777777777776in"   ![](media/image29.png){width="5.715277777777778in"
  height="7.371527777777778in"}                         height="7.267361111111111in"}

  ----------------------------------------------------- ----------------------------------------------------

[]{#__RefHeading___Toc86484625 .anchor}**Exhibit 2-20.** More POCs Types

[Buttons:]{.underline}

**OK** Will close the page and return to the Laboratory Point of Contact
Maintenance page. No editing or processing will occur from this MORE
page.

**Cancel** Will close the page and discard any changes made on the MORE
page. The page will return to the Laboratory Point of Contact
Maintenance page.

**Help** Will invoke online system Help for this page.