PJS_FP_PROJ_BGT_F

This table contains persistent budget data that has been fully summarized and has been loaded to Essbase, when Essbase is available.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PJS_FP_PROJ_BGT_F_PK	SCENARIO, PLAN_VERSION_ID, PROJECT_ELEMENT_ID, PROJECT_ELEMENT_ID_FLAG, TIME_ID, RBS_ELEMENT_ID, RBS_ELEMENT_ID_FLAG, CURRENCY_TYPE, CALENDAR_TYPE, CURRENCY_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
SCENARIO	VARCHAR2	10		Yes	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	Yes	Plan Version ID	Active
PLAN_VERSION_ID_FLAG	VARCHAR2	1		Yes	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	Yes	The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID	Active
PROJECT_ELEMENT_ID_FLAG	VARCHAR2	1		Yes	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	Yes	Period time ID	Active
RBS_VERSION_ID	NUMBER		18		Resource breakdown structure version ID	Active
RBS_ELEMENT_ID	NUMBER		18	Yes	Resource breakdown structure element ID	Active
RBS_ELEMENT_ID_FLAG	VARCHAR2	1		Yes	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		Yes	Currency type	Active
CURRENCY_CODE	VARCHAR2	15		Yes	Currency code	Active
CALENDAR_TYPE	VARCHAR2	1		Yes	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

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PJS_FP_PROJ_BGT_F_N1	Non Unique	FUSION_TS_TX_DATA	PROJECT_ID, PLAN_VERSION_ID, PROJECT_ELEMENT_ID, TIME_ID, RBS_ELEMENT_ID	Active
PJS_FP_PROJ_BGT_F_N2	Non Unique	FUSION_TS_TX_DATA	PJS_SUMMARY_ID	Active