EGO_RL_RULE_SETS

Details

Schema: FUSION
Object owner: EGO
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
EGO_RL_RULE_SETS_B_PK	RULE_SET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_SET_ID	NUMBER		18	Yes	The primary key of the table. This is also the surrogate key for this entity.
RULES_IMPLEMENTATION	VARCHAR2	20		Yes	Specifies the application the rule set should be executed for.
MODULE_ID	VARCHAR2	32			Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
IS_DRAFT	VARCHAR2	2			Indicates whether the rule set is a draft rule set.
RULE_SET_NAME	VARCHAR2	50		Yes	Specifies the internal name of the rule set.
RULE_SET_TYPE	VARCHAR2	50		Yes	Type of the rule set, for example assignment, validation or assignment and validation(composite).
COMPOSITE	VARCHAR2	50		Yes	Flag to indicate whether this rule set includes whether validation and assignment rules.
ASSOCIATION_CONTEXT	VARCHAR2	30		Yes	An optional context that will determine which association types are allowed for the rule set.
ASSOCIATION_TYPE	VARCHAR2	10			To which entity the rule set is associated with, for example Structure Type, Item Class, Attribute Group, Change Type etc.
ASSOCIATION_PK1	VARCHAR2	30			PK1_VALUE of the entity to which the rule set is associated with. For example, item class id, structure type id etc.
ASSOCIATION_PK2	VARCHAR2	80			PK2_VALUE of the associated entity, for example attribute group name in item attribute groups.
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.
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.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ego_rl_rule_set_bus_ents	ego_rl_rule_sets_b	RULE_SET_ID
ego_rl_rule_sets_tl	ego_rl_rule_sets_b	RULE_SET_ID
ego_rl_user_rules_b	ego_rl_rule_sets_b	RULE_SET_ID
ego_entity_auto_gen_metadata	ego_rl_rule_sets_b	AUTO_GEN_RULE_SET_ID
ego_rl_blend_rule_set_assocs	ego_rl_rule_sets_b	RULE_SET_ID
ego_rl_rule_set_assig	ego_rl_rule_sets_b	RULE_SET_ID
ego_rl_inc_rule_sets	ego_rl_rule_sets_b	RULE_SET_ID
ego_rl_inc_rule_sets	ego_rl_rule_sets_b	INCLUDED_RULE_SET_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGO_RL_RULE_SETS_B_N1	Non Unique	Default	COMPOSITE
EGO_RL_RULE_SETS_B_N2	Non Unique	Default	RULE_SET_TYPE, ASSOCIATION_TYPE
EGO_RL_RULE_SETS_B_U1	Unique	Default	RULE_SET_ID, ORA_SEED_SET1
EGO_RL_RULE_SETS_B_U11	Unique	Default	RULE_SET_ID, ORA_SEED_SET2