KCRT_FG_IMPACT_ANALYSIS_INT
This table is used for importing uCMDB-integrated requests.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KCRT_REQUESTS_INT |
TRANSACTION_ID |
PARENT_TRANSACTION_ID |
KCRT_REQUESTS |
REQUEST_ID |
REQUEST_ID |
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
REQUEST_TYPE_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
GROUP_ID |
NULLABLE |
NUMBER |
System-generated identifier |
TRANSACTION_ID |
NULLABLE |
NUMBER |
Provides a unique identifier for each transaction |
PARENT_TRANSACTION_ID |
NULLABLE |
NUMBER |
Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported |
REQUEST_ID |
NOT NULL |
NUMBER |
Identifies the request. This is normally left blank and is derived from the KCRT_REQUESTS_S sequence |
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
Identifies the request type. This is normally left blank and is derived from REQUEST_TYPE_NAME |
MAM_RFC_ID |
NULLABLE |
VARCHAR2(64) |
uCMDB RFC identifier |
IMPACT_RESULT_VALUE |
NULLABLE |
NUMBER |
uCMDB Impact analysis result |
IMPACT_RESULT_MEANING |
NULLABLE |
VARCHAR2(20) |
uCMDB Impact analysis result meaning |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_FG_IMPACT_ANALYSIS_INT_N1 |
NONUNIQUE |
1 |
GROUP_ID |
KCRT_FG_IMPACT_ANALYSIS_INT_N1 |
NONUNIQUE |
2 |
TRANSACTION_ID |
Sequences
This table uses no sequences.