eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.HZ_CONTACT_PREFERENCES

Object Details

Object Name:	HZ_CONTACT_PREFERENCES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_CONTACT_PREFERENCES
Subobject Name:
Status:	VALID

The HZ_CONTACT_PREFERENCES table stores information about contact preferences for parties or their addresses and contact points. For example, contact preference information can capture whether the deploying company can call a party, and whether it can call a particular phone number
or send e-mail to a particular address. Contact preferences can also indicate certain times of the day when a party should not be called. Additionally, preferences can be defined as valid only for a specific period of the year.
Contact preference information is captured under different entities, for example HZ_PARTIES, HZ_PARTY_SITES, and HZ_CONTACT_POINTS, and also under different contact types such as calls, e-mails, visits, and so on. A preference is always set for a particular purpose or topic, for example
marketing and emergency.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CONTACT_PREFERENCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTACT_PREFERENCE_ID
HZ_CONTACT_PREFERENCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_LEVEL_TABLE_ID
HZ_CONTACT_PREFERENCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREFERENCE_TOPIC_TYPE_ID CONTACT_LEVEL_TABLE_ID PREFERENCE_TOPIC_TYPE CONTACT_LEVEL_TABLE PREFERENCE_CODE CONTACT_TYPE
HZ_CONTACT_PREFERENCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREFERENCE_TOPIC_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CONTACT_PREFERENCE_ID	NUMBER	(15)	Yes	Unique identifier for the contact preference
CONTACT_LEVEL_TABLE	VARCHAR2	(30)	Yes	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.
CONTACT_LEVEL_TABLE_ID	NUMBER	(15)	Yes	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
CONTACT_TYPE	VARCHAR2	(30)	Yes	Type of contact that should or should not be made with the party. Uses the CONTACT_TYPE lookup.
PREFERENCE_CODE	VARCHAR2	(30)	Yes	Permission to use or not to use a particular contact method. Uses the PREFERENCE_CODE lookup.
PREFERENCE_TOPIC_TYPE	VARCHAR2	(30)		Appropriate subjects to send or not to send to the party that the preference is created for. Uses the PREFERENCE_TOPIC_TYPE lookup.
PREFERENCE_TOPIC_TYPE_ID	NUMBER	(15)		Reduced LOV depending on the preference topic table selected. The PREFERENCE_TOPIC_TYPE_ID column and PREFERENCE_TOPIC_TYPE_CODE column are mutually exclusive.
PREFERENCE_TOPIC_TYPE_CODE	VARCHAR2	(30)		Reduced LOV depending on the preference topic table selected. The PREFERENCE_TOPIC_TYPE_ID column and PREFERENCE_TOPIC_TYPE_CODE column are mutually exclusive.
PREFERENCE_START_DATE	DATE		Yes	Starting date of the period during which a party should or should not be contacted.
PREFERENCE_END_DATE	DATE			Ending date of the period during which a party should or should not be contacted.
PREFERENCE_START_TIME_HR	NUMBER			Starting hour of the time range during which a party should or should not be contacted. 0-23 hour format.
PREFERENCE_END_TIME_HR	NUMBER			Ending hour of the time range during which a party should or should not be contacted. 0-23 hour format.
PREFERENCE_START_TIME_MI	NUMBER			Starting minute of the time range during which a party should or should not be contacted. 0-59 minute format.
PREFERENCE_END_TIME_MI	NUMBER			Ending minute of the time range during which a party should or should not be contacted. 0-59 minute format.
MAX_NO_OF_INTERACTIONS	NUMBER			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.
MAX_NO_OF_INTERACT_UOM_CODE	VARCHAR2	(30)		The period of time during which the maximum number of interactions applies. Uses the MAX_NO_OF_INTERACT_UOM_CODE lookup.
REQUESTED_BY	VARCHAR2	(30)	Yes	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.
REASON_CODE	VARCHAR2	(30)		Reason that this type of contact should or should not be made. Uses the REASON_CODE lookup.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
OBJECT_VERSION_NUMBER	NUMBER	(15)		Version number used for the purpose of controlling concurrent programs
STATUS	VARCHAR2	(1)	Yes	Record status flag
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who Column
APPLICATION_ID	NUMBER			TCA Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTACT_PREFERENCE_ID
,      CONTACT_LEVEL_TABLE
,      CONTACT_LEVEL_TABLE_ID
,      CONTACT_TYPE
,      PREFERENCE_CODE
,      PREFERENCE_TOPIC_TYPE
,      PREFERENCE_TOPIC_TYPE_ID
,      PREFERENCE_TOPIC_TYPE_CODE
,      PREFERENCE_START_DATE
,      PREFERENCE_END_DATE
,      PREFERENCE_START_TIME_HR
,      PREFERENCE_END_TIME_HR
,      PREFERENCE_START_TIME_MI
,      PREFERENCE_END_TIME_MI
,      MAX_NO_OF_INTERACTIONS
,      MAX_NO_OF_INTERACT_UOM_CODE
,      REQUESTED_BY
,      REASON_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      STATUS
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM AR.HZ_CONTACT_PREFERENCES;

Dependencies

[top of page]

AR.HZ_CONTACT_PREFERENCES does not reference any database object

AR.HZ_CONTACT_PREFERENCES is referenced by following:

APPS: HZ_CONTACT_PREFERENCES