Find it EZ

Location: Tableau Server
Host: http://bnbrepository9/#/
Path: Tableau Samples/Quarterly Sales
Datasource Opportunities (Salesforce)
Query(s)
SELECT
        [Opportunities].[Id] AS [Opportunity ID],
        [Opportunities].[IsDeleted] AS [IsDeleted (Opportunities)],
        [Opportunities].[AccountId] AS [AccountId (Opportunities)],
        [Opportunities].[IsPrivate] AS [Private],
        [Opportunities].[Name] AS [Name (Opportunities)],
        [Opportunities].[StageName] AS [Stage],
        [Opportunities].[Amount],
        [Opportunities].[Probability] AS [Probability (%)],
        [Opportunities].[ExpectedRevenue] AS [Expected Amount],
        [Opportunities].[TotalOpportunityQuantity] AS [Quantity],
        [Opportunities].[CloseDate] AS [Close Date],
        [Opportunities].[Type] AS [Opportunity Type],
        [Opportunities].[NextStep] AS [Next Step],
        [Opportunities].[LeadSource] AS [Lead Source],
        [Opportunities].[IsClosed] AS [Closed],
        [Opportunities].[IsWon] AS [Won],
        [Opportunities].[ForecastCategory] AS [Forecast Category],
        [Opportunities].[ForecastCategoryName] AS [Forecast Category1],
        [Opportunities].[CampaignId] AS [Campaign ID],
        [Opportunities].[HasOpportunityLineItem] AS [Has Line Item],
        [Opportunities].[Pricebook2Id] AS [Price Book ID],
        [Opportunities].[OwnerId] AS [OwnerId (Opportunities)],
        [Opportunities].[CreatedDate] AS [CreatedDate (Opportunities)],
        [Opportunities].[CreatedById] AS [CreatedById (Opportunities)],
        [Opportunities].[LastModifiedDate] AS [LastModifiedDate (Opportunities)],
        [Opportunities].[LastModifiedById] AS [LastModifiedById (Opportunities)],
        [Opportunities].[SystemModstamp] AS [SystemModstamp (Opportunities)],
        [Opportunities].[LastActivityDate] AS [LastActivityDate (Opportunities)],
        [Opportunities].[FiscalQuarter] AS [Fiscal Quarter],
        [Opportunities].[FiscalYear] AS [Fiscal Year],
        [Opportunities].[Fiscal] AS [Fiscal Period],
        [Opportunities].[DeliveryInstallationStatus__c] AS [Delivery/Installation Status],
        [Opportunities].[TrackingNumber__c] AS [Tracking Number],
        [Opportunities].[OrderNumber__c] AS [Order Number],
        [Opportunities].[CurrentGenerators__c] AS [Current Generator(s)],
        [Opportunities].[MainCompetitors__c] AS [Main Competitor(s)]
FROM
        [Opportunity] AS [Opportunities]
SELECT
        [Account].[Id] AS [Id (Account)],
        [Account].[IsDeleted] AS [Deleted],
        [Account].[MasterRecordId] AS [Master Record ID],
        [Account].[Name] AS [Account Name],
        [Account].[Type] AS [Account Type],
        [Account].[ParentId] AS [Parent Account ID],
        [Account].[BillingStreet] AS [Billing Street],
        [Account].[BillingCity] AS [Billing City],
        [Account].[BillingState] AS [Billing State/Province],
        [Account].[BillingPostalCode] AS [Billing Zip/Postal Code],
        [Account].[BillingCountry] AS [Billing Country],
        [Account].[ShippingStreet] AS [Shipping Street],
        [Account].[ShippingCity] AS [Shipping City],
        [Account].[ShippingState] AS [Shipping State/Province],
        [Account].[ShippingPostalCode] AS [Shipping Zip/Postal Code],
        [Account].[ShippingCountry] AS [Shipping Country],
        [Account].[Phone] AS [Account Phone],
        [Account].[Fax] AS [Account Fax],
        [Account].[AccountNumber] AS [Account Number],
        [Account].[Website],
        [Account].[Sic] AS [SIC Code],
        [Account].[Industry],
        [Account].[AnnualRevenue] AS [Annual Revenue],
        [Account].[NumberOfEmployees] AS [Employees],
        [Account].[Ownership],
        [Account].[TickerSymbol] AS [Ticker Symbol],
        [Account].[Rating] AS [Account Rating],
        [Account].[Site] AS [Account Site],
        [Account].[OwnerId] AS [Owner ID],
        [Account].[CreatedDate] AS [CreatedDate (Account)],
        [Account].[CreatedById] AS [CreatedById (Account)],
        [Account].[LastModifiedDate] AS [LastModifiedDate (Account)],
        [Account].[LastModifiedById] AS [LastModifiedById (Account)],
        [Account].[SystemModstamp] AS [SystemModstamp (Account)],
        [Account].[LastActivityDate] AS [Last Activity],
        [Account].[Jigsaw] AS [Data.com Key],
        [Account].[JigsawCompanyId] AS [Jigsaw Company ID],
        [Account].[CleanStatus] AS [Clean Status],
        [Account].[AccountSource] AS [Account Source],
        [Account].[DunsNumber] AS [D-U-N-S Number],
        [Account].[Tradestyle],
        [Account].[NaicsCode] AS [NAICS Code],
        [Account].[NaicsDesc] AS [NAICS Description],
        [Account].[YearStarted] AS [Year Started],
        [Account].[SicDesc] AS [SIC Description],
        [Account].[DandbCompanyId] AS [D&B Company ID],
        [Account].[CustomerPriority__c] AS [Customer Priority],
        [Account].[SLA__c] AS [SLA],
        [Account].[Active__c] AS [Active],
        [Account].[NumberofLocations__c] AS [Number of Locations],
        [Account].[UpsellOpportunity__c] AS [Upsell Opportunity],
        [Account].[SLASerialNumber__c] AS [SLA Serial Number],
        [Account].[SLAExpirationDate__c] AS [SLA Expiration Date]
FROM
        [Account]
SELECT
        [OpportunityLineItem].[Id] AS [Line Item ID],
        [OpportunityLineItem].[OpportunityId] AS [OpportunityId (Opportunity Product)],
        [OpportunityLineItem].[SortOrder] AS [Sort Order],
        [OpportunityLineItem].[PricebookEntryId] AS [Price Book Entry ID],
        [OpportunityLineItem].[Quantity] AS [Quantity (Opportunity Product)],
        [OpportunityLineItem].[TotalPrice] AS [Total Price],
        [OpportunityLineItem].[UnitPrice] AS [Sales Price],
        [OpportunityLineItem].[ListPrice] AS [List Price],
        [OpportunityLineItem].[ServiceDate] AS [Date],
        [OpportunityLineItem].[Description] AS [Line Description],
        [OpportunityLineItem].[CreatedDate] AS [Created Date],
        [OpportunityLineItem].[CreatedById] AS [Created By ID],
        [OpportunityLineItem].[LastModifiedDate] AS [Last Modified Date],
        [OpportunityLineItem].[LastModifiedById] AS [Last Modified By ID],
        [OpportunityLineItem].[SystemModstamp] AS [System Modstamp],
        [OpportunityLineItem].[IsDeleted] AS [IsDeleted (Opportunity Product)]
FROM
        [OpportunityLineItem]
SELECT
        [PricebookEntry].[Id] AS [Id (Price Book Entry)],
        [PricebookEntry].[Name] AS [Product Name],
        [PricebookEntry].[Pricebook2Id] AS [Pricebook2Id (Price Book Entry)],
        [PricebookEntry].[Product2Id] AS [Product ID],
        [PricebookEntry].[UnitPrice] AS [UnitPrice (Price Book Entry)],
        [PricebookEntry].[IsActive] AS [IsActive (Price Book Entry)],
        [PricebookEntry].[UseStandardPrice] AS [Use Standard Price],
        [PricebookEntry].[CreatedDate] AS [CreatedDate (Price Book Entry)],
        [PricebookEntry].[CreatedById] AS [CreatedById (Price Book Entry)],
        [PricebookEntry].[LastModifiedDate] AS [LastModifiedDate (Price Book Entry)],
        [PricebookEntry].[LastModifiedById] AS [LastModifiedById (Price Book Entry)],
        [PricebookEntry].[SystemModstamp] AS [SystemModstamp (Price Book Entry)],
        [PricebookEntry].[ProductCode] AS [Product Code],
        [PricebookEntry].[IsDeleted] AS [IsDeleted (Price Book Entry)]
FROM
        [PricebookEntry]
SELECT
        [Product2].[Id] AS [Id (Product)],
        [Product2].[Name] AS [Name (Product)],
        [Product2].[ProductCode] AS [ProductCode (Product)],
        [Product2].[Description] AS [Product Description],
        [Product2].[IsActive] AS [IsActive (Product)],
        [Product2].[CreatedDate] AS [CreatedDate (Product)],
        [Product2].[CreatedById] AS [CreatedById (Product)],
        [Product2].[LastModifiedDate] AS [LastModifiedDate (Product)],
        [Product2].[LastModifiedById] AS [LastModifiedById (Product)],
        [Product2].[SystemModstamp] AS [SystemModstamp (Product)],
        [Product2].[Family] AS [Product Family],
        [Product2].[IsDeleted] AS [IsDeleted (Product)]
FROM
        [Product2]
SELECT
        [Opportunity Owner].[Id] AS [User ID],
        [Opportunity Owner].[Username],
        [Opportunity Owner].[LastName] AS [Last Name],
        [Opportunity Owner].[FirstName] AS [First Name],
        [Opportunity Owner].[Name] AS [Full Name],
        [Opportunity Owner].[CompanyName] AS [Company Name],
        [Opportunity Owner].[Division],
        [Opportunity Owner].[Department],
        [Opportunity Owner].[Title],
        [Opportunity Owner].[Street],
        [Opportunity Owner].[City],
        [Opportunity Owner].[State] AS [State/Province],
        [Opportunity Owner].[PostalCode] AS [Zip/Postal Code],
        [Opportunity Owner].[Country],
        [Opportunity Owner].[Email],
        [Opportunity Owner].[Phone],
        [Opportunity Owner].[Fax],
        [Opportunity Owner].[MobilePhone] AS [Cell],
        [Opportunity Owner].[Alias],
        [Opportunity Owner].[CommunityNickname] AS [Nickname],
        [Opportunity Owner].[IsActive] AS [IsActive (User)],
        [Opportunity Owner].[TimeZoneSidKey] AS [Time Zone],
        [Opportunity Owner].[UserRoleId] AS [Role ID],
        [Opportunity Owner].[LocaleSidKey] AS [Locale],
        [Opportunity Owner].[ReceivesInfoEmails] AS [Info Emails],
        [Opportunity Owner].[ReceivesAdminInfoEmails] AS [Admin Info Emails],
        [Opportunity Owner].[EmailEncodingKey] AS [Email Encoding],
        [Opportunity Owner].[ProfileId] AS [Profile ID],
        [Opportunity Owner].[UserType] AS [User Type],
        [Opportunity Owner].[LanguageLocaleKey] AS [Language],
        [Opportunity Owner].[EmployeeNumber] AS [Employee Number],
        [Opportunity Owner].[DelegatedApproverId] AS [Delegated Approver ID],
        [Opportunity Owner].[ManagerId] AS [Manager ID],
        [Opportunity Owner].[LastLoginDate] AS [Last Login],
        [Opportunity Owner].[LastPasswordChangeDate] AS [Last Password Change or Reset],
        [Opportunity Owner].[CreatedDate] AS [CreatedDate (User)],
        [Opportunity Owner].[CreatedById] AS [CreatedById (User)],
        [Opportunity Owner].[LastModifiedDate] AS [LastModifiedDate (User)],
        [Opportunity Owner].[LastModifiedById] AS [LastModifiedById (User)],
        [Opportunity Owner].[SystemModstamp] AS [SystemModstamp (User)],
        [Opportunity Owner].[OfflineTrialExpirationDate] AS [Offline Edition Trial Expiration Date],
        [Opportunity Owner].[OfflinePdaTrialExpirationDate] AS [Sales Anywhere Trial Expiration Date],
        [Opportunity Owner].[UserPermissionsMarketingUser] AS [Marketing User],
        [Opportunity Owner].[UserPermissionsOfflineUser] AS [Offline User],
        [Opportunity Owner].[UserPermissionsCallCenterAutoLogin] AS [Auto-login To Call Center],
        [Opportunity Owner].[UserPermissionsMobileUser] AS [Apex Mobile User],
        [Opportunity Owner].[UserPermissionsSFContentUser] AS [Salesforce CRM Content User],
        [Opportunity Owner].[UserPermissionsKnowledgeUser] AS [Knowledge User],
        [Opportunity Owner].[UserPermissionsInteractionUser] AS [Force.com Flow User],
        [Opportunity Owner].[UserPermissionsSupportUser] AS [Service Cloud User],
        [Opportunity Owner].[UserPermissionsJigsawProspectingUser] AS [Data.com User],
        [Opportunity Owner].[UserPermissionsSiteforceContributorUser] AS [Site.com Contributor User],
        [Opportunity Owner].[UserPermissionsSiteforcePublisherUser] AS [Site.com Publisher User],
        [Opportunity Owner].[ForecastEnabled] AS [Allow Forecasting],
        [Opportunity Owner].[UserPreferencesActivityRemindersPopup] AS [ActivityRemindersPopup],
        [Opportunity Owner].[UserPreferencesEventRemindersCheckboxDefault] AS [EventRemindersCheckboxDefault],
        [Opportunity Owner].[UserPreferencesTaskRemindersCheckboxDefault] AS [TaskRemindersCheckboxDefault],
        [Opportunity Owner].[UserPreferencesReminderSoundOff] AS [ReminderSoundOff],
        [Opportunity Owner].[UserPreferencesDisableAllFeedsEmail] AS [DisableAllFeedsEmail],
        [Opportunity Owner].[UserPreferencesDisableFollowersEmail] AS [DisableFollowersEmail],
        [Opportunity Owner].[UserPreferencesDisableProfilePostEmail] AS [DisableProfilePostEmail],
        [Opportunity Owner].[UserPreferencesDisableChangeCommentEmail] AS [DisableChangeCommentEmail],
        [Opportunity Owner].[UserPreferencesDisableLaterCommentEmail] AS [DisableLaterCommentEmail],
        [Opportunity Owner].[UserPreferencesDisProfPostCommentEmail] AS [DisProfPostCommentEmail],
        [Opportunity Owner].[UserPreferencesContentNoEmail] AS [ContentNoEmail],
        [Opportunity Owner].[UserPreferencesContentEmailAsAndWhen] AS [ContentEmailAsAndWhen],
        [Opportunity Owner].[UserPreferencesApexPagesDeveloperMode] AS [ApexPagesDeveloperMode],
        [Opportunity Owner].[UserPreferencesHideCSNGetChatterMobileTask] AS [HideCSNGetChatterMobileTask],
        [Opportunity Owner].[UserPreferencesDisableMentionsPostEmail] AS [DisableMentionsPostEmail],
        [Opportunity Owner].[UserPreferencesDisMentionsCommentEmail] AS [DisMentionsCommentEmail],
        [Opportunity Owner].[UserPreferencesHideCSNDesktopTask] AS [HideCSNDesktopTask],
        [Opportunity Owner].[UserPreferencesDisCommentAfterLikeEmail] AS [DisCommentAfterLikeEmail],
        [Opportunity Owner].[UserPreferencesDisableLikeEmail] AS [DisableLikeEmail],
        [Opportunity Owner].[UserPreferencesSortFeedByComment] AS [SortFeedByComment],
        [Opportunity Owner].[UserPreferencesDisableMessageEmail] AS [DisableMessageEmail],
        [Opportunity Owner].[UserPreferencesOptOutOfTouch] AS [OptOutOfTouch],
        [Opportunity Owner].[UserPreferencesDisableBookmarkEmail] AS [DisableBookmarkEmail],
        [Opportunity Owner].[UserPreferencesDisableSharePostEmail] AS [DisableSharePostEmail],
        [Opportunity Owner].[UserPreferencesEnableAutoSubForFeeds] AS [EnableAutoSubForFeeds],
        [Opportunity Owner].[UserPreferencesDisableFileShareNotificationsForApi] AS [DisableFileShareNotificationsForApi],
        [Opportunity Owner].[UserPreferencesLightningExperiencePreferred] AS [LightningExperiencePreferred],
        [Opportunity Owner].[ContactId] AS [Contact ID],
        [Opportunity Owner].[AccountId] AS [Account ID],
        [Opportunity Owner].[CallCenterId] AS [Call Center ID],
        [Opportunity Owner].[Extension],
        [Opportunity Owner].[FederationIdentifier] AS [SAML Federation ID],
        [Opportunity Owner].[AboutMe] AS [About Me],
        [Opportunity Owner].[FullPhotoUrl] AS [Url for full-sized Photo],
        [Opportunity Owner].[SmallPhotoUrl] AS [Photo],
        [Opportunity Owner].[DigestFrequency] AS [Chatter Email Highlights Frequency],
        [Opportunity Owner].[DefaultGroupNotificationFrequency] AS [Default Notification Frequency when Joining Groups]
FROM
        [User] AS [Opportunity Owner]
SELECT
        [UserRole].[Id] AS [Id (Role)],
        [UserRole].[Name],
        [UserRole].[ParentRoleId] AS [Parent Role ID],
        [UserRole].[RollupDescription] AS [Description],
        [UserRole].[OpportunityAccessForAccountOwner] AS [Opportunity Access Level for Account Owner],
        [UserRole].[CaseAccessForAccountOwner] AS [Case Access Level for Account Owner],
        [UserRole].[ContactAccessForAccountOwner] AS [Contact Access Level for Account Owner],
        [UserRole].[ForecastUserId] AS [ForecastUserId (Role)],
        [UserRole].[MayForecastManagerShare] AS [May Forecast Manager Share],
        [UserRole].[LastModifiedDate] AS [LastModifiedDate (Role)],
        [UserRole].[LastModifiedById] AS [LastModifiedById (Role)],
        [UserRole].[SystemModstamp] AS [SystemModstamp (Role)],
        [UserRole].[DeveloperName] AS [Developer Name],
        [UserRole].[PortalAccountId] AS [PortalAccountId (Role)],
        [UserRole].[PortalType] AS [Portal Type],
        [UserRole].[PortalAccountOwnerId] AS [User ID1]
FROM
        [UserRole]
SELECT
        [Manager].[Id] AS [Id (User)],
        [Manager].[Username] AS [Username (User)],
        [Manager].[LastName] AS [LastName (User)],
        [Manager].[FirstName] AS [FirstName (User)],
        [Manager].[Name] AS [Name (User)],
        [Manager].[CompanyName] AS [CompanyName (User)],
        [Manager].[Division] AS [Division (User)],
        [Manager].[Department] AS [Department (User)],
        [Manager].[Title] AS [Title (User)],
        [Manager].[Street] AS [Street (User)],
        [Manager].[City] AS [City (User)],
        [Manager].[State] AS [State (User)],
        [Manager].[PostalCode] AS [PostalCode (User)],
        [Manager].[Country] AS [Country (User)],
        [Manager].[Email] AS [Email (User)],
        [Manager].[Phone] AS [Phone (User)],
        [Manager].[Fax] AS [Fax (User)],
        [Manager].[MobilePhone] AS [MobilePhone (User)],
        [Manager].[Alias] AS [Alias (User)],
        [Manager].[CommunityNickname] AS [CommunityNickname (User)],
        [Manager].[IsActive] AS [IsActive (User) #1],
        [Manager].[TimeZoneSidKey] AS [TimeZoneSidKey (User)],
        [Manager].[UserRoleId] AS [UserRoleId (User)],
        [Manager].[LocaleSidKey] AS [LocaleSidKey (User)],
        [Manager].[ReceivesInfoEmails] AS [ReceivesInfoEmails (User)],
        [Manager].[ReceivesAdminInfoEmails] AS [ReceivesAdminInfoEmails (User)],
        [Manager].[EmailEncodingKey] AS [EmailEncodingKey (User)],
        [Manager].[ProfileId] AS [ProfileId (User)],
        [Manager].[UserType] AS [UserType (User)],
        [Manager].[LanguageLocaleKey] AS [LanguageLocaleKey (User)],
        [Manager].[EmployeeNumber] AS [EmployeeNumber (User)],
        [Manager].[DelegatedApproverId] AS [DelegatedApproverId (User)],
        [Manager].[ManagerId] AS [ManagerId (User)],
        [Manager].[LastLoginDate] AS [LastLoginDate (User)],
        [Manager].[LastPasswordChangeDate] AS [LastPasswordChangeDate (User)],
        [Manager].[CreatedDate] AS [CreatedDate (User) #1],
        [Manager].[CreatedById] AS [CreatedById (User) #1],
        [Manager].[LastModifiedDate] AS [LastModifiedDate (User) #1],
        [Manager].[LastModifiedById] AS [LastModifiedById (User) #1],
        [Manager].[SystemModstamp] AS [SystemModstamp (User) #1],
        [Manager].[OfflineTrialExpirationDate] AS [OfflineTrialExpirationDate (User)],
        [Manager].[OfflinePdaTrialExpirationDate] AS [OfflinePdaTrialExpirationDate (User)],
        [Manager].[UserPermissionsMarketingUser] AS [UserPermissionsMarketingUser (User)],
        [Manager].[UserPermissionsOfflineUser] AS [UserPermissionsOfflineUser (User)],
        [Manager].[UserPermissionsCallCenterAutoLogin] AS [UserPermissionsCallCenterAutoLogin (User)],
        [Manager].[UserPermissionsMobileUser] AS [UserPermissionsMobileUser (User)],
        [Manager].[UserPermissionsSFContentUser] AS [UserPermissionsSFContentUser (User)],
        [Manager].[UserPermissionsKnowledgeUser] AS [UserPermissionsKnowledgeUser (User)],
        [Manager].[UserPermissionsInteractionUser] AS [UserPermissionsInteractionUser (User)],
        [Manager].[UserPermissionsSupportUser] AS [UserPermissionsSupportUser (User)],
        [Manager].[UserPermissionsJigsawProspectingUser] AS [UserPermissionsJigsawProspectingUser (User)],
        [Manager].[UserPermissionsSiteforceContributorUser] AS [UserPermissionsSiteforceContributorUser (User)],
        [Manager].[UserPermissionsSiteforcePublisherUser] AS [UserPermissionsSiteforcePublisherUser (User)],
        [Manager].[ForecastEnabled] AS [ForecastEnabled (User)],
        [Manager].[UserPreferencesActivityRemindersPopup] AS [UserPreferencesActivityRemindersPopup (User)],
        [Manager].[UserPreferencesEventRemindersCheckboxDefault] AS [UserPreferencesEventRemindersCheckboxDefault (User)],
        [Manager].[UserPreferencesTaskRemindersCheckboxDefault] AS [UserPreferencesTaskRemindersCheckboxDefault (User)],
        [Manager].[UserPreferencesReminderSoundOff] AS [UserPreferencesReminderSoundOff (User)],
        [Manager].[UserPreferencesDisableAllFeedsEmail] AS [UserPreferencesDisableAllFeedsEmail (User)],
        [Manager].[UserPreferencesDisableFollowersEmail] AS [UserPreferencesDisableFollowersEmail (User)],
        [Manager].[UserPreferencesDisableProfilePostEmail] AS [UserPreferencesDisableProfilePostEmail (User)],
        [Manager].[UserPreferencesDisableChangeCommentEmail] AS [UserPreferencesDisableChangeCommentEmail (User)],
        [Manager].[UserPreferencesDisableLaterCommentEmail] AS [UserPreferencesDisableLaterCommentEmail (User)],
        [Manager].[UserPreferencesDisProfPostCommentEmail] AS [UserPreferencesDisProfPostCommentEmail (User)],
        [Manager].[UserPreferencesContentNoEmail] AS [UserPreferencesContentNoEmail (User)],
        [Manager].[UserPreferencesContentEmailAsAndWhen] AS [UserPreferencesContentEmailAsAndWhen (User)],
        [Manager].[UserPreferencesApexPagesDeveloperMode] AS [UserPreferencesApexPagesDeveloperMode (User)],
        [Manager].[UserPreferencesHideCSNGetChatterMobileTask] AS [UserPreferencesHideCSNGetChatterMobileTask (User)],
        [Manager].[UserPreferencesDisableMentionsPostEmail] AS [UserPreferencesDisableMentionsPostEmail (User)],
        [Manager].[UserPreferencesDisMentionsCommentEmail] AS [UserPreferencesDisMentionsCommentEmail (User)],
        [Manager].[UserPreferencesHideCSNDesktopTask] AS [UserPreferencesHideCSNDesktopTask (User)],
        [Manager].[UserPreferencesDisCommentAfterLikeEmail] AS [UserPreferencesDisCommentAfterLikeEmail (User)],
        [Manager].[UserPreferencesDisableLikeEmail] AS [UserPreferencesDisableLikeEmail (User)],
        [Manager].[UserPreferencesSortFeedByComment] AS [UserPreferencesSortFeedByComment (User)],
        [Manager].[UserPreferencesDisableMessageEmail] AS [UserPreferencesDisableMessageEmail (User)],
        [Manager].[UserPreferencesOptOutOfTouch] AS [UserPreferencesOptOutOfTouch (User)],
        [Manager].[UserPreferencesDisableBookmarkEmail] AS [UserPreferencesDisableBookmarkEmail (User)],
        [Manager].[UserPreferencesDisableSharePostEmail] AS [UserPreferencesDisableSharePostEmail (User)],
        [Manager].[UserPreferencesEnableAutoSubForFeeds] AS [UserPreferencesEnableAutoSubForFeeds (User)],
        [Manager].[UserPreferencesDisableFileShareNotificationsForApi] AS [UserPreferencesDisableFileShareNotificationsForApi (User)],
        [Manager].[UserPreferencesLightningExperiencePreferred] AS [UserPreferencesLightningExperiencePreferred (User)],
        [Manager].[ContactId] AS [ContactId (User)],
        [Manager].[AccountId] AS [AccountId (User)],
        [Manager].[CallCenterId] AS [CallCenterId (User)],
        [Manager].[Extension] AS [Extension (User)],
        [Manager].[FederationIdentifier] AS [FederationIdentifier (User)],
        [Manager].[AboutMe] AS [AboutMe (User)],
        [Manager].[FullPhotoUrl] AS [FullPhotoUrl (User)],
        [Manager].[SmallPhotoUrl] AS [SmallPhotoUrl (User)],
        [Manager].[DigestFrequency] AS [DigestFrequency (User)],
        [Manager].[DefaultGroupNotificationFrequency] AS [DefaultGroupNotificationFrequency (User)]
FROM
        [User] AS [Manager]