1. Tables and Views for Sales and Fusion Service
  2. MKT_IMP_URLS

MKT_IMP_URLS

Interface table for importing URLs.

Details

  • Schema: FUSION

  • Object owner: MKT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MKT_IMP_URLS_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments Status
BATCH_ID NUMBER 18 Yes Primary Key - Identifier that groups data into a batch Active
INTERFACE_ROW_ID NUMBER 18 Yes Primary Key - Used to link with rows in the error table Active
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. Active
IMPORT_STATUS_CODE VARCHAR2 30 Indicates the status of the record to be processed Active
ACTION_CODE VARCHAR2 30 Indicates the operation to be performed on a row, such as Insert, Update, etc. Active
FILE_RECORD_NUM NUMBER 10 File Record Number. Record indicator in the File.
REUSABLE_URL_EXT_REF VARCHAR2 64 Reusable URL External Reference - Stores the unique identifier of the reusable URL in the source system. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
CATEGORY VARCHAR2 30 This field stores the different types of categories for the reusable urls. Reference MKT_URL_CATEGORY lookups. Active
STATUS VARCHAR2 30 This field identifies whether the reusable url is active or not. Reference MKT_URL_STATUS lookups. Active
URL_ID NUMBER 18 URL Id is the marketing URL id. Active
URL_NAME VARCHAR2 250 URL Name is the marketing URL name. Active
URL_DESC VARCHAR2 1000 URL Description is the marketing URL description. Active
URL VARCHAR2 2000 URL is the hyperlink for the marketing URL. Active
URL_TYPE VARCHAR2 30 URL type. Identifies whether a URL is TRACKABLE_URL or REUSABLE_URL or RESPONSE_FORMS. Reference MKT_URL_TYPE lookups. Active
CREATE_RESP_FLAG VARCHAR2 1 Flag indicating if response needs to be created. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Indexes

Index Uniqueness Tablespace Columns Status
MKT_IMP_URLS_PK Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID Active