PJS_FP_BASE_FIN_L

Stores periodic data for summarization

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
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
PLANNED_BRDN_COST	NUMBER				PLANNED_BRDN_COST
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
CALENDAR_ID	NUMBER		18		Time dimension calendar ID	Active
CALENDAR_TYPE	VARCHAR2	1			Indicates whether PA or GL calendar	Active
PERIOD_NAME	VARCHAR2	30			Period name	Active
START_DATE	DATE				Start date	Active
END_DATE	DATE				End date	Active
RESOURCE_CLASS_ID	NUMBER		18		Resource attribute used to identify TXN_ACCUM_HEADER_ID	Active
CURRENCY_TYPE	VARCHAR2	1			Currency type	Active
CURRENCY_CODE	VARCHAR2	15			Currency code	Active
NAMED_ROLE	VARCHAR2	30			Resource attribute used to identify TXN_ACCUM_HEADER_ID	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				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
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_L_N1	Non Unique	Default	PROJECT_ID, TASK_ID, PERIOD_NAME