MKT_CM_FOLLOWUP_ACTIONS
This table stores details about the actions that need to be taken based on user click through.For example sales user may choose to be notified or create an activity after a user click through is tracked.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MKT_CM_FOLLOWUP_ACTIONS_PK |
FOLLOWUP_ACTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
FOLLOWUP_ACTION_ID | NUMBER | 18 | Yes | Followup Action Id. Primary Key | |
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. | |
CAMPAIGN_ID | NUMBER | 18 | Yes | Campaign Id. FK to MKT_CM_CAMPAIGNS. Follow up Action recorded for this campaign | |
CONDITION_CODE | VARCHAR2 | 30 | Condition Code could be response forms | ||
ACTION_CODE | VARCHAR2 | 30 | Action Code maps to MKT_CAMP_FOLLOWUP_ACTIONS lookup type | ||
URL_ID | NUMBER | 18 | Url Id | ||
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 |
---|---|---|
MKT_CM_FOLLOWUP_ACTIONS | mkt_cm_campaigns | CAMPAIGN_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MKT_CM_FOLLOWUP_ACTIONS_F1 | Non Unique | CAMPAIGN_ID | |
MKT_CM_FOLLOWUP_ACTIONS_PK | Unique | Default | FOLLOWUP_ACTION_ID |