KRML_CONTEXT_UPDATES_COPY

This table is a backup repository for entity context changes that impacted the Reporting Meta Layer at the last synchronization. This table is filled with data from KRML_CONTEXT_UPDATES just prior to the next synchronization.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_ENTITIES_NLS	ENTITY_ID	ENTITY_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_PARAMETER_SETS_NLS	PARAMETER_SET_ID	PARAMETER_SET_ID
KNTA_PARAMETER_SET_CONTEXTS	PARAMETER_SET_CONTEXT_ID	PARAMETER_SET_CONTEXT_ID

Column Descriptions

Column Name	Null?	Data Type	Description
PARAMETER_SET_CONTEXT_ID	NOT NULL	NUMBER	Functions as a primary key, linked to PARAMETER_SET_CONTEXT_ID in KNTA_PARAMETER_SET_CONTEXTS table
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
PARAMETER_SET_ID	NOT NULL	NUMBER	Identifies the parameter set that this view context is associated with
ENTITY_ID	NULLABLE	NUMBER	Identifies the entity that this view context is associated with
CONTEXT_VALUE	NULLABLE	VARCHAR2(200)	Identifies the entity context this view context is associated with
VISIBLE_CONTEXT_VALUE	NULLABLE	VARCHAR2(200)	Used to identify the RML_VIEW_NAME_ROOT from the context value
RML_VIEW_NAME_ROOT	NULLABLE	VARCHAR2(20)	Root of the generated Reporting Meta Layer view name. Copied from the RML_VIEW_NAME_ROOT column in the corresponding entity table
OBSOLETE_FLAG	NOT NULL	VARCHAR2(1)	Mark to identify entries which are no longer used

Indexes

Index Name	Index Type	Sequence	Column Name
KRML_CONTEXT_UPDATES_COPY_PK	UNIQUE	1	PARAMETER_SET_CONTEXT_ID

Sequences

This table uses no sequences.