PJS_FP_OPT_PLAN_B

This table contains non-persistent planning data that has been prorated when required and is only used by bulk summarization. The summary data is aggregated by period.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
RECORD_TYPE	VARCHAR2	4			Internal data source identifier	Active
TXN_ACCUM_HEADER_ID	NUMBER		18		Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping	Active
PROJECT_ID	NUMBER		18		Contains the PROJECT_ID, not the Project Number (SEGMENT1)	Active
BUSINESS_UNIT_ID	NUMBER		18		Business Unit ID	Active
TASK_ID	NUMBER		18		Task ID	Active
PLAN_VERSION_ID	NUMBER		18		Plan Version ID	Active
PLAN_CLASS_CODE	VARCHAR2	1			Indicates whether the plan is a budget or forecast plan	Active
PLAN_CURRENT_FLAG	VARCHAR2	1			Inernal flag	Active
CALENDAR_ID	NUMBER		18		Time dimension calendar ID	Active
CALENDAR_TYPE	VARCHAR2	1			Indicates whether PA or GL calendar	Active
RESOURCE_CLASS_ID	NUMBER		18		Resource attribute used to identify TXN_ACCUM_HEADER_ID	Active
PERIOD_NAME	VARCHAR2	30			Period name	Active
START_DATE	DATE				Start date	Active
END_DATE	DATE				End date	Active
CURRENCY_TYPE	VARCHAR2	1			Currency type	Active
CURRENCY_CODE	VARCHAR2	3			Currency code	Active
RAW_COST	NUMBER				Raw cost	Active
BRDN_COST	NUMBER				Burdened cost	Active
REVENUE	NUMBER				Revenue	Active
QUANTITY	NUMBER				Quantity	Active
PRJ_RAW_COST	NUMBER				Project raw cost	Active
PRJ_BRDN_COST	NUMBER				Project burdened cost	Active
PRJ_REVENUE	NUMBER				Project revenue	Active
FUN_RAW_COST	NUMBER				Project functional raw cost	Active
FUN_BRDN_COST	NUMBER				Project functional burdened cost	Active
FUN_REVENUE	NUMBER				Project functional revenue	Active
UOM_CODE	VARCHAR2	3			Unit of measure code	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
PJS_FP_OPT_PLAN_B_N1	Non Unique	FUSION_TS_TX_DATA	PROJECT_ID, PLAN_VERSION_ID