QP_MATRIX_DIMENSIONS

Details

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

Primary Key

Name	Columns
QP_MATRIX_DIMENSIONS_INT_PK	MATRIX_INT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MATRIX_INT_ID	NUMBER			Yes	Value that uniquely identifies the matrix dimension in the interface table.
FILTER_COLUMN_ORDER	NUMBER				This column stores the order in which the dimensions needs to be evaluated in case there are filtered dimensions in a given batch.
OPERATION_CODE	VARCHAR2	30			Value that identifies the operation to perform on the matrix dimensions.
SOURCE_ROOT_PARENT_ID	VARCHAR2	240			Value that uniquely identifies the parent entity in the source system. For discount list, it will be the discount list ID.
SOURCE_PARENT_ID	VARCHAR2	240			Value that uniquely identifies the parent for this matrix in the source system. For example, for discount list, it will be the pricing term ID.
SOURCE_MATRIX_ID	VARCHAR2	240			Value that uniquely identifies the matrix in the source system.
DIMENSION_NAME	VARCHAR2	100			Name of the dimension for the matrix.
DIMENSION_TYPE	VARCHAR2	50			Type of the dimension for the matrix. Applicable values are condition or result.
MAP_TO_RULE_COLUMN	VARCHAR2	30			Column in the rules table to which the dimension is mapped.
INTERFACE_STATUS	VARCHAR2	30			Status of the record, such as New, Error, Updated, Imported, and Validated.
LOAD_REQUEST_ID	NUMBER				Unique ID of the Load ESS job used to import into an interface table.
BATCH_NAME	VARCHAR2	50			Identifies the batch to be processed.
SUB_BATCH_NAME	VARCHAR2	80			Identifies the sub batch to be processed.
BATCH_ATTRIBUTE_CHAR1	VARCHAR2	50			Generic column to store information related to batching logic.
BATCH_ATTRIBUTE_CHAR2	VARCHAR2	50			Generic column to store information related to batching logic.
WEIGHT	NUMBER		18		Internally calculated attribute based on the predefined importance of the child records in a pricing batch. This attribute is used to determine weight of the item and helps batching the items so that the weight is distributed equally.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
MATRIX_ID	NUMBER				Number that uniquely identifies the matrix. The application updates this value based on Source Matrix Id and is used internally.
BATCH_ID	NUMBER		18		Value that identifies the pricing batch to process.
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.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
QP_MATRIX_DIMENSIONS_INT_N1	Non Unique	FUSION_TS_TX_IDX	BATCH_ID, BATCH_JOB_ID, SUB_BATCH_NAME, SOURCE_MATRIX_ID, SOURCE_ROOT_PARENT_ID
QP_MATRIX_DIMENSIONS_INT_N2	Non Unique	FUSION_TS_TX_IDX	LOAD_REQUEST_ID, SOURCE_PARENT_ID, SOURCE_ROOT_PARENT_ID
QP_MATRIX_DIMENSIONS_INT_U1	Unique	FUSION_TS_TX_DATA	MATRIX_INT_ID