PJB_CALCULATION_ELEMENTS

This table Stores the calculation element for event revenue and loss accrual transactions. This is a sibling table to Transactions (Events and Expenditure Items).

Details

Schema: FUSION
Object owner: PJB
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
PJB_CALCULATION_ELEMENTS_PK	CALCULATION_ELEMENT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CALCULATION_ELEMENT_ID	NUMBER		18	Yes	Identifier of calculation elements *****
EVENT_TYPE_CODE	VARCHAR2	1			EVENT_TYPE_CODE *****
LINKED_PROJECT_ID	NUMBER		18		LINKED_PROJECT_ID *****
LINKED_TASK_ID	NUMBER		18		LINKED_TASK_ID *****
BILL_PLAN_ID	NUMBER		18		BILL_PLAN_ID *****
CALLING_PROCESS	VARCHAR2	30			CALLING_PROCESS *****
TRANSACTION_EVENT_SOURCE	VARCHAR2	30			TRANSACTION_EVENT_SOURCE *****
CALCULATION_LEVEL_CODE	VARCHAR2	30			CALCULATION_LEVEL_CODE *****
LEDGER_CURRENCY_CODE	VARCHAR2	30			LEDGER_CURRENCY_CODE *****
LEDGER_CURR_ITD_COST	NUMBER				LEDGER_CURR_ITD_COST *****
LEDGER_CURR_BUDGET_COST	NUMBER				LEDGER_CURR_BUDGET_COST *****
CONTRACT_CURR_TOTAL_FUNDING	NUMBER				CONTRACT_CURR_TOTAL_FUNDING *****
CONT_CURR_ITD_EVENT_AMT	NUMBER				CONT_CURR_ITD_EVENT_AMT *****
CONT_CURR_PRIOR_EVENT_AMT	NUMBER				CONT_CURR_PRIOR_EVENT_AMT *****
CONT_CURR_ACTUAL_AMT_CALC	NUMBER				CONT_CURR_ACTUAL_AMT_CALC *****
EVENT_ID	NUMBER		18		Identifier of the event *****
CONTRACT_ID	NUMBER		18		Identifier of the contract *****
CONTRACT_LINE_ID	NUMBER		18		Identifier of the contract line *****
REVENUE_PLAN_ID	NUMBER		18		Identifier of the revenue plan *****
PERCENT_SPENT_CALCULATED	NUMBER				Percent Spent Calculated *****
PERCENT_COMPLETE_CALCULATED	NUMBER				Percent Complete Calculated *****
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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.
CONTRACT_CURR_CODE	VARCHAR2	30			CONTRACT_CURR_CODE *****
CONFIGURATION_ID	NUMBER		18		Unique identifier for a configuration used for creating the automatic event.
CONFIGURATION_ALIAS	VARCHAR2	2000			Audits the configurators as used during automatic event creation.
CONFIGURATION_VALUE	VARCHAR2	2000			Audits the amounts pertaining to each alias of the configurator used for creating the automatic event.
CONFIGURATION_FILTER	VARCHAR2	2000			Audits the configuration source and filter pertaining to each alias at the time of automatic event creation.
ALIAS1	VARCHAR2	80			Alias for first configurator source.
ALIAS1_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS1_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS2	VARCHAR2	80			Alias for second configurator source.
ALIAS2_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS2_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS3	VARCHAR2	80			Alias for third configurator source.
ALIAS3_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS3_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS4	VARCHAR2	80			Alias for fourth configurator source.
ALIAS4_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS4_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS5	VARCHAR2	80			Alias for fifth configurator source.
ALIAS5_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS5_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS6	VARCHAR2	80			Alias for sixth configurator source.
ALIAS6_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS6_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS7	VARCHAR2	80			Alias for seventh configurator source.
ALIAS7_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS7_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS8	VARCHAR2	80			Alias for eighth configurator source.
ALIAS8_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS8_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS9	VARCHAR2	80			Alias for nineth configurator source.
ALIAS9_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS9_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
ALIAS10	VARCHAR2	80			Alias for tenth configurator source.
ALIAS10_ORIG_VALUE	NUMBER				Original Value of Alias used in Orignal Configurator Event Amount.
ALIAS10_LATEST_VALUE	NUMBER				Latest Value of Alias computed during Reversing of Original Event.
TRANSACTION_COUNT	NUMBER				Number of Transactions which contributed to Original Event Amount.
EVENT_LATEST_AMOUNT	NUMBER				Latest Value of Event Amount computed during Reversing of Original Event.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJB_CALCULATION_ELEMENTS	pjb_billing_events	EVENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJB_CALCULATION_ELEMENTS_N1	Non Unique	Default	EVENT_ID
PJB_CALCULATION_ELEMENTS_U1	Unique	Default	CALCULATION_ELEMENT_ID