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 |