MKT_CM_STG_LSTOUTPTS
This table stores the reference to output list files generated in a Marketing Campaign Stage. When a marketing campaign stage gets executed during a campaign load/launch process, list files are generated which contain the list of targeted customers. This entity is kind of an internal tracking entity which tracks details about the list files generated.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MKT_CM_STG_LSTOUTPTS_PK |
LSTOUTPT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LSTOUTPT_ID | NUMBER | 18 | Yes | Primary Key Column | |
| 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. | |
| DOCUMENT_ID | VARCHAR2 | 2000 | Document Id in content repository. | ||
| CAMPAIGN_ID | NUMBER | 18 | Campaign Id. FK to MKT_CM_CAMPAIGNS table. | ||
| STAGE_ID | NUMBER | 18 | Stage Id. FK to MKT_CM_STAGES table. | ||
| STG_EXEC_ID | NUMBER | 18 | Stage Execution Id. FK to MKT_CM_STG_EXECS table. | ||
| FILE_NAME | VARCHAR2 | 200 | Output List File Name | ||
| FILE_PATH | VARCHAR2 | 250 | Output List File Path | ||
| FILE_SIZE | NUMBER | 10 | Output List File Size | ||
| RECORD_CNT | NUMBER | 10 | Output List Record Count | ||
| DELV_STATUS_CODE | VARCHAR2 | 30 | Delivery Status Code | ||
| DELV_PROFILE_ID | NUMBER | 18 | Delivery Profile Id. FK to MKT_TM_DLV_PROFILE table. | ||
| TREATMENT_ID | NUMBER | 18 | Treatment Id. FK to MKT_TM_TREATMENTS table. | ||
| CALL_LST_ID | NUMBER | 18 | Call List Id. FK to MKT_CALL_LST table. | ||
| BATCH_NUM | NUMBER | 10 | Output List File Batch Number | ||
| DESC_TXT | VARCHAR2 | 500 | Description Text | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| 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_STG_LSTOUTPTS | mkt_cm_stages | STAGE_ID |
| MKT_CM_STG_LSTOUTPTS | mkt_cm_stg_execs | STG_EXEC_ID |
| MKT_CM_STG_LSTOUTPTS | mkt_call_lst | CALL_LST_ID |
| MKT_CM_STG_LSTOUTPTS | mkt_tm_treatments | TREATMENT_ID |
| MKT_CM_STG_LSTOUTPTS | mkt_tm_dlv_profile | DELV_PROFILE_ID |
| MKT_CM_STG_LSTOUTPTS | mkt_cm_campaigns | CAMPAIGN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_CM_STG_LSTOUTPTS_F1 | Non Unique | Default | CAMPAIGN_ID |
| MKT_CM_STG_LSTOUTPTS_F2 | Non Unique | Default | TREATMENT_ID |
| MKT_CM_STG_LSTOUTPTS_F3 | Non Unique | Default | CALL_LST_ID |
| MKT_CM_STG_LSTOUTPTS_F4 | Non Unique | Default | DELV_PROFILE_ID |
| MKT_CM_STG_LSTOUTPTS_N1 | Non Unique | Default | STG_EXEC_ID, TREATMENT_ID, CALL_LST_ID |
| MKT_CM_STG_LSTOUTPTS_PK | Unique | LSTOUTPT_ID | |
| MKT_CM_STG_LSTOUTPTS_U1 | Unique | Default | STAGE_ID, FILE_NAME |