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.