EGO_RL_RULE_ATT_USAGES

This table stores information about the attribute usages in a rule. ATTR_USAGE_ID is a Surrogate Key for this entity. GROUP_USAGE_ID is a foreign key to EGO_RL_RULE_ATT_GROUPS and ATTR_NAME is the attribute used.

Details

• Schema: FUSION

• Object owner: EGO

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
EGO_RL_RULE_ATT_USAGES_PK	ATTR_USAGE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ATTR_USAGE_ID	NUMBER		18	Yes	The primary key of the table. This is also the surrogate key for this entity.
GROUP_USAGE_ID	NUMBER		18	Yes	Group Usage information for the attribute usage. Foreign Key to EGO_RL_RULE_ATT_GROUPS.
ATTR_NAME	VARCHAR2	30		Yes	The internal name of the attribute used in the rule.
VO_ATTR_NAME	VARCHAR2	40			The name of the VO attribute used to access this attribute.
CONTROL_LEVEL	VARCHAR2	1			Whether the attribute is controlled at the master or child organization level.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
EGO_RL_RULE_ATT_USAGES	ego_rl_rule_att_groups	GROUP_USAGE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGO_RL_RULE_ATT_USAGES_N1	Non Unique	Default	GROUP_USAGE_ID
EGO_RL_RULE_ATT_USAGES_U1	Unique	Default	ATTR_USAGE_ID