KRML_SYSTEM_CONTROLS

This table stores internal control sequences used by Reporting Meta Layer.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
SYSTEM_CONTROL_ID	NOT NULL	NUMBER	Unique identifier
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
CONTROL_NAME	NOT NULL	VARCHAR2(50)	Unique name of the control
VALUE	NULLABLE	VARCHAR2(100)	Value of this control

Indexes

Index Name	Index Type	Sequence	Column Name
KRML_SYSTEM_CONTROLS_PK	UNIQUE	1	SYSTEM_CONTROL_ID

Sequences

This table uses no sequences.