PJS_FP_SUM_PLAN1

This partitioned table contains non-persistent plan data mapped to RBS and prepared for Essbase. It is used during incremental and delete and re-summarize summarization for exposing data to Essbase.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

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
SCENARIO	VARCHAR2	10		Type of data in Essbase whether actuals, current baseline budget, etc.
RECORD_TYPE	VARCHAR2	4		Internal data source identifier	Active
PJS_SUMMARY_ID	NUMBER		18	The PJS_SUMMARY_ID is used by the transaction system to map a summarization event to a set of data to be summarized.	Active
PROJECT_ID	NUMBER		18	Contains the PROJECT_ID, not the Project Number (SEGMENT1)	Active
PLAN_VERSION_ID	NUMBER		18	Plan Version ID	Active
PLAN_VERSION_ID_FLAG	VARCHAR2	1		This 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_ID	NUMBER		18	The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID	Active
PROJECT_ELEMENT_ID_FLAG	VARCHAR2	1		This 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_ID	NUMBER		18	Period time ID	Active
RBS_VERSION_ID	NUMBER		18	Resource breakdown structure version ID	Active
RBS_ELEMENT_ID	NUMBER		18	Resource breakdown structure element ID	Active
RBS_ELEMENT_ID_FLAG	VARCHAR2	1		This 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_TYPE	VARCHAR2	1		Indicates whether PA or GL calendar	Active
CURRENCY_TYPE	VARCHAR2	1		Currency type	Active
CURRENCY_CODE	VARCHAR2	3		Currency code	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
REVENUE	NUMBER			Revenue	Active
LABOR_REVENUE	NUMBER			Revenue	Active
RAW_COST	NUMBER			Raw cost	Active
BILL_RAW_COST	NUMBER			Billable raw cost	Active
CAP_RAW_COST	NUMBER			Capitalizable raw cost	Active
EXP_RAW_COST	NUMBER			Expense raw cost	Active
LABOR_RAW_COST	NUMBER			Raw cost	Active
BILL_LABOR_RAW_COST	NUMBER			Billable raw cost	Active
EQUIPMENT_RAW_COST	NUMBER			Raw cost	Active
BRDN_COST	NUMBER			Burdened cost	Active
BILL_BRDN_COST	NUMBER			Billable burdened cost	Active
CAP_BRDN_COST	NUMBER			Capitalizable burdened cost	Active
EXP_BRDN_COST	NUMBER			Expense burdened cost	Active
LABOR_BRDN_COST	NUMBER			Burdened cost	Active
BILL_LABOR_BRDN_COST	NUMBER			Billable burdened cost	Active
EQUIPMENT_BRDN_COST	NUMBER			Burdened cost	Active
LABOR_HRS	NUMBER			Quantity	Active
BILL_LABOR_HRS	NUMBER			Quantity	Active
EQUIPMENT_HRS	NUMBER			Quantity	Active
BILL_EQUIPMENT_HRS	NUMBER			Quantity	Active