CMGMT_SUPPORT_TYPE_PROV

Description:

This table extracts the related multiple response Support & Services Audit Trail - Responsible User (I HSB 64143) 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 providers 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_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.