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	Marketing Response Product
Contains	Marketing Response Survey
Contains	Address
Contains	Phone
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.