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.