Table 398. S_UCM_CN_SMPROF 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_PROF_ID |
Varchar (15) |
The best version ID. A null value means the child record is unlinked. |
UCM_CONTACT_ID |
Varchar (15) |
The parent UCM contact ID. |
CONTACT_ID |
Varchar (15) |
The BV parent contact ID. |
AUTHOR1_ID_VAL |
Varchar (255) |
The author ID value provided by a data provider or a social integrator. |
AUTHOR_LINK_URL |
Varchar (500) |
The unique URL of the author profile on a social media site. |
AUTHOR_NAME |
Varchar (100) |
The unique user name of the contact on a specific social media site (such as Twitter or Facebook). For example: @user_name. This author name is unique within the social media site. |
CHANNEL_CD |
Varchar (30) |
A social media channel such as Facebook or Twitter which is associated with a contact or person. |
SUPPRESS_PROF_FLG |
Character(1) |
The flag indicates whether social profile attributes for a specific profile or author from a given social media channel are retrieved. |