KCRT_TABLE_ENTRIES_INT

This table corresponds to the KCRT_TABLE_ENTIRES table. This table will be processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface but also allow for scheduled processing. PL/SQL package will query this table, validate against appropriate tables and imports into the production tables.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KRML_CONTEXT_UPDATES

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KRML_CONTEXT_UPDATES_COPY

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

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

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_TABLE_ENTRIES

TABLE_ENTRY_ID

TABLE_ENTRY_ID

KRSC_ORG_UNIT_MEMBERS_INT

TRANSACTION_ID

TRANSACTION_ID

KNTA_USER_SECURITY_INT

TRANSACTION_ID

TRANSACTION_ID

KNTA_USERS_INT

TRANSACTION_ID

TRANSACTION_ID

KWFL_TRANSACTIONS_INT

TRANSACTION_ID

TRANSACTION_ID

KRSC_ORG_UNITS_INT

TRANSACTION_ID

TRANSACTION_ID

KWFL_STEP_TRANSITIONS_INT

TRANSACTION_ID

TRANSACTION_ID

KCRT_TRANSACTIONS

TRANSACTION_ID

TRANSACTION_ID

Column Descriptions

Column Name

Null?

Data Type

Description

GROUP_ID

NOT NULL

NUMBER

System-generated identifier

TRANSACTION_ID

NOT NULL

NUMBER

System-generated record identifier

PARENT_TRANSACTION_ID

NOT NULL

NUMBER

Transaction ID of the parent table being imported

PARENT_FIELD_TOKEN

NOT NULL

VARCHAR2(30)

Foreign Key in KNTA_PARAMETER_SET_FIELDS of the PARAMETER_TOKEN of the Table Component field that holds this row of data.

TABLE_ENTRY_ID

NULLABLE

NUMBER

Primary Key in KCRT_TABLE_ENTRIES_INT of this row of data.

REQUEST_ID

NULLABLE

NUMBER

Primary Key in KCRT_REQUESTS of the request with the Table Component field that contains this row of data

PARAMETER_SET_FIELD_ID

NULLABLE

NUMBER

Primary Key in KNTA_PARAMETER_SET_FIELDS of the field definition of the Table Component field that contains this row of data

SEQ

NOT NULL

NUMBER

This row of data's relative position in the Table Component.

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Primary Key in KNTA_PARAMETER_SET_CONTEXTS of the Table Component's column header definition set

VISIBLE_PARAMETER1-40

NULLABLE

VARCHAR2(200)

Table Component detail parameter

PARAMETER1-40

NULLABLE

VARCHAR2(200)

Table Component detail parameter

VISIBLE_PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Table Component detail parameter

PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Table Component detail parameter

LOOKUP_TYPE1-50

NULLABLE

VARCHAR2(80)

Lookup Type for the corresponding Parameter

VALIDATION_TYPE_CODE1-50

NULLABLE

VARCHAR2(30)

Validation Type Code for the corresponding Parameter

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.