CN_EST_CMP_MSR_RESULTS_ALL_GT

Temporary table to store calculated measure results

Details

Schema: FUSION
Object owner: CN
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
CN_EST_CMP_MSR_RESULTS_AL_PK	MSR_RESULT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
MSR_RESULT_ID	NUMBER			Yes	MSR_RESULT_ID	Active
TRANSACTION_ID	NUMBER				TRANSACTION_ID	Active
TRANSACTION_NAME	VARCHAR2	240			TRANSACTION_NAME	Active
TRANSACTION_LINE_NUMBER	NUMBER		18		TRANSACTION_LINE_NUMBER	Active
TRANSACTION_SUB_LINE_NUMBER	NUMBER		18		TRANSACTION_SUB_LINE_NUMBER	Active
COMP_PLAN_ID	NUMBER				COMP_PLAN_ID	Active
SCENARIO_ID	NUMBER		18		SCENARIO_ID	Active
MEASURE_TYPE	VARCHAR2	30			MEASURE_TYPE	Active
ELIGIBLE_CAT_ID	NUMBER		18		ELIGIBLE_CAT_ID	Active
OBJECT_STATUS	VARCHAR2	30			Object Status
ADJUSTMENT_STATUS	VARCHAR2	30			ADJUSTMENT_STATUS	Active
ADJUSTMENT_COMMENTS	VARCHAR2	1000			ADJUSTMENT_COMMENTS	Active
CALC_TO_FUNC_CURR_CNVRT	NUMBER				CALC_TO_FUNC_CURR_CNVRT	Active
CALC_TO_HOME_CURR_CNVRT	NUMBER				CALC_TO_HOME_CURR_CNVRT	Active
CALC_TO_SOURCE_CURR_CNVRT	NUMBER				CALC_TO_SOURCE_CURR_CNVRT	Active
CHANGED_CREDIT_FLAG	VARCHAR2	1			CHANGED_CREDIT_FLAG	Active
COLLECTION_STATUS	VARCHAR2	30			COLLECTION_STATUS	Active
CALC_CURRENCY_CODE	VARCHAR2	15			CALC_CURRENCY_CODE	Active
CREATED_DURING	VARCHAR2	30			CREATED_DURING	Active
CREDIT_AMT_SOURCE_CURR	NUMBER				CREDIT_AMT_SOURCE_CURR	Active
CREDIT_AMT_CALC_CURR	NUMBER				CREDIT_AMT_CALC_CURR	Active
CREDIT_AMT_FUNC_CURR	NUMBER				CREDIT_AMT_FUNC_CURR	Active
CREDIT_AMT_HOME_CURR	NUMBER				CREDIT_AMT_HOME_CURR	Active
HOME_CURRENCY_CODE	VARCHAR2	15			HOME_CURRENCY_CODE	Active
PROCESS_CODE	VARCHAR2	30			PROCESS_CODE	Active
REASON_CODE	VARCHAR2	30			REASON_CODE	Active
REVENUE_TYPE	VARCHAR2	30			Possible values : Revenue, Non revenue, a custom revenue type	Active
ROLE_ID	NUMBER		18		ROLE_ID	Active
ROLLUP_DATE	DATE				ROLLUP_DATE	Active
ROLLUP_LEVEL	NUMBER		18		ROLLUP_LEVEL	Active
SOURCE_CURRENCY_CODE	VARCHAR2	15			SOURCE_CURRENCY_CODE	Active
SOURCE_EVENT_DATE	DATE				SOURCE_EVENT_DATE	Active
SOURCE_TO_CALC_CURR_CNVRT	NUMBER				SOURCE_TO_CALC_CURR_CNVRT	Active
SOURCE_TO_FUNC_CURR_CNVRT	NUMBER				SOURCE_TO_FUNC_CURR_CNVRT	Active
SOURCE_TO_HOME_CURR_CNVRT	NUMBER				SOURCE_TO_HOME_CURR_CNVRT	Active
SOURCE_TRX_NUMBER	VARCHAR2	30			SOURCE_TRX_NUMBER	Active
SOURCE_TYPE	VARCHAR2	30			SOURCE_TYPE	Active
SPLIT_PCT	NUMBER				SPLIT_PCT	Active
CLSFN_RULE_ID	NUMBER		18		Classification Rule Id
TRANSACTION_AMT_CALC_CURR	NUMBER				TRANSACTION_AMT_CALC_CURR	Active
TRANSACTION_AMT_FUNC_CURR	NUMBER				TRANSACTION_AMT_FUNC_CURR	Active
TRANSACTION_AMT_HOME_CURR	NUMBER				TRANSACTION_AMT_HOME_CURR	Active
TRANSACTION_AMT_SOURCE_CURR	NUMBER				TRANSACTION_AMT_SOURCE_CURR	Active
TRANSACTION_QTY	NUMBER				TRANSACTION_QTY	Active
TRANSACTION_TYPE	VARCHAR2	30			TRANSACTION_TYPE	Active
SOURCE_ORG_ID	NUMBER		18		SOURCE_ORG_ID	Active
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.	Active
COMM_AMT_CALC_CURR	NUMBER				COMM_AMT_CALC_CURR	Active
COMM_AMT_FUNC_CURR	NUMBER				COMM_AMT_FUNC_CURR	Active
COMM_AMT_HOME_CURR	NUMBER				COMM_AMT_HOME_CURR	Active
COMMISSION_VALUE	NUMBER				COMMISSION_VALUE	Active
CREDIT_FACTOR	NUMBER				CREDIT_FACTOR	Active
EARNING_FACTOR	NUMBER				EARNING_FACTOR	Active
EARNING_ID	NUMBER		18		EARNING_ID	Active
EARNING_TYPE	VARCHAR2	30			EARNING_TYPE	Active
EARNING_TYPE_ID	NUMBER		18		EARNING_TYPE_ID	Active
FORMULA_ID	NUMBER				FORMULA_ID	Active
EVENT_FACTOR_VALUE	NUMBER				EVENT_FACTOR_VALUE	Active
FORMULA_WEIGHT	NUMBER				FORMULA_WEIGHT	Active
ERROR_REASON	VARCHAR2	150			ERROR_REASON	Active
GRP_BY_MEASURE_RESULT_ID	NUMBER		18		GRP_BY_MEASURE_RESULT_ID	Active
TIER_SPLITS	NUMBER		18		TIER_SPLITS	Active
FORMULA_ECAT_ID	NUMBER		18		FORMULA_ECAT_ID	Active
RATE_TABLE_VALUE_ID	NUMBER		18		RATE_TABLE_VALUE_ID	Active
SOURCE_EVENT_PERIOD_ID	NUMBER		18		SOURCE_EVENT_PERIOD_ID	Active
INPUT_ACHIEVED	NUMBER				INPUT_ACHIEVED	Active
OUTPUT_ACHIEVED	NUMBER				OUTPUT_ACHIEVED	Active
SOURCE_MEASURE_RESULT_ID	NUMBER		18		SOURCE_MEASURE_RESULT_ID	Active
PAY_PERIOD_ID	NUMBER				PAY_PERIOD_ID	Active
PENDING_DATE	DATE				PENDING_DATE	Active
PENDING_STATUS	VARCHAR2	30			PENDING_STATUS	Active
PLAN_COMPONENT_ID	NUMBER				PLAN_COMPONENT_ID	Active
SRP_COMP_PLAN_ID	NUMBER		18		SRP_COMP_PLAN_ID	Active
CREDIT_ID	NUMBER		18		CREDIT_ID	Active
PARTICIPANT_ID	NUMBER		18		Participant Id
CREDITED_PARTICIPANT_ID	NUMBER		18		CREDITED_PARTICIPANT_ID	Active
CUSTOMER_ID	NUMBER				Customer Identifier
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_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update 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
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.
TRX_ATTRIBUTE1	VARCHAR2	240			TRX_ATTRIBUTE1	Active
TRX_ATTRIBUTE2	VARCHAR2	240			TRX_ATTRIBUTE2	Active
TRX_ATTRIBUTE3	VARCHAR2	240			TRX_ATTRIBUTE3	Active
TRX_ATTRIBUTE4	VARCHAR2	240			TRX_ATTRIBUTE4	Active
TRX_ATTRIBUTE5	VARCHAR2	240			TRX_ATTRIBUTE5	Active
TRX_ATTRIBUTE6	VARCHAR2	240			TRX_ATTRIBUTE6	Active
TRX_ATTRIBUTE7	VARCHAR2	240			TRX_ATTRIBUTE7	Active
TRX_ATTRIBUTE8	VARCHAR2	240			TRX_ATTRIBUTE8	Active
TRX_ATTRIBUTE9	VARCHAR2	240			TRX_ATTRIBUTE9	Active
TRX_ATTRIBUTE10	VARCHAR2	240			TRX_ATTRIBUTE10	Active
TRX_ATTRIBUTE11	VARCHAR2	240			TRX_ATTRIBUTE11	Active
TRX_ATTRIBUTE12	VARCHAR2	240			TRX_ATTRIBUTE12	Active
TRX_ATTRIBUTE13	VARCHAR2	240			TRX_ATTRIBUTE13	Active
TRX_ATTRIBUTE14	VARCHAR2	240			TRX_ATTRIBUTE14	Active
TRX_ATTRIBUTE15	VARCHAR2	240			TRX_ATTRIBUTE15	Active
TRX_ATTRIBUTE_NUMBER1	NUMBER				TRX_ATTRIBUTE_NUMBER1	Active
TRX_ATTRIBUTE_NUMBER2	NUMBER				TRX_ATTRIBUTE_NUMBER2	Active
TRX_ATTRIBUTE_NUMBER3	NUMBER				TRX_ATTRIBUTE_NUMBER3	Active
TRX_ATTRIBUTE_NUMBER4	NUMBER				TRX_ATTRIBUTE_NUMBER4	Active
TRX_ATTRIBUTE_NUMBER5	NUMBER				TRX_ATTRIBUTE_NUMBER5	Active
TRX_ATTRIBUTE_NUMBER6	NUMBER				TRX_ATTRIBUTE_NUMBER6	Active
TRX_ATTRIBUTE_NUMBER7	NUMBER				TRX_ATTRIBUTE_NUMBER7	Active
TRX_ATTRIBUTE_NUMBER8	NUMBER				TRX_ATTRIBUTE_NUMBER8	Active
TRX_ATTRIBUTE_NUMBER9	NUMBER				TRX_ATTRIBUTE_NUMBER9	Active
TRX_ATTRIBUTE_NUMBER10	NUMBER				TRX_ATTRIBUTE_NUMBER10	Active
TRX_ATTRIBUTE_NUMBER11	NUMBER				TRX_ATTRIBUTE_NUMBER11	Active
TRX_ATTRIBUTE_NUMBER12	NUMBER				TRX_ATTRIBUTE_NUMBER12	Active
TRX_ATTRIBUTE_NUMBER13	NUMBER				TRX_ATTRIBUTE_NUMBER13	Active
TRX_ATTRIBUTE_NUMBER14	NUMBER				TRX_ATTRIBUTE_NUMBER14	Active
TRX_ATTRIBUTE_NUMBER15	NUMBER				TRX_ATTRIBUTE_NUMBER15	Active
TRX_ATTRIBUTE_NUMBER16	NUMBER				TRX_ATTRIBUTE_NUMBER16	Active
TRX_ATTRIBUTE_NUMBER17	NUMBER				TRX_ATTRIBUTE_NUMBER17	Active
TRX_ATTRIBUTE_NUMBER18	NUMBER				TRX_ATTRIBUTE_NUMBER18	Active
TRX_ATTRIBUTE_NUMBER19	NUMBER				TRX_ATTRIBUTE_NUMBER19	Active
TRX_ATTRIBUTE_NUMBER20	NUMBER				TRX_ATTRIBUTE_NUMBER20	Active
TRX_ATTRIBUTE_NUMBER21	NUMBER				TRX_ATTRIBUTE_NUMBER21	Active
TRX_ATTRIBUTE_NUMBER22	NUMBER				TRX_ATTRIBUTE_NUMBER22	Active
TRX_ATTRIBUTE_NUMBER23	NUMBER				TRX_ATTRIBUTE_NUMBER23	Active
TRX_ATTRIBUTE_NUMBER24	NUMBER				TRX_ATTRIBUTE_NUMBER24	Active
TRX_ATTRIBUTE_NUMBER25	NUMBER				TRX_ATTRIBUTE_NUMBER25	Active
TRX_ATTRIBUTE_NUMBER26	NUMBER				TRX_ATTRIBUTE_NUMBER26	Active
TRX_ATTRIBUTE_NUMBER27	NUMBER				TRX_ATTRIBUTE_NUMBER27	Active
TRX_ATTRIBUTE_NUMBER28	NUMBER				TRX_ATTRIBUTE_NUMBER28	Active
TRX_ATTRIBUTE_NUMBER29	NUMBER				TRX_ATTRIBUTE_NUMBER29	Active
TRX_ATTRIBUTE_NUMBER30	NUMBER				TRX_ATTRIBUTE_NUMBER30	Active
TRX_ATTRIBUTE_NUMBER31	NUMBER				TRX_ATTRIBUTE_NUMBER31	Active
TRX_ATTRIBUTE_NUMBER32	NUMBER				TRX_ATTRIBUTE_NUMBER32	Active
TRX_ATTRIBUTE_NUMBER33	NUMBER				TRX_ATTRIBUTE_NUMBER33	Active
TRX_ATTRIBUTE_NUMBER34	NUMBER				TRX_ATTRIBUTE_NUMBER34	Active
TRX_ATTRIBUTE_NUMBER35	NUMBER				TRX_ATTRIBUTE_NUMBER35	Active
TRX_ATTRIBUTE_NUMBER36	NUMBER				TRX_ATTRIBUTE_NUMBER36	Active
TRX_ATTRIBUTE_NUMBER37	NUMBER				TRX_ATTRIBUTE_NUMBER37	Active
TRX_ATTRIBUTE_NUMBER38	NUMBER				TRX_ATTRIBUTE_NUMBER38	Active
TRX_ATTRIBUTE_NUMBER39	NUMBER				TRX_ATTRIBUTE_NUMBER39	Active
TRX_ATTRIBUTE_NUMBER40	NUMBER				TRX_ATTRIBUTE_NUMBER40	Active
TRX_ATTRIBUTE_NUMBER41	NUMBER				TRX_ATTRIBUTE_NUMBER41	Active
TRX_ATTRIBUTE_NUMBER42	NUMBER				TRX_ATTRIBUTE_NUMBER42	Active
TRX_ATTRIBUTE_NUMBER43	NUMBER				TRX_ATTRIBUTE_NUMBER43	Active
TRX_ATTRIBUTE_NUMBER44	NUMBER				TRX_ATTRIBUTE_NUMBER44	Active
TRX_ATTRIBUTE_NUMBER45	NUMBER				TRX_ATTRIBUTE_NUMBER45	Active
TRX_ATTRIBUTE_NUMBER46	NUMBER				TRX_ATTRIBUTE_NUMBER46	Active
TRX_ATTRIBUTE_NUMBER47	NUMBER				TRX_ATTRIBUTE_NUMBER47	Active
TRX_ATTRIBUTE_NUMBER48	NUMBER				TRX_ATTRIBUTE_NUMBER48	Active
TRX_ATTRIBUTE_NUMBER49	NUMBER				TRX_ATTRIBUTE_NUMBER49	Active
TRX_ATTRIBUTE_NUMBER50	NUMBER				TRX_ATTRIBUTE_NUMBER50	Active
INVENTORY_ITEM_ID	NUMBER				This column represents the Product Identifier

Indexes

Index	Uniqueness	Columns
CN_EST_CMP_MSR_RSLTS_GT_U1	Unique	MSR_RESULT_ID