SSIS Components for Salesforce

Build 25.0.9434

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.

GeocodeAccuracy String False

Accuracy level of the geocode for the address.

Email String False

Email address used by the user for communication and notifications.

EmailPreferencesAutoBcc Bool False

Indicates if outgoing emails are automatically BCC'd to the sender.

EmailPreferencesAutoBccStayInTouch Bool False

Specifies if stay-in-touch emails are automatically BCC'd to the sender.

EmailPreferencesStayInTouchReminder Bool 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.

BadgeText String True

Field containing BadgeText information.

IsActive Bool 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 Bool False

Indicates whether the user receives informational emails from Salesforce.

ReceivesAdminInfoEmails Bool 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.

DefaultCurrencyIsoCode String False

Field containing DefaultCurrencyIsoCode information.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

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.

StartDay String False

Field containing StartDay information.

EndDay String False

Field containing EndDay information.

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.

LastModifiedById String True

User.Id

Identifier of the user who last modified the user record.

PasswordExpirationDate Datetime True

Date associated with PasswordExpiration.

NumberOfFailedLogins Int True

Field containing NumberOfFailedLogins information.

SuAccessExpirationDate Date True

Date associated with SuAccessExpiration.

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 Bool False

Indicates whether the user has marketing permissions, such as managing campaigns.

UserPermissionsOfflineUser Bool False

Specifies whether the user has access to the Salesforce Offline Edition.

UserPermissionsCallCenterAutoLogin Bool False

Allows the user to automatically log into the assigned call center.

UserPermissionsSFContentUser Bool False

Specifies whether the user has access to Salesforce Customer Relationship Management (CRM) Content.

UserPermissionsKnowledgeUser Bool False

Grants access to Salesforce Knowledge features.

UserPermissionsInteractionUser Bool False

Allows the user to create, run, or manage flows in Flow Builder.

UserPermissionsSupportUser Bool False

Grants Service Cloud access to the user, enabling case management and related features.

UserPermissionsJigsawProspectingUser Bool False

Field containing UserPermissionsJigsawProspectingUser information.

UserPermissionsSiteforceContributorUser Bool False

Enables the user to contribute to Site.com (now Experience Cloud) content.

UserPermissionsSiteforcePublisherUser Bool False

Allows the user to publish content within Site.com (Experience Cloud) environments.

UserPermissionsWorkDotComUserFeature Bool False

Field containing UserPermissionsWorkDotComUserFeature information.

ForecastEnabled Bool False

Indicates whether the user can access forecasting features for sales planning.

UserPreferencesActivityRemindersPopup Bool False

Determines whether the user receives pop-up reminders for activities.

UserPreferencesEventRemindersCheckboxDefault Bool False

Controls whether event reminders are enabled by default when creating new events.

UserPreferencesTaskRemindersCheckboxDefault Bool False

Controls whether reminders are enabled by default when creating new tasks.

UserPreferencesReminderSoundOff Bool False

Indicates whether the reminder sound is disabled for pop-up notifications.

UserPreferencesDisableAllFeedsEmail Bool False

Indicates whether the user has disabled all Chatter email notifications.

UserPreferencesDisableFollowersEmail Bool False

Indicates whether the user has disabled email notifications when someone follows them.

UserPreferencesDisableProfilePostEmail Bool False

Specifies whether the user receives emails for profile posts.

UserPreferencesDisableChangeCommentEmail Bool False

Determines whether the user is notified by email when comments are changed.

UserPreferencesDisableLaterCommentEmail Bool False

Indicates whether the user receives email notifications for later comments on posts they commented on.

UserPreferencesDisProfPostCommentEmail Bool False

Specifies whether the user is notified about comments on their profile posts.

UserPreferencesContentNoEmail Bool False

Field containing UserPreferencesContentNoEmail information.

UserPreferencesContentEmailAsAndWhen Bool False

Field containing UserPreferencesContentEmailAsAndWhen information.

UserPreferencesApexPagesDeveloperMode Bool False

Enables developer mode, which shows Apex debug logs and page component outlines.

UserPreferencesReceiveNoNotificationsAsApprover Bool False

Field containing UserPreferencesReceiveNoNotificationsAsApprover information.

UserPreferencesReceiveNotificationsAsDelegatedApprover Bool False

Field containing UserPreferencesReceiveNotificationsAsDelegatedApprover information.

UserPreferencesHideCSNGetChatterMobileTask Bool False

Hides the task encouraging the user to install Chatter Mobile.

UserPreferencesDisableMentionsPostEmail Bool False

Disables email notifications when the user is mentioned in a post.

UserPreferencesDisMentionsCommentEmail Bool False

Disables email notifications when the user is mentioned in a comment.

UserPreferencesHideCSNDesktopTask Bool False

Hides the task suggesting Chatter Desktop setup.

UserPreferencesHideChatterOnboardingSplash Bool False

Suppresses the Chatter onboarding splash screen for the user.

UserPreferencesHideSecondChatterOnboardingSplash Bool False

Suppresses a second Chatter onboarding screen, if available.

UserPreferencesDisCommentAfterLikeEmail Bool False

Prevents email alerts for comments made after the user likes a post.

UserPreferencesDisableLikeEmail Bool False

Indicates whether the user receives emails when someone likes their post.

UserPreferencesSortFeedByComment Bool False

Field containing UserPreferencesSortFeedByComment information.

UserPreferencesDisableMessageEmail Bool False

Disables email notifications for private messages sent via Chatter.

UserPreferencesJigsawListUser Bool False

Field containing UserPreferencesJigsawListUser information.

UserPreferencesDisableBookmarkEmail Bool False

Prevents email notifications when someone bookmarks the user's content.

UserPreferencesDisableSharePostEmail Bool False

Disables email notifications for shared Chatter posts involving the user.

UserPreferencesActionLauncherEinsteinGptConsent Bool False

Field containing UserPreferencesActionLauncherEinsteinGptConsent information.

UserPreferencesAssistiveActionsEnabledInActionLauncher Bool False

Field containing UserPreferencesAssistiveActionsEnabledInActionLauncher information.

UserPreferencesEnableAutoSubForFeeds Bool False

Automatically subscribes the user to feeds they interact with.

UserPreferencesDisableFileShareNotificationsForApi Bool False

Disables email notifications triggered by API-based file shares.

UserPreferencesShowTitleToExternalUsers Bool False

Allows the user's job title to be visible to external community users.

UserPreferencesShowManagerToExternalUsers Bool False

Allows the user's manager information to be shown to external users.

UserPreferencesShowEmailToExternalUsers Bool False

Allows the user's email address to be visible to external users.

UserPreferencesShowWorkPhoneToExternalUsers Bool False

Allows the user's work phone number to be displayed to external users.

UserPreferencesShowMobilePhoneToExternalUsers Bool False

Allows the user's mobile number to be visible to external users.

UserPreferencesShowFaxToExternalUsers Bool False

Allows the user's fax number to be displayed to external users.

UserPreferencesShowStreetAddressToExternalUsers Bool False

Allows the user's street address to be shown to external users.

UserPreferencesShowCityToExternalUsers Bool False

Allows the user's city to be visible to external users.

UserPreferencesShowStateToExternalUsers Bool False

Allows the user's state or province to be visible to external users.

UserPreferencesShowPostalCodeToExternalUsers Bool False

Allows the user's postal or ZIP code to be displayed to external users.

UserPreferencesShowCountryToExternalUsers Bool False

Allows the user's country to be visible to external users.

UserPreferencesShowProfilePicToGuestUsers Bool False

Enables the user's profile picture to be shown to guest users.

UserPreferencesShowTitleToGuestUsers Bool False

Allows the user's title to be shown to unauthenticated guest users.

UserPreferencesShowCityToGuestUsers Bool False

Allows the user's city to be displayed to guest users.

UserPreferencesShowStateToGuestUsers Bool False

Allows the user's state or province to be visible to guest (unauthenticated) users.

UserPreferencesShowPostalCodeToGuestUsers Bool False

Allows the user's postal or ZIP code to be shown to guest users.

UserPreferencesShowCountryToGuestUsers Bool False

Allows the user's country to be visible to guest users.

UserPreferencesShowForecastingChangeSignals Bool False

Field containing UserPreferencesShowForecastingChangeSignals information.

UserPreferencesLiveAgentMiawSetupDeflection Bool False

Field containing UserPreferencesLiveAgentMiawSetupDeflection information.

UserPreferencesHideS1BrowserUI Bool False

Hides the Salesforce1 (now Salesforce mobile web) interface in the browser for the user.

UserPreferencesDisableEndorsementEmail Bool False

Field containing UserPreferencesDisableEndorsementEmail information.

UserPreferencesPathAssistantCollapsed Bool False

Field containing UserPreferencesPathAssistantCollapsed information.

UserPreferencesCacheDiagnostics Bool False

Field containing UserPreferencesCacheDiagnostics information.

UserPreferencesShowEmailToGuestUsers Bool False

Field containing UserPreferencesShowEmailToGuestUsers information.

UserPreferencesShowManagerToGuestUsers Bool False

Field containing UserPreferencesShowManagerToGuestUsers information.

UserPreferencesShowWorkPhoneToGuestUsers Bool False

Field containing UserPreferencesShowWorkPhoneToGuestUsers information.

UserPreferencesShowMobilePhoneToGuestUsers Bool False

Field containing UserPreferencesShowMobilePhoneToGuestUsers information.

UserPreferencesShowFaxToGuestUsers Bool False

Field containing UserPreferencesShowFaxToGuestUsers information.

UserPreferencesShowStreetAddressToGuestUsers Bool False

Field containing UserPreferencesShowStreetAddressToGuestUsers information.

UserPreferencesLightningExperiencePreferred Bool False

Field containing UserPreferencesLightningExperiencePreferred information.

UserPreferencesPreviewLightning Bool False

Field containing UserPreferencesPreviewLightning information.

UserPreferencesHideEndUserOnboardingAssistantModal Bool False

Field containing UserPreferencesHideEndUserOnboardingAssistantModal information.

UserPreferencesHideLightningMigrationModal Bool False

Field containing UserPreferencesHideLightningMigrationModal information.

UserPreferencesHideSfxWelcomeMat Bool False

Field containing UserPreferencesHideSfxWelcomeMat information.

UserPreferencesHideBiggerPhotoCallout Bool False

Field containing UserPreferencesHideBiggerPhotoCallout information.

UserPreferencesGlobalNavBarWTShown Bool False

Field containing UserPreferencesGlobalNavBarWTShown information.

UserPreferencesGlobalNavGridMenuWTShown Bool False

Field containing UserPreferencesGlobalNavGridMenuWTShown information.

UserPreferencesCreateLEXAppsWTShown Bool False

Field containing UserPreferencesCreateLEXAppsWTShown information.

UserPreferencesFavoritesWTShown Bool False

Field containing UserPreferencesFavoritesWTShown information.

UserPreferencesRecordHomeSectionCollapseWTShown Bool False

Field containing UserPreferencesRecordHomeSectionCollapseWTShown information.

UserPreferencesRecordHomeReservedWTShown Bool False

Field containing UserPreferencesRecordHomeReservedWTShown information.

UserPreferencesFavoritesShowTopFavorites Bool False

Field containing UserPreferencesFavoritesShowTopFavorites information.

UserPreferencesExcludeMailAppAttachments Bool False

Field containing UserPreferencesExcludeMailAppAttachments information.

UserPreferencesSuppressTaskSFXReminders Bool False

Field containing UserPreferencesSuppressTaskSFXReminders information.

UserPreferencesSuppressEventSFXReminders Bool False

Field containing UserPreferencesSuppressEventSFXReminders information.

UserPreferencesPreviewCustomTheme Bool False

Field containing UserPreferencesPreviewCustomTheme information.

UserPreferencesHasCelebrationBadge Bool False

Field containing UserPreferencesHasCelebrationBadge information.

UserPreferencesUserDebugModePref Bool False

Field containing UserPreferencesUserDebugModePref information.

UserPreferencesSRHOverrideActivities Bool False

Field containing UserPreferencesSRHOverrideActivities information.

UserPreferencesNewLightningReportRunPageEnabled Bool False

Field containing UserPreferencesNewLightningReportRunPageEnabled information.

UserPreferencesReverseOpenActivitiesView Bool False

Field containing UserPreferencesReverseOpenActivitiesView information.

UserPreferencesHasSentWarningEmail Bool False

Field containing UserPreferencesHasSentWarningEmail information.

UserPreferencesHasSentWarningEmail238 Bool False

Field containing UserPreferencesHasSentWarningEmail238 information.

UserPreferencesHasSentWarningEmail240 Bool False

Field containing UserPreferencesHasSentWarningEmail240 information.

UserPreferencesDismissPersonalSpaceLegalMessage Bool False

Field containing UserPreferencesDismissPersonalSpaceLegalMessage information.

UserPreferencesNativeEmailClient Bool False

Field containing UserPreferencesNativeEmailClient information.

UserPreferencesHideManagedEcaMobilePubModal Bool False

Field containing UserPreferencesHideManagedEcaMobilePubModal information.

UserPreferencesShowForecastingRoundedAmounts Bool False

Field containing UserPreferencesShowForecastingRoundedAmounts information.

HasUserVerifiedPhone Bool True

Indicates whether the record has UserVerifiedPhone.

HasUserVerifiedEmail Bool True

Indicates whether the record has UserVerifiedEmail.

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.

IsExtIndicatorVisible Bool True

Indicates whether the record has the ExtIndicatorVisible characteristic.

OutOfOfficeMessage String True

Field containing OutOfOfficeMessage information.

MediumPhotoUrl String True

Field containing MediumPhotoUrl information.

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.

JigsawImportLimitOverride Int False

Field containing JigsawImportLimitOverride information.

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.

BannerPhotoUrl String True

Field containing BannerPhotoUrl information.

SmallBannerPhotoUrl String True

Field containing SmallBannerPhotoUrl information.

MediumBannerPhotoUrl String True

Field containing MediumBannerPhotoUrl information.

IsProfilePhotoActive Bool True

Indicates whether the record has the ProfilePhotoActive characteristic.

IndividualId String False

Individual.Id

ID of the data privacy record associated with this record.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

TriggerAutoResponseEmail Bool False

Indicates whether to trigger auto-response rules (true) or not (false), for leads and cases.

TriggerOtherEmail Bool False

Indicates whether to trigger email outside the organization (true) or not (false).

TriggerUserEmail Bool False

Indicates whether to trigger email that is sent to users in the organization (true) or not (false).

SystemModstamp Datetime True

System-generated timestamp of the most recent change to the user record.

LastModifiedDate Datetime True

Date and time when the user record was last updated.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434