User
Stores details about Salesforce users, including login credentials, profiles, and roles.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the user record. | |
| Username | String | False |
Login name used by the user to sign in to Salesforce. | |
| LastName | String | False |
User's last name as entered in their profile. | |
| FirstName | String | False |
User's first name as entered in their profile. | |
| Name | String | True |
Full name of the user, typically a combination of first and last names. | |
| CompanyName | String | False |
Name of the company or organization the user is associated with. | |
| Division | String | False |
User's division within the organization, used for reporting and filtering. | |
| Department | String | False |
Department that the user belongs to, such as Sales or IT. | |
| Title | String | False |
Job title of the user within the organization. | |
| Street | String | False |
Street address listed in the user's contact information. | |
| City | String | False |
City listed in the user's contact information. | |
| State | String | False |
State or province listed in the user's contact information. | |
| PostalCode | String | False |
Postal or ZIP code listed in the user's contact information. | |
| Country | String | False |
Country listed in the user's contact information. | |
| Latitude | Double | False |
Geographic latitude coordinate for the user's address. | |
| Longitude | Double | False |
Geographic longitude coordinate for the user's address. | |
| String | False |
Email address used by the user for communication and notifications. | ||
| EmailPreferencesAutoBcc | Boolean | False |
Indicates if outgoing emails are automatically BCC'd to the sender. | |
| EmailPreferencesAutoBccStayInTouch | Boolean | False |
Specifies if stay-in-touch emails are automatically BCC'd to the sender. | |
| EmailPreferencesStayInTouchReminder | Boolean | False |
Indicates whether the user receives reminders to stay in touch with contacts. | |
| SenderEmail | String | False |
Email address used as the sender for outbound emails from this user. | |
| SenderName | String | False |
Display name used as the sender for outbound emails from this user. | |
| Signature | String | False |
Email signature appended to messages sent by the user. | |
| StayInTouchSubject | String | False |
Default subject line used for stay-in-touch request emails. | |
| StayInTouchSignature | String | False |
Signature used in stay-in-touch emails sent by the user. | |
| StayInTouchNote | String | False |
Default message body for stay-in-touch request emails. | |
| Phone | String | False |
Primary phone number listed for the user. | |
| Fax | String | False |
Fax number associated with the user. | |
| MobilePhone | String | False |
Mobile or cell phone number listed for the user. | |
| Alias | String | False |
Shortened alias or nickname used for identification in internal Salesforce processes. | |
| CommunityNickname | String | False |
Nickname used by the user in Salesforce communities. | |
| IsActive | Boolean | False |
Indicates whether the user account is currently active. | |
| TimeZoneSidKey | String | False |
Time zone setting for the user, which affects calendar and time-based features. | |
| UserRoleId | String | False |
UserRole.Id |
Identifier for the user role, which defines hierarchy and access levels. |
| LocaleSidKey | String | False |
Locale setting that controls regional formatting such as dates and numbers. | |
| ReceivesInfoEmails | Boolean | False |
Indicates whether the user receives informational emails from Salesforce. | |
| ReceivesAdminInfoEmails | Boolean | False |
Indicates whether the user receives administrative-related emails from Salesforce. | |
| EmailEncodingKey | String | False |
Character encoding used for the user's email communications, such as UTF-8 or ISO-8859-1. | |
| ProfileId | String | False |
Profile.Id |
Identifier of the profile assigned to the user, which defines their permissions and access. |
| UserType | String | True |
Category of the user, such as Standard, Partner, or Customer Portal. | |
| LanguageLocaleKey | String | False |
Language preference setting used to localize the user interface. | |
| EmployeeNumber | String | False |
Employee identification number assigned to the user by the organization. | |
| DelegatedApproverId | String | False |
Identifier of the user authorized to approve items on behalf of this user. | |
| ManagerId | String | False |
User.Id |
Identifier of the user's manager, used for hierarchy and reporting. |
| LastLoginDate | Datetime | True |
Date and time when the user last logged into Salesforce. | |
| LastPasswordChangeDate | Datetime | True |
Date and time when the user last changed or reset their password. | |
| CreatedDate | Datetime | True |
Date and time when the user record was created. | |
| CreatedById | String | True |
User.Id |
Identifier of the user who created this user record. |
| LastModifiedDate | Datetime | True |
Date and time when the user record was last updated. | |
| LastModifiedById | String | True |
User.Id |
Identifier of the user who last modified the user record. |
| SystemModstamp | Datetime | True |
System-generated timestamp of the most recent change to the user record. | |
| OfflineTrialExpirationDate | Datetime | True |
Expiration date of the user's trial license for Salesforce Offline Edition. | |
| OfflinePdaTrialExpirationDate | Datetime | True |
Expiration date of the user's trial license for Salesforce Sales Anywhere or PDA support. | |
| UserPermissionsMarketingUser | Boolean | False |
Indicates whether the user has marketing permissions, such as managing campaigns. | |
| UserPermissionsOfflineUser | Boolean | False |
Specifies whether the user has access to the Salesforce Offline Edition. | |
| UserPermissionsCallCenterAutoLogin | Boolean | False |
Allows the user to automatically log into the assigned call center. | |
| UserPermissionsMobileUser | Boolean | False |
Indicates whether the user is enabled for Salesforce mobile features. | |
| UserPermissionsSFContentUser | Boolean | False |
Specifies whether the user has access to Salesforce Customer Relationship Management (CRM) Content. | |
| UserPermissionsKnowledgeUser | Boolean | False |
Grants access to Salesforce Knowledge features. | |
| UserPermissionsInteractionUser | Boolean | False |
Allows the user to create, run, or manage flows in Flow Builder. | |
| UserPermissionsSupportUser | Boolean | False |
Grants Service Cloud access to the user, enabling case management and related features. | |
| UserPermissionsSiteforceContributorUser | Boolean | False |
Enables the user to contribute to Site.com (now Experience Cloud) content. | |
| UserPermissionsSiteforcePublisherUser | Boolean | False |
Allows the user to publish content within Site.com (Experience Cloud) environments. | |
| UserPermissionsChatterAnswersUser | Boolean | False |
Grants the user access to Chatter Answers, enabling community question and answer features. | |
| ForecastEnabled | Boolean | False |
Indicates whether the user can access forecasting features for sales planning. | |
| UserPreferencesActivityRemindersPopup | Boolean | False |
Determines whether the user receives pop-up reminders for activities. | |
| UserPreferencesEventRemindersCheckboxDefault | Boolean | False |
Controls whether event reminders are enabled by default when creating new events. | |
| UserPreferencesTaskRemindersCheckboxDefault | Boolean | False |
Controls whether reminders are enabled by default when creating new tasks. | |
| UserPreferencesReminderSoundOff | Boolean | False |
Indicates whether the reminder sound is disabled for pop-up notifications. | |
| UserPreferencesDisableAllFeedsEmail | Boolean | False |
Indicates whether the user has disabled all Chatter email notifications. | |
| UserPreferencesDisableFollowersEmail | Boolean | False |
Indicates whether the user has disabled email notifications when someone follows them. | |
| UserPreferencesDisableProfilePostEmail | Boolean | False |
Specifies whether the user receives emails for profile posts. | |
| UserPreferencesDisableChangeCommentEmail | Boolean | False |
Determines whether the user is notified by email when comments are changed. | |
| UserPreferencesDisableLaterCommentEmail | Boolean | False |
Indicates whether the user receives email notifications for later comments on posts they commented on. | |
| UserPreferencesDisProfPostCommentEmail | Boolean | False |
Specifies whether the user is notified about comments on their profile posts. | |
| UserPreferencesApexPagesDeveloperMode | Boolean | False |
Enables developer mode, which shows Apex debug logs and page component outlines. | |
| UserPreferencesHideCSNGetChatterMobileTask | Boolean | False |
Hides the task encouraging the user to install Chatter Mobile. | |
| UserPreferencesDisableMentionsPostEmail | Boolean | False |
Disables email notifications when the user is mentioned in a post. | |
| UserPreferencesDisMentionsCommentEmail | Boolean | False |
Disables email notifications when the user is mentioned in a comment. | |
| UserPreferencesHideCSNDesktopTask | Boolean | False |
Hides the task suggesting Chatter Desktop setup. | |
| UserPreferencesHideChatterOnboardingSplash | Boolean | False |
Suppresses the Chatter onboarding splash screen for the user. | |
| UserPreferencesHideSecondChatterOnboardingSplash | Boolean | False |
Suppresses a second Chatter onboarding screen, if available. | |
| UserPreferencesDisCommentAfterLikeEmail | Boolean | False |
Prevents email alerts for comments made after the user likes a post. | |
| UserPreferencesDisableLikeEmail | Boolean | False |
Indicates whether the user receives emails when someone likes their post. | |
| UserPreferencesDisableMessageEmail | Boolean | False |
Disables email notifications for private messages sent via Chatter. | |
| UserPreferencesOptOutOfTouch | Boolean | False |
Indicates whether the user has opted out of stay-in-touch requests. | |
| UserPreferencesDisableBookmarkEmail | Boolean | False |
Prevents email notifications when someone bookmarks the user's content. | |
| UserPreferencesDisableSharePostEmail | Boolean | False |
Disables email notifications for shared Chatter posts involving the user. | |
| UserPreferencesEnableAutoSubForFeeds | Boolean | False |
Automatically subscribes the user to feeds they interact with. | |
| UserPreferencesDisableFileShareNotificationsForApi | Boolean | False |
Disables email notifications triggered by API-based file shares. | |
| UserPreferencesShowTitleToExternalUsers | Boolean | False |
Allows the user's job title to be visible to external community users. | |
| UserPreferencesShowManagerToExternalUsers | Boolean | False |
Allows the user's manager information to be shown to external users. | |
| UserPreferencesShowEmailToExternalUsers | Boolean | False |
Allows the user's email address to be visible to external users. | |
| UserPreferencesShowWorkPhoneToExternalUsers | Boolean | False |
Allows the user's work phone number to be displayed to external users. | |
| UserPreferencesShowMobilePhoneToExternalUsers | Boolean | False |
Allows the user's mobile number to be visible to external users. | |
| UserPreferencesShowFaxToExternalUsers | Boolean | False |
Allows the user's fax number to be displayed to external users. | |
| UserPreferencesShowStreetAddressToExternalUsers | Boolean | False |
Allows the user's street address to be shown to external users. | |
| UserPreferencesShowCityToExternalUsers | Boolean | False |
Allows the user's city to be visible to external users. | |
| UserPreferencesShowStateToExternalUsers | Boolean | False |
Allows the user's state or province to be visible to external users. | |
| UserPreferencesShowPostalCodeToExternalUsers | Boolean | False |
Allows the user's postal or ZIP code to be displayed to external users. | |
| UserPreferencesShowCountryToExternalUsers | Boolean | False |
Allows the user's country to be visible to external users. | |
| UserPreferencesShowProfilePicToGuestUsers | Boolean | False |
Enables the user's profile picture to be shown to guest users. | |
| UserPreferencesShowTitleToGuestUsers | Boolean | False |
Allows the user's title to be shown to unauthenticated guest users. | |
| UserPreferencesShowCityToGuestUsers | Boolean | False |
Allows the user's city to be displayed to guest users. | |
| UserPreferencesShowStateToGuestUsers | Boolean | False |
Allows the user's state or province to be visible to guest (unauthenticated) users. | |
| UserPreferencesShowPostalCodeToGuestUsers | Boolean | False |
Allows the user's postal or ZIP code to be shown to guest users. | |
| UserPreferencesShowCountryToGuestUsers | Boolean | False |
Allows the user's country to be visible to guest users. | |
| UserPreferencesHideS1BrowserUI | Boolean | False |
Hides the Salesforce1 (now Salesforce mobile web) interface in the browser for the user. | |
| ContactId | String | False |
Contact.Id |
Identifier of the contact record associated with the user, if applicable. |
| AccountId | String | True |
Account.Id |
Identifier of the account linked to the user, primarily for community or partner users. |
| CallCenterId | String | False |
CallCenter.Id |
Identifier of the call center configuration assigned to the user. |
| Extension | String | False |
Phone extension number associated with the user for call center use. | |
| FederationIdentifier | String | False |
Unique SAML federation ID used for single sign-on (SSO) authentication. | |
| AboutMe | String | False |
Free-text field where the user can provide a brief biography or personal description. | |
| FullPhotoUrl | String | True |
URL linking to the user's full-sized profile photo. | |
| SmallPhotoUrl | String | True |
URL linking to the user's thumbnail-sized profile photo. | |
| DigestFrequency | String | False |
Frequency setting for how often the user receives Chatter digest emails. | |
| DefaultGroupNotificationFrequency | String | False |
Default notification frequency for Chatter group updates when the user joins a group. | |
| LastViewedDate | Datetime | True |
Timestamp indicating when the user record was last viewed. | |
| LastReferencedDate | Datetime | True |
Timestamp indicating when the user record was last referenced in related records or automation. | |
| GeoLoc__Latitude__s | Double | False |
Custom field capturing the user's geographic latitude, typically used for mapping or territory management. | |
| GeoLoc__Longitude__s | Double | False |
Custom field capturing the user's geographic longitude. | |
| GeoLoc__c | String | True |
Custom geolocation field storing latitude and longitude as a single string or formatted point. | |
| TextLong__c | String | False |
Custom long-text field for storing extended user information or metadata. | |
| ExternId__c | String | False |
Custom external identifier used to map the Salesforce user to an external system or source. |