PJS_FP_BASE_FIN

This table contains persistent actuals data that is aggregated by period and has relevant resource attributes assigned.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TXN_ACCUM_HEADER_ID	NUMBER		18	Yes	Accum header Identifier	Active
PLANNED_BRDN_COST	NUMBER				PLANNED_BRDN_COST
PROJECT_ID	NUMBER		18	Yes	Project Identifier	Active
BUSINESS_UNIT_ID	NUMBER		18		Business Unit ID	Active
TASK_ID	NUMBER		18	Yes	Task Identifier	Active
CALENDAR_ID	NUMBER		18		Time dimension calendar ID	Active
CALENDAR_TYPE	VARCHAR2	1		Yes	Indicates whether PA or GL calendar	Active
PERIOD_NAME	VARCHAR2	30		Yes	Period name	Active
START_DATE	DATE				Start date	Active
END_DATE	DATE				End date	Active
RESOURCE_CLASS_ID	NUMBER		18		Resource Class Identifier	Active
CURRENCY_TYPE	VARCHAR2	1		Yes	Currency type	Active
CURRENCY_CODE	VARCHAR2	15		Yes	Currency code	Active
NAMED_ROLE	VARCHAR2	30			Named Role associated with the Resource	Active
RAW_COST	NUMBER				Raw cost	Active
BILL_RAW_COST	NUMBER				Billable raw cost	Active
CAP_RAW_COST	NUMBER				Capitalizable raw cost	Active
EXPENSE_RAW_COST	NUMBER				Expense 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
EXPENSE_BRDN_COST	NUMBER				Expense burdened cost	Active
REVENUE	NUMBER				REVENUE	Active
UBR	NUMBER				Unbilled receivable	Active
UER	NUMBER				Unearned revenue	Active
QUANTITY	NUMBER				Quantity	Active
BILL_QUANTITY	NUMBER				Billable Quantity	Active
CAP_QUANTITY	NUMBER				Quantity	Active
EXPENSE_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	30			Unit of measure code	Active
INVOICE_AMT	NUMBER				Invoice amount	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
AWARD_PERIOD_ID	NUMBER		18		Identifier for the award budget period. The award budget period is defined separately from the GL period.
CONTRACT_ID	NUMBER		18		Unique identifier of the award.
FUNDING_SOURCE_ID	NUMBER		18		Identifier of the award funding source.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_FP_BASE_FIN_N1	Non Unique	FUSION_TS_TX_DATA	PROJECT_ID, TASK_ID, PERIOD_NAME
PJS_FP_BASE_FIN_N2	Non Unique	Default	PROJECT_ID, CURRENCY_TYPE, CALENDAR_TYPE
PJS_FP_BASE_FIN_U1	Unique	Default	TXN_ACCUM_HEADER_ID, PROJECT_ID, TASK_ID, PERIOD_NAME, AWARD_PERIOD_ID, CURRENCY_TYPE, CURRENCY_CODE, CALENDAR_TYPE, CONTRACT_ID, FUNDING_SOURCE_ID, UOM_CODE