SMI_USR_IDENTITY

User Identity | #masterdata | Component: Social Media Intelligence Foundation
Column Name Description
CLIENT Client
DATAPROVIDERNAME FK Data Provider Name
USERIDINDATAPROVIDER FK Social Media User ID in Data Provider
COUNTER Counter
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ISLOGINIDENTITY Login Identity Show values
ISALLOWEDFORLOGIN Login Allowed Show values
ISEXPIREDSESSION Session Expired Show values
GENDER Gender Show values
ISVERIFIED Is Account Verified Show values
Column Name Description Domain name
SOCIALMEDIACHANNEL Social Media Channel Code SMI_UNIQUE_ID
SOCIALUSER Social Media User ID SMI_USER
NICKNAME Nickname SMI_NAME
LASTLOGINTIMESTAMP_UTC Last Login Timestamp TZNTSTMPL
PHOTOURL Social User Profile Image URL SMI_SOCIALUSERIMAGEURL
THUMBNAILURL Thumbnail URL SMI_URL
FIRSTNAME First Name SMI_USERNAME
LASTNAME Last Name SMI_USERNAME
AGE Social Media User Age SMI_AGE
BIRTHDAY Birth Day SMI_DAY
BIRTHMONTH Birth Month SMI_MONTH
BIRTHYEAR Birth Year SMI_YEAR
EMAIL E-mail SMI_EMAIL
COUNTRYCODE Country/Region Key LAND1
STATE State Name SMI_STATE
CITY Location SMI_LOCATIONNAME
ZIP Zip Code SMI_ZIP
PROFILEURL Link to User Profile in a Social Media Channel SMI_SOCIALUSERPROFILELINK
PROXIEDEMAIL Proxy E-mail SMI_EMAIL
ADDRESS Social Media User Address SMI_ADDRESS
LANGUAGES Languages Known SMI_LANG
PROFESSIONALHEADLINE Professional Headline SMI_PROFESSIONALHEADLINE
BIO Social Media User Bio SMI_BIO
INDUSTRY Industry Name SMI_NAME
SPECIALITIES Professional Strengths SMI_SPECIALITIES
RELIGION Religion SMI_RELIGION
POLITICALVIEW Political View SMI_POLITICALVIEW
INTERESTEDIN Interests SMI_INTERESTEDIN
RELATIONSHIPSTATUS Relationship Status SMI_RELATIONSHIPSTATUS
HOMETOWN Hometown SMI_LOCATIONNAME
FOLLOWERSCOUNT Number of Followers SMI_COUNT
FOLLOWINGCOUNT Following Count SMI_COUNT
USERNAME Social Media User Name SMI_USERNAME
LOCALE Language Code SMI_LOCALE
USERTIMEZONE Time Zone TZNZONE
DUMMY_USR_IDENTITY null
Master Data Relations Join Conditions
DataProviderName
  • Data Provider Name
  • Client
  • Social Media User ID in Data Provider
UserIDinDataProvider
  • Data Provider Name
  • Client
  • Social Media User ID in Data Provider