TransplantEpisodeDetails

This table contains information regarding the transplant episode. Only episodes whose Episode Type Class (I HBD 130) is 4 - Transplant will be included.

Column Name	Type	Description
PhysicalDeploymentOwnerIdentifier	VARCHAR	ID of the physical deployment owner for this record. Physical owners will be where the data is hosted, either on the cross-over server or the owner deployment.
HistoricTransplantState	VARCHAR	This item is used to document the state where transplant occurred for a historic transplant.
TransplantEpisodeStatus	INTEGER	The status of the episode. Use this column to filter deleted episodes by using "<>3" comparison.
LastUnosIntestineStatusDate	DATETIME	The date of the most recent United Network for Organ Sharing (UNOS) intestine status.
TransplantManagingCenterIdentifier	INTEGER	Stores the managing transplant center for an episode at the time of transplant or donation.
TransplantCommitteeReviewDate	DATETIME	Date on which the patient's information was presented at a multi-disciplinary committee meeting to determine whether to list the patient for transplant.
TransplantTransportationMethod	INTEGER	The method of transportation to the transplant center.
LastUnosHeartStatus	VARCHAR	The most recent United Network for Organ Sharing (UNOS) heart status.
LastUnosCalculatedPanelReactiveAntibodyScore	INTEGER	The most recent United Network for Organ Sharing (UNOS) Calculated Panel Reactive Antibodies (CPRA) score.
TransplantEpisodeNextReviewDateTime	DATETIME	Date on which the transplant episode and the patient chart should be reviewed.
TransplantLastUnitedNetworkForOrganSharingCalculationOfAsScoreDate	DATETIME	The date of the most recent CAS subscore.
HistoricTransplantFacilityFaxNumber	VARCHAR	Fax for the facility where the historic transplant took place.
TransplantEpisodeComputedSurgeryDate	DATETIME	Computed transplant date for a transplant episode. The following fields are checked, in this order, to obtain the transplant date: 1. Transplant Date (I HSB 30050). 2. From the transplant status history, the first time the episode reached the Transplanted phase in the system (I HSB 30056).
TransplantDischargeDateTime	DATETIME	Date on which the patient was discharged after the transplant surgery.
Is	VARCHAR	Indicates whether the most recent United Network for Organ Sharing (UNOS) liver score is a PELD score
LastUnosCalculatedPanelReactiveAntibodyScoreDate	DATETIME	The most recent United Network for Organ Sharing (UNOS) Calculated Panel Reactive Antibodies (CPRA) score update date.
TransplantCurrentStatusReason	INTEGER	Reason for the transplant episode's current phase and status.
DrugUseAtTransplant	INTEGER	The donor or recipient's drug use at transplant.
TransplantCurrentStageDateTime	DATETIME	Effective date for the current phase, status, and reason of the transplant episode.
WaitlistManagingTransplantCenter	INTEGER	Stores the managing transplant center for an episode at the time of waitlisting
HistoricalTransplantUnitedNetworkForOrganSharingCenterCode	INTEGER	United Network for Organ Sharing (UNOS) center where the historical transplant occurred.
LastUnosLiverScoreDate	DATETIME	The date of the most recent United Network for Organ Sharing (UNOS) liver score update.
TransplantAdmissionDate	DATETIME	Date on which the patient was admitted for the transplant procedure.
TransplantEvaluationStartDate	DATETIME	Date on which transplant evaluation began for the patient.
TobaccoUseAtTransplantStatus	INTEGER	The donor or recipient's tobacco usage at transplant.
HasUnmanageableFluidElectrolyteLossesIndicator	VARCHAR	Indicates whether the patient has unmanageable fluid-electrolyte losses.
TransplantEpisodeComputedReferralDate	DATETIME	Computed referral date for a transplant episode. The following fields are checked, in this order, to obtain the referral date: 1. Transplant Referral Date (I HSB 30113). 2. From the transplant status history, the first time the episode reached the Pre-Evaluation phase in the system (I HSB 30056).
HasLostTwoVascularAccessSitesForIntestine	VARCHAR	Indicates whether the patient has lost two or more vascular access sites for the intestine.
TransplantEpisodeNoteIdentifier	VARCHAR	The transplant episode note record ID.
IntestinalVascularAccessExhaustedIndicator	VARCHAR	Indicates whether the patient has exhausted vascular access to the intestine.
HistoricTransplantCoordinatorName	VARCHAR	The coordinator for the historic transplant.
ExhaustedVascularAccessForHemodialysisIndicator	VARCHAR	Indicates whether the patient has exhausted vascular access for hemodialysis.
TransplantEpisodeCurrentStage	INTEGER	Phase of the transplant episode.
LiveDonorPossibilityCategory	INTEGER	The category number for the possibilities being investigated to find a live transplant donor. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
LastUnosIntestineStatus	VARCHAR	The most recent United Network for Organ Sharing (UNOS) intestine status.
IsReceivingOralNutritionIndicator	VARCHAR	Indicates whether the patient is receiving oral nutrition.
IsHistoricTransplantEpisodeFlag	VARCHAR	flag indicating a historic transplant episode
LastLungCompositeAllocationScore	NUMERIC	Most recent lung composite allocation score
HistoricTransplantCountyName	VARCHAR	This item stores the county where a historic transplant occurred
TransplantAlcoholUse	INTEGER	The donor or recipient's alcohol usage at transplant.
IntravenousFluidDependentIndicator	VARCHAR	Indicates whether the patient is dependent on intravenous fluids.
TransplantWaitlistDate	DATETIME	Date on which the patient was placed on the waitlist
TransplantEpisodeStatus	INTEGER	Status of the current phase of the transplant episode.
IsLastUnosLiverScoreStatus	VARCHAR	Indicates whether the most recent United Network for Organ Sharing (UNOS) liver score is a liver status.
TransplantComputedWaitlistDate	DATETIME	Computed waitlist date for a transplant episode. The following fields are checked, in this order, to obtain the waitlist date: 1. Transplant Center Waitlist Date (I HSB 30074). 2. Transplant Waitlist Qualifying Date (I HSB 30061). 3. From the transplant status history, the first time the episode reached the Waitlist phase in the system (I HSB 30056).
TransplantDonorMinimumWeight	NUMERIC	The minimum acceptable donor weight.
IsPeritonealAccessExhausted	VARCHAR	Indicates whether the patient has exhausted peritoneal access.
TransplantEvaluationCompletionDate	DATETIME	Date on which the transplant evaluation was completed for the patient.
HistoricTransplantFacilityPhoneNumber	VARCHAR	Phone number of the facility where the historic transplant took place.
TransplantTotalParenteralNutritionDependencyIndicator	VARCHAR	Indicates whether the patient is dependent on total parenteral nutrition (TPN).
CommitteeReviewTransplantCenter	INTEGER	Stores the managing transplant center for an episode at the time of the committee review
LogicalDeploymentOwnerIdentifier	VARCHAR	ID of the logical deployment owner for this record. Logical owners show the deployment where the record was created but doesn't represent if the record is a part of version skew.
ReferralTransplantCenter	INTEGER	Stores the managing transplant center for an episode at the time of referral
TransplantSurgeryAdmissionContactSerialNumber	NUMERIC	The contact serial number (CSN) for the hospital admission when the transplant surgery was performed.
TransplantSurgeonProviderIdentifier	VARCHAR	The surgeon specified in the transplant care team. If surgeon is not specified in the care team, it will be looked up from the associated surgical log.
TransplantComputedCommitteeReviewDate	DATETIME	Computed committee review date for a transplant episode. The following fields are checked, in this order, to obtain the committee review date: 1. Transplant Committee Review Date (I HSB 30025). 2. The earliest review date from Committee Review encounters linked to the episode (I EPT 98025).
LastUnosLungAllocationScoreDate	DATETIME	The date of the most recent United Network for Organ Sharing (UNOS) lung allocation score.
PatientBloodTypeUnacceptableAntigenCode	INTEGER	List the patient's BW unacceptable antigen
DonorMaximumWeightRequirement	NUMERIC	The maximum acceptable donor weight
Is	VARCHAR	Indicates whether the patient is receiving nutrition through a gastric tube.
LastUnosHeartStatusDate	DATETIME	The date of the most recent United Network for Organ Sharing (UNOS) heart status.
CenterWaitlistDate	DATETIME	Date on which the patient was added to the center waitlist.
TransplantWeightInKilograms	NUMERIC	The donor or recipient's weight at transplant, in kg.
NonReconstructableGastrointestinalTractIndicator	VARCHAR	Indicates whether the patient has a non-reconstructable GI tract.
TransplantEpisodeEarliestOrganClampDateTime	DATETIME	Contains the earliest clamp time from organs associated with the transplant episode. If there are no clamp times for any associated organs, this will be null.
PatientIdentification	VARCHAR	The patient associated with the episode.
TransplantDonorWillingnessIndicator	VARCHAR	Is the organ donor willing to donate organ to anyone?
TransplantComputedAdmissionDate	DATETIME	Computed admission date for a transplant episode. The following fields are checked, in this order, to obtain the admission date: 1. Transplant Admission Date (I HSB 30048). 2. The admission date from the encounter linked to the episode as the admission encounter (I EPT 18850), as stored in item TX ADMISSION CONTACT SERIAL NUMBER (I HSB 30185).
HistoricTransplantLocationName	VARCHAR	This item stores the location where a historic transplant occurred
TransplantSurgeryDate	DATETIME	Date on which the transplant surgery took place.
LastUnosLungAllocationScore	NUMERIC	The most recent United Network for Organ Sharing (UNOS) lung allocation score.
TransplantEpisodeOwningCenter	INTEGER	The transplant center that owns the patient episode.
TransplantEpisodeComputedEvaluationDate	DATETIME	Computed evaluation date for a transplant episode. The following fields are checked, in this order, to obtain the evaluation date: 1. Transplant Evaluation Date (I HSB 30007). 2. From the transplant status history, the first time the episode reached the Evaluation phase in the system (I HSB 30056).
TransplantEpisodeComputedDischargeDate	DATETIME	Computed discharge date for a transplant episode. The following fields are checked, in this order, to obtain the discharge date: 1. Transplant Discharge Date (I HSB 30006). 2. The discharge date from the encounter linked to the episode as the admission encounter (I EPT 18855), as stored in item TX ADMISSION CONTACT SERIAL NUMBER (I HSB 30185).
ManagingTransplantCenterAtEvaluationStart	INTEGER	Stores the managing transplant center for an episode at the start of the evaluation
TransplantNumber	INTEGER	Stores the transplant number