TRANSPLANT_STAT_HX

Description:

This table contains information about a transplant episode's phase, status, and reason.

Primary Key

Column Name	Ordinal Position
SUMMARY_BLOCK_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SUMMARY_BLOCK_ID	NUMERIC	No
	The unique ID of the episode of care record.
2	LINE	INTEGER	No
	Each line represents a change in status for this transplant episode.
3	TX_STAGE_C_NAME	VARCHAR	No
	The phase of the transplant episode, e.g. Pre-Evaluation, Evaluation, Transplanted. May contain organization-specific values: No Category Entries: Referral Evaluation Waitlist Admitted for Transplant Transplanted
4	TX_STAT_DT	DATETIME	No
	Effective date associated with the patient's transplant phase, status, and reason.
5	TX_STATUS_OUT_C_NAME	VARCHAR	No
	Status associated with the patient's transplant phase and reason. May contain organization-specific values: Yes Category Entries: Active Internal Hold Declined Approved Removed Denied Follow-up Denied Not Followed Inactive Deferred Deferred Follow-up Deferred Not Followed Ineligible Ready for Committee Ready for Listing Approved for Listing Approved for Live Donor Only Active Follow-up Reporting Follow-up Only Not Followed
6	TX_STAT_UPD_USER_ID	VARCHAR	No
	The unique ID of the user who updated the transplant phase, status, or reason.
7	TX_STAT_UPD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	TX_STAT_UPD_INST	DATETIME (Local)	No
	The instant the transplant phase, status, or reason was updated.
9	TX_STATUS_REASON_C_NAME	VARCHAR	No
	Reason for the patient's transplant phase and status. May contain organization-specific values: Yes Category Entries: Patient Died Unable to Contact Patient Financial/Insurance Complications Patient Choice Not a Candidate Graft Lost Other Candidate Listed in Error Program Inactive for 2+ Years Transplanted in Another Country Candidate Workup Incomplete Substance Abuse Medical Non-Compliance Refused Transplant Temporarily too Sick Temporarily too Well Transplant Pending Weight Issues Candidate for Living Donor Transplant Only Physician/Surgeon Unavailable Candidate Requires Multi-Organ Transplant Only, Isolated Offers Not Accepted Transferred to Another Center Patient Died During Transplant Procedure Candidate Condition Improved, Transplant Not Needed Candidate Condition Deteriorated, too Sick for Transplant Transplanted at Another Center Candidate Listed for Unacceptable Antigens Only Patient Lost to Follow-up Referred too Early Patient Cancellation Patient No Show Does Not Meet Criteria Pending Additional Tests Pending Insurance Approval Ready for Scheduling Scheduled for Evaluation Ready for Committee Ready for Listing Followed Up at Another Location
10	TXP_PHASE_ENC_CSN	NUMERIC	No
	Contact Serial Number (CSN) for the encounter where the transplant phase, status, or reason was changed. This is used in the transplant history audit trail. It is also used to provide a link to the encounter in which the phase was changed.