PJS_FP_SUM_FIN3_1

This table contains non-persistent actuals data mapped to RBS and prepared for Essbase. It is used during online summarization for exposing data to Essbase.

Details

Schema: FUSION
Object owner: PJS
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Comments
WORKER_ID	NUMBER		18	A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance.
SCENARIO	VARCHAR2	10		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.
PROJECT_ID	NUMBER		18	Contains the PROJECT_ID, not the Project Number (SEGMENT1)
PROJECT_ELEMENT_ID	NUMBER		18	The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID
PROJECT_ELEMENT_ID_FLAG	VARCHAR2	1		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).
TIME_ID	NUMBER		18	Period time ID
RBS_VERSION_ID	NUMBER		18	Resource breakdown structure version ID
RBS_ELEMENT_ID	NUMBER		18	Resource breakdown structure element ID
RBS_ELEMENT_ID_FLAG	VARCHAR2	1		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).
CALENDAR_TYPE	VARCHAR2	1		Indicates whether PA or GL calendar
CURRENCY_TYPE	VARCHAR2	1		Currency type
CURRENCY_CODE	VARCHAR2	15		Currency code
REVENUE	NUMBER			Revenue
LABOR_REVENUE	NUMBER			Revenue
RAW_COST	NUMBER			Raw cost
BILL_RAW_COST	NUMBER			Billable raw cost
CAP_RAW_COST	NUMBER			Capitalizable raw cost
EXP_RAW_COST	NUMBER			Expense raw cost
LABOR_RAW_COST	NUMBER			Raw cost
BILL_LABOR_RAW_COST	NUMBER			Billable raw cost
EQUIPMENT_RAW_COST	NUMBER			Raw cost
BRDN_COST	NUMBER			Burdened cost
BILL_BRDN_COST	NUMBER			Billable burdened cost
CAP_BRDN_COST	NUMBER			Capitalizable burdened cost
EXP_BRDN_COST	NUMBER			Expense burdened cost
LABOR_BRDN_COST	NUMBER			Burdened cost
BILL_LABOR_BRDN_COST	NUMBER			Billable burdened cost
EQUIPMENT_BRDN_COST	NUMBER			Burdened cost
LABOR_HRS	NUMBER			Quantity
BILL_LABOR_HRS	NUMBER			Quantity
EQUIPMENT_HRS	NUMBER			Quantity
BILL_EQUIPMENT_HRS	NUMBER			Quantity
SUP_INV_COMMITTED_COST	NUMBER			Supplier invoice commitment cost
PO_COMMITTED_COST	NUMBER			Purchase order commitment cost
PR_COMMITTED_COST	NUMBER			Requisition commitment cost
OTH_COMMITTED_COST	NUMBER			Commitment cost that is not Purchace Order, Requisition or Supplier Invoice
INVOICE_AMT	NUMBER			Invoice amount
RETIRE_RAW_COST	NUMBER			Raw cost
RETIRE_BRDN_COST	NUMBER			Burdened cost
PERIOD_NAME	VARCHAR2	30		Name of the GL or PA period in which transaction occurred.
START_DATE	DATE			Start date of the current GL or PA period.
END_DATE	DATE			End date of the current GL or PA period.
CALENDAR_ID	NUMBER		18	Identifier of the calendar from Time dimension.
UOM_CODE	VARCHAR2	30		The unit by which to measure amounts in a transaction.
TXN_ACCUM_HEADER_ID	NUMBER		18	Identifier of the unique combination of resource attributes.
RESOURCE_CLASS_ID	NUMBER		18	Identifier of the resource class.
SUP_INV_CMT_RAW_COST	NUMBER			Supplier invoice commitment cost amount.
PO_CMT_RAW_COST	NUMBER			Purchase order commitment cost amount.
PR_CMT_RAW_COST	NUMBER			Purchase requisition commitment cost amount.
OTH_CMT_RAW_COST	NUMBER			Commitment cost amount from thrid party source.
CMT_SUP_INV_QUANTITY	NUMBER			Suplier invoice commitment quantity.
CMT_PO_QUANTITY	NUMBER			Purchase order commitment quantity.
CMT_PR_QUANTITY	NUMBER			Purchase requisition commitment quantity.
CMT_OTH_QUANTITY	NUMBER			Commitment quantity from third party source.
QUANTITY	NUMBER			The number of units of the work performed.
BILL_QUANTITY	NUMBER			The number of units of work that are billable.
CAP_QUANTITY	NUMBER			The number of units of work that are capitalizable.
EXPENSE_QUANTITY	NUMBER			The number of units of work that are neither billable nor capitalizable.
ADDL_ATTRIBUTE_NUM_1	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_2	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_3	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_4	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_5	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_6	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_7	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_8	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_9	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_10	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_1	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_2	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_3	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_4	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_5	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_6	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_7	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_8	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_9	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_10	VARCHAR2	150		Oracle internal use only.
TO_CMT_RAW_COST	NUMBER			Raw cost committed through transfer orders.
TO_COMMITTED_COST	NUMBER			Burdened cost committed through transfer orders.
CMT_TO_QUANTITY	NUMBER			Quantity committed through transfer orders.
RCPT_CMT_RAW_COST	NUMBER			Raw cost committed through receipts.
RCPT_COMMITTED_COST	NUMBER			Burdened cost committed through receipts.
CMT_RCPT_QUANTITY	NUMBER			Quantity committed through receipts.
ADDL_ATTRIBUTE_NUM_11	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_NUM_12	NUMBER			Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_11	VARCHAR2	150		Oracle internal use only.
ADDL_ATTRIBUTE_CHAR_12	VARCHAR2	150		Oracle internal use only.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_FP_SUM_FIN3_1_N1	Non Unique	Default	WORKER_ID, PROJECT_ID