KRML_CONTEXT_UPDATES

This table is a repository for entity context changes that impact the Reporting Meta Layer, based on the last update date. Population of this table is triggered by changes to the KNTA_PARAMETER_SET_CONTEXTS table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_ENTITIES_NLS

ENTITY_ID

ENTITY_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KNTA_PARAMETER_SETS_NLS

PARAMETER_SET_ID

PARAMETER_SET_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_PK

UNIQUE

1

PARAMETER_SET_CONTEXT_ID

Sequences

This table uses no sequences.