Transcription
HONEST BROKERDATA DICTIONARYClinical Research Data WarehouseResearch Data Toolsi2b2 & TriNetX query tools help research teams discover and validate patient cohorts usingexisting well-aggregated, de-identified clinical data from various sources.Honest Broker is an IRB-approved research data extraction tool.CTSI Biomedical Informatics TeamCRDW@mcw.edu
Table of ContentsClinical Research Data Warehouse (CRDW) . 3CRDW Tools . 3Data Sources (w/start date) . 4Data Integrity Partners . 4Data Access (Data Release Agreements) . 4Data Team/Support . 4Honest Broker Tables . 5Allergy History . 5Biospecimens (Froedtert Only) . 5Diagnosis (Dx) . 6Diagnostic Results . 7Encounters . 8Encounters – Future Appointments – Identified Extract Only. 9Genomics (Froedtert Only) . 9Imaging Orders (Froedtert Only) . 11Immunization. 12Medication Orders . 13Medications Administered . 14NAACCR Data (Froedtert Only) . 15Ob/Gyn Mother & Baby Data (Froedtert Only) . 17Patient Demographics . 19Patient Contact Info – Identified Extract Only . 20Problem List . 20Procedures (Px) . 21Social History – Lifestyle . 22Vitals . 25Value Sets . 26Encounter Type [enc type] . 26Diagnosis Source [dx source] . 26Ethnicity [hispanic c] . 26Race [race c] . 26Result Modifier . 27References . 27Change Log . 27CTSI Honest Broker Data Dictionary, version 2.7, May 2021Page 2
Clinical Research Data Warehouse (CRDW)The CRDW is an aggregation of de-identified clinical data from various sources. De-identified patient data can be accessed through query tools and extracted using the HonestBroker tools Identified patient data can be extracted by researchers who have an approved IRB protocolusing the Honest Broker Identified Extract process PHI Protected Health Information - not available on de-identified tablesCRDW ToolsAll CTSI data warehouse tools are available at https://ctri.mcw.edu/resources/bmi-links/Data Warehouses Froedtert & The Medical College of Wisconsino Froedtert Hospital in Milwaukeeo Froedtert Menomonee Falls (Community Memorial Hospital)o Froedtert West Bend (St. Joseph Hospital West Bend)o Community Physicians clinicso Medical College of Wisconsin clinics Children’s Wisconsin (Children’s Specialty Group data only)Query Tools i2b2 – Informatics for Integrating Biology and the Bedside TriNetX ( https://www.trinetx.com/trinetx-live/ )Data Extraction Tools Honest Broker (HIPAA-compliant, IRB-approved)o De-identifiedo IdentifiedCTSI Honest Broker Data Dictionary, version 2.7, May 2021Page 3
Data Sources (w/start date) Epic EHR (electronic health record) Systemso Froedtert & Medical College of Wisconsin (October 2004)o Community Memorial Hospital (May 2012)o Community Physicians Clinics (July 2013)o St. Joseph West Bend (September 2013)o Children’s Hospital (November 2013)§ Children’s Specialty Group only (Children’s Medical Group data not available)Foundation Medicine genetic testing results ( 2007, low n)Froedtert Hospital legacy systems retired in 2012o Affinity (clinical ordering and billing system)o Intellidose (oncology treatment protocol system)o SIS (surgical documentation system)GE/IDX Physician Billing System ( 1999 to 11/30/2018)o Group 3 Medical College Physicianso Group 4 Children’s Specialty Groupo Group 7 FMCCP (Community Physicians)NAACCR Tumor Registry (SJH – 2001, CMH - 1989, FMLH – 1989)OnCore Clinical Trials Management Systemo Biospecimen data from MCW tissue bank (2012)o Clinical Trials enrollment (yes/no)Data Integrity Partners MCW Institutional Review Board (IRB)Froedtert Office of Clinical Research and Innovative Care Compliance (OCRICC)F&MCW Epic Core Team, Clinical Informatics & Pharmacy InformaticsData Access (Data Release Agreements)Our access form is available at https://ctri.mcw.edu/cda/crdw/ PI should complete one Data Release Agreement (DRA) per project If you are in the early stages of project development, you may be general in your descriptionof desired data elements and intended use of our tools. A DRA for an existing project can bemodified manually to add new team members upon request to the user access contact below.Data Team/SupportTechnical Issues i2b2 or Honest Broker, contact CRDW@mcw.edu TriNetX, contact support@trinetx.comUser Access & Training Contact Kris Osinski, CTSI Biomedical Informatics Business Analysto kosinski@mcw.edu or 414-805-7245 (office)CTSI Honest Broker Data Dictionary, version 2.7, May 2021Page 4
Honest Broker TablesAllergy HistorySource: EpicPrimary date for sort/filter: i2b2 start date (this is a coalescence of two date fields)*Table Granularity: each row represents a documented instance of a specific reaction for a specificallergen documented during a specific allergy review session for a specific patient, so a single patientcould have multiple rows even if they have only one allergen in their recordColumnDescriptionEncrypted?mrn*Note: Froedtert MRN is in 00000000 formatPHIpatient num*Masked i2b2 patient numberYeshx allergen id*ID of the Epic allergen from allergy historyline*The position of the allergen within the Epic allergy listhx descriptionName of the allergen (agent) from allergy historyallergen type cID of the allergen typeallergen type nameName of the allergen type (e.g., Environmental, Food)reaction c*ID of the Epic reaction categoryreaction nameName of the Epic reaction category (e.g., Skin – rash vs. hives)hx reaction commentFree text reaction commentsi2b2 start datealrgy hx entry dttmThis represents the hx noted date. If this field is empty then it Yes, shiftedrepresents the alrgy hx entry dttm.The date the patient made it known that they had experiencedYes, shiftedan allergic reactionThe date the allergy history was entered into EpicYes, shiftedhx status cID of the allergy history statushx status nameName of the allergy history status: Active/Deletedhx allergy type cID of the allergy type category. This value represents the natureor character of the allergy.Name of the allergy type (e.g., side effect, intolerance)hx noted datehx allergy type namehx severity cPHIhx severity nameID of the allergy severity category. This value represents howserious the allergy is.Name of the allergy severity category (High/Medium/Low)alrgy hx dlt cmtFree text reason for allergy deletionPHIBiospecimens (Froedtert Only)Source: OnCore, specimen tracking system used by MCW Tissue BankPrimary date for sort/filter: created on date*Table Granularity: each row represents a specific diagnosis code from a specific specimen bar codefor a specific patient, so a single patient could have multiple rows even if they have only onespecimen bar code stored in the tissue bankColumnDescriptionEncrypted?mrn*Note: Froedtert MRN is in 00000000 formatCTSI Honest Broker Data Dictionary, version 2.7, May 2021PHIPage 5
patient num*Masked i2b2 patient numberYescreated on dateThe date the biospecimen record was created in OnCoreYes, shiftedpathology statusPathologist’s determination; unknown if not reviewedspecimen bar code*specimen typeMCW Tissue Bank identifier, need this ID with leading zeroformat to request tissue in iLabThe preparation method of the biospecimenbody siteThe anatomical site from which the specimen was takentumor siteAdditional detail about the body siteinitial diagnosis*Clinical indication(s) from the encounter in which thebiospecimen was takenIndicates the owner of the banked tissueprotocol nameNoDiagnosis (Dx)Sources: Epic, GEIDX professional billing (Froedtert Affinity data planned for future!)Primary date for sort/filter: dx date*Table Granularity: each row represents a specific diagnosis code from a specific encounter for aspecific patient, so a single patient could have multiple rows even if they have only one encounter intheir recordColumnDescriptionEncrypted?mrn*Note: Froedtert MRN is in 00000000 formatPHIpatient num*Masked i2b2 patient numberYesencounter num/id*ID of the encounter (may be fabricated if not from Epic)Yesenc type (see value set)Category for broad characterization of encounter typedx dateDate of the encounter associated with the diagnosisprovider idEpic ID for the provider linked to the diagnosis codeprovider nameName of the provider linked to the diagnosis codeprovider titleCredentials of the provider linked to the diagnosis codedx nameDescription of the ICD diagnosis codedx code*ICD diagnosis codedx type9 ICD-9, 10 ICD-10dx source (see value set)Indicates the specific type of source for the diagnosis datadx originIndicates the broad source of the diagnosis datapdx (principal dx indicator)P Principal diagnosis, S Secondary diagnosisraw pdxProvides the specific source of the diagnosis codesourcesystem cdIndicates the source system for the data (e.g., IDX, Epic)CTSI Honest Broker Data Dictionary, version 2.7, May 2021Yes, shiftedPage 6
Diagnostic ResultsSource: Epic, Mosaiq (future for Froedtert only)Primary date for sort/filter: i2b2 date*Table Granularity: each row represents a specific result component from a specific procedure orderfrom a specific encounter for a specific patient, so a single patient could have multiple rows even ifthey have only one encounter in their recordColumnDescriptionEncrypted?mrn*Note: Froedtert MRN is in 00000000 formatPHIpatient num*Masked i2b2 patient numberYesencounter num/id*ID of the encounter (may be fabricated if not from Epic)Yesi2b2 dateRepresents a coalesce of specimen date and result dateYes, shiftedloinc codehttps://loinc.orgcomponent id*LOINC coding is a standardized terminology for healthmeasurements, observations and documentsID of the Epic clinical result componentcomponent nameName of the Epic clinical result componentres quant or qualIndicat
DATA DICTIONARY Clinical Research Data Warehouse CTSI Biomedical Informatics Team CRDW@mcw.edu Research Data Tools i2b2 & TriNetX query tools help research teams discover and validate patient cohorts using existing well-aggregated, de-identified clinical data from various sources. Honest Broker is an IRB-approved research data extraction tool. CTSI Honest Broker Data Dictionary
