Contact Preference

The contact preference associated with a trading community member. For example, do not call Joe Smith between 10 a.m. and 12 noon on weekdays.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/}ContactPreference

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

Source System Reference

Contained by

Trading Community Person Details

Contained by

Electronic Data Interchange

Contained by

Instant Messaging

Contained by

E-Mail

Contained by

Household

Contained by

Telex

Contained by

Phone

Contained by

Web

Contained by

Contact Address

Contained by

Trading Community Organization Details

Contained by

Electronic File Transfer

Contained by

Address

Handled by

Trading Community Group

Handled by

Deal Registration Service

Handled by

Trading Community Organization

Handled by

Marketing Response Service

Handled by

Company and User Registration

Handled by

Sales Account Service

Handled by

Sales Party

Handled by

Sales Party Resource Service

Handled by

Sales Party Territory service

Handled by

Partner Service

Handled by

Partner Program Enrollment Service

Handled by

Trading Community Person Information

Attributes

The following table describes attributes in the service data object.

Name Type Description

ContactLevelTable

string

Table that stores the contact level of the contact preference. Uses the SUBJECT_TABLE lookup. Value can be HZ_PARTIES, HZ_PARTIES_SITES, or HZ_CONTACT_POINTS.

ContactLevelTableId

long

Foreign key to the table specified in CONTACT_LEVEL_TABLE column. Can be PARTY_ID from HZ_PARTIES table, CONTACT_POINT_ID from HZ_CONTACT_POINTS table, or PARTY_SITE_ID from HZ_PARTY_SITES table.

ContactPreferenceId

long

Unique identifier for the contact preference.
  • Primary Key

ContactType

string

Type of contact that should or should not be made with the party. Uses the CONTACT_TYPE lookup.

CreatedBy

string

The user who created the record.

CreatedByModule

string

The module that created the record.

CreationDate

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

The date when the record was created.

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.

MaximumNoOfInteractUOMCode

string

The period of time during which the maximum number of interactions applies. Uses the MAX_NO_OF_INTERACT_UOM_CODE lookup.

MaximumNoOfInteractions

decimal

The number of times you can use this contact point. The period of time that this number applies is stored in the MAX_NO_OF_INTERACT_UOM_CODE column.

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.

OriginalSystemReference

Source System Reference

The identifier for the record from the original system.

PreferenceCode

string

Permission to use or not to use a particular contact method. Uses the PREFERENCE_CODE lookup.

PreferenceEndDate

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

Ending date of the period during which a party should or should not be contacted.

PreferenceEndTimeHR

int

Ending hour of the time range during which a party should or should not be contacted. 0-23 hour format.

PreferenceEndTimeMi

int

Ending minute of the time range during which a party should or should not be contacted. 0-59 minute format.

PreferenceStartDate

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

Starting date of the period during which a party should or should not be contacted.

PreferenceStartTimeHR

int

Starting hour of the time range during which a party should or should not be contacted. 0-23 hour format.

PreferenceStartTimeMi

int

Starting minute of the time range during which a party should or should not be contacted. 0-59 minute format.

PreferenceTopicType

string

Appropriate subjects to send or not to send to the party that the preference is created for. Uses the PREFERENCE_TOPIC_TYPE lookup.

PreferenceTopicTypeCode

string

The reduced list of values depending on the preference topic table selected. The PREFERENCE_TOPIC_TYPE_ID column and PREFERENCE_TOPIC_TYPE_CODE column are mutually exclusive.

PreferenceTopicTypeId

long

The reduced list of values depending on the preference topic table selected. The PREFERENCE_TOPIC_TYPE_ID column and PREFERENCE_TOPIC_TYPE_CODE column are mutually exclusive.

ReasonCode

string

Reason that this type of contact should or should not be made. Uses the REASON_CODE lookup.

RequestId

long

A system-generated read-only attribute used by the application framework.

RequestedBy

string

Indicates if the permission or restriction was created internally or requested by the party. Uses the REQUESTED_BY lookup. Value can be internal or party.

Status

string

The status of the record.