Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: