CMGMT_SUPPORT_TYPE_POOL

Description: |
This table extracts the related multiple response Support & Services Audit Trail - Responsible Pool (I HSB 64144) item.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EPISODE_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EPISODE_ID | NUMERIC | No |
The unique identifier for the episode record.
2 | GROUP_LINE | INTEGER | No |
The line number of the historical support and service type information in the episode record. Together with EPISODE_ID, this forms the foreign key to the CMGMT_SUPPORT_TYPE_HX table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple responsible pools in the snapshot of the support and services audit trail (SI HSB 64140) associated with the support and service type from the CMGMT_SUPPORT_TYPE_HX table.
4 | SUPPORT_TYPE_RESP_REGISTRY_ID | NUMERIC | No |
The unique identifier of the historical responsible pool for the support and service type.
5 | SUPPORT_TYPE_RESP_REGISTRY_ID_REGISTRY_NAME | VARCHAR | No |
The name of the In Basket registry in the HIP master file.