| Literature DB >> 21873473 |
Nicholas Anderson1, Aaron Abend, Aaron Mandel, Estella Geraghty, Davera Gabriel, Rob Wynden, Michael Kamerick, Kent Anderson, Julie Rainwater, Peter Tarczy-Hornoch.
Abstract
OBJECTIVE: The Cross-Institutional Clinical Translational Research project explored a federated query tool and looked at how this tool can facilitate clinical trial cohort discovery by managing access to aggregate patient data located within unaffiliated academic medical centers.Entities:
Mesh:
Year: 2011 PMID: 21873473 PMCID: PMC3392860 DOI: 10.1136/amiajnl-2011-000133
Source DB: PubMed Journal: J Am Med Inform Assoc ISSN: 1067-5027 Impact factor: 4.497
Figure 1Cross-Institutional Clinical Translational Research (CICTR) network security diagram (simplified) describing isolation of Shared Health Research Information Network (SHRINE) cells from direct access to i2b2 data repositories. CICTR, Cross-Institutional Clinical Translational Research project; DMZ, Demilitarized Zone; IP, Internet Protocol; JDBC, Java Database Connectivity; SSL, Secure Sockets Layer; UCSF, University of California, San Francisco; UW, University of Washington; VLAN, Virtual Local Area Network; VPN, Virtual Private Network.
Figure 2Local site-coordinated data loading, deidentification, and mapping processes.
Common demographics deidentification and mapping methods
| Element | Function | Method |
| MRN | Obfuscated | Site-dependent |
| DOB | Obfuscated | 1/1/YYYY |
| Gender | Mapped | HL7 v2, Table 001 |
| Age | Calculated | Relative to DOB |
| Race/ethnicity | Mapped | OMB R/E |
| Geocode | Calculated | First 3 digits and all zip codes <20 K patients clustered into State:00000 |
| Vital status | Mapped | HL7 Entity.LivingSubject.deceasedInd |
| Marital status | Mapped | HL7 v2, Table 002 |
| Language | Mapped | ISO-639.2 |
DOB, date of birth; HL7, health level 7; MRN, medical record number; OMB R/E, office of management and budget racial/ethnicity.
State: 00000 represents the state (eg, WA) associated with a blank zipcode of 00000) HL7 v2, Table 002 refers to table 002 of the HL7 standard which defines marital status.
Patient event data scope and mapping methods
| Data source | Scope | Mapping method | Terminology |
| Diagnoses | 001-999 V01-V89 E800-E999 | Association | ICD-9 |
| Medication orders | All local formularies | Instance | RxNorm |
| Laboratory orders | Diabetes-focused common LOINC subset | Instance | LOINC |
| Discharge dispositions | All | Instance | HL7 |
HL7, health level 7; ICD-9, International Classification of Disease version 9; LOINC, Logical Observation Identifiers Names and Codes; RxNorm, A standardized nomenclature for clinical drugs and drug delivery.
HL7 v2.7 target discharge disposition table
| HL7 description | HL7 code |
| Discharged to home or self-care (routine discharge) | 1 |
| Discharged/transferred to another short-term general hospital for inpatient care | 2 |
| Discharged/transferred to skilled nursing facility | 3 |
| Discharged/transferred to an intermediate care facility | 4 |
| Discharged/transferred to another type of institution for inpatient care or referred for outpatient services to another institution | 5 |
| Discharged/transferred to home under care of organized home health service organization | 6 |
| Left against medical advice or discontinued care | 7 |
| Admitted as an inpatient to this hospital | 9 |
| Discharge to be defined at state level, if necessary | 10 |
| Law enforcement custody | 12 |
| Other, undetermined | 13 |
| Psychiatric facility | 14 |
| Discharge to federal hospital | 15 |
| Expired (ie, dead) | 20 |
| Still patient or expected to return for outpatient services (ie, still a patient) | 30 |
Figure 3Return of aggregated and blurred results across Cross-Institutional Clinical Translational Research (CICTR) network.
Cross-Institutional Clinical Translational Research population as of April 15, 2011
| Site | Archive history | Update frequency | Patient count in thousands |
| UW | 5 years | Daily | 1460 |
| UCSF | 4 years | Daily | 3090 |
| UCD | 7 years | Daily | 706 |
| Total | 5256 |
UCSF, University of California, San Francisco University of California, Davis; UW, University of Washington.
Figure 4Descriptive spiral model of implementation phases and stakeholders. CER, Comparative Effectiveness Research; ETL, Extraction, Transformation and Loading SHRINE - Shared Health Research Information Network; IRB, Institutional Review Board; i2b2, Informatics for Integrating Biology and the Bedside