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)
William Beaumont Hospital (Royal Oak, MI)
Children's Hospital of Michigan (Detroit, MI)
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)
Spectrum Health (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 Hospital & Medical Center (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)
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.