PJS_FP_OPT_PLAN

This table contains persistent planning data that has been prorated when required. 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	Yes	Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping	Active
PROJECT_ID	NUMBER		18	Yes	Contains the PROJECT_ID, not the Project Number (SEGMENT1)	Active
BUSINESS_UNIT_ID	NUMBER		18		Business Unit ID	Active
TASK_ID	NUMBER		18	Yes	Task ID	Active
PLAN_VERSION_ID	NUMBER		18	Yes	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		Yes	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		Yes	Currency type	Active
CURRENCY_CODE	VARCHAR2	15		Yes	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
CONTRACT_ID	NUMBER		18		Unique identifier of the award.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_FP_OPT_PLAN_N1	Non Unique	FUSION_TS_TX_DATA	PROJECT_ID, PLAN_VERSION_ID, TASK_ID, PERIOD_NAME
PJS_FP_OPT_PLAN_N2	Non Unique	Default	PROJECT_ID, PLAN_VERSION_ID, CURRENCY_TYPE, CALENDAR_TYPE
PJS_FP_OPT_PLAN_U1	Unique	Default	TXN_ACCUM_HEADER_ID, PROJECT_ID, TASK_ID, PLAN_VERSION_ID, CALENDAR_TYPE, PERIOD_NAME, CURRENCY_TYPE, CURRENCY_CODE