Share this page

# KCRT_FG_SERVICE_INT

This table stores information for importing services into the KCRT_FG_SERVICE table.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_TRANSACTIONS | TRANSACTION_ID | PARENT_TRANSACTION_ID
KCRT_FG_CMQC_APP_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_TEMP_BATCH_UPDATE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMDB_APPLICATION | REQUEST_ID | REQUEST_ID
FND_CONCURRENT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_FG_WORK_ITEMS | REQUEST_ID | REQUEST_ID
KCRT_FG_UCMDB | REQUEST_ID | REQUEST_ID
KCRT_FG_SLA | REQUEST_ID | REQUEST_ID
KCRT_FG_SERVICE | 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_QC_INSTANCE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_STATUS | REQUEST_ID | REQUEST_ID
KCRT_FG_DEMAND_SCHEDULE | REQUEST_ID | REQUEST_ID
KCRT_FG_IMPACT_ANALYSIS | REQUEST_ID | REQUEST_ID
KCRT_FG_MASTER_PROJ_REF | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_ASSET | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_PROPOSAL | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_ISSUE | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_REFERENCE | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_RESOURCE_REQ | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_RISK | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_ISSUE | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_RISK | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_SCOPE_CHANGE | REQUEST_ID | REQUEST_ID
KCRT_FG_QC_DEFECT_INFO | REQUEST_ID | REQUEST_ID
KCRT_FG_QC_INFO | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID
KNTA_SERVICES_NLS | SERVICE_ID | SERVICE_ID
KRSC_ORG_UNITS_INT | TRANSACTION_ID | TRANSACTION_ID
KNTA_USERS_INT | TRANSACTION_ID | TRANSACTION_ID
KWFL_TRANSACTIONS_INT | TRANSACTION_ID | TRANSACTION_ID
KWFL_STEP_TRANSITIONS_INT | TRANSACTION_ID | TRANSACTION_ID
KNTA_USER_SECURITY_INT | TRANSACTION_ID | TRANSACTION_ID
KRSC_ORG_UNIT_MEMBERS_INT | TRANSACTION_ID | TRANSACTION_ID
KCRT_TRANSACTIONS | TRANSACTION_ID | TRANSACTION_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
GROUP_ID | NULLABLE | NUMBER | System-generated identifier
TRANSACTION_ID | NULLABLE | NUMBER | Transaction ID
PARENT_TRANSACTION_ID | NULLABLE | NUMBER | Parent transaction ID
REQUEST_ID | NOT NULL | NUMBER | Request ID
REQUEST_TYPE_ID | NOT NULL | NUMBER | Request type ID
SERVICE_ID | NULLABLE | VARCHAR2(40) | Service ID
SERVICE_NAME | NULLABLE | VARCHAR2(255) | Service name

## Indexes

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

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