KNTA_PARAM_SET_FIELDS

This table stores information that connects the parameters set and the fields according to the relevant entity type which is described by the column PARAMETER_SET_CONTEXT_ID.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_ENTITIES_NLS	ENTITY_ID	FIELD_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KRML_CONTEXT_UPDATES	PARAMETER_SET_CONTEXT_ID	PARAMETER_SET_CONTEXT_ID
KRML_CONTEXT_UPDATES_COPY	PARAMETER_SET_CONTEXT_ID	PARAMETER_SET_CONTEXT_ID
KNTA_PARAMETER_SET_CONTEXTS	PARAMETER_SET_CONTEXT_ID	PARAMETER_SET_CONTEXT_ID
KNTA_VALIDATIONS_NLS	VALIDATION_ID	SEARCH_VALIDATION_ID
KNTA_SECTIONS_NLS	SECTION_ID	SECTION_ID
KNTA_PARAM_SET_FIELDS_NLS	PARAMETER_SET_FIELD_ID	SOURCE_PARAMETER_SET_ID
KNTA_VALIDATIONS_NLS	VALIDATION_ID	VALIDATION_ID
KNTA_VALIDATION_PROFILES_NLS	VALIDATION_PROFILE_ID	VALIDATION_PROFILE_ID

Column Descriptions

Column Name	Null?	Data Type	Description
ADVANCED_DEF_PROPERTY
PARAMETER_SET_FIELD_ID	NOT NULL	NUMBER	System-generated 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
PARAMETER_SET_CONTEXT_ID	NOT NULL	NUMBER
FIELD_ID	NULLABLE	NUMBER
PROMPT	NOT NULL	VARCHAR2(100)
DESCRIPTION	NULLABLE	VARCHAR2(400)
PARAMETER_TOKEN	NOT NULL	VARCHAR2(30)
PARAMETER_COLUMN_NUMBER	NULLABLE	NUMBER
PARAMETER_TABLE_NAME	NULLABLE	VARCHAR2(30)
PARAMETER_VALUE_COL_NAME	NULLABLE	VARCHAR2(30)
PARAMETER_VIS_VALUE_COL_NAME	NULLABLE	VARCHAR2(30)
VALIDATION_ID	NOT NULL	NUMBER
DEFAULT_TYPE	NULLABLE	NUMBER
VISIBLE_DEFAULT_CONST_VALUE	NULLABLE	VARCHAR2(4000)
DEFAULT_PARAMETER_TOKEN	NULLABLE	VARCHAR2(30)
PRODUCT_SCOPE_CODE	NOT NULL	VARCHAR2(40)
SECTION_ID	NULLABLE	NUMBER
COLUMN_NUMBER	NULLABLE	NUMBER
ROW_NUMBER	NULLABLE	NUMBER
GRID_HEIGHT	NULLABLE	NUMBER
GRID_WIDTH	NULLABLE	NUMBER
COMPONENT_LINES	NULLABLE	NUMBER
DISPLAY_FLAG	NOT NULL	VARCHAR2(1)
DISPLAY_ONLY_FLAG	NOT NULL	VARCHAR2(1)
UPDATEABLE_FLAG	NOT NULL	VARCHAR2(1)
REQUIRED_FLAG	NOT NULL	VARCHAR2(1)
TRANS_HISTORY_FLAG	NOT NULL	VARCHAR2(1)
NOTES_HISTORY_FLAG	NOT NULL	VARCHAR2(1)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
WORKBENCH_ONLY_FLAG	NOT NULL	VARCHAR2(1)
MULTI_FLAG	NOT NULL	VARCHAR2(1)
VALIDATION_PROFILE_ID	NULLABLE	NUMBER
SOURCE_TYPE_CODE	NULLABLE	VARCHAR2(30)
SOURCE	NULLABLE	VARCHAR2(100)
CLEAR_RULE	NULLABLE	VARCHAR2(500)
DISPLAY_ONLY_RULE	NULLABLE	VARCHAR2(200)
REQUIRED_RULE	NULLABLE	VARCHAR2(200)
BATCH_NUMBER	NULLABLE	NUMBER
SEARCH_VALIDATION_ID	NULLABLE	NUMBER
SEARCHABLE_FLAG	NULLABLE	VARCHAR2(1)
VISIBLE_TO_ALL_FLAG	NOT NULL	VARCHAR2(1)
EDITABLE_BY_ALL_FLAG	NOT NULL	VARCHAR2(1)
TABLE_COLUMN_SEQUENCE	NULLABLE	NUMBER
DISPLAY_TOTAL_FLAG	NULLABLE	VARCHAR2(1)
SOURCE_PARAMETER_SET_ID	NULLABLE	NUMBER
SOURCE_PARAMETER_SET_FIELD_ID	NULLABLE	NUMBER
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)
DEFAULT_CONST_VALUE	NULLABLE	VARCHAR2(4000)
REVERSE_PARAMETER_SET_FIELD_ID	NULLABLE	NUMBER	Record the reciprocal field

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_PARAMETER_SET_FIELDS_N1	NONUNIQUE	1	PARAMETER_SET_CONTEXT_ID
KNTA_PARAMETER_SET_FIELDS_N2	NONUNIQUE	1	PROMPT
KNTA_PARAMETER_SET_FIELDS_N3	NONUNIQUE	1	PARAMETER_TOKEN
KNTA_PARAMETER_SET_FIELDS_N4	NONUNIQUE	1	SECTION_ID
KNTA_PARAMETER_SET_FIELDS_U1	UNIQUE	1	PARAMETER_SET_FIELD_ID
SYS_C00109352669	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.