QP_MATRIX_RULES
This Dynamic Matrix table contains the Dynamic Matrix Rule.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_MATRIX_RULES_PK |
DYNAMIC_MATRIX_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DYNAMIC_MATRIX_RULE_ID | NUMBER | 18 | Yes | Primary Key of the table qp_matrix_rules and it's a unique number. | |
| DYNAMIC_MATRIX_ID | NUMBER | 18 | Yes | Primary Key of the table qp_matrices and it's a unique number. | |
| DYNAMIC_MTX_RULE_GUID | VARCHAR2 | 64 | Yes | This is a unique identifier generated for the matrix rules (GUID). | |
| RULE_START_DATE | TIMESTAMP | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | |||
| RULE_END_DATE | TIMESTAMP | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | |||
| VALUE_STRING1 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING2 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING3 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING4 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING5 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING6 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING7 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING8 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING9 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING10 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING11 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING12 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING13 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING14 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING15 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING16 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING17 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING18 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING19 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING20 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING21 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING22 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING23 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING24 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_STRING25 | VARCHAR2 | 100 | Conditional Dimension String value. | ||
| VALUE_NUMBER1 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER2 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER3 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER4 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER5 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER6 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER7 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER8 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER9 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER10 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER11 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER12 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER13 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER14 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER15 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER16 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER17 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER18 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER19 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER20 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER21 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER22 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER23 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER24 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_NUMBER25 | NUMBER | Conditional Dimension Numeric value. | |||
| VALUE_DATE1 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE2 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE3 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE4 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE5 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE6 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE7 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE8 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE9 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE10 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE11 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE12 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE13 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE14 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE15 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE16 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE17 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE18 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE19 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE20 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE21 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE22 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE23 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE24 | DATE | Conditional Dimension Date value. | |||
| VALUE_DATE25 | DATE | Conditional Dimension Date value. | |||
| VALUE_TIMESTAMP1 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP2 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP3 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP4 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP5 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP6 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP7 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP8 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP9 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP10 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP11 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP12 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP13 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP14 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP15 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP16 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP17 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP18 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP19 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP20 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP21 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP22 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP23 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP24 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| VALUE_TIMESTAMP25 | TIMESTAMP | Conditional Dimension Timestamp value. | |||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 240 | Matrix Rule Unique identifier in the source system. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| QP_MATRIX_RULES | qp_matrices | DYNAMIC_MATRIX_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_MATRIX_RULES_FK1 | Non Unique | FUSION_TS_TX_IDX | DYNAMIC_MATRIX_ID |
| QP_MATRIX_RULES_PK | Unique | FUSION_TS_TX_IDX | DYNAMIC_MATRIX_RULE_ID |
| QP_MATRIX_RULES_U1 | Unique | FUSION_TS_TX_IDX | DYNAMIC_MTX_RULE_GUID |