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)

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.