EGO_RL_RULE_SUB_EXPRESSIONS

Stores groovy scripts for sub expressions of rules that are too large for a single groovy script. SUB_EXPRESSION_ID is Surrogate Key for this entity. RULE_ID is a foreign key to EGO_RL_USER_RULES_B

Details

• Schema: FUSION

• Object owner: EGO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
EGO_RL_RULE_SUB_EXPRESSION_PK	SUB_EXPRESSION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SUB_EXPRESSION_ID	NUMBER		18	Yes	The primary key of the table. This is also the surrogate key for this entity.
RULE_ID	NUMBER		18		Rule these sub expressions are for. Foreign Key to EGO_RL_USER_RULES_B
SEQUENCE	NUMBER		18	Yes	Decides execution order in context of other sub expressions for this rule.
TYPE	VARCHAR2	20		Yes	Whether this sub expression corresponds to an If or Then expression in the rule.
GROOVY_SCRIPT_1	CLOB				Groovy script for this sub expression
GROOVY_BYTES_1	BLOB				Compiled groovy script associated with the rule.
GROOVY_SCRIPT_2	CLOB				The secondary groovy script for this sub expression if it also has a Return Value expression.
GROOVY_BYTES_2	BLOB				The compiled secondary groovy script for this sub expression if it also has a Return Value expression.
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.
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_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
EGO_RL_RULE_SUB_EXPRESSIONS	ego_rl_user_rules_b	RULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGO_RL_RULE_SUB_EXPRESSIONS_N1	Non Unique	Default	RULE_ID
EGO_RL_RULE_SUB_EXPRESSIONS_U1	Unique	Default	SUB_EXPRESSION_ID