PJS_FP_EXTR_PLANV_B

This table contains non-persistent plan version and related data used by bulk summarization.

Details

Name	Datatype	Length	Precision	Comments	Status
WORKER_ID	NUMBER		18	A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance.	Active
PROJECT_ID	NUMBER		18	Contains the PROJECT_ID, not the Project Number (SEGMENT1)	Active
PROJECT_UNIT_ID	NUMBER		18	Project unit ID	Active
BUSINESS_UNIT_ID	NUMBER		18	Business Unit ID	Active
PLAN_VERSION_NUMBER	NUMBER		18	Plan version number	Active
PLAN_VERSION_ID	NUMBER		18	Plan Version ID	Active
PLAN_TYPE_ID	NUMBER		18	Plan type ID	Active
PLAN_CLASS_CODE	VARCHAR2	1		Indicates whether the plan is a budget or forecast plan	Active
TIME_PHASED_TYPE_CODE	VARCHAR2	30		Indicates whether a plan should be prorated the beginning or end of a period, or evenly	Active
CURRENT_BUDGET_FLAG	VARCHAR2	1		Inernal flag	Active
ORIGINAL_BUDGET_FLAG	VARCHAR2	1		Inernal flag	Active
CURRENT_FORECAST_FLAG	VARCHAR2	1		Inernal flag	Active
PRIOR_FORECAST_FLAG	VARCHAR2	1		Inernal flag	Active
DIM_PLAN_STATUS	VARCHAR2	30		Comparison attribute between extracted plans and plans in the dimension.	Active
DIM_PLAN_ROWID	ROWID			Comparison attribute between extracted plans and plans in the dimension.	Active

Index	Uniqueness	Tablespace	Columns
PJS_FP_EXTR_PLANV_B_N1	Non Unique	FUSION_TS_TX_DATA	PROJECT_ID, PLAN_VERSION_ID