PJS_FP_SUM_PLAN1_GT

This global temporary table contains non-persistent plan data mapped to RBS and prepared for Essbase. It is used during online summarization for exposing data to Essbase.

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 SCENARIOVARCHAR210Type of data in Essbase whether actuals, current baseline budget, etc. RECORD_TYPEVARCHAR24Internal data source identifierActive PJS_SUMMARY_IDNUMBER18The PJS_SUMMARY_ID is used by the transaction system to map a summarization event to a set of data to be summarized.Active PROJECT_IDNUMBER18Contains the PROJECT_ID, not the Project Number (SEGMENT1)Active PLAN_VERSION_IDNUMBER18Plan Version IDActive PLAN_VERSION_ID_FLAGVARCHAR21This flag indicates whether the PLAN_VERSION_ID is an interior node, or a self node (both of which have the same PLAN_VERSION_ID).Active PROJECT_ELEMENT_IDNUMBER18The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_IDActive PROJECT_ELEMENT_ID_FLAGVARCHAR21This flag indicates whether the PROJECT_ELEMENT_ID is an interior node, or a self node (both of which have the same PROJECT_ELEMENT_ID).Active TIME_IDNUMBER18Period time IDActive RBS_VERSION_IDNUMBER18Resource breakdown structure version IDActive RBS_ELEMENT_IDNUMBER18Resource breakdown structure element IDActive RBS_ELEMENT_ID_FLAGVARCHAR21This flag indicates whether the RBS_ELEMENT_ID is an interior node, or a self node (both of which have the same RBS_ELEMENT_ID).Active CALENDAR_TYPEVARCHAR21Indicates whether PA or GL calendarActive CURRENCY_TYPEVARCHAR21Currency typeActive CURRENCY_CODEVARCHAR23Currency codeActive PLAN_TYPE_IDNUMBER18Plan type IDActive PLAN_CLASS_CODEVARCHAR21Indicates whether the plan is a budget or forecast planActive REVENUENUMBERRevenueActive LABOR_REVENUENUMBERRevenueActive RAW_COSTNUMBERRaw costActive BILL_RAW_COSTNUMBERBillable raw costActive CAP_RAW_COSTNUMBERCapitalizable raw costActive EXP_RAW_COSTNUMBERExpense raw costActive LABOR_RAW_COSTNUMBERRaw costActive BILL_LABOR_RAW_COSTNUMBERBillable raw costActive EQUIPMENT_RAW_COSTNUMBERRaw costActive BRDN_COSTNUMBERBurdened costActive BILL_BRDN_COSTNUMBERBillable burdened costActive CAP_BRDN_COSTNUMBERCapitalizable burdened costActive EXP_BRDN_COSTNUMBERExpense burdened costActive LABOR_BRDN_COSTNUMBERBurdened costActive BILL_LABOR_BRDN_COSTNUMBERBillable burdened costActive EQUIPMENT_BRDN_COSTNUMBERBurdened costActive LABOR_HRSNUMBERQuantityActive BILL_LABOR_HRSNUMBERQuantityActive EQUIPMENT_HRSNUMBERQuantityActive BILL_EQUIPMENT_HRSNUMBERQuantityActive