EGI_IO_MAP_B
This table stores the Mapping header level information.
Details
-
Schema: FUSION
-
Object owner: EGI
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
EGI_IO_MAP_B_PK |
MAPPING_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
MAPPING_ID | NUMBER | 18 | Yes | Unique identifier of the import map mapping. | |
DEFAULT_FLAG | VARCHAR2 | 1 | Identifies if the import format is the default import format of an item class. | ||
TYPE | VARCHAR2 | 2 | Identifies if the mapping is an import map or an import format. | ||
MAPPING_CODE | VARCHAR2 | 80 | Yes | The internal name of the import map. | |
OBJECT_NAME | VARCHAR2 | 30 | Yes | Name of the object being imported. | |
GENERIC_MAP_FLAG | VARCHAR2 | 1 | Yes | Identifies if the import map is visible to all suppliers. | |
ITEM_CLASS_ID | NUMBER | 18 | Yes | Provides metadata common to all items that share the category. For example, the item catalog category "Engine" describes attributes, functions and other characteristics common to several item numbers, such as Engine M10000 and Engine M20000. | |
ACTIVE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether an import map is active. | |
INCLUDE_REQUIRED_ATTRIBUTES | VARCHAR2 | 1 | Identifies if required attributes are to be included to an import format. | ||
FILE_TYPE | VARCHAR2 | 30 | Yes | The type or extension of the source file that contains the data being imported. | |
FILE_SELECTION | VARCHAR2 | 30 | Yes | A choice to select a specific file, or to select from a list of recently used files. | |
ENCODING_TYPE | VARCHAR2 | 30 | Yes | File encoding format that is applied for the import activity. | |
DATE_FORMAT | VARCHAR2 | 30 | Yes | Date format that is applied for the import activity. | |
DATA_DELIMETER | VARCHAR2 | 30 | Delimiter used in the data file uploaded to the import map. | ||
DELIMITER | VARCHAR2 | 20 | Delimiter used in the data file uploaded to the import map. | ||
DELIMITER_VALUE | VARCHAR2 | 20 | Delimiter used to concatenate different segments when configured item numbers are created. | ||
TIMESTAMP_FORMAT | VARCHAR2 | 30 | Yes | Time stamp format applied for import activity | |
UPLOAD_FROM | VARCHAR2 | 7 | The location of the source file. | ||
PARENT_MAPPING_ID | NUMBER | 18 | Unique identifier of the source import map. | ||
INT_EXT_FLAG | VARCHAR2 | 1 | Yes | Identifies if the usage of an object is external or internal. For example an external user, such as a supplier, can view an external import format but not an internal import format. | |
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. | |
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. | ||
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. | ||
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 |
---|---|---|
egi_io_map_source | egi_io_map_b | MAPPING_ID |
egi_io_map_destination | egi_io_map_b | MAPPING_ID |
egi_io_map_tl | egi_io_map_b | MAPPING_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
EGI_IO_MAP_B_PK | Unique | Default | MAPPING_ID, ORA_SEED_SET1 |
EGI_IO_MAP_B_PK1 | Unique | Default | MAPPING_ID, ORA_SEED_SET2 |
EGI_IO_MAP_B_U1 | Unique | Default | MAPPING_CODE, TYPE, ORA_SEED_SET1 |
EGI_IO_MAP_B_U11 | Unique | Default | MAPPING_CODE, TYPE, ORA_SEED_SET2 |