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.