MSC_PLAN_EXTRACTS

This table stores list of analytic tables and views of each plan, which can be extracted by external systems.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSC_PLAN_EXTRACTS_PK	PLAN_ID, ENTITY_TYPE, ENTITY_ID, PART_NUMBER

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Plan identifier. The plan whose analytic tables are to be extracted.
ENTITY_TYPE	VARCHAR2	30		Yes	Entity type. Values: EXTRACT_DIMENSION, EXTRACT_FACT.
ENTITY_ID	NUMBER		18	Yes	Entity identifier. For dimension: dimension_id, for fact: granularity_id.
PART_NUMBER	NUMBER		18	Yes	Part number. If the entity is divided into n parts, the value will be between 1 and n.
PDS_TABLE_NAME	VARCHAR2	30			Name of table or view that stores the given entity.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_PLAN_EXTRACTS_U1	Unique	Default	PLAN_ID, ENTITY_TYPE, ENTITY_ID, PART_NUMBER