ATK_QB_QRY_CRITERIA
table for rule criterias defined based on which the Rule's/Query's sqlQuery is created
Details
-
Schema: FUSION
-
Object owner: ATK
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ATK_QB_QRY_CRITERIA_PK |
CRITERIA_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CRITERIA_ID | NUMBER | 18 | Yes | Primary key of this table. | |
| SEQUENCE_NUMBER | NUMBER | 18 | Yes | The criteria of a particular parent have to be evaluated in a particular order. This ordering can be achieved using this sequnce number. | |
| CRITERIA_TYPE | VARCHAR2 | 240 | Yes | A Criteria can be one of the two types 'GROUP', or 'ITEM'. This column represents the type of the criteria. | |
| PARENT_ID | NUMBER | 18 | Yes | Every criteria does have a parent. The parent can be a query or another criteria of type 'GROUP'. This column identifies the parent. | |
| PARENT_TYPE | VARCHAR2 | 240 | Yes | Every criteria does have a parent. The parent can be a query or another criteria of type 'GROUP'. This column identifies the type of the parent. The valid values are QUERY or GROUP. | |
| CONJUNCTION_OPERATOR | VARCHAR2 | 240 | The criteria which are logical expressions are generally sepereated by operators like 'AND', 'OR' etc. This column represents this conjucntion operator. | ||
| LEFT_HAND_EXP_TYPE | VARCHAR2 | 240 | The product teams can have either an expression or an attribute on the left hand side of the expression. This column represents what is present on the left hand side of the criteria. | ||
| OPERATION_NAME | VARCHAR2 | 240 | Defines the operation on Left hand side operands | ||
| LHSLEFT_OPERAND_IDENTIFIER | VARCHAR2 | 480 | The identification number of the left operand in the left hand side expression. | ||
| LHSLEFT_OPERAND_TYPE | VARCHAR2 | 240 | The data type of the left operand in the left hand side expression. | ||
| LHSLEFT_OPERAND_VS_FLAG | VARCHAR2 | 3 | This field is used to determine whether the left hand operand is associated to a valueset of not. If the value is 'Y' then the operand is associated to a valueset. If the value is 'N' the operand is not assocaited to a valueset. | ||
| LHSRGHT_OPERAND_IDENTIFIER | VARCHAR2 | 480 | The identification number of the right operand in the left hand side expression. | ||
| OPERATOR_CODE | VARCHAR2 | 240 | Represents the operator used in the expression. | ||
| RHS_OPERAND_TYPE | VARCHAR2 | 240 | The right hand side of the expression can be either an 'OPERAND' or a 'LITERAL'. This column is used to identify the type of the right hand side of the expression. | ||
| RHS_LITERAL_VALUE | VARCHAR2 | 2000 | The literal value used in the right hand side of the expression. | ||
| RHS_DATE_LITERAL_VALUE | DATE | This holds a literal date value on the right hand side of the criteria. | |||
| RHS_VALUESET_LITERAL_VALUE | VARCHAR2 | 480 | This column stores the literal value that the user has selected from the value set associated with the LHS left operand. | ||
| RHS_VALUESET_NUMBER_VALUE | NUMBER | This column stores the value that the user has selected from the value set of type number associated with the LHS left operand. | |||
| RHS_VALUESET_DATE_VALUE | DATE | This column stores the value that the user has selected from the value set of type date associated with the LHS left operand. | |||
| RHS_NUMBER_LITERAL_VALUE | NUMBER | This holds a literal number value on the right hand side of the criteria. | |||
| RHS_OPERAND_IDENTIFIER | VARCHAR2 | 480 | The identification number of the operand in the right hand side expression. | ||
| CASE_SENSITIVE_FLAG | VARCHAR2 | 4 | This column is used only when we are dealing with the operands of STRING type. If the value of this column is 'Y' then the operation should not take case into consideration. Otherwise the comparision should be case sensitive. | ||
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ATK_QB_QRY_CRITERIA_PK | Unique | Default | CRITERIA_ID |