S_CONTACT_IDNTY_DOC Table

The following table shows details of the S_CONTACT_IDNTY_DOC table.

Column Name Data Type Comments

ROW_ID

Varchar

Required.

CONTACT_ID

Varchar

Required. Contact ID. The foreign key table is S_CONTACT.

ISS_COUNTRY_CD

Varchar

Country code.

ISS_STATE_CD

Varchar

State code.

TYPE_CD

Varchar

Required. National ID type, such as passport, driver’s license, and so on.

IDENTITY_DOC_NUM

Varchar

Required. National ID. By default, this is not encrypted.

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.