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_SMATTRMAP Table
Table 401 shows details for the new S_CIF_SMATTRMAP cross reference table which is used to provide support for Social Media Profile Attribute Cross Reference data.
Table 401. S_CIF_SMATTRMAP table details
|
|
|
ROW_ID |
Varchar (15) |
Siebel system field. |
CON_SMATTR_ID |
Varchar 15) |
Social Media Profile Attribute Best Version Record ID. |
CIF_EXT_SYST_ID |
Varchar (15) |
External System ID. |
EXT_CON_SMATTR_ID1 |
Varchar (100) |
First Cross Reference ID. |
EXT_CON_SMATTR_ID2 |
Varchar (100) |
Place holder for second cross reference ID. |
EXT_CON_SMATTR_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. |
|