ZPM_PARTNER_DIM_MEMBERS
A generic intersection table that defines values selected for an owner such as a partner profile or program that allow multiple values to be selected from multi-choice dropdowns or shuttle pickers.
Details
-
Schema: FUSION
-
Object owner: ZPM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZPM_PARTNER_DIM_MEMBERS_PK |
PARTNER_DIM_MEMBERS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARTNER_DIM_MEMBERS_ID | NUMBER | 18 | Yes | This column is the private key of this table. | |
| OWNER_ID | NUMBER | 18 | Yes | The identifier of the entity that owns the relationship with the dimension data. For example, partner profile, partner program, or enrollment. | |
| OWNER_TYPE | VARCHAR2 | 20 | Yes | The type of entity that owns the relationship with the dimension data. For example, partner profile, partner program, or enrollment. | |
| PARTITION_TYPE_CODE | VARCHAR2 | 30 | Yes | The type of partition in which the data is stored. | |
| DIMENSION_CODE | VARCHAR2 | 5 | Yes | The dimension of the item being stored. For example, geography. | |
| INTEGRATION_ID | VARCHAR2 | 80 | Yes | The reference to the actual dimension member item. | |
| ATTRIBUTE_PK1 | VARCHAR2 | 30 | This is the ATTRIBUTE PK1 column. | ||
| ATTRIBUTE_PK2 | VARCHAR2 | 30 | This is the ATTRIBUTE PK1 column. | ||
| DIM_SUBTYPE_CODE | VARCHAR2 | 30 | A specific type of item within the dimension code. For example, for the products dimension there could be product items and product categories. | ||
| DIMENSION_MEMBER_NAME | VARCHAR2 | 360 | Yes | The name of the dimension remember this record refers to. This is stored in case the dimension member was removed and the user still needs to know the name of the item that was removed. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic 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 detect whether another session has updated the row since it was queried. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZPM_PARTNER_DIM_MEMBERS_N1 | Non Unique | Default | PARTITION_TYPE_CODE, OWNER_TYPE, ATTRIBUTE_PK1, ATTRIBUTE_PK2 |
| ZPM_PARTNER_DIM_MEMBERS_PK | Unique | Default | PARTNER_DIM_MEMBERS_ID |
| ZPM_PARTNER_DIM_MEMBERS_U1 | Unique | Default | PARTITION_TYPE_CODE, DIMENSION_CODE, OWNER_TYPE, OWNER_ID, INTEGRATION_ID |
| ZPM_PARTNER_DIM_MEMBERS_U2 | Unique | Default | LAST_UPDATE_DATE, PARTNER_DIM_MEMBERS_ID |