MSC_PLAN_FORECAST

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
MSC_PLAN_FORECAST_PROFILE_PK	TRANSACTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_ID	NUMBER		18	Yes	This column is the primary key for this table.
ANALYSIS_SET	NUMBER		18		ANALYSIS_SET column holds the set of measures and dimension members.
PROPORT_RUN_DATE	TIMESTAMP				Stores the last run date of the proport process.
ENG_NETCHG_HASH	CLOB				A hash value is calculated for the existing forecast tree of the demand forecast profile and used to detect if the forecast tree was modified by the user since the last run, in which case the full run will be forced instead of a net change run which is the default.
ANALYSIS_SET_CLOB	CLOB				Stores the definition for the analysis set stored by the forecasting profile.
PLAN_ID	NUMBER		18	Yes	Holds the plan id of the forecasting profile.
FORECAST_PROFILE_ID	NUMBER		18	Yes	Unique identifier of the forecasting profile.
HISTORICAL_BUCKETS	NUMBER				This columns holds the number of historical buckets considered by the forecasting profile.
LOCKED_FUTURE_PERIODS	NUMBER				This column holds the number of initial forecast periods that are locked for forecasting.
FORECAST_PROFILE_ORDER	NUMBER		9		Position number in the forecast list of the forecast profiles.
ENG_RUN_DATE	TIMESTAMP				Last net change run date/time for the forecasting engine by plan.
HISTORICAL_OFFSET	NUMBER				Number of history time buckets shifted backward to adjust History End Date.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
HISTORY_END_DATE	DATE				Last History date for the forecasting profile by plan.
FORECAST_START_DATE	DATE				First Forecast date for the forecasting profile by plan.
HYPERTUNING_SETTING	NUMBER		5		A dynamic Column under demand tab in edit plan options, which opens the Settings for Hyperparameter Tuning dialog box. In addition, it holds the corresponding plan's population percent value to be used in the Hyperparameters Tuning calculation in the selected forecasting profile. Percent value corresponds to the Percentage of Nodes to Tune field in the same dialog box. By default, percent value is taken from the HypertuneSamplePercent forecasting parameter. Values can be any percent between O and 100. 0% means no tuning. 100% means tuning on all plan’s population. Any percent between means hyperparameters tuning on part of the plan’s population.
IS_AUTOMATIC_TUNING_ENABLED	NUMBER				Holds the corresponding value selected in the Settings for Hyperparameter Tuning dialog box in the Enable hyperparameter tuning check box field. Dialog box can be opened from the Hyperparameters Settings Column’s in the Plan Options Page. Not checked is saved as 0, checked is saved as 1.
OUTPUT_OPTIONS	NUMBER				Holds the corresponding value which was added in the Output Options field in the Settings for Hyperparameter Tuning dialog box. Dialog box can be opened from the Hyperparameters Settings Column's in the Plan Options Page. The user can select 'Tune and Use' or 'Tune and Compare' the Hyperparameters Tuning results for the specific forecasting profile inside a specific plan. 'Tune and Use' is stored as 1 in the database and 'Tune and Compare' as 2.
PLANNING_ADVISOR_NOTIFY	NUMBER				Holds the corresponding value which was selected in the Planning Advisor Notification field in the Settings for Hyperparameter Tuning dialog box. Dialog box can be opened from the Hyperparameters Settings Column’s in the Plan Options Page. Notification to Planning Advisor about Hyperparameter Tuning on the specific forecasting profile and plan can be disabled or enabled.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_PLAN_FORECAST_PROFILES	msc_plan_definitions	PLAN_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_PLAN_FC_PROFILES_U1	Unique	Default	TRANSACTION_ID
MSC_PLAN_FORECAST_PROFILES_U2	Unique	Default	PLAN_ID, FORECAST_PROFILE_ID