Marketing Response

The entity created based on the reaction of the targeted audience to the marketing message and is used to judge the positive or negative outcome of a marketing campaign.

QName: {http://xmlns.oracle.com/apps/marketing/response/responseService/}MktRmResponse

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

Address

Contains

Phone

Contains

Marketing Response Survey

Contains

Marketing Response Product

Handled by

Marketing Response Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountId

long

The identifier of the account.

AttachmentEntityName

string

The entity name of the attachment to this response.

BUId

long

The identifier of the business unit.

CallListId

long

The identifier of the associated list.

Campaign

string

The name of the campaign associated with the response.

CampaignId

long

The unique identifier for the campaign.

CampaignMediaId

long

The identifier of the campaign media.

CampaignName

string

The name of the associated campaign.

Channel

string

The response channel.

ContactAddress

string

The address of the contact on this response.

ContactFaxNumber

string

The fax number of the contact on this response.

ContactId

long

The identifier of the contact.

ContactName

string

The contact name of the primary contact on the response.

ContactPhoneNumber

string

The phone number of the contact on this response.

ContactPointId

long

The unique primary key identifier for the contact point.

ContactPointType

string

The type of the contact point.

ContactRelationshipId

long

The identifier of the contact relationship record in Trading Community Architecture (TCA).

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.

CustomerId

long

The unique identifier of the customer.

CustomerName

string

The name of the customer.

DescriptionText

string

The description of+D1061 the marketing response.

DestinationName

string

The name of the destination.

EndDate

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

Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.

EventRegistrationId

long

The identifier of the event registration which resulted in this response.

FaxType

string

The type of fax.

FormattedPhoneNumber

string

The formatted phone number.

FwdCntctRelshpId

long

The identifier of the forwarding contact relationship. Reference to the party relationship record of the forwarding contact.

FwdContactId

long

The identifier of the forwarding contact.

HyperlinkName

string

The name of the hyperlink.

HyperlinkURL

string

The URL associated with the response.

HzStatusActive

string

Indicates if the TCA record is active.

IPAddressCode

string

The internal IP address code.

ImportTaskId

long

The identifier of the import task associated with this response, if imported.

InteractionId

long

The identifier of the interaction.

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.

LeadId

long

The identifier of the lead.

LoadNumber

long

The Load Number corresponding to Campaign Load.

MessageActivationNumber

string

Represents one or more device addresses to receive incoming SMS messages.

MessageContent

string

The message content of the SMS message.

MessageIdentifier

string

The unique identifier for the SMS message as assigned by the User Messaging Service module.

MktProdAssoc1

Marketing Response Product

The reference to Marketing Product.

MktRmResponseSvyLog1

Marketing Response Survey

The reference to Marketing Response Survey log.

Name

string

The name of the response.

ObjectType

string

The object Type on the response.

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.

Offer

string

The offer associated with the response.

OpportunityId

long

The identifier of the opportunity.

OutcomeCode

string

The Response Outcome code.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PartySite

Address

The reference to Party Site.

PartyType

string

The party type of the contact. The party type can only be Person, Organization, or Group.

PartyUniqueName

string

This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.

Phone

Phone

The phone information for the entity.

PhoneType

string

The phone type of the associated contact point.

PrimaryPhoneNumber

string

The telephone number in local format. The number should not include country code, area code, or extension.

ReferDomain

string

The Web domain of the referrer. For example, yahoo.com, facebook.com, and so on.

ReferKeywords

string

The keywords or hash tags tagged to the post that the visitor/referrer is responding to.

ReferSourceCode

string

The originating marketing source code for the referrer.

ReferTabStream

string

The name of the tab or stream in Virtue.

ReferWebOfferId

long

The reference to the web marketing offer pertaining to the referrer.

ReplyDeliveryMethodCode

string

The internal code of the delivery method of the reply.

ReplyEmailAddress

string

The email address on the reply.

ReplyFaxPhoneNumber

string

The Fax number on the reply.

ReplyMailAddress

string

The mailing address on the reply.

ReplyMailCity

string

The city on the mailing address on the reply.

ReplyMailCountry

string

The country on the mailing address on the reply.

ReplyMailCounty

string

The county on the mailing address on the reply.

ReplyMailProvince

string

The province on the mailing address on the reply.

ReplyMailState

string

The state on the mailing address on the reply.

ReplyMailZipCode

string

The Zip code on the mailing address on the reply.

ReplyPhoneNumber

string

The phone number on the reply.

ReplyPriorityCode

string

The response priority recorded on the reply.

ResponseDate

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

The response date.

ResponseId

long

The primary identifier of the response.
  • Primary Key

ResponseMethod

string

The response method on the response.

ResponseNumber

string

The unique alternate identifier for the marketing response.

ResponseTypeCode

string

The response type code.

ResponseURL

string

The URL of the marketing response.

Score

decimal

The score recorded on the response.

SourceCode

string

The source code recorded on the response.

SourceCodeId

decimal

The identifier of the source code recorded on the response.

StageExecutionId

long

The unique identifier of a specific execution of a marketing campaign stage.

StageMemberId

long

The identifier of the stage member.

StartDate

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

Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.

StatusCode

string

The pre-defined code used to indicate the status.

SubjectText

string

The subject text of the response.

SubscribeDirectMailCode

string

The subscription Direct Mail Code.

SubscribeEmailCode

string

The subscription Email Code.

SubscribeFaxCode

string

The subscription Fax Code.

SubscribePhoneCode

string

The subscription Subscribe Phone Code.

Text

{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler

The detailed text of the response.

TreatmentId

long

The identifier of the treatment.

TreatmentName

string

The name of the treatment associated with the response.

TreatmentName1

string

The name of the treatment associated with the response.

URLId

long

The identifier of the URL of the marketing response.