TRANSPLANT_COOR_HX

Description:

This table contains a list of all coordinator(s) who have been or are listed as the transplant episode coordinators. This table also contains all organ classes that have been added or removed from the episode.

Primary Key

Column Name	Ordinal Position
SUMMARY_BLOCK_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SUMMARY_BLOCK_ID	NUMERIC	No
	The transplant episode record ID.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	TX_COORD_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.
4	TX_COORD_UPD_USR_ID	VARCHAR	No
	The user who updated transplant coordinator field.
5	TX_COORD_UPD_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	TX_COORD_UPD_INST	DATETIME (Local)	No
	The instant when transplant coordinator was updated
7	TX_COORD_STAT_C_NAME	VARCHAR	No
	Stores whether the coordinator is active or inactive May contain organization-specific values: No Category Entries: Added Removed Automatically Added
8	TX_CLASS_HX_C_NAME	VARCHAR	No
	Stores organ classifications that have been added or deleted from the episode. May contain organization-specific values: No Category Entries: Lung Pancreas Liver Kidney Intestine Heart Islet Face Upper Limb Abdominal Wall Leg Penis Trachea Uterus Larynx Bladder