The Contact feature class manages contact information, for example; company name, contact person, address, and email address.
The contact form provides access to several wastewater network features using the link buttons in the Related Tables tab.
- Feature class — WW_CONTACT
- Feature type — Attribute
Name | Data Type | Description |
---|---|---|
ACTIVE |
Number |
Is this contact active? (Yes/No) |
BANK |
Varchar2 |
The bank associated with this record. |
BANK_ACCOUNT_ID |
Varchar2 |
The bank account ID associated with this record. |
BANK_CODE |
Varchar2 |
The bank code associated with this record. |
BIRTH_DATE |
Date |
The date of birth associated with this record. |
BIRTH_NAME |
Varchar2 |
The name at birth of this record. |
BIRTH_PLACE |
Varchar2 |
The place of birth associated with this record. |
CITY |
Varchar2 |
The city associated with this record. |
COMPANY |
Varchar2 |
The company associated with this record. |
COMPANY_2 |
Varchar2 |
Additional company information for this record. |
DATE_CHANGED |
Date |
The date of the last time this record was changed. |
DATE_CREATED |
Date |
The date when this record was created. |
DIRECT_DIALING |
Varchar2 |
The direct dialing number for this record. |
|
Varchar2 |
The email address associated with this record. |
FAX |
Varchar2 |
The fax number associated with this record. |
FIRST_NAME |
Varchar2 |
The first name associated with this record. |
HOUSE |
Varchar2 |
The house number associated with this record. |
INTERNET |
Varchar2 |
The homepage URL associated with this record. |
JOB_DESCRIPTION |
Varchar2 |
The job description for this record. |
NAME |
Varchar2 |
The name associated with this record. |
NARRATIVE |
Varchar2 |
A description or other unique information concerning this record. |
PERSONAL_ID |
Varchar2 |
The ID of the person associated with this record. |
PHONE_MOBILE |
Varchar2 |
The mobile phone number. |
PHONE_OFFICE |
Varchar2 |
The office phone number. |
PHONE_PRIVATE |
Varchar2 |
The private phone number. |
POSTAL_CODE |
Varchar2 |
The postal code associated with this record. |
STREET |
Varchar2 |
The street associated with this record. |
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 this item's data integrity and should not be used to store this item's data. |