Table 400. S_UCM_CN_SMATTR table details
|
|
|
ROW_ID |
Varchar (15) |
Siebel system field. |
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. |
BV_LAST_UPD |
UTC Date Time (7) |
The last update date time of the best version record. |
BV_LAST_UPD_BY |
Varchar (15) |
The last updated user login of the best version record. |
EXT_SYST_ID |
Varchar (15) |
External system ID. |
UCM_EXT_ID |
Varchar (100) |
The UCM external unique identifier. |
UCM_EXT_LOGIN |
Varchar (30) |
External user login. |
UCM_EXT_UPD_TS |
UTC Date Time (7) |
The last updated date of the external system. |
UCM_TXN_DESC |
Varchar (250) |
The UCM transaction description. |
UCM_TYPE_CD |
Varchar (30) |
The status or type of the record. |
UCM_UID |
Varchar (100) |
The UCM unique identifier. |
CON_SM_ATTR_ID |
Varchar (15) |
The best version ID. A null value means the child record is unlinked. |
UCM_CON_SM_PROF_ID |
Varchar (15) |
The parent UCM contact social media profile ID. |
CON_SM_PROF_ID |
Varchar (15) |
The BV parent contact social media profile ID. |
NAME |
Varchar (100) |
Attribute name of the profile recieved from a source system, such as: Follower, Tweets, Friends, Likes, Age, DoB, and so on. |
SOURCE_CD |
Varchar (30) |
The source (data provider) through which the profile data, such as: Buzzient, Visible, Actionly, Hotsuite, and so on. |
VALUE |
Varchar (500) |
Value for an attribute. For example, Name = Pradeep, Followers = 59, Friends = 150, and Likes = 2. |
