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.