Skip to main content

Cloud

User profile properties in SharePoint 2010

This post gives a listing of the User Profile properties available Out-of-the-Box in SharePoint 2010 and additional properties added by NewsGator Social Sites 2010 when installed on top of MySites.

It can be a handy resource in cases where you do not have access to the Central Admin or the User Profile Service Application.

Column Headers explained:

Property Name – gives the display name of the property.

Property Type – gives the data type of the property as it is stored in the database.

Table 1: SharePoint 2010 Out-of-the-Box User Profile properties

SharePoint 2010 OOTB User Properties
 
Display Name Internal Name Property Type
Basic Information SPS-Section-BasicInfo Section
Id UserProfile_GUID unique identifier
SID SID binary
Active Directory Id ADGuid binary
Account name AccountName Person <Specific to connection>
First name FirstName string (Single Value)
Phonetic First Name SPS-PhoneticFirstName string (Single Value)
Last name LastName string (Single Value)
Phonetic Last Name SPS-PhoneticLastName string (Single Value)
Name PreferredName ‪string (Single Value)‬
Phonetic Display Name SPS-PhoneticDisplayName string (Single Value)
Work phone WorkPhone string (Single Value)
Department Department string (Single Value)
Title Title string (Single Value)
Job Title SPS-JobTitle string (Single Value)
Manager Manager Person
About me AboutMe HTML
Personal site PersonalSpace URL
Picture PictureURL URL
User name UserName string (Single Value)
Quick links QuickLinks string (Single Value)
Web site WebSite URL
Public site redirect PublicSiteRedirect URL
Data source SPS-DataSource string (Single Value)
MemberOf SPS-MemberOf string (Multi Value)
Dotted-line Manager SPS-Dotted-line Person
Peers SPS-Peers string (Single Value)
Ask Me About SPS-Responsibility string (Multi Value)
SIP Address SPS-SipAddress string (Single Value)
My Site Upgrade SPS-MySiteUpgrade boolean
Don’t Suggest List SPS-DontSuggestList Person
Proxy addresses SPS-ProxyAddresses string (Multi Value)
Hire date SPS-HireDate date
Display Order SPS-DisplayOrder integer
Claim User Identifier SPS-ClaimID string (Single Value)
Claim Provider Identifier SPS-ClaimProviderID string (Single Value)
Claim Provider Type SPS-ClaimProviderType string (Single Value)
Last Colleague Added SPS-LastColleagueAdded date
Outlook Web Access URL SPS-OWAUrl URL
Saved Account Name SPS-SavedAccountName string (Single Value)
Saved SID SPS-SavedSID binary
Resource Forest SID SPS-ResourceSID binary
Object Exists SPS-ObjectExists string (Single Value)
Distinguished Name SPS-DistinguishedName string (Single Value)
Source Object Distinguished Name SPS-SourceObjectDN string (Multi Value)
Last Keyword Added SPS-LastKeywordAdded date
Contact Information SPS-Section-ContactInfo Section
Work e-mail WorkEmail E-mail
Mobile phone CellPhone string (Single Value)
Fax Fax string (Single Value)
Home phone HomePhone string (Single Value)
Office Office string (Single Value)
Office Location SPS-Location string (Single Value)
Time Zone SPS-TimeZone time zone
Assistant Assistant Person
Details SPS-Section-Details Section
Past projects SPS-PastProjects string (Multi Value)
Skills SPS-Skills string (Multi Value)
Schools SPS-School string (Multi Value)
Birthday SPS-Birthday date no year
Status Message SPS-StatusNotes string (Single Value)
Delegation SPS-Section-Delegation Section
Newsfeed Settings SPS-Section-Preferences Section
Interests SPS-Interests string (Multi Value)
Email Notifications SPS-EmailOptin integer
Custom Properties SPS-Section-CustomProperties Section

Table 2: Additional properties added by NewsGator Social Sites 2010

Additional NewsGator SocialSites 2010 Properties

Display Name Internal Name Property Type
Social Notification Properties NewsGatorProperties Section
Receive Instant Notification Emails NGAllowMetaEmail Boolean
Receive 24-hour Digest Email NGReceiveDigestEmail Boolean

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Madhuri Jagiasi

More from this Author

Follow Us