# User: User - Name: `User` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: User ## Table Columns The columns of the table `User` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AboutMe` | `string` | About Me | ☐ | | | `AccountId` | `string` | Account ID | ☐ | | | `Alias` | `string` | Alias | ☐ | | | `BadgeText` | `string` | Badge Text | ☐ | | | `BannerPhotoUrl` | `string` | Banner Photo (URL) | ☐ | | | `CallCenterId` | `string` | Call Center ID | ☐ | | | `City` | `string` | City | ☐ | | | `CommunityNickname` | `string` | Community Nickname | ☐ | | | `CompanyName` | `string` | Company Name | ☐ | | | `ContactId` | `string` | Contact ID | ☐ | | | `Country` | `string` | Country | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `DefaultGroupNotificationFrequency` | `string` | Default Group Notification Frequency | ☐ | | | `DelegatedApproverId` | `string` | Delegated Approver ID | ☐ | | | `Department` | `string` | Department | ☐ | | | `DigestFrequency` | `string` | Digest Frequency | ☐ | | | `Division` | `string` | Division | ☐ | | | `Email` | `string` | Email | ☐ | | | `EmailEncodingKey` | `string` | Email Encoding Key | ☐ | | | `EmailPreferencesAutoBcc` | `boolean` | Email Preferences Auto BCC | ☐ | | | `EmailPreferencesAutoBccStayInTouch` | `boolean` | Email Preferences Auto BCC Stay in Touch | ☐ | | | `EmailPreferencesStayInTouchReminder` | `boolean` | Email Preferences Stay in Touch Reminder | ☐ | | | `EmployeeNumber` | `string` | Employee Number | ☐ | | | `Extension` | `string` | Extension | ☐ | | | `Fax` | `string` | Fax | ☐ | | | `FederationIdentifier` | `string` | Federation Identifier | ☐ | | | `FirstName` | `string` | First Name | ☐ | | | `ForecastEnabled` | `boolean` | Forecast Enabled | ☐ | | | `FullPhotoUrl` | `string` | Full Photo (URL) | ☐ | | | `GeocodeAccuracy` | `string` | Geocode Accuracy | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsActive` | `boolean` | Is Active | ☐ | | | `IsProfilePhotoActive` | `boolean` | Is Profile Photo Active | ☐ | | | `JigsawImportLimitOverride` | `int32` | Jigsaw Import Limit Override | ☐ | | | `LanguageLocaleKey` | `string` | Language Locale Key | ☐ | | | `LastLoginDate` | `datetime` | Last Login Date | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastName` | `string` | Last Name | ☐ | | | `LastPasswordChangeDate` | `datetime` | Last Password Change Date | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `Latitude` | `double` | Latitude | ☐ | | | `LocaleSidKey` | `string` | Locale SID Key | ☐ | | | `Longitude` | `double` | Longitude | ☐ | | | `ManagerId` | `string` | Manager ID | ☐ | | | `MediumBannerPhotoUrl` | `string` | Medium Banner Photo URL | ☐ | | | `MediumPhotoUrl` | `string` | Medium Photo (URL) | ☐ | | | `MobilePhone` | `string` | Mobile Phone | ☐ | | | `Name` | `string` | Name | ☐ | | | `OfflinePdaTrialExpirationDate` | `datetime` | Offline PDA Trial Expiration Date | ☐ | | | `OfflineTrialExpirationDate` | `datetime` | Offline Trial Expiration Date | ☐ | | | `Phone` | `string` | Phone | ☐ | | | `PostalCode` | `string` | Postal Code | ☐ | | | `ProfileId` | `string` | Profile ID | ☐ | | | `ReceivesAdminInfoEmails` | `boolean` | Receives Admin Info Emails | ☐ | | | `ReceivesInfoEmails` | `boolean` | Receives Info Emails | ☐ | | | `SenderEmail` | `string` | Sender Email | ☐ | | | `SenderName` | `string` | Sender Name | ☐ | | | `Signature` | `string` | Signature | ☐ | | | `SmallBannerPhotoUrl` | `string` | Small Banner Photo URL | ☐ | | | `SmallPhotoUrl` | `string` | Small Photo (URL) | ☐ | | | `State` | `string` | State | ☐ | | | `StayInTouchNote` | `string` | Stay in Touch Note | ☐ | | | `StayInTouchSignature` | `string` | Stay in Touch Signature | ☐ | | | `StayInTouchSubject` | `string` | Stay in Touch Subject | ☐ | | | `Street` | `string` | Street | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `TimeZoneSidKey` | `string` | Timezone SID Key | ☐ | | | `Title` | `string` | Title | ☐ | | | `Username` | `string` | User Name | ☐ | | | `UserPermissionsCallCenterAutoLogin` | `boolean` | User Permissions Call Center Auto Login | ☐ | | | `UserPermissionsInteractionUser` | `boolean` | User Permissions Interaction User | ☐ | | | `UserPermissionsJigsawProspectingUser` | `boolean` | User Permissions Jigsaw Prospecting User | ☐ | | | `UserPermissionsKnowledgeUser` | `boolean` | User Permissions Knowledge User | ☐ | | | `UserPermissionsMarketingUser` | `boolean` | User Permissions Marketing User | ☐ | | | `UserPermissionsMobileUser` | `boolean` | User Permissions Mobile User | ☐ | | | `UserPermissionsOfflineUser` | `boolean` | User Permissions Offline User | ☐ | | | `UserPermissionsSFContentUser` | `boolean` | User Permissions Salesforce Content User | ☐ | | | `UserPermissionsSiteforceContributorUser` | `boolean` | User Permissions Site.com Contributor User | ☐ | | | `UserPermissionsSiteforcePublisherUser` | `boolean` | User Permissions Site.com Publisher User | ☐ | | | `UserPermissionsSupportUser` | `boolean` | User Permissions Support User | ☐ | | | `UserPermissionsWorkDotComUserFeature` | `boolean` | User Permissions Work.com User Feature | ☐ | | | `UserPreferencesActivityRemindersPopup` | `boolean` | User Preferences Activity Reminders Popup | ☐ | | | `UserPreferencesApexPagesDeveloperMode` | `boolean` | User Preferences Apex Pages Developer Mode | ☐ | | | `UserPreferencesCacheDiagnostics` | `boolean` | User Preferences Cache Diagnostics | ☐ | | | `UserPreferencesContentEmailAsAndWhen` | `boolean` | User Preferences Content Email as and When | ☐ | | | `UserPreferencesContentNoEmail` | `boolean` | User Preferences Content No Email | ☐ | | | `UserPreferencesCreateLEXAppsWTShown` | `boolean` | User Preferences Create LEX Apps WT Shown | ☐ | | | `UserPreferencesDisableAllFeedsEmail` | `boolean` | User Preferences Disable All Feeds Email | ☐ | | | `UserPreferencesDisableBookmarkEmail` | `boolean` | User Preferences Disable Bookmark Email | ☐ | | | `UserPreferencesDisableChangeCommentEmail` | `boolean` | User Preferences Disable Change Comment Email | ☐ | | | `UserPreferencesDisableEndorsementEmail` | `boolean` | User Preferences Disable Endorsement Email | ☐ | | | `UserPreferencesDisableFeedbackEmail` | `boolean` | User Preferences Disable Feedback Email | ☐ | | | `UserPreferencesDisableFileShareNotificationsForApi` | `boolean` | User Preferences Disable File Share Notifications for API | ☐ | | | `UserPreferencesDisableFollowersEmail` | `boolean` | User Preferences Disable Followers Email | ☐ | | | `UserPreferencesDisableLaterCommentEmail` | `boolean` | User Preferences Disable Later Comment Email | ☐ | | | `UserPreferencesDisableLikeEmail` | `boolean` | User Preferences Disable Like Email | ☐ | | | `UserPreferencesDisableMentionsPostEmail` | `boolean` | User Preferences Disable Mentions Post Email | ☐ | | | `UserPreferencesDisableMessageEmail` | `boolean` | User Preferences Disable Message Email | ☐ | | | `UserPreferencesDisableProfilePostEmail` | `boolean` | User Preferences Disable Profile Post Email | ☐ | | | `UserPreferencesDisableSharePostEmail` | `boolean` | User Preferences Disable Share Post Email | ☐ | | | `UserPreferencesDisableWorkEmail` | `boolean` | User Preferences Disable Work Email | ☐ | | | `UserPreferencesDisCommentAfterLikeEmail` | `boolean` | User Preferences Disable Comment After Like Email | ☐ | | | `UserPreferencesDisMentionsCommentEmail` | `boolean` | User Preferences Disable Mentions Comment Email | ☐ | | | `UserPreferencesDisProfPostCommentEmail` | `boolean` | User Preferences Disable Profile Post Comment Email | ☐ | | | `UserPreferencesEnableAutoSubForFeeds` | `boolean` | User Preferences Enable Auto Subscribe for Feeds | ☐ | | | `UserPreferencesEventRemindersCheckboxDefault` | `boolean` | User Preferences Event Reminders Checkbox Default | ☐ | | | `UserPreferencesFavoritesWTShown` | `boolean` | User Preferences Favorites WT Shown | ☐ | | | `UserPreferencesGlobalNavBarWTShown` | `boolean` | User Preferences Global Nav Bar WT Shown | ☐ | | | `UserPreferencesGlobalNavGridMenuWTShown` | `boolean` | User Preferences Global Nav Grid Menu WT Shown | ☐ | | | `UserPreferencesHideBiggerPhotoCallout` | `boolean` | User Preferences Hide Bigger Photo Callout | ☐ | | | `UserPreferencesHideChatterOnboardingSplash` | `boolean` | User Preferences Hide Chatter Onboarding Splash | ☐ | | | `UserPreferencesHideCSNDesktopTask` | `boolean` | User Preferences Hide CSN Desktop Task | ☐ | | | `UserPreferencesHideCSNGetChatterMobileTask` | `boolean` | User Preferences Hide CSN Get Chatter Mobile Task | ☐ | | | `UserPreferencesHideEndUserOnboardingAssistantModal` | `boolean` | User Preferences Hide End User Onboarding Assistant Modal | ☐ | | | `UserPreferencesHideLightningMigrationModal` | `boolean` | User Preferences Hide Lightning Migration Modal | ☐ | | | `UserPreferencesHideS1BrowserUI` | `boolean` | User Preferences Hide S1 Browser UI | ☐ | | | `UserPreferencesHideSecondChatterOnboardingSplash` | `boolean` | User Preferences Hide Second Chatter Onboarding Splash | ☐ | | | `UserPreferencesHideSfxWelcomeMat` | `boolean` | User Preferences Hide SFX Welcome Mat | ☐ | | | `UserPreferencesJigsawListUser` | `boolean` | User Preferences Jigsaw List User | ☐ | | | `UserPreferencesLightningExperiencePreferred` | `boolean` | User Preferences Lightning Experience Preferred | ☐ | | | `UserPreferencesPathAssistantCollapsed` | `boolean` | User Preferences Path Assistant Collapsed | ☐ | | | `UserPreferencesPreviewLightning` | `boolean` | User Preferences Preview Lightning | ☐ | | | `UserPreferencesReminderSoundOff` | `boolean` | User Preferences Reminder Sound Off | ☐ | | | `UserPreferencesShowCityToExternalUsers` | `boolean` | User Preferences Show City to External Users | ☐ | | | `UserPreferencesShowCityToGuestUsers` | `boolean` | User Preferences Show City to Guest Users | ☐ | | | `UserPreferencesShowCountryToExternalUsers` | `boolean` | User Preferences Show Country to External Users | ☐ | | | `UserPreferencesShowCountryToGuestUsers` | `boolean` | User Preferences Show Country to Guest Users | ☐ | | | `UserPreferencesShowEmailToExternalUsers` | `boolean` | User Preferences Show Email to External Users | ☐ | | | `UserPreferencesShowEmailToGuestUsers` | `boolean` | User Preferences Show Email to Guest Users | ☐ | | | `UserPreferencesShowFaxToExternalUsers` | `boolean` | User Preferences Show Fax to External Users | ☐ | | | `UserPreferencesShowFaxToGuestUsers` | `boolean` | User Preferences Show Fax to Guest Users | ☐ | | | `UserPreferencesShowManagerToExternalUsers` | `boolean` | User Preferences Show Manager to External Users | ☐ | | | `UserPreferencesShowManagerToGuestUsers` | `boolean` | User Preferences Show Manager to Guest Users | ☐ | | | `UserPreferencesShowMobilePhoneToExternalUsers` | `boolean` | User Preferences Show Mobile Phone to External Users | ☐ | | | `UserPreferencesShowMobilePhoneToGuestUsers` | `boolean` | User Preferences Show Mobile Phone to Guest Users | ☐ | | | `UserPreferencesShowPostalCodeToExternalUsers` | `boolean` | User Preferences Show Postal Code to External Users | ☐ | | | `UserPreferencesShowPostalCodeToGuestUsers` | `boolean` | User Preferences Show Postal Code to Guest Users | ☐ | | | `UserPreferencesShowProfilePicToGuestUsers` | `boolean` | User Preferences Show Profile Picture to Guest Users | ☐ | | | `UserPreferencesShowStateToExternalUsers` | `boolean` | User Preferences Show State to External Users | ☐ | | | `UserPreferencesShowStateToGuestUsers` | `boolean` | User Preferences Show State to Guest Users | ☐ | | | `UserPreferencesShowStreetAddressToExternalUsers` | `boolean` | User Preferences Show Street Address to External Users | ☐ | | | `UserPreferencesShowStreetAddressToGuestUsers` | `boolean` | User Preferences Show Street Address to Guest Users | ☐ | | | `UserPreferencesShowTitleToExternalUsers` | `boolean` | User Preferences Show Title to External Users | ☐ | | | `UserPreferencesShowTitleToGuestUsers` | `boolean` | User Preferences Show Title to Guest Users | ☐ | | | `UserPreferencesShowWorkPhoneToExternalUsers` | `boolean` | User Preferences Show Work Phone to External Users | ☐ | | | `UserPreferencesShowWorkPhoneToGuestUsers` | `boolean` | User Preferences Show Work Phone to Guest Users | ☐ | | | `UserPreferencesSortFeedByComment` | `boolean` | User Preferences Sort Feed by Comment | ☐ | | | `UserPreferencesTaskRemindersCheckboxDefault` | `boolean` | User Preferences Task Reminders Checkbox Default | ☐ | | | `UserRoleId` | `string` | User Role ID | ☐ | | | `UserType` | `string` | User Type | ☐ | |