Share this page

# KCRT_FG_CMQC_PROJ_STATUS_INT

This table is used for importing CMQC Project Status requests.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_FG_DEMAND_SCHEDULE | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_RESOURCE_REQ | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_QC_INSTANCE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_PROJECT_STATUS | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_QC_ADMIN | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_ASSET | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_ISSUE | REQUEST_ID | REQUEST_ID
KRSC_ORG_UNIT_MEMBERS_INT | TRANSACTION_ID | TRANSACTION_ID
KCRT_FG_PROJ_SCOPE_CHANGE | REQUEST_ID | REQUEST_ID
KWFL_TRANSACTIONS_INT | TRANSACTION_ID | TRANSACTION_ID
KCRT_TRANSACTIONS | TRANSACTION_ID | PARENT_TRANSACTION_ID
KCRT_FG_SLA | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_TRANSACTIONS | TRANSACTION_ID | TRANSACTION_ID
KCRT_FG_QC_INFO | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_APP_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_PROPOSAL | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_STATUS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID
KCRT_FG_WORK_ITEMS | REQUEST_ID | REQUEST_ID
KNTA_USERS_INT | TRANSACTION_ID | TRANSACTION_ID
KCRT_FG_PFM_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_QC_DEFECT_INFO | REQUEST_ID | REQUEST_ID
KCRT_FG_CMDB_APPLICATION | REQUEST_ID | REQUEST_ID
KRSC_ORG_UNITS_INT | TRANSACTION_ID | TRANSACTION_ID
KCRT_FG_PROJ_ISSUE | REQUEST_ID | REQUEST_ID
KCRT_FG_IMPACT_ANALYSIS | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_STATUS | REQUEST_ID | REQUEST_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_FG_MASTER_PROJ_REF | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_RISK | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_REFERENCE | REQUEST_ID | REQUEST_ID
KNTA_USER_SECURITY_INT | TRANSACTION_ID | TRANSACTION_ID
KWFL_STEP_TRANSITIONS_INT | 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 | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update.
PARENT_TRANSACTION_ID | NOT NULL | NUMBER | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update.
REQUEST_ID | NULLABLE | NUMBER | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update.
REQUEST_TYPE_ID | NULLABLE | NUMBER | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_FG_CMQC_PROJ_STAT_INT_N1 | NONUNIQUE | 1 | GROUP_ID
KCRT_FG_CMQC_PROJ_STAT_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: