PJS_FP_EXTR_PLANV_GT

This global temporary table contains non-persistent plan version and related data used by online summarization.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

Columns

Name

WORKER_IDNUMBER18A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance.Active PROJECT_IDNUMBER18Contains the PROJECT_ID, not the Project Number (SEGMENT1)Active PROJECT_UNIT_IDNUMBER18Project unit ID BUSINESS_UNIT_IDNUMBER18Business Unit IDActive PLAN_VERSION_NUMBERNUMBER18Plan version number PLAN_VERSION_IDNUMBER18Plan Version IDActive PLAN_TYPE_IDNUMBER18Plan type IDActive PLAN_CLASS_CODEVARCHAR21Indicates whether the plan is a budget or forecast planActive TIME_PHASED_TYPE_CODEVARCHAR230Indicates whether a plan should be prorated the beginning or end of a period, or evenlyActive CURRENT_BUDGET_FLAGVARCHAR21Inernal flagActive ORIGINAL_BUDGET_FLAGVARCHAR21Inernal flagActive CURRENT_FORECAST_FLAGVARCHAR21Inernal flagActive PRIOR_FORECAST_FLAGVARCHAR21Inernal flagActive DIM_PLAN_STATUSVARCHAR230Comparison attribute between extracted plans and plans in the dimension.Active DIM_PLAN_ROWIDROWIDComparison attribute between extracted plans and plans in the dimension.Active

Indexes

Index	Uniqueness	Columns
PJS_FP_EXTR_PLANV_GT_N1	Non Unique	WORKER_ID, PROJECT_ID