KRML_PARAMETER_SET_FLDS_COPY

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

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
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_FIELD_ID	PARAMETER_SET_FIELD_ID
KNTA_PARAMETER_SETS_NLS	PARAMETER_SET_ID	SOURCE_PARAMETER_SET_ID

Column Descriptions

Column Name	Null?	Data Type	Description
PARAMETER_SET_FIELD_ID	NOT NULL	NUMBER	Functions as primary key, linked to PARAMETER_SET_FIELD_ID in KNTA_PARAMETER_SET_FIELDS 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_CONTEXT_ID	NOT NULL	NUMBER	Foreign key to KNTA_PARAMETER_SET_CONTEXTS
BATCH_NUMBER	NULLABLE	NUMBER	Identifies which "batch" grouping this field belongs to
PARAMETER_COLUMN_NUMBER	NULLABLE	NUMBER	Specifies in which column on this field's parent entity table to store this field's data
PROMPT	NULLABLE	VARCHAR2(100)	Field prompt
PARAMETER_TOKEN	NULLABLE	VARCHAR2(30)	Token name for this field
DESCRIPTION	NULLABLE	VARCHAR2(240)	Field description
PARAMETER_TABLE_NAME	NULLABLE	VARCHAR2(30)	For field group fields, this value is the table where the values are stored.
PARAMETER_VALUE_COL_NAME	NULLABLE	VARCHAR2(30)	For field group fields, this value is the column where the hidden values are stored.
PARAMETER_VIS_VALUE_COL_NAME	NULLABLE	VARCHAR2(30)	For field group fields, this value is the column where the visible values are stored.
SOURCE_PARAMETER_SET_ID	NULLABLE	NUMBER	Parameter set ID of the field, used to determine if a field is a standard request header field, custom request header field, or field group field.

Indexes

Index Name	Index Type	Sequence	Column Name
KRML_PARAMETER_SET_FLDS_CPY_PK	UNIQUE	1	PARAMETER_SET_FIELD_ID

Sequences

This table uses no sequences.