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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 | The unique identifier of the partner to which this LOV value belongs. | ||
| LOOKUP_TYPE | VARCHAR2 | 30 | 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 | The value from a multi-value LOV category which applies to the profile. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZPM_PARTNER_MULTIVAL_LOVSN2_ | Non Unique | Default | AUDIT_ACTION_TYPE_ |
| ZPM_PARTNER_MULTIVAL_LOVS_PK_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, PARTNER_MULTIVAL_LOV_ID |
| ZPM_PARTNER_MULTIVAL_LOVS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, PARTY_ID, LOOKUP_TYPE, LOOKUP_CODE |
| ZPM_PARTNER_MULTIVAL_LOVS_U2_ | Unique | Default | LAST_UPDATED_BY, LAST_UPDATE_DATE, PARTNER_MULTIVAL_LOV_ID |
| ZPM_PARTNER_MV_LOVN1_ | Non Unique | Default | PARTNER_MULTIVAL_LOV_ID |