QP_MATRIX_DERIVED_VOQUERY

This table contains the query derived from the matrix dimensions belonging to View object query domain used during Matrix FBDI. This is populated in java and used for matrix rule validation in PLSQL.

Details

• Schema: FUSION

• Object owner: QP

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
QP_MATRIX_DERIVED_VOQUERY_PK	MATRIX_DERIVED_VOQUERY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MATRIX_DERIVED_VOQUERY_ID	NUMBER		18	Yes	Primary Key of the table qp_matrix_derived_voquery and its a unique number.
DIMENSION_ID	NUMBER		18		Value that uniquely identifies the dimension. It is mapped to dynamic_matrix_dimension_id of the table qp_matrix_dimensions_b.
VOQ_QUERY	CLOB				This columns holds the query that is derived from the dimension with domain type as VIEW_OBJECT_QUERY.
BATCH_ID	NUMBER		18		Value that identifies the pricing batch to process.
SUB_BATCH_NAME	VARCHAR2	50			Identifies the sub batch to be processed.
BATCH_JOB_ID	NUMBER		18		Value that identifies the records in the batch that belong to the current run.This is the request id of the parent ESS job.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated 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.

Indexes

Index	Uniqueness	Tablespace	Columns
QP_MATRIX_DERIVED_VOQUERY_U1	Unique	FUSION_TS_TX_IDX	MATRIX_DERIVED_VOQUERY_ID