C_Smi_Usr_Consolidate

Consumption view for User Information from Data Provider | view: CSMIUSRDPINFO | Extraction: Not supported | Component: Social Media Intelligence Foundation
Tables used: SMI_USR_IDENTITY
Column Name Description
SocialDataProviderName FK Data Provider Name
UserIdInSocialDataProvider FK Social Media User ID in Data Provider
SocialMediaIdentityCounter Counter
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsLogInSocialMediaIdentity Login Identity Show values
IsAllowedForLogIn Login Allowed Show values
IsExpiredSession Session Expired Show values
GenderCode Gender Show values
IsVerifiedSocialProfile Is Account Verified Show values
Column Name Description Domain name
SocialMediaChannel Social Media Channel Code SMI_UNIQUE_ID
SocialUserID Social Media User ID SMI_USER
NickName Nickname SMI_NAME
LastLogInTimeStampUTC Last Login Timestamp TZNTSTMPL
SocialMediaProfilePhotoURL Social User Profile Image URL SMI_SOCIALUSERIMAGEURL
SocialMediaProfileThumbnailURL Thumbnail URL SMI_URL
FirstName First Name SMI_USERNAME
LastName Last Name SMI_USERNAME
AgeOfSocialUser Social Media User Age SMI_AGE
DayOfBirth Birth Day SMI_DAY
MonthOfBirth Birth Month SMI_MONTH
YearOfBirth Birth Year SMI_YEAR
EmailIDOfSocialUser E-mail SMI_EMAIL
CountryCode Country/Region Key LAND1
RegionName State Name SMI_STATE
CityName Location SMI_LOCATIONNAME
PostalCode Zip Code SMI_ZIP
SocialMediaProfileURL Link to User Profile in a Social Media Channel SMI_SOCIALUSERPROFILELINK
ProxyEmailAddress Proxy E-mail SMI_EMAIL
AddressText Social Media User Address SMI_ADDRESS
LanguagesKnownBySocialUser Languages Known SMI_LANG
ProfessionalHeadLine Professional Headline SMI_PROFESSIONALHEADLINE
BiographyOfSocialUser Social Media User Bio SMI_BIO
IndustryName Industry Name SMI_NAME
SocialUserSpecializationInfo Professional Strengths SMI_SPECIALITIES
Religion Religion SMI_RELIGION
PoliticalView Political View SMI_POLITICALVIEW
InterestedIn Interests SMI_INTERESTEDIN
RelationshipStatusText Relationship Status SMI_RELATIONSHIPSTATUS
HomeTown Hometown SMI_LOCATIONNAME
FollowersCountOfSocialUser Number of Followers SMI_COUNT
SocialUserFollowingCount Following Count SMI_COUNT
SocialMediaUserName Social Media User Name SMI_USERNAME
LocaleLanguage Language Code SMI_LOCALE
SocialUserTimeZone Time Zone TZNZONE
Master Data Relations Join Conditions
DataProviderName
  • Data Provider Name
  • Social Media User ID in Data Provider
  • Client
UserIDinDataProvider
  • Data Provider Name
  • Social Media User ID in Data Provider
  • Client