ODBC Driver for Salesforce

Build 25.0.9434

PromptVersion

Schema file for PromptVersion.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

ParentId String False

Prompt.Id

ID of the parent object in the hierarchy.

MasterLabel String False

The custom object label that appears in the user interface.

Description String False

Text description of the record.

DisplayType String False

Type classification for Display.

DisplayPosition String False

Field containing DisplayPosition information.

TimesToDisplay Int False

Field containing TimesToDisplay information.

DelayDays Int False

Field containing DelayDays information.

StartDate Date False

Start date for the record or activity.

EndDate Date False

End date for the record or activity.

UserAccess String False

Field containing UserAccess information.

IsPublished Bool False

Indicates whether the record has the Published characteristic.

PublishedDate Date False

Date associated with Published.

PublishedByUserId String False

User.Id

ID of the PublishedByUser associated with this record.

Header String False

Field containing Header information.

DismissButtonLabel String False

Field containing DismissButtonLabel information.

ShouldDisplayActionButton Bool False

Field containing ShouldDisplayActionButton information.

ActionButtonLabel String False

Field containing ActionButtonLabel information.

ActionButtonLink String False

Field containing ActionButtonLink information.

Title String False

Title of the contact or person, for example CEO or Vice President.

VersionNumber Int False

Version identification number.

TargetPageType String False

Type classification for TargetPage.

TargetPageKey1 String False

Field containing TargetPageKey1 information.

TargetPageKey2 String False

Field containing TargetPageKey2 information.

TargetAppNamespacePrefix String False

Field containing TargetAppNamespacePrefix information.

TargetAppDeveloperName String False

Field containing TargetAppDeveloperName information.

Body String False

The content of the feed item or post.

ShouldIgnoreGlobalDelay Bool False

Field containing ShouldIgnoreGlobalDelay information.

UserProfileAccess String False

Field containing UserProfileAccess information.

VideoLink String False

Field containing VideoLink information.

StepNumber Int False

Step identification number.

ThemeColor String False

Field containing ThemeColor information.

ThemeSaturation String False

Field containing ThemeSaturation information.

TargetPageKey1Ref String False

Field containing TargetPageKey1Ref information.

ImageAltText String False

Field containing ImageAltText information.

ImageId String False

ContentAsset.Id

ID of the Image associated with this record.

ImageLink String False

Field containing ImageLink information.

ImageLocation String False

Field containing ImageLocation information.

TargetPageKey3 String False

Field containing TargetPageKey3 information.

ElementRelativePosition String False

Field containing ElementRelativePosition information.

ReferenceElementContext String False

Field containing ReferenceElementContext information.

TargetPageKey4 String False

Field containing TargetPageKey4 information.

TargetRecordTypeId String False

RecordType.Id

ID of the TargetRecordType associated with this record.

ExperienceContextId String False

Site.Id

ID of the ExperienceContext associated with this record.

ExperienceContextIdType String False

Specifies the type of the 'ExperienceContextId' polymorphic field to use in the statement.

ExperienceContextIdExternalFieldName String False

Specifies the external field name of the 'ExperienceContextId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

Experience String False

Field containing Experience information.

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.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

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