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.