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]