KNTA_PARAM_SET_FLD_SETUPS

This table stores setup information for parameter set fields.

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_PARAM_SET_FIELDS_NLS

PARAMETER_SET_FIELD_ID

PARAMETER_SET_FIELD_ID

KRML_PARAMETER_SET_FLDS_COPY

PARAMETER_SET_FIELD_ID

PARAMETER_SET_FIELD_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PARAM_SET_FLD_SETUP_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_FIELD_ID

NOT NULL

NUMBER

Identifier of the set field this record describes

ALLOW_PROMPT_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether to allow a prompt for this field

ALLOW_DESCRIPTION_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether to allow a description for this field

ALLOW_ENABLED_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field is enabled

ALLOW_VALIDATION_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field allows validation

ALLOW_MULTI_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field allows multiple values

ALLOW_EDITABLE_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field is editable

ALLOW_TRANS_HISTORY_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field allows transaction history to be saved

ALLOW_DISP_IN_SEARCH_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field is displayed in a search

ALLOW_NOTES_HISTORY_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field will appear in the notes history section when the field is changed

ALLOW_SEARCH_VALIDATION_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field allows a search validation

ALLOW_DEFAULT_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether the field allows a default value

ALLOW_VISIBLE_SECURITY_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether to allow the security of the field to be visible

ALLOW_EDITABLE_SECURITY_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines whether to allow the security of the field to be editable

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_PARAM_SET_FLD_SETUPS_U1

UNIQUE

1

PARAM_SET_FLD_SETUP_ID

Sequences

Sequence Name

Sequence Type

KNTA_PARAM_SET_FLD_SETUPS_S

PARAM_SET_FLD_SETUP_ID