Marketing Treatment

The marketing message that is delivered to the audience targeted within a campaign.

QName: {http://xmlns.oracle.com/apps/marketing/coreMarketing/treatments/model/}Treatment

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Marketing Treatment Product

Handled by

Marketing Treatment Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

ActiveFlag

boolean

Indicates the activity status of the marketing treatment as Active or Inactive.

ActivityDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the treatment was made active.

ApprovalStatusCode

string

Indicates the approval status code associated with this treatment.

AttachmentEntityName

string

The name of the attachment associated with this treatment.

BUId

long

The identifier of the business unit associated with this record.

CampaignUsage

string

The campaign usage associated with this treatment.

ChannelCode

string

The channel associated with this treatment.

ChannelType

string

The channel type of the treatment.

CharacterSet

string

The character set associated with this treatment.

ClickCount

long

The click count for this treatment template record.

ConfirmInTreatmentId

long

The treatment designated to use in an opt-in process flow.

ConfirmOutTreatmentId

long

The treatment designated to use in a double opt-in process flow as a treatment to confirm the opt-in choice.

ContentThumbnailURL

string

The URL associated with the thumbnail image of this treatment.

ConversionCurrencyCode

string

The currency code of the currency being converted to.

ConversionRateType

string

The currency conversion rate type that is used to derive the exchange rate for converting the user-entered currency to CRM Corporate currency.

CreateInteractionFlag

boolean

Indicates whether the interactions must be created for outbound send operation of this treatment.

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

DelvProfileId

long

The row ID of the delivery profile record.

EmailBcc

string

Blind copy email address value for email treatment.

EmailCc

string

Copy email address value for email treatment.

EmailFrom

string

The from address to include in email treatment.

EmailReplyTo

string

The reply to email address to include in email treatment.

EmailSubject

string

The subject line for the email treatment.

ExpirationDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The expiration date associated with this treatment.

FolderPath

string

The folder path where the treatment content is placed in Oracle Universal Content Management application.

HTMLContentItemId

string

The identifier of the content item associated with the HTML content for this treatment.

HTMLFooterId

long

Identifier of the HTML version of the footer associated with this treatment.

HTMLHeaderId

long

Identifier of the HTML version of the header associated with this treatment.

HTMLTemplateId

long

Identifier of the HTML version of the template for this treatment.

InboundPriority

string

The inbound priority associated with the treatment.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

LastUsedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The most recent date when this treatment was used for a campaign.

Locale

string

The locale associated with this treatment.

LockedFlag

boolean

Indicates whether this treatment is locked. A locked treatment cannot be updated.

LookupCode

string

To be deleted.

LookupType

string

To be deleted.

Meaning

string

To be deleted.

ObjectVersionNumber

int

The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.

ObjectVersionNumber1

int

The attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was last queried.

OpenCount

long

Indicates the number of times this treatment's content was opened by end users.

Owner

string

The owner associated with the treatment.

OwnerId

long

The resource identifier associated with the owner of the treatment.

OwnerResourceOrgId

long

The resource organization identifier associated with the owner of the treatment.

OwnerTreeCode

string

The resource organization hierarchy tree code associated with the resource organization which the owner of the treatment belongs to.

OwnerTreeStructureCode

string

The resource organization hierarchy tree structure code associated with the resource organization to which the owner of the treatment belongs.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PrimaryOrgId

long

The primary organization of the treatment.

Rating

long

The rating associated with this treatment.

ResponseChannel

string

The response channel associated with this treatment. Indicates the channel through which the responses are expected.

SeedListId

long

The identifier of the seed list associated with this treatment. Seed list includes test data.

SubscriberListId

long

The identifier of the subscription list associated with this treatment.

SupplierId

long

The identifier of the delivery profile associated with this treatment.

Team

string

To be deleted.

TeamId

long

The resource team associated with this treatment.

TemplateFlag

boolean

Indicates whether this record is a treatment template.

TemplateName

string

The name of the treatment template used to create this treatment.

TextContentItemId

string

The identifier of the text content item associated with this treatment.

TextFooterId

long

The identifier of the text version of the footer associated with this treatment.

TextHeaderId

long

The identifier of the text version of the header associated with this treatment.

TextTemplateId

long

The identifier of the text version of the template for this treatment.

TrackUrlsFlag

boolean

Indicates whether the tracking of URLs within treatment content is enabled or disabled.

TreatmentCode

string

The code associated with this treatment.

TreatmentDescriptionText

string

The description of this treatment.

TreatmentId

long

The primary identifier of this record.
  • Primary Key

TreatmentLanguage

string

The language of the treatment.

TreatmentName

string

The name of the treatment.

TreatmentName1

string

The name of the treatment.

TreatmentNumber

string

The number associated with this treatment.

TreatmentType

string

The type of the treatment.

TrmtItemAssoc

Marketing Treatment Product

To be deleted.

VendorId

long

The identifier of the marketing supplier associated with this treatment.

VendorName

string

The name of the marketing supplier associated with this treatment.