Oracle Customer Hub (UCM) Master Data Management Reference > Schema Changes for Oracle Customer Hub (UCM) Version 8.2 > New Tables for Oracle Customer Hub (UCM) Version 8.2 >

S_CIF_CON_NM_MP Table


Table 404 show details of the new S_CIF_CON_NM_MP table which is used for Name cross references.

Table 404. S_CIF_CON_NM_MP table details
Column Name
Data Type
Comments

ROW_ID

Varchar (15)

Required. Siebel system field.

CON_NAME_ID

Varchar (15)

Required. The name of the best version record ID. The foreign key table is S_CONTACT_NAME.

CIF_EXT_SYST_ID

Varchar (15)

Required. The external system ID. The foreign key table is S_CIF_EXT_SYST.

EXT_CON_NAME_ID1

Varchar (100)

Required. The first cross reference ID.

EXT_CON_NAME_ID2

Varchar (100)

Place holder for second cross reference ID.

EXT_CON_NAME_ID3

Varchar (100)

Place holder for third cross reference ID.

COMMENTS

Varchar (250)

Comments.

CONFLICT_ID

Varchar (15)

Required. Siebel system field.

CREATED

UTC Date Time (7)

Required. Siebel system field.

CREATED_BY

Varchar (15)

Required. Siebel system field. The foreign key table is S_USER.

DB_LAST_UPD

UTC Date Time (7)

Required. Siebel system field.

DB_LAST_UPD_SRC

Varchar (50)

Required. Siebel system field.

LAST_UPD

UTC Date Time (7)

Siebel system field.

LAST_UPD_BY

Varchar (15)

Siebel system field. The foreign key table is S_USER.

MODIFICATION_NUM

Number (22)

Siebel system field.

Oracle Customer Hub (UCM) Master Data Management Reference Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.