TXP_PHASE_HX_AUDIT

Description:

This table contains the audit trail for transplant phase, including changes from phase history as well as editing in transplant info section.

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 identifier for the episode record.
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	PHASE_HX_AUDIT_C_NAME	VARCHAR	No
	Stores the audit trail for transplant episode phase updates. May contain organization-specific values: No Category Entries: Referral Evaluation Waitlist Admitted for Transplant Transplanted
4	DATE_HX_AUDIT_DT	DATETIME	No
	Stores the audit trail for transplant episode status date updates.
5	STATUS_HX_AUDIT_C_NAME	VARCHAR	No
	Stores the audit trail for transplant episode status updates. 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	UPDATE_USER_AUDIT_ID	VARCHAR	No
	This item stores the audit trail for the users who update the phase history in both Phase History activity and Transplant Information section.
7	UPDATE_USER_AUDIT_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	UPDATE_INST_AUD_DTTM	DATETIME (Local)	No
	This item stores the audit trail for the instant when the transplant phase history is updated in both Phase History activity and Transplant Information section.
9	REASON_HX_AUDIT_C_NAME	VARCHAR	No
	Stores the audit trail of the reasons the transplant episode status was updated. 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	PHASE_AUD_EVENT_C_NAME	VARCHAR	No
	Stores the audit trail for if data was added, edited, or removed from the transplant episode's phase, status, reason, and/or date. May contain organization-specific values: No Category Entries: Added Removed Automatically Added