KCRT_RT_REQUEST_RESOURCES
This table is used for storing the resources assigned to a request.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KCRT_FG_SLA |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_CMQC_QC_ADMIN |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PFM_PROJECT |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PFM_ASSET |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_CMQC_APP_PROJECT |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PROG_RESOURCE_REQ |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PROJ_ISSUE |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_CMQC_TEST_PROJECT |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_CMDB_APPLICATION |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PROJ_SCOPE_CHANGE |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PROG_ISSUE |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_CMQC_TEST_STATUS |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PFM_PROPOSAL |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_DEMAND_SCHEDULE |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_MASTER_PROJ_REF |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_CMQC_PROJECT_STATUS |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_PROJ_RISK |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_QC_INFO |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_QC_DEFECT_INFO |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_WORK_ITEMS |
REQUEST_ID |
REQUEST_ID |
KCRT_REQUESTS |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_CMQC_QC_INSTANCE |
REQUEST_ID |
REQUEST_ID |
KCRT_FG_IMPACT_ANALYSIS |
REQUEST_ID |
REQUEST_ID |
KCRT_REQUEST_RSC_ACTUALS |
REQUEST_RSC_ACTUALS_ID |
REQUEST_RSC_ACTUALS_ID |
RSC_RESOURCE_ROLES |
RESOURCE_ID |
RESOURCE_ID |
RSC_RESOURCES |
RESOURCE_ID |
RESOURCE_ID |
KNTA_I18N_RESOURCES_NLS |
RESOURCE_ID |
RESOURCE_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
RESOURCE_REQUEST_ID |
NULLABLE |
NUMBER |
System-generated identifier |
RESOURCE_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_ID |
NULLABLE |
NUMBER |
|
REQUEST_RSC_ACTUALS_ID |
NULLABLE |
NUMBER |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_RT_REQUEST_RESOURCES_N1 |
NONUNIQUE |
1 |
RESOURCE_ID |
KCRT_RT_REQUEST_RESOURCES_N2 |
NONUNIQUE |
1 |
REQUEST_ID |
KCRT_RT_REQUEST_RESOURCES_U1 |
NONUNIQUE |
1 |
RESOURCE_ID |
KCRT_RT_REQUEST_RESOURCES_U1 |
NONUNIQUE |
2 |
REQUEST_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KCRT_RT_REQUEST_RESOURCES_S |
RESOURCE_REQUEST_ID |