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