MSC_CC_BO_ENTITY_MAP

This is used for fusion collections to identify the entities associated with the business objects the user has chosen to monitor.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
MSC_CC_BO_ENTITY_MAP_PK	BUSINESS_OBJECT, ENTITY

Columns

Name	Datatype	Length	Not-null	Comments
BUSINESS_OBJECT	VARCHAR2	60	Yes	The business object the user may wish to monitor for collection.
ENTITY	VARCHAR2	33	Yes	An entity that will be monitored if the business object is monitored.
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
MSC_CC_BO_ENTITY_MAP	msc_business_objects_b	BUSINESS_OBJECT
MSC_CC_BO_ENTITY_MAP	msc_cc_master_entities	ENTITY

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_CC_BO_ENTITY_MAP_U1	Unique	Default	BUSINESS_OBJECT, ENTITY, ORA_SEED_SET1
MSC_CC_BO_ENTITY_MAP_U11	Unique	Default	BUSINESS_OBJECT, ENTITY, ORA_SEED_SET2