PJO_XBS_ACCUM_F

PJO Online Summarization Fact Table

Details

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

Primary Key

Name	Columns
PJO_XBS_ACCUM_F_PK	LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PROJECT_ID	NUMBER		18		PROJECT_ID *****	Active
PROJECT_ORG_ID	NUMBER		18		PROJECT_ORG_ID *****	Active
PROJECT_ORGANIZATION_ID	NUMBER		18		PROJECT_ORGANIZATION_ID *****	Active
PROJECT_UNIT_ID	NUMBER		18		PROJECT_UNIT_ID *****	Active
PROJECT_ELEMENT_ID	NUMBER		18		PROJECT_ELEMENT_ID *****	Active
RBS_VERSION_ID	NUMBER		18		RBS_VERSION_ID *****	Active
RBS_ELEMENT_ID	NUMBER		18		RBS_ELEMENT_ID *****	Active
PLAN_VERSION_ID	NUMBER		18		PLAN_VERSION_ID *****	Active
PLAN_TYPE_ID	NUMBER		18		PLAN_TYPE_ID *****	Active
PLAN_TYPE_CODE	VARCHAR2	2			PLAN_TYPE_CODE *****	Active
PERIOD_NAME	VARCHAR2	30			PERIOD_NAME *****	Active
PERIOD_TYPE_ID	NUMBER		18		PERIOD_TYPE_ID *****	Active
CALENDAR_TYPE	VARCHAR2	1			CALENDAR_TYPE *****	Active
RBS_AGGR_LEVEL	VARCHAR2	1			RBS_AGGR_LEVEL *****	Active
WBS_ROLLUP_FLAG	VARCHAR2	1			WBS_ROLLUP_FLAG *****	Active
CURRENCY_CODE	VARCHAR2	30			CURRENCY_CODE *****	Active
START_DATE	DATE				START_DATE *****	Active
END_DATE	DATE				END_DATE *****	Active
ACT_START_DATE	DATE				Stores actuals start date.
ACT_END_DATE	DATE				Stores actuals end date.
LINE_ID	NUMBER		18	Yes	LINE_ID *****	Active
QUANTITY	NUMBER				QUANTITY *****	Active
LABOR_HRS	NUMBER				LABOR_HRS *****	Active
EQUIP_HRS	NUMBER				EQUIP_HRS *****	Active
ACT_QUANTITY	NUMBER				ACT_QUANTITY *****	Active
ACT_LABOR_HRS	NUMBER				ACT_LABOR_HRS *****	Active
ACT_EQUIP_HRS	NUMBER				ACT_EQUIP_HRS *****	Active
ACT_BILL_LABOR_HRS	NUMBER				ACT_BILL_LABOR_HRS *****	Active
ACT_BILL_EQUIP_HRS	NUMBER				ACT_BILL_EQUIP_HRS *****	Active
ETC_QUANTITY	NUMBER				ETC_QUANTITY *****	Active
ETC_LABOR_HRS	NUMBER				ETC_LABOR_HRS *****	Active
ETC_EQUIP_HRS	NUMBER				ETC_EQUIP_HRS *****	Active
CMT_SUP_INV_QUANTITY	NUMBER				CMT_SUP_INV_QUANTITY *****	Active
CMT_PO_QUANTITY	NUMBER				CMT_PO_QUANTITY *****	Active
CMT_PR_QUANTITY	NUMBER				CMT_PR_QUANTITY *****	Active
CMT_OTH_QUANTITY	NUMBER				CMT_OTH_QUANTITY *****	Active
PC_RAW_COST	NUMBER				PC_RAW_COST *****	Active
PC_BRDN_COST	NUMBER				PC_BRDN_COST *****	Active
PC_REVENUE	NUMBER				PC_REVENUE *****	Active
PC_LABOR_RAW_COST	NUMBER				PC_LABOR_RAW_COST *****	Active
PC_LABOR_BRDN_COST	NUMBER				PC_LABOR_BRDN_COST *****	Active
PC_EQUIPMENT_RAW_COST	NUMBER				PC_EQUIPMENT_RAW_COST *****	Active
PC_EQUIPMENT_BRDN_COST	NUMBER				PC_EQUIPMENT_BRDN_COST *****	Active
PC_ACT_RAW_COST	NUMBER				PC_ACT_RAW_COST *****	Active
PC_ACT_BRDN_COST	NUMBER				PC_ACT_BRDN_COST *****	Active
PC_ACT_REVENUE	NUMBER				PC_ACT_REVENUE *****	Active
PC_ACT_LABOR_RAW_COST	NUMBER				PC_ACT_LABOR_RAW_COST *****	Active
PC_ACT_LABOR_BRDN_COST	NUMBER				PC_ACT_LABOR_BRDN_COST *****	Active
PC_ACT_EQUIP_RAW_COST	NUMBER				PC_ACT_EQUIP_RAW_COST *****	Active
PC_ACT_EQUIP_BRDN_COST	NUMBER				PC_ACT_EQUIP_BRDN_COST *****	Active
PC_ACT_BILL_RAW_COST	NUMBER				PC_ACT_BILL_RAW_COST *****	Active
PC_ACT_BILL_BRDN_COST	NUMBER				PC_ACT_BILL_BRDN_COST *****	Active
PC_ETC_RAW_COST	NUMBER				PC_ETC_RAW_COST *****	Active
PC_ETC_BRDN_COST	NUMBER				PC_ETC_BRDN_COST *****	Active
PC_ETC_REVENUE	NUMBER				PC_ETC_REVENUE *****	Active
PC_ETC_LABOR_RAW_COST	NUMBER				PC_ETC_LABOR_RAW_COST *****	Active
PC_ETC_LABOR_BRDN_COST	NUMBER				PC_ETC_LABOR_BRDN_COST *****	Active
PC_ETC_EQUIP_RAW_COST	NUMBER				PC_ETC_EQUIP_RAW_COST *****	Active
PC_ETC_EQUIP_BRDN_COST	NUMBER				PC_ETC_EQUIP_BRDN_COST *****	Active
PC_SUP_INV_CMT_RAW_COST	NUMBER				PC_SUP_INV_CMT_RAW_COST *****	Active
PC_SUP_INV_CMT_BRDN_COST	NUMBER				PC_SUP_INV_CMT_BRDN_COST *****	Active
PC_PO_CMT_RAW_COST	NUMBER				PC_PO_CMT_RAW_COST *****	Active
PC_PO_CMT_BRDN_COST	NUMBER				PC_PO_CMT_BRDN_COST *****	Active
PC_PR_CMT_RAW_COST	NUMBER				PC_PR_CMT_RAW_COST *****	Active
PC_PR_CMT_BRDN_COST	NUMBER				PC_PR_CMT_BRDN_COST *****	Active
PC_OTH_CMT_RAW_COST	NUMBER				PC_OTH_CMT_RAW_COST *****	Active
PC_OTH_CMT_BRDN_COST	NUMBER				PC_OTH_CMT_BRDN_COST *****	Active
PFC_RAW_COST	NUMBER				PFC_RAW_COST *****	Active
PFC_BRDN_COST	NUMBER				PFC_BRDN_COST *****	Active
PFC_REVENUE	NUMBER				PFC_REVENUE *****	Active
PFC_LABOR_RAW_COST	NUMBER				PFC_LABOR_RAW_COST *****	Active
PFC_LABOR_BRDN_COST	NUMBER				PFC_LABOR_BRDN_COST *****	Active
PFC_EQUIPMENT_RAW_COST	NUMBER				PFC_EQUIPMENT_RAW_COST *****	Active
PFC_EQUIPMENT_BRDN_COST	NUMBER				PFC_EQUIPMENT_BRDN_COST *****	Active
PFC_ACT_RAW_COST	NUMBER				PFC_ACT_RAW_COST *****	Active
PFC_ACT_BRDN_COST	NUMBER				PFC_ACT_BRDN_COST *****	Active
PFC_ACT_REVENUE	NUMBER				PFC_ACT_REVENUE *****	Active
PFC_ACT_LABOR_RAW_COST	NUMBER				PFC_ACT_LABOR_RAW_COST *****	Active
PFC_ACT_LABOR_BRDN_COST	NUMBER				PFC_ACT_LABOR_BRDN_COST *****	Active
PFC_ACT_EQUIP_RAW_COST	NUMBER				PFC_ACT_EQUIP_RAW_COST *****	Active
PFC_ACT_EQUIP_BRDN_COST	NUMBER				PFC_ACT_EQUIP_BRDN_COST *****	Active
PFC_ACT_BILL_RAW_COST	NUMBER				PFC_ACT_BILL_RAW_COST *****	Active
PFC_ACT_BILL_BRDN_COST	NUMBER				PFC_ACT_BILL_BRDN_COST *****	Active
PFC_ETC_RAW_COST	NUMBER				PFC_ETC_RAW_COST *****	Active
PFC_ETC_BRDN_COST	NUMBER				PFC_ETC_BRDN_COST *****	Active
PFC_ETC_REVENUE	NUMBER				PFC_ETC_REVENUE *****	Active
PFC_ETC_LABOR_RAW_COST	NUMBER				PFC_ETC_LABOR_RAW_COST *****	Active
PFC_ETC_LABOR_BRDN_COST	NUMBER				PFC_ETC_LABOR_BRDN_COST *****	Active
PFC_ETC_EQUIP_RAW_COST	NUMBER				PFC_ETC_EQUIP_RAW_COST *****	Active
PFC_ETC_EQUIP_BRDN_COST	NUMBER				PFC_ETC_EQUIP_BRDN_COST *****	Active
PFC_SUP_INV_CMT_RAW_COST	NUMBER				PFC_SUP_INV_CMT_RAW_COST *****	Active
PFC_SUP_INV_CMT_BRDN_COST	NUMBER				PFC_SUP_INV_CMT_BRDN_COST *****	Active
PFC_PO_CMT_RAW_COST	NUMBER				PFC_PO_CMT_RAW_COST *****	Active
PFC_PO_CMT_BRDN_COST	NUMBER				PFC_PO_CMT_BRDN_COST *****	Active
PFC_PR_CMT_RAW_COST	NUMBER				PFC_PR_CMT_RAW_COST *****	Active
PFC_PR_CMT_BRDN_COST	NUMBER				PFC_PR_CMT_BRDN_COST *****	Active
PFC_OTH_CMT_RAW_COST	NUMBER				PFC_OTH_CMT_RAW_COST *****	Active
PFC_OTH_CMT_BRDN_COST	NUMBER				PFC_OTH_CMT_BRDN_COST *****	Active
TC_RAW_COST	NUMBER				TC_RAW_COST *****	Active
TC_BRDN_COST	NUMBER				TC_BRDN_COST *****	Active
TC_REVENUE	NUMBER				TC_REVENUE *****	Active
TC_LABOR_RAW_COST	NUMBER				TC_LABOR_RAW_COST *****	Active
TC_LABOR_BRDN_COST	NUMBER				TC_LABOR_BRDN_COST *****	Active
TC_EQUIPMENT_RAW_COST	NUMBER				TC_EQUIPMENT_RAW_COST *****	Active
TC_EQUIPMENT_BRDN_COST	NUMBER				TC_EQUIPMENT_BRDN_COST *****	Active
TC_ACT_RAW_COST	NUMBER				TC_ACT_RAW_COST *****	Active
TC_ACT_BRDN_COST	NUMBER				TC_ACT_BRDN_COST *****	Active
TC_ACT_REVENUE	NUMBER				TC_ACT_REVENUE *****	Active
TC_ACT_LABOR_RAW_COST	NUMBER				TC_ACT_LABOR_RAW_COST *****	Active
TC_ACT_LABOR_BRDN_COST	NUMBER				TC_ACT_LABOR_BRDN_COST *****	Active
TC_ACT_EQUIP_RAW_COST	NUMBER				TC_ACT_EQUIP_RAW_COST *****	Active
TC_ACT_EQUIP_BRDN_COST	NUMBER				TC_ACT_EQUIP_BRDN_COST *****	Active
TC_ACT_BILL_RAW_COST	NUMBER				TC_ACT_BILL_RAW_COST *****	Active
TC_ACT_BILL_BRDN_COST	NUMBER				TC_ACT_BILL_BRDN_COST *****	Active
TC_ETC_RAW_COST	NUMBER				TC_ETC_RAW_COST *****	Active
TC_ETC_BRDN_COST	NUMBER				TC_ETC_BRDN_COST *****	Active
TC_ETC_REVENUE	NUMBER				TC_ETC_REVENUE *****	Active
TC_ETC_LABOR_RAW_COST	NUMBER				TC_ETC_LABOR_RAW_COST *****	Active
TC_ETC_LABOR_BRDN_COST	NUMBER				TC_ETC_LABOR_BRDN_COST *****	Active
TC_ETC_EQUIP_RAW_COST	NUMBER				TC_ETC_EQUIP_RAW_COST *****	Active
TC_ETC_EQUIP_BRDN_COST	NUMBER				TC_ETC_EQUIP_BRDN_COST *****	Active
TC_SUP_INV_CMT_RAW_COST	NUMBER				TC_SUP_INV_CMT_RAW_COST *****	Active
TC_SUP_INV_CMT_BRDN_COST	NUMBER				TC_SUP_INV_CMT_BRDN_COST *****	Active
TC_PO_CMT_RAW_COST	NUMBER				TC_PO_CMT_RAW_COST *****	Active
TC_PO_CMT_BRDN_COST	NUMBER				TC_PO_CMT_BRDN_COST *****	Active
TC_PR_CMT_RAW_COST	NUMBER				TC_PR_CMT_RAW_COST *****	Active
TC_PR_CMT_BRDN_COST	NUMBER				TC_PR_CMT_BRDN_COST *****	Active
TC_OTH_CMT_RAW_COST	NUMBER				TC_OTH_CMT_RAW_COST *****	Active
TC_OTH_CMT_BRDN_COST	NUMBER				TC_OTH_CMT_BRDN_COST *****	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	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
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
EFFECTIVE_START_DATE	DATE				Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.	Active
EFFECTIVE_END_DATE	DATE				Date Effective Entity: indicates the date at the end of the date range within which the row is effective.	Active
CMT_TO_QUANTITY	NUMBER				Effort in hours associated with transfer orders.
TC_TO_CMT_RAW_COST	NUMBER				Raw cost associated with transfer orders in transaction currency.
TC_TO_CMT_BRDN_COST	NUMBER				Burdened cost associated with transfer orders in transaction currency.
PC_TO_CMT_RAW_COST	NUMBER				Raw cost associated with transfer orders in project currency.
PC_TO_CMT_BRDN_COST	NUMBER				Burdened cost associated with transfer orders in project currency.
PFC_TO_CMT_RAW_COST	NUMBER				Raw cost associated with transfer orders in project ledger currency.
PFC_TO_CMT_BRDN_COST	NUMBER				Burdened cost associated with transfer orders in project ledger currency.
CMT_RCPT_QUANTITY	NUMBER				Effort in hours associated with receipts.
TC_RCPT_CMT_RAW_COST	NUMBER				Raw cost associated with receipts in transaction currency.
TC_RCPT_CMT_BRDN_COST	NUMBER				Burdened cost associated with receipts in transaction currency.
PC_RCPT_CMT_RAW_COST	NUMBER				Raw cost associated with receipts in project currency.
PC_RCPT_CMT_BRDN_COST	NUMBER				Burdened cost associated with receipts in project currency.
PFC_RCPT_CMT_RAW_COST	NUMBER				Raw cost associated with receipts in project ledger currency.
PFC_RCPT_CMT_BRDN_COST	NUMBER				Burdened cost associated with receipts in project ledger currency.
PFC_ACT_INVOICED	NUMBER				The actual invoiced amount of the project in project ledger currency.
PC_ACT_INVOICED	NUMBER				The actual invoiced amount of the project in project currency.
TC_ACT_INVOICED	NUMBER				The actual invoiced amount of the project in transaction currency.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJO_XBS_ACCUM_F	pjo_wbs_headers	PLAN_VERSION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJO_XBS_ACCUM_F_N1	Non Unique	FUSION_TS_TX_IDX	PROJECT_ID, PLAN_VERSION_ID, PERIOD_TYPE_ID
PJO_XBS_ACCUM_F_N2	Non Unique	FUSION_TS_TX_DATA	PROJECT_ID, PLAN_VERSION_ID, PROJECT_ELEMENT_ID, RBS_ELEMENT_ID
PJO_XBS_ACCUM_F_N3	Non Unique	Default	PLAN_VERSION_ID
PJO_XBS_ACCUM_F_U1	Unique	FUSION_TS_TX_DATA	LINE_ID