SMI_USR_IDENTITY - User Identity

User Identity information is stored in SAP table SMI_USR_IDENTITY.
It is part of development package BS_SOMI_DATA_MODELS in software component CA-EPT-SMI. This development package consists of objects that can be grouped under "Datta Models for Social Media Intelligence".

Fields for table SMI_USR_IDENTITY

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	*
DATAPROVIDERNAME	Data Provider Name	X	SMI_DATAPROVIDERNAME	CHAR	20	SMI_USR_PROFILE
USERIDINDATAPROVIDER	Social Media User ID in Data Provider	X	SMI_USERIDINDATAPROVIDER	CHAR	160	SMI_USR_PROFILE
COUNTER	Counter	X	SMI_COUNTER	INT4	4
SOCIALMEDIACHANNEL	Social Media Channel Code		SMI_SOCIALMEDIACHANNEL	CHAR	8
SOCIALUSER	Social Media User ID		SMI_SOCIALUSER	CHAR	100
ISLOGINIDENTITY	Login Identity		SMI_ISLOGINIDENTITY	CHAR	2
NICKNAME	Nickname		SMI_NICKNAME	CHAR	160
ISALLOWEDFORLOGIN	Login Allowed		SMI_ISALLOWEDFORLOGIN	CHAR	2
ISEXPIREDSESSION	Session Expired		SMI_ISEXPIREDSESSION	CHAR	2
LASTLOGINTIMESTAMP_UTC	Last Login Timestamp		SMI_LASTLOGINTIMESTAMP	DEC	11
PHOTOURL	Social User Profile Image URL		SMI_SOCIALUSERIMAGEURL	CHAR	1024
THUMBNAILURL	Thumbnail URL		SMI_THUMBNAILURL	CHAR	1024
FIRSTNAME	First Name		SMI_FNAME	CHAR	510
LASTNAME	Last Name		SMI_LNAME	CHAR	510
GENDER	Gender		SMI_GENDERCODE	CHAR	2
AGE	Social Media User Age		SMI_AGE	CHAR	6
BIRTHDAY	Birth Day		SMI_BIRTHDAY	CHAR	4
BIRTHMONTH	Birth Month		SMI_BIRTHMONTH	CHAR	4
BIRTHYEAR	Birth Year		SMI_BIRTHYEAR	CHAR	8
EMAIL	E-mail		SMI_EMAIL	CHAR	510
COUNTRYCODE	Country/Region Key		LAND1	CHAR	6	*
STATE	State Name		SMI_STATE	CHAR	100
CITY	Location		SMI_LOCATIONNAME	CHAR	100
PROFILEURL	Link to User Profile in a Social Media Channel		SMI_SOCIALUSERPROFILELINK	CHAR	510
PROXIEDEMAIL	Proxy E-mail		SMI_PROXYEMAIL	CHAR	510
ADDRESS	Social Media User Address		SMI_ADDRESS	STRG	8
LANGUAGES	Languages Known		SMI_LANG	STRG	8
PROFESSIONALHEADLINE	Professional Headline		SMI_PROFESSIONALHEADLINE	STRG	8
BIO	Social Media User Bio		SMI_BIO	STRG	8
INDUSTRY	Industry Name		SMI_INDUSTRY	CHAR	160
SPECIALITIES	Professional Strengths		SMI_SPECIALITIES	STRG	8
RELIGION	Religion		SMI_RELIGION	CHAR	100
POLITICALVIEW	Political View		SMI_POLITICALVIEW	CHAR	100
INTERESTEDIN	Interests		SMI_INTERESTEDIN	CHAR	510
RELATIONSHIPSTATUS	Relationship Status		SMI_RELATIONSHIPSTATUS	CHAR	100
HOMETOWN	Hometown		SMI_HOMETOWN	CHAR	100
FOLLOWERSCOUNT	Number of Followers		SMI_FOLLOWERSCOUNT	INT4	4
FOLLOWINGCOUNT	Following Count		SMI_FOLLOWINGCOUNT	INT4	4
USERNAME	Social Media User Name		SMI_SOCIALUSERNAME	CHAR	510
LOCALE	Language Code		SMI_LOCALE	CHAR	40
ISVERIFIED	Is Account Verified		SMI_ISVERIFIED	CHAR	2
USERTIMEZONE	Time Zone		SMI_TIMEZONE	CHAR	12	*
.INCLUDE				SMI_S_USR_IDENTITY_CI	0
DUMMY_USR_IDENTITY	Dummy Description			CHAR	2