A house connector is the point at which a service connects to a house.
- Computation table — WW_HOUSE_CONNECTOR
- Feature type — Attribute
| Name | Data Type | Description |
|---|---|---|
|
BOTTOM_ELEVATION |
Number |
The elevation of the bottom part of the item relative to the section, measured in meters. |
|
CADASTRAL_INFO |
Varchar2 |
Description of cadastral information, such as land boundaries, structure locations, boundary dimensions, etc. |
|
CONNECTION_FEE |
Number |
The connection fee for the house connection. |
|
DATE_ACQUIRED |
Date |
The acquisition date of the data. |
|
DATE_CREATION |
Date |
The date when the item was created. |
|
DATE_STARTUP |
Date |
The date when responsibility for the item was taken. |
|
FID_CONSESSIONAIRE |
Number |
The concessionaire of this item. Related to:
|
|
FID_INSTALLER |
Number |
The enterprise in charge of building the item. Related to:
|
|
FID_LOCATION |
Number |
The location of the item (street).
Related to:
|
|
FID_MAINTENANCE |
Number |
The company that is responsible for the maintenance of this item. Related to:
|
|
FID_OPERATOR |
Number |
The operator of this item Related to:
|
|
FID_OWNER |
Number |
The owner of this item Related to:
|
|
HOUSE |
Varchar2 |
The house number. |
|
HOUSE_SUPPLEMENT |
Varchar2 |
The house number supplement. |
|
ID_ACCURACY |
Number |
How the current position of the item was determined. For example, exactly, by positioning, unknown, inexactly, etc. Related to:
|
|
ID_CONDITION |
Number |
The condition of the item. For example, broken, leaking, etc. Related to:
|
|
ID_DISPOSITION_STATE |
Number |
The state of the disposition of the item. For example, death, planed, etc. Related to:
|
|
ID_OWNERSHIP |
Number |
The owner of this item. Related to:
|
|
ID_PRE_TREATMENT |
Number |
The type of pre-treatment made before the house connection. Related to:
|
|
JURISTIC_NAME_NUMBER |
Varchar2 |
The juristic name or number (construction number). |
|
LOCATION |
Varchar2 |
A brief description of where the item is located. For example, 1m of the wall. |
|
NAME_NUMBER |
Varchar2 |
The name or number of this item. |
|
NARRATIVE |
Varchar2 |
A description or other unique information concerning the subject item. |
| PUMP_POWER |
Number |
The power of the pump used at the house connection. |
|
RETENSION_CAPACITY |
Number |
The retention capacity for the house connection measured in cubic meters. |
|
ROUTE_NUMBER |
Varchar2 |
The meter-reading route/area for the house connection meter. |
|
USER_FLAG |
Varchar2 |
An operator defined work area. This attribute can be used by the operator for user defined system processes. It does not effect the subject item's data integrity and should not be used to store the subject item's data. |
For more information, see Network Point Creation.
Manage Customer Information
The WW_HOUSE_CONNECTOR table has a Customer Number attribute. However, there is no table for managing customer information because customers often use external software (for example, SAP) for this purpose.
To manage customer information, use the Data Model Administrator to create the appropriate feature classes.
To manage customer information
- Create a new Customer feature class in the Administration topic.
- Add attributes as needed, for example Name, Address, Telephone, and Email.
- Customize the feature class form using the Form Designer.
- In the House Connector form, add a Basic ComboBox control for Customer Number and create the relation to the newly created table containing the customers.
For more information, see the Form Designer Introduction.
Generate Customer Notifications
The Wastewater module helps you generate notification letters regarding planned work or problems in the wastewater network. For example, you might do a network trace to find all house connectors in an affected area so you can notify customers.
There are three ways to generate customer notification letters.
- Use the Report Designer.
For more information about the Report Designer, see the Report Designer Introduction.
- Use AutoCAD Map 3D toolset to export to Microsoft® Word.
- Export the data to any format and use external software to generate letters. For example, export a customer list to Microsoft® Excel®.