MKT_IMP_MAP
This table stores information about the import mapping which is the mapping from the staging table to individual attributes in the destination data store. It contains the header level details for the import mapping itself. The child entity "Import Mapping Column" holds the detailed column by column mapping information.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MKT_IMP_MAP_PK |
IMPORT_MAP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| IMPORT_MAP_ID | NUMBER | 18 | Yes | This column holds import map id and, is a primary key. | |
| CLASSIC_MAP_ID | NUMBER | 18 | Stored classic map id for standard map. | ||
| CLASSIC_MAP_OBJECT | VARCHAR2 | 100 | Stored classic map object for standard map. | ||
| IMPORT_TYPE | VARCHAR2 | 50 | This Column specifies whether the map created is from Claasic,Standard or simplified Import | ||
| HEADER_ROW_INCLUDED | VARCHAR2 | 1 | Field indicates whether the Header row was included or not for the Map | ||
| FILE_TYPE_CODE | VARCHAR2 | 30 | Input file type used for the map. Possible values are ZIP, CSV, XML and TXT | ||
| EXTENSIBLE_FLAG | VARCHAR2 | 1 | To support the extensibility of maps for import as optional choice. | ||
| SEEDED_FLAG | VARCHAR2 | 1 | Seeded Flag to indicate whether the map is a seeded map or not. | ||
| VISIBLE_FLAG | VARCHAR2 | 1 | Visible Flag to indicate wheter the map is going to be visible in the maps listing page. | ||
| IMPORT_MAP_NUM | VARCHAR2 | 130 | Yes | This column holds import mapping numer and, is used for alternate key. | |
| NAME | VARCHAR2 | 100 | Yes | This column holds import mapping name. | |
| DESC_TEXT | VARCHAR2 | 250 | This column holds mapping description text. | ||
| OBJECT_TYPE_CD | VARCHAR2 | 128 | Import object type (lead, response, account, contact, prospect) | ||
| LOCKED_FLAG | VARCHAR2 | 1 | Indicates whether the mapping is locked for editing | ||
| ORGANIZATION_ID | NUMBER | 18 | This column holds organization Identifier. | ||
| 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. | |
| DECIMAL_SEPARATOR | VARCHAR2 | 3 | Decimal Separator in the file being imported | ||
| DATE_FORMAT | VARCHAR2 | 30 | Date Format to be validated against for the incoming file data | ||
| TIMESTAMP_FORMAT | VARCHAR2 | 30 | TimeStamp format to be validated against for incoming file data | ||
| OBJECT_DETAIL_NAME | VARCHAR2 | 100 | This column holds File Import Object Name | ||
| IMPORT_MAP_TYPE | VARCHAR2 | 1 | This columns is to differentiate either system map or user map. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| OBJECT_PARENT_LIC | VARCHAR2 | 2000 | Comma separated list of 'LANG_INDEPENDENT_CODE' values used to identify potential parent of object of a current object. Will be used for hierarchical display purpose | ||
| OBJECT_TYPE | VARCHAR2 | 100 | These will be used for defining the security predicates. Possible values could be: StandardObject, StandardChild, CustomChildOfStandard, CustomObject, CUstomChildOfCustom, IntersectionObject | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MKT_IMP_MAP | hz_parties | ORGANIZATION_ID |
| mkt_imp_jobs | mkt_imp_map | IMPORT_MAP_ID |
| mkt_imp_map_columns | mkt_imp_map | IMPORT_MAP_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_IMP_MAP_N1 | Non Unique | Default | UPPER("NAME") |
| MKT_IMP_MAP_N2 | Non Unique | Default | OBJECT_TYPE_CD |
| MKT_IMP_MAP_PK | Unique | Default | IMPORT_MAP_ID, ORA_SEED_SET1 |
| MKT_IMP_MAP_PK1 | Unique | Default | IMPORT_MAP_ID, ORA_SEED_SET2 |