SOCIALDATA

Social Data Definition | #masterdata | Component: Social Media Intelligence Foundation
Column Name Description
CLIENT Client
SOCIALDATAUUID Social Data Identifier
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SOCIALPOSTACTIONSTATUS Social Post Action Status Show values
TYPE Social Media Post Type Show values
Column Name Description Domain name
SOCIALPOST Social Media Data ID String SMI_SOCIALPOST
LANGUAGE Language Description SMI_LANGUAGE
CREATEDBYUSER Created By User ID SMI_USER
CREATIONDATETIME Post Creation Timestamp SMI_DATETIME
SOCIALPOSTTYPE Type of Feeds Like Video, Photo, Status, Etc. SMI_SOCIALPOSTTYPE
SOCIALPOSTLINK Link to the Post in a Particular Social Media Channel SMI_SOCIALPOSTLINK
NUMBEROFPOSITIVEVOTES Count of Likes or Shares for a Post in Media Channel SMI_NUMBEROFPOSITIVEVOTES
LOCATIONNAME Location SMI_LOCATIONNAME
COUNTRYNAME Country SMI_COUNTRYNAME
LONGITUDEMEASURE Longitude SMI_GEOMEASURE
LATITUDEMEASURE Latitude SMI_GEOMEASURE
SOCIALPOSTCATEGORY Categorization of Social Post SMI_SOCIALPOSTCATEGORY
CREATIONUSERNAME Social Media User Name SMI_USERNAME
SOCIALPOSTRETRIVEDBYUSER User Details Used to Retrieve Social Post SMI_USERNAME
SOCIALPOSTSEARCHTERMTEXT Search Term SMI_SOCIALPOSTSEARCHTERMTEXT
CREATEDAT Creation Date and Time in System (UTC Timestamp) TZNTSTMPS
SOCIALPOSTTEXT Mention Text SMI_SOCIALPOSTTEXT
CREATIONDATETIME_UTC Creation Date and Time in Socl Media Channel (UTC Timestamp) TZNTSTMPS
SOCIALPOSTPARENT Social Media Data ID String SMI_SOCIALPOST
SOCIALPOSTROOT Social Media Data ID String SMI_SOCIALPOST
COUNTRYCODE Country/Region Key LAND1
INTERNAL_ID Internal ID of Social Media Post CRM_SOC_POST_INTERNAL_ID
POST_STATUS Object Status CRM_J_STATUS
MAIN_CATEGORY Assigned Main Category CHAR10
SENTIMENT Sentiment of Social Media Post CRM_SOC_DATA_SENTIMENT
SOCIAL_ACC_CODE ID of Social Media User Account CHAR4
PROCESSOR User Name in User Master Record XUBNAME
REPLY_CREATED_BY User Name in User Master Record XUBNAME
CONTENT_UC Social data content upper case CHAR255
SENDER_USER_ACCOUNT_UC Upper case of social user account CHAR100
SENDER_USER_ACCOUNT Social Media User Account SMI_SOCIALUSERACCOUNT
RECEIVER_USER_ACCOUNT Social Media User Account SMI_SOCIALUSERACCOUNT
RECEIVER_USER_ID Social Media User ID SMI_USER
RECEIVER_USER_ACCOUNT_UC Upper case of social user account CHAR100
Master Data Relations Join Conditions
Social Media Data Retrieval Mode
  • Social Media Data Retrieval Mode
  • Client
Social Media Channel Code