Share this page

# KCRT_FG_UCMDB_INT

This table is a child table of KCRT_REQUESTS_INT. This table is used to import data into KCRT_FG_UCMDB. This table is 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 while also allowing for scheduled processing. The PL/SQL package queries this table, validates against appropriate tables and imports into the production tables.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_REQUESTS_INT | TRANSACTION_ID | PARENT_TRANSACTION_ID
KCRT_FG_CMDB_APPLICATION | REQUEST_ID | REQUEST_ID
KCRT_FG_DEMAND_SCHEDULE | REQUEST_ID | REQUEST_ID
KCRT_FG_SLA | REQUEST_ID | REQUEST_ID
KCRT_FG_WORK_ITEMS | REQUEST_ID | REQUEST_ID
KCRT_TEMP_BATCH_UPDATE | REQUEST_ID | REQUEST_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_REFERENCE | REQUEST_ID | REQUEST_ID
KCRT_FG_QC_INFO | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_ASSET | REQUEST_ID | REQUEST_ID
KCRT_FG_UCMDB | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_PROPOSAL | REQUEST_ID | REQUEST_ID
KCRT_FG_IMPACT_ANALYSIS | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_ISSUE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_PROJECT_STATUS | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_QC_ADMIN | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_ISSUE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_QC_INSTANCE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_STATUS | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_SCOPE_CHANGE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_APP_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_MASTER_PROJ_REF | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_RISK | REQUEST_ID | REQUEST_ID
KCRT_FG_QC_DEFECT_INFO | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_RESOURCE_REQ | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID
KWFL_TRANSACTIONS_INT | TRANSACTION_ID | TRANSACTION_ID
KRSC_ORG_UNITS_INT | TRANSACTION_ID | TRANSACTION_ID
KWFL_STEP_TRANSITIONS_INT | TRANSACTION_ID | TRANSACTION_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
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 identifier
PARENT_TRANSACTION_ID | NOT NULL | NUMBER | System-generated identifier of the parent transaction
REQUEST_ID | NULLABLE | NUMBER | Request Id
REQUEST_TYPE_ID | NULLABLE | NUMBER | Request type ID
UCMDB_CI_LIST | NULLABLE | VARCHAR2(4000) | uCMDB Configure Item list
UCMDB_REPORT_VALUE | NULLABLE | VARCHAR2(255) | Refer to KNTA_DOCUMENTS.DOCUMENT_ID
UCMDB_REPORT_MEANING | NULLABLE | VARCHAR2(255) | Refer to KNTA_DOCUMENTS.NAME and KNTA_DOCUMENTS.EXTENTION

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_FG_UCMDB_INT_N1 | NONUNIQUE | 1 | GROUP_ID
KCRT_FG_UCMDB_INT_N1 | NONUNIQUE | 2 | TRANSACTION_ID

## Sequences

This table does not use any 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: