|
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) for Siebel Innovation Pack 2014 >
S_CIF_SMPROFMAP Table
Table 400 shows details for the new S_CIF_SMPROFMAP cross reference table which is used to provide support for Social Media Profile Cross Reference data.
Table 400. S_CIF_SMPROFMAP table details
|
|
|
ROW_ID |
Varchar (15) |
Siebel system field. |
CON_SMPROF_ID |
Varchar 15) |
Social Media Profile Best Version Record ID |
CIF_EXT_SYST_ID |
Varchar (15) |
External System ID. |
EXT_CON_SMPROF_ID1 |
Varchar (100) |
First Cross Reference ID. |
EXT_CON_SMPROF_ID2 |
Varchar (100) |
Place holder for second cross reference ID. |
EXT_CON_SMPROF_ID3 |
Varchar (100) |
Place holder for third cross reference ID. |
COMMENTS |
Varchar (250) |
Comments. |
CONFLICT_ID |
Varchar (15) |
Siebel system field. |
CREATED |
UTC Date Time (7) |
Siebel system field. |
CREATED_BY |
Varchar (15) |
Siebel system field. |
DB_LAST_UPD |
UTC Date Time (7) |
Siebel system field. |
DB_LAST_UPD_SRC |
Varchar (50) |
Siebel system field. |
LAST_UPD |
UTC Date Time (7) |
Siebel system field. |
LAST_UPD_BY |
Varchar (15) |
Siebel system field. |
MODIFICATION_NUM |
Number (22) |
Siebel system field. |
| 
