The Learning Healthcare (Data) System: Virtual Data Warehouse Data Capture Revisited

Background/Aims: At the 2014 HCSRN annual meeting, Bachman and colleagues presented an excellent investigation into rates of encounters and drug fills at Virtual Data Warehouse (VDW) sites in order to evaluate (among other things) the VDW enrollment file’s “OUTSIDE_UTILIZATION” field, which purporte...

Full description

Saved in:
Bibliographic Details
Published inJournal of Patient-Centered Research and Reviews Vol. 3; no. 3; pp. 226 - 227
Main Authors Aumer, Susan M, Hoch, Brian A, Ng, Dan, Mathur, Priyam, Hornbrook, Mark C, Harding, William H, Wong, Carmen C, Bachman, Don, Pardee, Roy E, Cleveland, Catherine R, Jordan, Celia, Meier, Jeremy
Format Journal Article
LanguageEnglish
Published Aurora Health Care, Inc 15.08.2016
Subjects
Online AccessGet full text

Cover

Loading…
Abstract Background/Aims: At the 2014 HCSRN annual meeting, Bachman and colleagues presented an excellent investigation into rates of encounters and drug fills at Virtual Data Warehouse (VDW) sites in order to evaluate (among other things) the VDW enrollment file’s “OUTSIDE_UTILIZATION” field, which purported to flag periods during which complete data capture of either pharmacy or encounter data was suspect. That investigation revealed serious problems with the flag, calling its usefulness into question. Taking this to heart, the VDW enrollment workgroup proposed removing this field and adding a suite of six new flags intended to express confidence in the capture of pharmacy, laboratory, outpatient encounter, inpatient encounter, tumor and electronic medical record data individually. These flags are assigned by local VDW analysts on the basis of their knowledge of data capture limitations at their respective sites for identifiable subgroups of patients. VDW programs were written and tested for creating these new data incompleteness variables. All HCSRN sites were invited to run these programs and share their results. Methods: Modeled after Bachman et al.’s work, we calculated rates of pharmacy fills, lab results, encounters, tumor records and vital signs by the appropriate new flag. We then plotted these rates over time to see whether in fact the people/periods flagged as having suspect data capture did in fact have lower rates compared to those who/that were not. Results: At the sites that implemented the flags, data capture rates generally varied in line with expectations — suspected incomplete groups had markedly lower rates. Of the six flags, “incomplete_rx” saw the best implementations, with all seven implementing sites showing clear distinctions between people whose data capture was suspect and those for whom it was not. “Incomplete_tumor” had the most variable implementations, with clear distinctions at some sites but not others. Conclusion: On balance, the new flags stand to improve the quality of data-based research in the HCSRN. Projects needing to define populations at risk of exposure to particular pharmacy fills, tumors or lab result values, for example, would do well to use the new flags to screen out people for whom exposure risk may not be completely captured.
AbstractList Background/Aims: At the 2014 HCSRN annual meeting, Bachman and colleagues presented an excellent investigation into rates of encounters and drug fills at Virtual Data Warehouse (VDW) sites in order to evaluate (among other things) the VDW enrollment file’s “OUTSIDE_UTILIZATION” field, which purported to flag periods during which complete data capture of either pharmacy or encounter data was suspect. That investigation revealed serious problems with the flag, calling its usefulness into question. Taking this to heart, the VDW enrollment workgroup proposed removing this field and adding a suite of six new flags intended to express confidence in the capture of pharmacy, laboratory, outpatient encounter, inpatient encounter, tumor and electronic medical record data individually. These flags are assigned by local VDW analysts on the basis of their knowledge of data capture limitations at their respective sites for identifiable subgroups of patients. VDW programs were written and tested for creating these new data incompleteness variables. All HCSRN sites were invited to run these programs and share their results. Methods: Modeled after Bachman et al.’s work, we calculated rates of pharmacy fills, lab results, encounters, tumor records and vital signs by the appropriate new flag. We then plotted these rates over time to see whether in fact the people/periods flagged as having suspect data capture did in fact have lower rates compared to those who/that were not. Results: At the sites that implemented the flags, data capture rates generally varied in line with expectations — suspected incomplete groups had markedly lower rates. Of the six flags, “incomplete_rx” saw the best implementations, with all seven implementing sites showing clear distinctions between people whose data capture was suspect and those for whom it was not. “Incomplete_tumor” had the most variable implementations, with clear distinctions at some sites but not others. Conclusion: On balance, the new flags stand to improve the quality of data-based research in the HCSRN. Projects needing to define populations at risk of exposure to particular pharmacy fills, tumors or lab result values, for example, would do well to use the new flags to screen out people for whom exposure risk may not be completely captured.
Author Ng, Dan
Jordan, Celia
Wong, Carmen C
Mathur, Priyam
Cleveland, Catherine R
Hornbrook, Mark C
Harding, William H
Meier, Jeremy
Aumer, Susan M
Bachman, Don
Hoch, Brian A
Pardee, Roy E
Author_xml – givenname: Susan M
  surname: Aumer
  fullname: Aumer, Susan M
– givenname: Brian A
  surname: Hoch
  fullname: Hoch, Brian A
– givenname: Dan
  surname: Ng
  fullname: Ng, Dan
– givenname: Priyam
  surname: Mathur
  fullname: Mathur, Priyam
– givenname: Mark C
  surname: Hornbrook
  fullname: Hornbrook, Mark C
– givenname: William H
  surname: Harding
  fullname: Harding, William H
– givenname: Carmen C
  surname: Wong
  fullname: Wong, Carmen C
– givenname: Don
  surname: Bachman
  fullname: Bachman, Don
– givenname: Roy E
  surname: Pardee
  fullname: Pardee, Roy E
– givenname: Catherine R
  surname: Cleveland
  fullname: Cleveland, Catherine R
– givenname: Celia
  surname: Jordan
  fullname: Jordan, Celia
– givenname: Jeremy
  surname: Meier
  fullname: Meier, Jeremy
BookMark eNpNkMFLwzAUxoNMcM6dveaoh25J06apN6nTCQVBix5D0rzajq4tSSfsv7ddZXh4vPc-vt-D712jWdM2gNAtJSsa-XGw9hkjHuGxWNGA-BdofhZm_-YrtHRuRwihoR-xkM5RlpWAU1C2qZpvvAVV92WuLOC7J9Wre_xxdD3sH_BnZfuDqvGo4q_BULYHB9OaqK4_DMg7_FSu6sHcoMtC1Q6Wf32BsudNlmy99O3lNXlMPU0J9z1aRDSigeCGxmFohM8ICwBowSIWi6G4MZxBEYSacMMF4aEWOlfcFLE2OVug9XQ2t61zFgrZ2Wqv7FFSIk9vkWNyOSaX41sGAk-Ehs6Cc2dg1-XWniy_F6FgrA
ContentType Journal Article
DBID AAYXX
CITATION
DOI 10.17294/2330-0698.1402
DatabaseName CrossRef
DatabaseTitle CrossRef
DatabaseTitleList
DeliveryMethod fulltext_linktorsrc
Discipline Medicine
EISSN 2330-0698
EndPage 227
ExternalDocumentID 10_17294_2330_0698_1402
jpcrr1402
GroupedDBID 5VS
AAKDD
AAYXX
ADBBV
ALMA_UNASSIGNED_HOLDINGS
BCNDV
CITATION
GROUPED_DOAJ
IPNFZ
KQ8
M~E
OK1
RIG
ID FETCH-LOGICAL-b1062-1f7171486d1955d823034ee1f373987396dd63ef45b06d68065b8bca6df9bdc3
ISSN 2330-0698
IngestDate Wed Oct 23 14:17:54 EDT 2024
Tue Jan 24 20:41:10 EST 2017
IsDoiOpenAccess false
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Issue 3
Language English
LinkModel OpenURL
MergedId FETCHMERGED-LOGICAL-b1062-1f7171486d1955d823034ee1f373987396dd63ef45b06d68065b8bca6df9bdc3
OpenAccessLink https://doi.org/10.17294/2330-0698.1402
PageCount 2
ParticipantIDs bepress_primary_jpcrr1402
crossref_primary_10_17294_2330_0698_1402
PublicationCentury 2000
PublicationDate 8-15-2016
2016-08-15
PublicationDateYYYYMMDD 2016-08-15
PublicationDate_xml – month: 08
  year: 2016
  text: 8-15-2016
  day: 15
PublicationDecade 2010
PublicationTitle Journal of Patient-Centered Research and Reviews
PublicationYear 2016
Publisher Aurora Health Care, Inc
Publisher_xml – name: Aurora Health Care, Inc
SSID ssj0001527351
Score 2.007543
Snippet Background/Aims: At the 2014 HCSRN annual meeting, Bachman and colleagues presented an excellent investigation into rates of encounters and drug fills at...
SourceID crossref
bepress
SourceType Aggregation Database
Publisher
StartPage 226
SubjectTerms Supplement
Title The Learning Healthcare (Data) System: Virtual Data Warehouse Data Capture Revisited
URI http://digitalrepository.aurorahealthcare.org/jpcrr/vol3/iss3/135
Volume 3
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwnV1bS8MwFA5TQXwRrzhv5MEHZVTbps1a32QqQ9QHmZe3sjQp88I2ynzQX-TP9JwmbeMN1IeFNi2nI-cjOfdDyE4bfUeCSUe6Aotqq74TxSlcyXbYFrHMpMB854tL3r0Ozu7Cu0bjzYpaep6I_fT127yS_3AV5oCvmCX7B85WRGECroG_MAKHYfw1j89L20a3juQCqfG4j2JhbCqSo95_c58XuSL4pHULrw1A6Vf6ttMfF56EqyLXfPKxe6cls5oqrA6GdGKTz5apFaTT40xl09orlUsd5nM1emlZFT3TgTG7HtcxAN1RPhQgxT-WCUS1-bbzhIFNJgCzylg0kY7GYOFxtMDqlE29r_mMYa8b3Xx6X30zZzZmZuGP2Zusz63z2te1Bb4cBYDCANNdSspwJrh-feqVnv5Ph2EVoojKEZJIkECCBBIkMEVmfNjSIkt51_noIAYWvT6r75k6Ukjj4OOfAFVL6DBnSxiypJreApk3rKVHGluLpKGGS2T2wgRcLJMeQIyWEKM1xOgu4maPangdUgMuirO0Ape-NeCiFbhWSO_0pNfpOqYRhyM8l_uOl4HSD3ozl14chhJ9syxQystYm8UR_LiUnKksCIXLJUdfvYhE2ucyi4VM2SqZHo6Gao3QWGExocyLAiyL6aooVWmoYFeAQUWZ3yRNszTJWFdbSR7GaZ7jsjXJbrlY1cMfuLT--1c3yFwN0k0yPcmf1RbImROxXbD4Hez0d7I
link.rule.ids 315,783,787,867,27938,27939
linkProvider Directory of Open Access Journals
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=The+Learning+Healthcare+%28Data%29+System%3A+Virtual+Data+Warehouse+Data+Capture+Revisited&rft.jtitle=Journal+of+patient-centered+research+and+reviews&rft.au=Pardee%2C+Roy+E&rft.au=Bachman%2C+Don&rft.au=Hornbrook%2C+Mark+C&rft.au=Cleveland%2C+Catherine+R&rft.date=2016-08-15&rft.issn=2330-0698&rft.eissn=2330-0698&rft.volume=3&rft.issue=3&rft.spage=226&rft.epage=227&rft_id=info:doi/10.17294%2F2330-0698.1402&rft.externalDBID=n%2Fa&rft.externalDocID=10_17294_2330_0698_1402
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=2330-0698&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=2330-0698&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=2330-0698&client=summon