CZ_RW_EXPRESSION_NODES
This table stores parsed rule data in the form of expression trees while converting EBS and Fusion rules to redwood.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CZ_RW_EXPRESSION_NODES_PK |
EXPR_NODE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXPR_NODE_ID | NUMBER | 18 | Yes | System generated unique identifier of the rule expression node. | |
| 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. | |
| RULE_ID | NUMBER | 18 | Yes | Identifier of the rule for which this expression node belongs to. | |
| NODE_PATH | CLOB | For expression nodes that reference structure nodes or attributes, this column contains the reference path. | |||
| PARENT_EXPR_NODE_ID | NUMBER | 18 | Identifier of the parent expression node. | ||
| DELETED_FLAG | NUMBER | 18 | Yes | This flag indicates the logical deletion of the row. The Non-Zero value represents deleted state and 0 represents not-deleted state. A user controlled background purge process will actually delete the orphaned rows with the Non-Zero flag value. | |
| EXPR_TYPE | VARCHAR2 | 30 | Yes | Primary type of this expression node: operator, literal, node, property, punctuation, systemproperty, constant, argument, template, forall, iterator, whereclause, compatible, operatorbyname, foralldistinct, nodebyname, eventargument. | |
| TEMPLATE_CODE | VARCHAR2 | 48 | Exact function of this expression node when applicable, when not null FK to CZ_RULE_TEMPLATES.TEMPLATE_CODE. | ||
| SEQ_NBR | NUMBER | 9 | Yes | Provides an ordering among associated records. | |
| DATA_VALUE | VARCHAR2 | 4000 | Holds a string value for this node when expression node is of a literal-value type. | ||
| DATA_NUM_VALUE | NUMBER | Holds a numeric value for this node when expression node is of a literal-value type. | |||
| DATA_TYPE | VARCHAR2 | 48 | Specifies data type of the expression node value when applicable. FK to CZ_SIGNATURES.SIGNATURE_CODE. | ||
| PARAM_INDEX | NUMBER | 9 | Denormalized argument_index from the template parameter being used in a template application. | ||
| ARGUMENT_INDEX | NUMBER | 9 | Stores the argument index when expr_type = argument in a template definition. | ||
| ARGUMENT_NAME | VARCHAR2 | 255 | Stores the name of the argument when expr_type = argument in a template definition or a ForAll construct. | ||
| PARAM_SIGNATURE_CODE | VARCHAR2 | 48 | Semantic extension: stores signature info of the java argument being used in an event binding. | ||
| ARGUMENT_SIGNATURE_CODE | VARCHAR2 | 48 | Semantic extension: stores event-specific argument signature info when expr_type = eventargument in an event binding. | ||
| UDA_ID | VARCHAR2 | 128 | Associates this record with a User Defined Attribute. | ||
| TRANS_ATTR_ID | NUMBER | 18 | Associates this record with a Transactional Item Attribute. | ||
| SUPPL_ATTR_ID | NUMBER | 18 | Associates this record with a Supplemental Attribute. | ||
| SOURCE_OFFSET | NUMBER | 9 | For a Statement rule participant, stores the starting location in the text for this node. | ||
| SOURCE_LENGTH | NUMBER | 9 | For a Statement rule participant, stores length of text representing this node. | ||
| DISPLAY_NODE_DEPTH | NUMBER | 9 | If expr_type = node, this field specifies the depth of the compound reference from which the reference path was created; in 'unparse'/display, that many parent nodes must be displayed. | ||
| EVENT_EXECUTION_SCOPE | NUMBER | 9 | In case rule_type is EVENT_BINDING, this is the execution scope for this event binding: 1 = SCOPE_GLOBAL 2 = SCOPE_MODEL_NODE_SUBTREE 4 = SCOPE_MODEL_NODE_ONLY. | ||
| CX_CLASS_NAME | VARCHAR2 | 1000 | Fully qualified configurator extension class name. | ||
| CX_METHOD_NAME | VARCHAR2 | 1000 | Configurator extension method name. | ||
| JAVA_DATA_TYPE | VARCHAR2 | 1000 | Java data type to which the data type of the expression node maps. | ||
| RELATIVE_NODE_PATH | VARCHAR2 | 1000 | Model node ID path relative to the base node, used for Configurator extensions. | ||
| NODE_NAME_PATH | CLOB | Name path that uniquely identifies a model node or an attribute to which the expression node is bound. This is used only in error reporting for a Configurator extension rule as its value can become stale when model changes. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CZ_RW_EXPRESSION_NODES | cz_rw_conversion_rules_int | RULE_ID |
| CZ_RW_EXPRESSION_NODES | cz_rule_templates | TEMPLATE_CODE |
| CZ_RW_EXPRESSION_NODES | cz_signatures | DATA_TYPE |
| CZ_RW_EXPRESSION_NODES | cz_signatures | PARAM_SIGNATURE_CODE |
| CZ_RW_EXPRESSION_NODES | cz_signatures | ARGUMENT_SIGNATURE_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_RW_EXPRESSION_NODES_N1 | Non Unique | Default | RULE_ID |
| CZ_RW_EXPRESSION_NODES_U1 | Unique | Default | EXPR_NODE_ID |