TRANSPLANT_INFO

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

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_BLOCK_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique ID of the episode of care record.
2 | TX_REV_DT | DATETIME | No |
Date on which the patient's information was presented at a multi-disciplinary committee meeting to determine whether to list the patient for transplant.
3 | TX_EPSD_TYPE_C_NAME | VARCHAR | No |
Indicates whether the patient is a donor or a recipient for the transplant.
May contain organization-specific values: No
Category Entries:
Donor
Recipient
4 | TX_NUM | INTEGER | No |
Stores the transplant number
5 | TX_HIST_LOCATION | VARCHAR | No |
This item stores the location where a historic transplant occurred
6 | TX_SURG_DT | DATETIME | No |
Date on which the transplant surgery took place.
7 | TX_IS_HISTORIC_YN | VARCHAR | No |
flag indicating a historic transplant episode
May contain organization-specific values: No
Category Entries:
Yes
No
8 | TX_EPSD_NOTE_HNO_ID | VARCHAR | No |
The transplant episode note record ID.
9 | TX_HIST_COUNTY_C_NAME | VARCHAR | No |
This item stores the county where a historic transplant occurred
May contain organization-specific values: Yes
10 | TX_WAITLIST_DT | DATETIME | No |
Date on which the patient was placed on the waitlist
11 | TX_DNR_POS_C_NAME | VARCHAR | No |
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).
May contain organization-specific values: Yes
Category Entries:
Being Evaluated
Exhausted
Donor Found
12 | TX_DISCHARGE_DT | DATETIME | No |
Date on which the patient was discharged after the transplant surgery.
13 | TX_CURRENT_STAGE_C_NAME | VARCHAR | No |
Phase of the transplant episode.
May contain organization-specific values: No
Category Entries:
Referral
Evaluation
Waitlist
Admitted for Transplant
Transplanted
14 | TX_CURRENT_STAGE_DT | DATETIME | No |
Effective date for the current phase, status, and reason of the transplant episode.
15 | TX_CURRENT_STATUS_C_NAME | VARCHAR | No |
Status of the current phase of the transplant episode.
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
16 | TX_CURRENT_REASON_C_NAME | VARCHAR | No |
Reason for the transplant episode's current 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
17 | TXP_EXTERNAL_CITY | VARCHAR | No |
City where the external transplant procedure was performed.
18 | ADMISSION_DT | DATETIME | No |
Date on which the patient was admitted for the transplant procedure.
19 | BW_UNACCEPT_AG_C_NAME | VARCHAR | No |
List the patient's BW unacceptable antigen
May contain organization-specific values: Yes
Category Entries:
BW4
BW6
Not Applicable
20 | TXP_NEXT_REVIEW_DT | DATETIME | No |
Date on which the transplant episode and the patient chart should be reviewed.
21 | TXP_ADMIT_CSN | NUMERIC | No |
The contact serial number (CSN) for the hospital admission when the transplant surgery was performed.
22 | IN_TPN_DEPENDENT_YN | VARCHAR | No |
Indicates whether the patient is dependent on total parenteral nutrition (TPN).
May contain organization-specific values: No
Category Entries:
No
Yes
23 | IN_IV_DEPENDENT_YN | VARCHAR | No |
Indicates whether the patient is dependent on intravenous fluids.
The category values for this column were already listed for column: IN_TPN_DEPENDENT_YN
24 | IN_ORAL_FEEDING_YN | VARCHAR | No |
Indicates whether the patient is receiving oral nutrition.
The category values for this column were already listed for column: IN_TPN_DEPENDENT_YN
25 | IN_TUBE_FEEDING_YN | VARCHAR | No |
Indicates whether the patient is receiving nutrition through a gastric tube.
The category values for this column were already listed for column: IN_TPN_DEPENDENT_YN
26 | LISTED_ELSEWHERE | VARCHAR | No |
Non-United Network for Organ Sharing (UNOS) center where the patient is listed.
27 | TIME_TO_CENTER | NUMERIC | No |
The patient's travel time in hours to the transplant center.
28 | EXHAUST_VASC_HEM_YN | VARCHAR | No |
Indicates whether the patient has exhausted vascular access for hemodialysis.
The category values for this column were already listed for column: TX_IS_HISTORIC_YN
29 | EXHAUST_PERITON_YN | VARCHAR | No |
Indicates whether the patient has exhausted peritoneal access.
The category values for this column were already listed for column: TX_IS_HISTORIC_YN
30 | EXHAUST_IN_VASC_YN | VARCHAR | No |
Indicates whether the patient has exhausted vascular access to the intestine.
The category values for this column were already listed for column: TX_IS_HISTORIC_YN
31 | LOSS_VASC_SITES_YN | VARCHAR | No |
Indicates whether the patient has lost two or more vascular access sites for the intestine.
The category values for this column were already listed for column: TX_IS_HISTORIC_YN
32 | FLUID_ELEC_LOSS_YN | VARCHAR | No |
Indicates whether the patient has unmanageable fluid-electrolyte losses.
The category values for this column were already listed for column: TX_IS_HISTORIC_YN
33 | NONRECON_GITRACT_YN | VARCHAR | No |
Indicates whether the patient has a non-reconstructable GI tract.
The category values for this column were already listed for column: TX_IS_HISTORIC_YN
34 | TXP_REFERRAL_DT | DATETIME | No |
Date on which the patient was referred to transplant-related specialty care.
35 | TX_HIST_PHONE | VARCHAR | No |
Phone number of the facility where the historic transplant took place.
36 | TX_HIST_FAX | VARCHAR | No |
Fax for the facility where the historic transplant took place.
37 | TX_HIST_COORD | VARCHAR | No |
The coordinator for the historic transplant.
38 | TX_HIST_CENTER_C_NAME | VARCHAR | No |
United Network for Organ Sharing (UNOS) center where the historical transplant occurred.
May contain organization-specific values: Yes
Category Entries:
Univ of South Alabama Med Ctr (Mobile, AL)
Baptist Med Ctr Princeton (Birmingham, AL)
Children's of Alabama (Birmingham, AL)
University of Alabama Hospital (Birmingham, AL)
Baptist Medical Center (Little Rock, AR)
Arkansas Children's Hospital (Little Rock, AR)
John L. McClellan VA Hospital (Little Rock, AR)
UAMS Medical Center (Little Rock, AR)
Phoenix Children's Hospital (Phoenix, AZ)
Banner-University Medical Center Phoenix (Phoenix, AZ)
Phoenix Regional Medical Center (Phoenix, AZ)
Mayo Clinic Hospital Arizona (Phoenix, AZ)
St. Joseph's Hospital and Medical Center (Phoenix, AZ)
Scottsdale Healthcare Osborn (Scottsdale, AZ)
Veterans Admin Med Ctr Tucson (Tucson, AZ)
Banner University Medical Center-Tucson (Tucson, AZ)
St Bernardine Med Center (San Bernardino, CA)
Alta Bates Med Ctr (Berkeley, CA)
Summit Med Ctr (Oakland, CA)
Rady Children's Hospital and Health Center (San Diego, CA)
Children's Hospital Los Angeles (Los Angeles, CA)
Cedars-Sinai Medical Center (Los Angeles, CA)
El Camino Hosp (Mountain View, CA)
Eisenhower Mem Hosp (Rancho Mirage, CA)
Scripps Green Hospital (La Jolla, CA)
City of Hope National Medical Center (Duarte, CA)
University of California Irvine Medical Center (Orange, CA)
Kaiser Permanente Hospital (Los Angeles, CA)
Kaiser Permanente Hosp Oakland (Oakland, CA)
Kaiser Permanente-San Fran. Med. Ctr (San Francisco, CA)
Harbor UCLA Medical Center (Torrance, CA)
St. Mary Medical Center (Long Beach, CA)
Loma Linda University Medical Center (Loma Linda, CA)
Mercy Hosp and Med Ctr (San Diego, CA)
Santa Rosa Memorial Hosp (Santa Rosa, CA)
Lucile Salter Packard Children's Hospital at Stanford (Palo Alto, CA)
California Pacific Medical Center-Van Ness Campus (San Francisco, CA)
Riverside Community Hospital (Riverside, CA)
Hoag Mem Hosp Presbyterian (Newport Beach, CA)
Arrowhead Reg. Med. Ctr. (Colton, CA)
Univ of Southern CA Med Ctr (Los Angeles, CA)
University of California San Diego Medical Center (La Jolla, CA)
University of California San Francisco Medical Center (San Francisco, CA)
Sutter Medical Center Sacramento (Sacramento, CA)
Sharp Memorial Hospital (San Diego, CA)
Saint Joseph Hospital (Orange, CA)
University of California Davis Medical Center (Sacramento, CA)
Stanford Health Care (Stanford, CA)
St. Vincent Medical Center (Los Angeles, CA)
University of California at Los Angeles Medical Center (Los Angeles, CA)
Keck Hospital of USC (Los Angeles, CA)
Western Medical Center (Santa Ana, CA)
Children's Hospital Colorado (Aurora, CO)
Memorial Hosp (Colorado Springs, CO)
AdventHealth Porter (Denver, CO)
Poudre Valley Hosp (Fort Collins, CO)
Presbyterian/St Luke's Medical Center (Denver, CO)
University of Colorado Hospital/Health Science Center (Aurora, CO)
Hartford Hospital (Hartford, CT)
Yale New Haven Hospital (New Haven, CT)
Children's National Medical Center (Washington, DC)
Medstar Georgetown Transplant Institute (Washington, DC)
George Washington University Hospital (Washington, DC)
Howard University Hospital (Washington, DC)
Providence Hosp (Washington, DC)
Washington Hospital Center (Washington, DC)
Walter Reed National Military Medical Center at Bethesda (Bethesda, MD)
Nemours Children's Hospital Delaware (Wilmington, DE)
Christiana Care Health Services (Newark, DE)
Johns Hopkins All Children's Hospital (St. Petersburg, FL)
Broward Health Medical Center (Fort Lauderdale, FL)
Bert Fish Med Ctr (New Smyrna Beach, FL)
Cleveland Clinic Florida Weston (Weston, FL)
AdventHealth Orlando (Orlando, FL)
Gulf Coast Medical Center (Ft Myers, FL)
Jackson Memorial Hospital University of Miami School of Medicine (Miami, FL)
Shands Jacksonville (Jacksonville, FL)
Miami Children's Hosp (Miami, FL)
St Joseph's Hosp (Tampa, FL)
Mayo Clinic Hospital Florida (Jacksonville, FL)
Tampa General Hospital (Tampa, FL)
Tallahassee Memorial Hospital (Tallahassee, FL)
UF Health Shands Hospital (Gainesville, FL)
University Medical Center (Jacksonville, FL)
Children’s Healthcare of Atlanta - Arthur M. Blank Hospital (Atlanta, GA)
Emory University Hospital (Atlanta, GA)
Grady Memorial Hospital (Atlanta, GA)
Wellstar MCG Health, affiliated with Medical College of Georgia (Augusta, GA)
Piedmont Hospital (Atlanta, GA)
Saint Joseph's Hospital of Atlanta (Atlanta, GA)
University Hospital (Augusta, GA)
Hawaii Medical Center East (Honolulu, HI)
Iowa Methodist Medical Center (Des Moines, IA)
The Iowa City VA Health Care System (Iowa City, IA)
University of Iowa Hospitals and Clinics Transplant Programs (Iowa City, IA)
Mercy Medical Center-Des Moines (Des Moines, IA)
Advocate Christ Medical Center (Oak Lawn, IL)
Ann & Robert H. Lurie Children's Hospital of Chicago (Chicago, IL)
Evanston Hospital (Evanston, IL)
Edward Hines Jr. Veterans Administration Medical Center (Hines, IL)
Loyola University Medical Center (Maywood, IL)
Springfield Memorial Hospital (Springfield, IL)
Northwestern Memorial Hospital (Chicago, IL)
Rush University Medical Center (Chicago, IL)
OSF Saint Francis Medical Center (Peoria, IL)
St. Johns Hospital (Springfield, IL)
University of Chicago Medical Center (Chicago, IL)
University of Illinois Medical Center (Chicago, IL)
Indiana University Health (Indianapolis, IN)
Indiana University Med Ctr (Indianapolis, IN)
Lutheran Hospital of Fort Wayne (Ft Wayne, IN)
Ascension St. Vincent Hospital (Indianapolis, IN)
St. Francis Hospital and Medical Center (Topeka, KS)
Via Christi Hospitals Wichita, Inc. (Wichita, KS)
Kansas Heart Hospital (Wichita, KS)
University of Kansas Hospital (Kansas City, KS)
Columbia Audubon Hosp (Louisville, KY)
Jewish Hospital (Louisville, KY)
Norton Children's Hospital (Louisville, KY)
University of Kentucky Medical Center (Lexington, KY)
Children's Hospital (New Orleans, LA)
Lakeview Hospital (Covington, LA)
University Medical Center (Lafayette, LA)
University Hospital (New Orleans, LA)
Ochsner Foundation Hospital (New Orleans, LA)
Memorial Med Ctr (New Orleans, LA)
Schumpert Health System (Shreveport, LA)
Louisiana State Univ Med Ctr (Shreveport, LA)
Tulane Medical Center (Metairie, LA)
Willis-Knighton Medical Center (Shreveport, LA)
Beth Israel Deaconess Medical Center (Boston, MA)
Baystate Medical Center (Springfield, MA)
Boston Medical Center (Boston, MA)
Boston VA Med Ctr (Boston, MA)
Boston Children's Hospital (Boston, MA)
Lahey Clinic Medical Center (Burlington, MA)
Massachusetts General Hospital (Boston, MA)
Tufts Medical Center (Boston, MA)
Brigham and Women's Hospital (Boston, MA)
UMass Memorial Medical Center (Worcester, MA)
Johns Hopkins Bayview Med Ctr (Baltimore, MD)
Johns Hopkins Hospital (Baltimore, MD)
Warren Grant Magnuson Clinical Ctr (Bethesda, MD)
Shady Grove Adventist Hosp (Rockville, MD)
University of Maryland Medical System (Baltimore, MD)
Washington Adventist Hosp (Takoma Park, MD)
Maine Medical Center (Portland, ME)
Corewell Health William Beaumont University Hospital (Royal Oak, MI)
Children's Hospital of Michigan (Detroit, MI)
Corewell Health Helen DeVos Children's Hospital (Grand Rapids, MI)
Henry Ford Hospital (Detroit, MI)
Harper University Hospital Detroit Medical Center (Detroit, MI)
Hurley Medical Center (Flint, MI)
Borgess Med Ctr (Kalamazoo, MI)
Grace Hosp (Detroit, MI)
Ascension St. John Hospital (Detroit, MI)
Mercy Health Saint Mary's (Grand Rapids, MI)
University of Michigan Medical Center (Ann Arbor, MI)
Abbott Northwestern Hospital (Minneapolis, MN)
Children's Minnesota (Minneapolis, MN)
Hennepin County Medical Center (Minneapolis, MN)
Mayo Clinic Hospital Minnesota (Rochester, MN)
Metropolitan Mt Sinai Med Ctr (Minneapolis, MN)
Veterans Administration Medical Center (Minneapolis, MN)
Saint Marys Hospital (Mayo Clinic) (Rochester, MN)
University of Minnesota Medical Center, Fairview (Minneapolis, MN)
Barnes-Jewish Hospital (St. Louis, MO)
Cardinal Glennon Children's Hospital (St. Louis, MO)
St. Louis Children's Hospital at Washington University Medical Center (St Louis, MO)
Children's Mercy Hospital (Kansas City, MO)
John Cochran VA Hosp (St Louis, MO)
DePaul Health Ctr (Bridgeton, MO)
St Johns Mercy Med Ctr (St Louis, MO)
St Luke's Hospital of Kansas City (Kansas City, MO)
Menorah Med Ctr (Kansas City, MO)
Research Medical Center (Kansas City, MO)
St Johns Reg Med Ctr (Joplin, MO)
SSM Health Saint Louis University Hospital (St Louis, MO)
University of Missouri Hospital and Clinics (Columbia, MO)
University of Mississippi Medical Center (Jackson, MS)
Wake Forest Baptist Medical Center (Winston Salem, NC)
Carolinas Medical Center (Charlotte, NC)
Duke University Hospital (Durham, NC)
Durham VA Medical Center (Durham, NC)
ECU Health Medical Center (Greenville, NC)
University of North Carolina Hospitals (Chapel Hill, NC)
Dakota Heartland Health System (Fargo, ND)
Sanford Bismarck Medical Center (Bismarck, ND)
Sanford Medical Center Fargo (Fargo, ND)
BryanLGH Medical Center East (Lincoln, NE)
Nebraska Health System (Omaha, NE)
St Joseph Hosp (Omaha, NE)
The Nebraska Medical Center (Omaha, NE)
Mary Hitchcock Memorial Hospital (Lebanon, NH)
Newark Beth Israel Medical Center (Newark, NJ)
Hackensack University Medical Center (Hackensack, NJ)
Virtua Our Lady of Lourdes Hospital (Camden, NJ)
Robert Wood Johnson University Hospital (New Brunswick, NJ)
Saint Barnabas Medical Center (Livingston, NJ)
University Hospital (Newark, NJ)
University Hospital, University of New Mexico Health Sciences Center (Albuquerque, NM)
Presbyterian Hospital (Albuquerque, NM)
Sunrise Hosp and Medical Center (Las Vegas, NV)
University Medical Center of Southern Nevada (Las Vegas, NV)
Albany Medical Center Hospital (Albany, NY)
Children's Hosp of Buffalo (Buffalo, NY)
Buffalo VA Medical Center (Buffalo, NY)
Buffalo General Hosp/Children's Hosp (Buffalo, NY)
NY Presbyterian Hospital/Columbia Univ. Medical Center (New York, NY)
State University of New York, Downstate Medical Center (Brooklyn, NY)
Erie County Medical Center (Buffalo, NY)
Strong Memorial Hospital, University of Rochester Medical Center (Rochester, NY)
Montefiore Medical Center (Bronx, NY)
Mount Sinai Medical Center (New York, NY)
North Shore University Hospital/Northwell Health (Manhasset, NY)
New York-Presbyterian Hospital/Weill Cornell Medical Center (New York, NY)
University Hospital of State University of New York at Stony Brook (Stony Brook, NY)
St. Luke's Roosevelt Hospital Center (New York, NY)
NYU Langone Health (New York, NY)
State University of New York Upstate Medical University (Syracuse, NY)
Westchester Medical Center (Valhalla, NY)
Akron City Hospital (Akron, OH)
Children's Hosp Med Ctr of Akron (Akron, OH)
The Cleveland Clinic Foundation (Cleveland, OH)
Nationwide Children's Hospital (Columbus, OH)
Children's Hospital Medical Center (Cincinnati, OH)
University of Toledo Medical Center (Toledo, OH)
Miami Valley Hospital (Dayton, OH)
Ohio State University Medical Center (Columbus, OH)
St Elizabeth Health Ctr (Youngstown, OH)
The Christ Hospital (Cincinnati, OH)
University of Cincinnati Medical Center (Cincinnati, OH)
University Hospitals of Cleveland (Cleveland, OH)
Integris Baptist Medical Center (Oklahoma City, OK)
Children's Hospital of Oklahoma (Oklahoma City, OK)
Hillcrest Med Ctr (Tulsa, OK)
OU Medical Center (Oklahoma City, OK)
St. Anthony Hospital (Oklahoma City, OK)
Saint Francis Hospital (Tulsa, OK)
St John Medical Center (Tulsa, OK)
Legacy Good Samaritan Hospital and Medical Center (Portland, OR)
Providence Portland Medical Center (Portland, OR)
Providence St. Vincent Medical Center (Portland, OR)
Portland Veterans Administration Medical Center (Portland, OR)
Oregon Health and Science University (Portland, OR)
Albert Einstein Medical Center (Philadelphia, PA)
Allegheny General Hospital (Pittsburgh, PA)
UPMC Children's Hospital of Pittsburgh (Pittsburgh, PA)
Children's Hospital of Philadelphia (Philadelphia, PA)
Geisinger Medical Center (Danville, PA)
Penn State Milton S Hershey Medical Center (Hershey, PA)
Pinnacle Health System at Harrisburg Hospital (Harrisburg, PA)
Hahnemann University Hospital (Philadelphia, PA)
The Lankenau Hospital (Wynnewood, PA)
Lehigh Valley Hospital (Allentown, PA)
Oakland VA Medical Center (Pittsburgh, PA)
University of Pittsburgh Medical Center (Pittsburgh, PA)
St. Christopher's Hospital for Children (Philadelphia, PA)
Thomas Jefferson University Hospital (Philadelphia, PA)
Temple University Hospital (Philadelphia, PA)
Hospital of the University of Pennsylvania (Philadelphia, PA)
VA Pittsburgh Healthcare System (Pittsburgh, PA)
Geisinger Wyoming Valley Medical Ctr (Wilkes-Barre, PA)
Cardiovascular Center of Puerto Rico and the Caribbean (San Juan, PR)
Auxilio Mutuo Hospital (Hato Rey, PR)
Rhode Island Hospital (Providence, RI)
Medical University of South Carolina (Charleston, SC)
Providence Hosp (Columbia, SC)
Richland Memorial Hosp (Columbia, SC)
Avera McKennan Hospital (Sioux Falls, SD)
Baptist Memorial Hospital (Memphis, TN)
Erlanger Medical Center (Chattanooga, TN)
Johnson City Med Ctr Hosp (Johnson City, TN)
Le Bonheur Children's Medical Center (Memphis, TN)
Methodist University Hospital (Memphis, TN)
Centennial Medical Center (Nashville, TN)
Saint Thomas Hospital (Nashville, TN)
University of Tennessee Medical Center at Knoxville (Knoxville, TN)
Univ of Tennessee Med Center (Memphis, TN)
Vanderbilt University Medical Center (Nashville, TN)
Nashville Veterans Administration Hospital (Nashville, TN)
Brackenridge Hosp (Austin, TX)
Baylor Scott and White All Saints Medical Center-Fort Worth (Fort Worth, TX)
Brooke Army Med Ctr (Fort Sam Houston, TX)
University Hospital, University of Texas Health Science Center (San Antonio, TX)
Cook Children's Medical Center (Fort Worth, TX)
Methodist Children's Hosp of S. Texas (San Antonio, TX)
Children's Medical Center of Dallas (Dallas, TX)
Seton Medical Center Austin (Austin, TX)
North Austin Medical Center (Austin, TX)
Texas Health Harris Methodist Fort Worth Hospital (Fort Worth, TX)
Baylor Med Ctr Grapevine (Grapevine, TX)
Medical City Dallas Hospital (Dallas, TX)
Memorial Hermann Hospital, University of Texas at Houston (Houston, TX)
CHI St. Luke's Health Baylor College of Medicine Medical Center (Houston, TX)
Methodist Specialty and Transplant Hospital (San Antonio, TX)
University of Texas Medical Branch at Galveston (Galveston, TX)
University Medical Center (Lubbock, TX)
Covenant Medical Center (Lubbock, TX)
Methodist Dallas Medical Center (Dallas, TX)
Houston Methodist Hospital (Houston, TX)
Medical City Fort Worth (Fort Worth, TX)
Parkland Health and Hospital System (Dallas, TX)
Christus Santa Rosa Hospital Medical Center (San Antonio, TX)
Sierra Medical Ctr (El Paso, TX)
UT Southwestern Medical Center/William P. Clements Jr. University Hospital (Dallas, TX)
Scott and White Memorial Hospital (Temple, TX)
Texas Children's Hospital (Houston, TX)
Baylor University Medical Center (Dallas, TX)
East Texas Medical Center (Tyler, TX)
Wilford Hall Medical Center (Lackland AFB, TX)
Zale-Lipshv University Hospital (Dallas, TX)
Unknown Hospital
Intermountain Medical Center (Murray, UT)
Salt Lake City VA Medical Center (Salt Lake City, UT)
University of Utah Medical Center (Salt Lake City, UT)
Primary Children's Hospital (Salt Lake City, UT)
Children's Hospital of the King's Daughters (Norfolk, VA)
Inova Fairfax Hospital (Falls Church, VA)
Henrico Doctors' Hospital (Richmond, VA)
VCU Health System Authority, VCUMC (Richmond, VA)
Hunter Holmes McGuire Veterans Administration Medical Center (Richmond, VA)
Sentara Norfolk General Hospital (Norfolk, VA)
Carilion Roanoke Memorial Hospital (Roanoke, VA)
University of Virginia Health Sciences Center (Charlottesville, VA)
The University of Vermont Medical Center (Burlington, VT)
Seattle Children's Hospital (Seattle, WA)
Providence Sacred Heart Medical Center & Children's Hospital (Spokane, WA)
Swedish Medical Center (Seattle, WA)
University of Washington Medical Center (Seattle, WA)
Virginia Mason Medical Center (Seattle, WA)
Children's Hospital of Wisconsin (Milwaukee, WI)
John L Doyne Hospital (Milwaukee, WI)
Zablocki VA Medical Center (Milwaukee, WI)
Froedtert Memorial Lutheran Hospital (Milwaukee, WI)
Aurora St. Luke's Medical Center (Milwaukee, WI)
University of Wisconsin Hospital and Clinics (Madison, WI)
Charleston Area Medical Center (Charleston, WV)
West Virginia University Hospitals Inc. (Morgantown, WV)
Foreign Transplant Center
Other Hospital
The Queen's Medical Center (Honolulu, HI)
Crozer-Chester Medical Center (Upland, PA)
Halifax Health (Daytona Beach, FL)
Memorial Regional Hospital/Joe DiMaggio Children's Hospital (Hollywood, FL)
Corewell Health Grand Rapids Hospitals (Grand Rapids, MI)
Sanford Health/USD Medical Center (Sioux Falls, SD)
Driscoll Children's Hospital (Corpus Christi, TX)
Las Palmas Medical Center (El Paso, TX)
McAllen Medical Center (McAllen, TX)
Michael E. DeBakey VA Medical Center (Houston, TX)
Birmingham VA Medical Center (Birmingham, AL)
Univ of MN Amplatz Children's Hosp (Minneapolis, MN)
Children's Nebraska (Omaha, NE)
Memorial Regional Hospital (Hollywood, FL)
UPMC Hamot (Erie, PA)
UCSF Medical Center at Mission Bay (San Francisco, CA)
Largo Medical Center (Largo, FL)
Ascension Sacred Heart Pensacola (Pensacola, FL)
James J. Peters VA Medical Center (Bronx, NY)
Long Island Jewish Medical Center-Cohen Children's Medical Center (Queens, NY)
VA Portland Health Care System (Portland, OR)
MUSC Children's Hospital (Charleston, SC)
Doctor's Hospital at Renaissance (Edinburg, TX)
University Children’s Health (San Antonio, TX)
Reading Hospital (Reading, PA)
Dell Children's Medical Center (Austin, TX)
Prisma Health Greenville Memorial Hospital (Greenville, SC)
Dell Seton Medical Center at The University of Texas at Austin (Austin, TX)
MUSC Lancaster (Lancaster, SC)
Renown Regional Medical Center (Reno, NV)
Mercy Health - St. Vincent Medical Center (Toledo, OH)
Antelope Valley Medical Center (Lancaster, CA)
Ralph H. Johnson Veterans Affairs Health Care System (Charleston, SC)
39 | TX_EVAL_DT | DATETIME | No |
Date on which transplant evaluation began for the patient.
40 | TX_DNR_WILLING_YN | VARCHAR | No |
Is the organ donor willing to donate organ to anyone?
The category values for this column were already listed for column: TX_IS_HISTORIC_YN
41 | TXP_CALC_RFL_DATE | DATETIME | No |
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). 3. From the transplant status history, the first time the episode reached the Evaluation phase in the system (I HSB 30056). 4. Episode Start Date (I HSB 70).
42 | TXP_CALC_EVAL_DATE | DATETIME | No |
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).
43 | TXP_CALC_CR_DATE | DATETIME | No |
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).
44 | TXP_CALC_ADMIT_DATE | DATETIME | No |
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).
45 | TXP_CALC_DISCHRG_DT | DATETIME | No |
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).
46 | TXPORT_MTHD_C_NAME | VARCHAR | No |
The method of transportation to the transplant center.
May contain organization-specific values: Yes
Category Entries:
Car
Ambulance
Airplane
Helicopter
47 | UNOS_ACCEPT | VARCHAR | No |
The United Network for Organ Sharing (UNOS) waitlist acceptance code.
48 | DONOR_MIN_WT | NUMERIC | No |
The minimum acceptable donor weight.
49 | DONOR_MAX_WT | NUMERIC | No |
The maximum acceptable donor weight
50 | TX_CENTER_WL_DT | DATETIME | No |
Date on which the patient was added to the center waitlist.
51 | EPISODE_STATUS_C_NAME | VARCHAR | No |
The status of the episode. Use this column to filter deleted episodes by using "<>3" comparison.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
52 | TXP_REF_PROV_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.
53 | TXP_SURGEON_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.
54 | TXP_CALC_EVAL_END_DT | DATETIME | No |
Computed evaluation end date for a transplant episode. The following fields are checked, in this order, to obtain the evaluation date: 1. Transplant Evaluation End Date (I HSB 30081). 2. If the episode is declined for transplant, use the status date 3. if the patient is waitlisted or above, use the center waitlist date(I HSB 30074), if empty, use waitlist date(I HSB 30061) 4. if patient died during referral/evaluation then return patient death date(I EPT 115)
55 | UNOS_LIVER_SCORE | VARCHAR | No |
The most recent United Network for Organ Sharing (UNOS) liver score.
56 | UNOS_LIVER_SCORE_DT | DATETIME | No |
The date of the most recent United Network for Organ Sharing (UNOS) liver score update.
57 | UNOS_LIVER_IS_PELD_YN | VARCHAR | No |
Indicates whether the most recent United Network for Organ Sharing (UNOS) liver score is a PELD score
The category values for this column were already listed for column: IN_TPN_DEPENDENT_YN
58 | UNOS_LIVER_IS_STATUS_YN | VARCHAR | No |
Indicates whether the most recent United Network for Organ Sharing (UNOS) liver score is a liver status.
The category values for this column were already listed for column: IN_TPN_DEPENDENT_YN
59 | UNOS_HEART_STATUS | VARCHAR | No |
The most recent United Network for Organ Sharing (UNOS) heart status.
60 | UNOS_HEART_STATUS_DT | DATETIME | No |
The date of the most recent United Network for Organ Sharing (UNOS) heart status.
61 | UNOS_LAS | NUMERIC | No |
The most recent United Network for Organ Sharing (UNOS) lung allocation score.
62 | UNOS_LAS_DT | DATETIME | No |
The date of the most recent United Network for Organ Sharing (UNOS) lung allocation score.
63 | UNOS_CPRA | INTEGER | No |
The most recent United Network for Organ Sharing (UNOS) Calculated Panel Reactive Antibodies (CPRA) score.
64 | UNOS_CPRA_DT | DATETIME | No |
The most recent United Network for Organ Sharing (UNOS) Calculated Panel Reactive Antibodies (CPRA) score update date.
65 | TXP_EVAL_END_DT | DATETIME | No |
Date on which the transplant evaluation was completed for the patient.
66 | UNOS_IN_STATUS | VARCHAR | No |
The most recent United Network for Organ Sharing (UNOS) intestine status.
67 | UNOS_IN_STATUS_DT | DATETIME | No |
The date of the most recent United Network for Organ Sharing (UNOS) intestine status.
68 | TXP_CENTER_C_NAME | VARCHAR | No |
The transplant center that owns the patient episode.
The category values for this column were already listed for column: TX_HIST_CENTER_C_NAME
69 | TXP_SURG_DTTM | DATETIME (UTC) | No |
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.
70 | HEIGHT_AT_TXP | NUMERIC | No |
The donor or recipient's height at transplant, in cm.
71 | WEIGHT_AT_TXP | NUMERIC | No |
The donor or recipient's weight at transplant, in kg.
72 | TOBACCO_USE_AT_TXP_C_NAME | VARCHAR | No |
The donor or recipient's tobacco usage at transplant.
May contain organization-specific values: No
Category Entries:
Every Day
Some Days
Smoker, Current Status Unknown
Former
Never
Never Assessed
Passive Smoke Exposure - Never Smoker
Unknown
Heavy Smoker
Light Smoker
73 | ALCOHOL_USE_AT_TXP_C_NAME | VARCHAR | No |
The donor or recipient's alcohol usage at transplant.
May contain organization-specific values: No
Category Entries:
Yes
No
Not Asked
Defer
Not Currently
Never
74 | DRUG_USE_AT_TXP_C_NAME | VARCHAR | No |
The donor or recipient's drug use at transplant.
May contain organization-specific values: No
Category Entries:
Yes
No
Not Asked
Defer
Not Currently
Never
75 | UNOS_CAS | NUMERIC | No |
Most recent lung composite allocation score
76 | UNOS_CAS_DATE | DATETIME | No |
The date of the most recent CAS subscore.