SMI_USR_ACCOUNT

User Account | #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
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ISUSERREGISTERED Is the User Registered Show values
ISUSERACCOUNTVERIFIED Is User Account Verified Show values
ISUSERACCNTACTIVE Is User Account Active Show values
ISUSERACCNTLOCKEDOUT Is User Account Locked Show values
Column Name Description Domain name
USERIDSIGNATURE Signature SMI_USERIDSIG
SIGNATURETIMESTAMP_UTC User Acct Signature Timestamp (UTC) TZNTSTMPL
SOCIALMEDIACHANNEL Social Media Channel Code SMI_UNIQUE_ID
USERREGSTRDTIMESTAMP_UTC User Registered Timestamp (UTC) TZNTSTMPL
USERACCNTVERIFIEDTIMESTAMP_UTC User Acct Verified Timestamp (UTC) TZNTSTMPL
INFLUENCERRANK Influencer Rank SMI_USER_INFLUENCERRANK
LASTLOGINLOCATION_COUNTRYCODE Country/Region Key LAND1
LASTLOGINLOCATION_STATE State Name SMI_STATE
LASTLOGINLOCATION_CITY Location SMI_LOCATIONNAME
LASTLOGINLOCATION_LATITUDE User Latitude Measure SMI_MEASURE
LASTLOGINLOCATION_LONGITUDE User Longitude Measure SMI_MEASURE
OLDESTDATAUPDATEDTIMESTAMP_UTC Oldest Update Timestamp (UTC) TZNTSTMPL
ACCOUNTCREATEDTIMESTAMP_UTC User Account Created Timestamp (UTC) TZNTSTMPL
REGISTRATIONSOURCE User Registration Source SMI_REGISTRATIONSOURCE
DUMMY_USR_ACCOUNT null
Master Data Relations Join Conditions
Data Provider Name
  • Data Provider Name
  • Client
  • Social Media User ID in Data Provider
User ID in Data Provider
  • Data Provider Name
  • Client
  • Social Media User ID in Data Provider