Oracle Customer Hub (UCM) Master Data Management Reference > Schema Changes for Oracle Customer Hub (UCM) Version 8.2 > Modified Tables for Oracle Customer Hub (UCM) Version 8.2 >
S_CONTACT_IDNTY_DOC Table
Table 419 shows details of the S_CONTACT_IDNTY_DOC table.
Table 419. S_CONTACT_IDNTY_DOC table
|
|
|
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. |
|