Share
 
 

Contact Feature Class

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.

EMAIL

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.

Was this information helpful?