OSS_MRA_MATRIX

Details

Name	Columns
OSS_MRA_MATRIX_PK	FAMILY_CODE, EXECUTION_NUMBER, MATRIX_KEY

Name	Datatype	Length	Precision	Not-null	Comments
FAMILY_CODE	VARCHAR2	30		Yes	Name for service mapping datasources used.
EXECUTION_NUMBER	NUMBER		18	Yes	Unique identifier of the execution.
MATRIX_KEY	NUMBER		18	Yes	Oracle internal use only.
DYNAMIC_MATRIX_CLASS_ID	NUMBER		18		Oracle internal use only.
DYNAMIC_MATRIX_DIMENSION_NAME	VARCHAR2	80			Oracle internal use only.
SOURCE_CODE_NAME	VARCHAR2	100			Dimension source name in matrix setup.
FACT_SM_SOURCE	VARCHAR2	100			Business object mapped to dimension source.
FACT_SM_ENTITY_ATTRIBUTE	VARCHAR2	100			Service mapping entity attribute.
FACT_SM_VO_ATTRIBUTE	VARCHAR2	100			Service mapping view attribute mapped to entity attribute.
FACT_SM_DB_ATTRIBUTE	VARCHAR2	30			Service mapping DB attribute mapped to view attribute.
DIMENSION_DB_ATTRIBUTE	VARCHAR2	30			Attribute in QP_MATRIX_RULES_VL table that stores the value of a matrix rule condition.
DIMENSION_OPERATOR	VARCHAR2	30			Operator used in matrix rule condition.
DIMENSION_DATA_TYPE	VARCHAR2	30			Data type of matrix rule condition.
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_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.

Index	Uniqueness	Tablespace	Columns
OSS_MRA_MATRIX_PK	Unique	Default	FAMILY_CODE, EXECUTION_NUMBER, MATRIX_KEY