ATK_QB_CONTEXTS_ALL

Details

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

Primary Key

Name	Columns
ATK_QB_CONTEXTS_ALL_B_PK	CONTEXT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONTEXT_ID	NUMBER		18	Yes	Primary key of the table.
APPLICATION_ID	NUMBER		18	Yes	Represents the application to which the context object belongs to.
CONTEXT_NAME	VARCHAR2	240		Yes	Name of the context object. This name is used for fetching queries, fetching the rule results etc.
MULTI_VALUE_FLAG	VARCHAR2	3			Represents whether there is conditional dependency among the results that are to be returned when a rule matches.
MULTI_RULE_RESULT_FLAG	VARCHAR2	3			Represents whether to return the result of first matching rule or the results of all the matching rules
CONTEXT_TYPE_CODE	VARCHAR2	15		Yes	This column is used to identify whether the context object is used for creating the rules or setting up queries. The current values to be assigned are "RULES" and "QUERY"
FLEX_FIELD_NAME	VARCHAR2	240			If one result value depends on another value then we use the DFF. This field represents the name of the DFF.
FLEX_FIELD_APP_ID	NUMBER		18		Represents the application to which the DFF belongs to.
USE_DEFAULT_FLAG	VARCHAR2	3			Determines whether to use the default result if no rule matches.
IS_DEFAULT_REQUIRED_FLAG	VARCHAR2	3			Determines whether the default value is mandatory or not.
CONTEXT_CATEGORY	VARCHAR2	240		Yes	This column is used to prevent the context name clashes.
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.
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
IS_QUERY_USER_NAME_UNIQUE	VARCHAR2	1			Flag to restrict the user to create rules or queries with unique user name under a rule or query group.
UNIQUE_QRY_USER_NAME_REQ_MSG	VARCHAR2	150			Error message raised when creating query or rule with existing user name under a query group or rule group.
IS_QRY_CRITERIA_REQ	VARCHAR2	1			Flag to restrict the user to create rules with atleast one criteria or condition.
QRY_CRITERIA_REQ_MSG	VARCHAR2	150			Error message raised when trying to create query or rule without condition or criteria.
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
atk_qb_contexts_all_tl	atk_qb_contexts_all_b	CONTEXT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ATK_QB_CONTEXTS_ALL_B_PK	Unique	Default	CONTEXT_ID, ORA_SEED_SET1
ATK_QB_CONTEXTS_ALL_B_PK1	Unique	Default	CONTEXT_ID, ORA_SEED_SET2