QP_MATRIX_RULES_ATTR_GT
This table is a global temporary table which is used by the different Import FBDI processes and will contain the matrix rules rows derived from matrix rules interface table when operation code is UPDATE. This will help quickly compare all the updated columns for a matrix rules row with the current values of the columns in the base table. The data in this table will be deleted on commit.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
QP_MATRIX_RULES_ATTR_GT_PK |
DYNAMIC_MATRIX_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DYNAMIC_MATRIX_RULE_ID | NUMBER | 18 | Yes | Unique ID of the matrix rules copied from the table qp_matrix_rules. | |
| DYNAMIC_MATRIX_ID | NUMBER | 18 | Primary Key of the table qp_matrices and it's a unique number. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| QP_MATRIX_RULES_ATTR_GT_U1 | Unique | DYNAMIC_MATRIX_RULE_ID |