PJS_FP_PROJ_FCST_F_B

This table contains non-persistent forecast data that has been fully summarized and will be loaded to Essbase. It is used by bulk summarization only.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
SCENARIO	VARCHAR2	10			Type of data in Essbase whether actuals, current baseline budget, etc.
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
PLAN_TYPE_ID	NUMBER		18		Plan type 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
CURRENCY_TYPE	VARCHAR2	1			Currency type	Active
CURRENCY_CODE	VARCHAR2	3			Currency code	Active
CALENDAR_TYPE	VARCHAR2	1			Indicates whether PA or GL calendar	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
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active