It is an intersection object contains Eloqua Campaign's Shared List Snapshot. This is needed in CX Sales not only to have Eloqua activities mapped but also to return reference stories when Eloqua asks during landing page loading.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MKT_CAMP_SHAREDLIST_SNAPS_PK |
SHAREDLIST_SNAPSHOT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SHAREDLIST_SNAPSHOT_ID | NUMBER | 18 | Yes | Campaign Shared List Snapshot Id. Primary Key of the table. | |
CAMPAIGN_ID | NUMBER | 18 | Yes | Reference Key to Campaign Header | |
SOURCE_SYS_SHARED_LIST_ID | NUMBER | 18 | Source System Campaign's Shared List Id | ||
SOURCE_SYS_CAMPAIGN_ID | NUMBER | 18 | Source System Campaign Identifier | ||
LEAD_ID | NUMBER | 18 | Yes | Reference Key to Lead Identifier | |
CONTACT_ID | NUMBER | 18 | Yes | Reference Key to Contact Identifier | |
CONTACT_EMAIL_ADDRESS | VARCHAR2 | 320 | Primary Contact's Email Address | ||
SOURCE_SYS_CONTACT_ID | NUMBER | 18 | Source System Contact Identifier | ||
SYNC_STATUS | VARCHAR2 | 30 | Sync Status: 'Add' / 'Remove' before syncing. 'Added' after syncing. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
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. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MKT_CAMP_SHAREDLIST_SNAPS_N1 | Non Unique | Default | CAMPAIGN_ID, SYNC_STATUS |
MKT_CAMP_SHAREDLIST_SNAPS_N2 | Non Unique | Default | SOURCE_SYS_CAMPAIGN_ID, SOURCE_SYS_CONTACT_ID, CAMPAIGN_ID |
MKT_CAMP_SHAREDLIST_SNAPS_PK | Unique | Default | SHAREDLIST_SNAPSHOT_ID |
MKT_CAMP_SHAREDLIST_SNAPS_N3 | Non Unique | Default | CAMPAIGN_ID, LEAD_ID, CONTACT_ID |