CONTACT_ID

Varchar

Required. The foreign key table is S_CONTACT.

ROW_ID

Varchar

Required.

TYPE_CD

Varchar

Required. Values include Legal, Maiden, Diploma, and so on.

FST_NAME

Varchar

Person's first name.

LAST_NAME

Varchar

Person's last name.

MID_NAME

Varchar

Person's middle name.

SECOND_LAST_NAME

Varchar

Optional. Second last name. Used for contacts with two last names.

FULL_NAME

Varchar

Required. Concatenation of first, middle, last, and second last name.

ALIAS_NAME

Varchar

Optional. Alternate name used by person.

NICK_NAME

Varchar

Optional. Person's nickname.

PER_TITLE

Varchar

Personal Title. Values include Mr., Mrs., Dr., and so on.

PER_TITLE_SUFFIX

Varchar

Personal title suffix. Values include Esq., CPA, PhD, and so on.

PREF_FST_NAME

Varchar

Preferred first name.

HONORARY_TITLE

Varchar

Job title.

ROYAL_PREFIX

Varchar

Royal prefix. Rarely used, but it is required for royal contacts.

ROYAL_SUFFIX

Varchar

Royal suffix. Rarely used, but it is required for royal contacts.

EFF_START_DT

Date

Required. Effective start date. The default value is created date, but this value can be overwritten.

EFF_END_DT

Date

Effective end date.

CNTRY_FORMAT_MASK

Varchar

Country name format.