MSC_FLEX_FIELD_MAPPING

This table is used to store the descriptive flex field mappings from source and destination tables.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSC_FLEX_FIELD_MAPPING_PK	FLEX_FIELD_MAPPING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
FLEX_FIELD_MAPPING_ID	NUMBER		18	Yes	Sequence generated Unique identifier for flex field mapping.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	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
SR_INSTANCE_ID	NUMBER		18	Yes	Applications' Instance Identifier	Active
ENTITY_NAME	VARCHAR2	33		Yes	Entity name to which the flex field mapping is done	Active
SR_TABLE_NAME	VARCHAR2	230			source table name from where the flex field attributes are picked	Active
SR_COLUMN_NAME	VARCHAR2	30			source table column name (flex field attribute name)	Active
DEST_COLUMN_NAME	VARCHAR2	30		Yes	Destination table flex field column name into which the value in SR_COLUMN_NAME will be stored.	Active
DEST_TABLE_NAME	VARCHAR2	30		Yes	Destination table name for the entity	Active
SR_FLEXFIELD_CODE	VARCHAR2	64			Stores the flexfield name or code. Used for Entity Additional Details column.
SR_ATTR_REFERENCE	VARCHAR2	230			Name of the context under the flexfield code selected
SR_ATTR_TYPE	NUMBER		3		Stores the type of source attribute. Golbal or Context type
ATTRIBUTE_ID	NUMBER		18		Planning Attribute ID to which the SR_ATTR_ID is mapped to.
OVERRIDE_REL_SCO	NUMBER		1		Denotes if override release for SCO Mapper is enabled for the Display attribute. Default is No with value of Null/2. It will be 1 if updated Yes.
OVERRIDE_REL_ATTR_REF	VARCHAR2	230			Overridden Attribute Reference for the SCO Mapper.
OVERRIDE_REL_ATTR_NAME	VARCHAR2	30			Overridden Attribute for the SCO Mapper.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MSC_FLEX_FIELD_MAPPING_U1	Unique	Default	FLEX_FIELD_MAPPING_ID
MSC_FLEX_FIELD_MAPPING_U2	Unique	FUSION_TS_TX_IDX	SR_INSTANCE_ID, ENTITY_NAME, DEST_TABLE_NAME, DEST_COLUMN_NAME	Active