****************************************************************************************************
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]