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.