MKT_SR_CONTACT

This table stores the cache data for Contacts Real Time target level. Specifically, it saves the customer identifiers of complex segmentation criteria which can be used in other segments and to keep track of which targets joined and left a segment.

Details

• Schema: FUSION

• Object owner: MKT

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MKT_SR_CONTACT_PK	GUID, TARGET_LEVEL_ID

Columns

Name	Datatype	Length	Not-null	Comments
GUID	VARCHAR2	50	Yes	Unique identifier of the saved result set
TARGET_LEVEL_ID	VARCHAR2	30	Yes	Target level ID that qualified for this saved result set
OFFER_CODE	VARCHAR2	100		Standard attribute for offer code
CHANNEL	VARCHAR2	100		Standard attribute for channel type
TAG_01	VARCHAR2	250		Column to hold custom attribute or column
TAG_02	VARCHAR2	250		Column to hold custom attribute or column
TAG_03	VARCHAR2	250		Column to hold custom attribute or column
TAG_04	VARCHAR2	250		Column to hold custom attribute or column
TAG_05	VARCHAR2	250		Column to hold custom attribute or column
TAG_06	VARCHAR2	250		Column to hold custom attribute or column
TAG_07	VARCHAR2	250		Column to hold custom attribute or column
TAG_08	VARCHAR2	250		Column to hold custom attribute or column
TAG_09	VARCHAR2	250		Column to hold custom attribute or column
TAG_10	VARCHAR2	250		Column to hold custom attribute or column
TAG_11	VARCHAR2	250		Column to hold custom attribute or column
TAG_12	VARCHAR2	250		Column to hold custom attribute or column
TAG_13	VARCHAR2	250		Column to hold custom attribute or column
TAG_14	VARCHAR2	250		Column to hold custom attribute or column
TAG_15	VARCHAR2	250		Column to hold custom attribute or column

Foreign Keys

Table	Foreign Table	Foreign Key Column
MKT_SR_CONTACT	mkt_sr_header	GUID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MKT_SR_CONTACT_N1	Non Unique	FUSION_TS_TX_DATA	GUID	Obsolete
MKT_SR_CONTACT_U1	Unique	Default	GUID, TARGET_LEVEL_ID