MSS_PLAN_STATUS_DETAIL

This table stores steps in a plan task execution with status and progress.

Details

• Schema: FUSION

• Object owner: MSS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSS_PLAN_STATUS_DETAIL_PK	EXECUTION_ID, STEP_SEQ

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Identifier of the Production Scheduling plan.
EXECUTION_ID	NUMBER		18	Yes	Reference to parent execution Id
STEP_SEQ	NUMBER		2	Yes	Sequence number of the plan exeuction step.
REQUEST	NUMBER		5	Yes	Request handled by the engine or data refresh: OpenPlan=1, ReopenPlan=2, SolvePlan=3, ReschedulePlan=4, SavePlan=5, StoreModelExtractBlob=6, ResetStoredPlanBlobs=7, ClosePlan=8, AbortPlan=9, RefreshPlanData=100
STATUS	NUMBER		5	Yes	Plan execution status for this request: PlanRunning=0, PlanSucceeded=1, PlanFailed=2
PERCENTAGE	NUMBER		3	Yes	Percentage of completeness of plan exeuction.
START_DATE	TIMESTAMP			Yes	Start date-time of handling the request
END_DATE	TIMESTAMP			Yes	Completion date-time of handling the request
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSS_PLAN_STATUS_DETAIL	mss_plan_status	EXECUTION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSS_PLAN_STATUS_DETAIL_U1	Unique	Default	EXECUTION_ID, STEP_SEQ