ZPM_PARTNER_MULTIVAL_LOVS

A generic intersection table that defines values selected for all profile fields that allow multiple values to be selected from simple LOVs that are not justified as entities in their own right.

Details

• Schema: FUSION

• Object owner: ZPM

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ZPM_PARTNER_MULTIVAL_LOVS_PK	PARTNER_MULTIVAL_LOV_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARTNER_MULTIVAL_LOV_ID	NUMBER		18	Yes	The unique identifier of a specific LOV code selected for a specific multi-value field in the partner profile.
PARTY_ID	NUMBER		18	Yes	The unique identifier of the partner to which this LOV value belongs.
LOOKUP_TYPE	VARCHAR2	30		Yes	An LOV code defining the category to which the LOV value belongs. This value indicates which profile field to which the value belongs.
LOOKUP_CODE	VARCHAR2	30		Yes	The value from a multi-value LOV category which applies to the profile.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZPM_PARTNER_MULTIVAL_LOVS	zpm_partner_profiles	PARTY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZPM_PARTNER_MULTIVAL_LOVS_PK	Unique	Default	PARTNER_MULTIVAL_LOV_ID
ZPM_PARTNER_MULTIVAL_LOVS_U1	Unique	Default	PARTY_ID, LOOKUP_TYPE, LOOKUP_CODE
ZPM_PARTNER_MULTIVAL_LOVS_U2	Unique	Default	LAST_UPDATE_DATE, PARTNER_MULTIVAL_LOV_ID