MSC_ENGINE_COMMUNICATION

Engine Configuration Table , Filled by Manager.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSC_ENGINE_COMMUNICATION_PK	EXECUTION_ID, PLAN_ID, PROFILE_ID, PNAME

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXECUTION_ID	NUMBER		18	Yes	Unique context ID of the plan run.
PLAN_ID	NUMBER		18	Yes	The ID of the plan for which parameters are passed.
PROFILE_ID	NUMBER		18	Yes	The ID of the demand forecast profile for which parameters are passed.
PNAME	VARCHAR2	40		Yes	Parameter name to be passed to demand planning Engine.
PTYPE	VARCHAR2	20		Yes	Describes the type of parameter being passed, indicating in which coloumns the value may be stored.
VALUE_FLOAT	NUMBER		17		Stores value for numeric parameters, either float or integer.
VALUE_DATE	DATE				Stores value for date parameters.
VALUE_STRING	VARCHAR2	2000			Stores value for generic named parameters or short queries.
VALUE_CLOB	CLOB				Stores value of long queries exceeding 2000 charachters.
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
MSC_ENGINE_COMMUNICATION	msc_engine_communication	EXECUTION_ID, PLAN_ID, PROFILE_ID, PNAME
msc_engine_communication	msc_engine_communication	EXECUTION_ID, PLAN_ID, PROFILE_ID, PNAME

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_ENGINE_COMMUNICATION_U1	Unique	Default	EXECUTION_ID, PLAN_ID, PROFILE_ID, PNAME