MKT_IMP_MAP_COLUMNS

Details

Schema: FUSION
Object owner: MKT
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
MKT_IMP_MAP_COLUMNS_PK	MAP_COLUMN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MAP_COLUMN_ID	NUMBER		18	Yes	Primary key
TXN_VO_ATTR_LEN	NUMBER		10		This column specifies Fusion Table Column Width
INT_VO_ATTR_NAME	VARCHAR2	100			This column specifies the interface attribute name
INT_VO_ATTR_COL	VARCHAR2	100			The column saves the column name of the interface table for the corresponding INT_VO_ATTR_NAME
TXN_VO_ATTR_NAME	VARCHAR2	100			Transaction VO Attribute Name corresponding to the interface VO Attribute
TXN_VO_ATTR_TYPE	VARCHAR2	100			This column specifies the datatype of the transaction VO Attribute
TXN_VO_ATTR_COL	VARCHAR2	100			The column saves the column name of the base table for the corresponding TXN_VO_ATTR_NAME
TXN_VO_ATTR_TABLE	VARCHAR2	100			The column saves the value of the base table name
MAP_COLUMN_NUM	VARCHAR2	160		Yes	alternate key
IMPORT_MAP_ID	NUMBER		18		Identifies the parent mapping (foreign key to MKT_IMP_MAP.IMPORT_MAP_ID)
IMP_FIELD_SEQ_NUM	NUMBER		10		Field Sequence Number
IMP_FIELD_NAME	VARCHAR2	500			Stores field name which is extracted from the import file
LOGIC_OBJ_NAME	VARCHAR2	60			Mapped VO name
OBJECT_NAME	VARCHAR2	60			Mapped table name
OBJECT_DISPLAY_NAME	VARCHAR2	100			Object display name
LOGIC_OBJ_COL_NAME	VARCHAR2	120			Mapped VO attribute name
OBJ_COL_NAME	VARCHAR2	60			Mapped table column name
OBJ_COL_DISPLAY_NAME	VARCHAR2	120			Object field display name
SAMPLE_VAL	VARCHAR2	100			Sample Value
REQD_FIELD_FLAG	VARCHAR2	1			Required Field Flag
IGNORE_FIELD_FLAG	VARCHAR2	1			Ignore field flag
ALLOW_FIELD_UPDATE	VARCHAR2	1			Allow field update flag
EXACT_MATCH_FLAG	VARCHAR2	1			Exact match flag
COLUMN_WIDTH	NUMBER		10		Column width
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.
OBJECT_TYPE	VARCHAR2	128			Object of the mapped column
SOURCE_FILE_NAME	VARCHAR2	120			Source File Name to store the name of the file used to do the import of the data in file import
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.
MAP_COLUMN_TYPE	VARCHAR2	100			It specifies whether the mapping column is an EXTERNAL column (specified in CSV file by customer) or an INTERNAL column (not specified by user in csv file, but needed internally by File Import framework). It will have possible values as values as INTERNAL and EXTERNAL
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_COLUMNS	mkt_imp_map	IMPORT_MAP_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MKT_IMP_MAP_COLUMNS_FK1	Non Unique	Default	IMPORT_MAP_ID
MKT_IMP_MAP_COLUMNS_PK	Unique	Default	MAP_COLUMN_ID, ORA_SEED_SET1
MKT_IMP_MAP_COLUMNS_PK1	Unique	Default	MAP_COLUMN_ID, ORA_SEED_SET2