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