OSS_MRA_MATRIX
Captures matrix metadata for batch flows.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
Name | Columns |
---|---|
OSS_MRA_MATRIX_PK |
FAMILY_CODE, EXECUTION_NUMBER, MATRIX_KEY |
Columns
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
OSS_MRA_MATRIX_PK | Unique | Default | FAMILY_CODE, EXECUTION_NUMBER, MATRIX_KEY |