200 likes | 349 Views
Data Access Framework Data Element Based Queries SWG. May 19, 2014. Meeting Etiquette. Remember: If you are not speaking, keep your phone on mute Do not put your phone on hold – if you need to take a call, hang up and dial in again when finished with your other call
E N D
Data Access FrameworkData Element Based Queries SWG May 19, 2014
Meeting Etiquette • Remember: If you are not speaking, keep your phone on mute • Do not put your phone on hold – if you need to take a call, hang up and dial in again when finished with your other call • Hold = Elevator Music = very frustrated speakers and participants • This meeting, like all of our meeting is being recorded • Another reason to keep your phone on mute when not speaking • Feel free to use the “Chat” feature for questions, comments or any items you would like the moderator or participants to know. From S&I Framework to Participants: Hi everyone: remember to keep your phone on mute NOTE: This meeting is being recorded and will be posted on the DAF Wikipage, under “Materials” “Past Meetings”
Notional Project Timeline S&I Lifecycle (Discovery Pilot & Evaluation) January2014 February March April May June Today 5/19 UC 2 Consensus (2/5) Draft DAF/IHE White Paper Complete (2/28) DAF/IHE White Paper Published Discovery (Use Case 2) IGConsensus UC 2: Targeted Data Access: Inter-Organizational Query Define Use Case & Functional Requirements Implementation (DAF/IHE Community) IHE Activities White Paper Comment Period White Paper Comment Period DAF IHE/ S&I Joint Work Group DAF IHE/ S&I Joint WG Implementation (S&I Community) TWG 1: Document Metadata based access for LDAF & TDAF Candidate Standards Analysis Finalize Actors + Transactions + Technology Stacks and Standards Create IG’s based on existing standards Implementation (S&I Community) TWG 2: Data Element based access for LDAF & TDAF Candidate Standards Analysis Finalize Actors + Transactions + Technology Stacks and Standards Signifies milestone or deliverable Create SWG to profile standards for data element access
General Announcements • Meeting Cancellations • Due to the upcoming Federal holiday (Memorial Day), the meetings that have been scheduled for Monday, May 26th will be cancelled and resume on Monday, June 2nd. • DAF IHE/S&I Joint WG (10:00 am EDT) • Data Elements SWG (3:00 pm EDT) • Direct Transport SWG (4:00 pm EDT)
General Announcements CONTINUED • We Invite Interested Members to Attend our DAF IHE/S&I Joint Work Group • The purpose of these calls will be to • 1) examine and prioritize the gaps addressed in the White Paper; and • 2) begin drafting a road map for how these gaps will be addressed • The next meeting will take place Monday, June 2nd from 10:00-11:00 am EDT) • Meeting details are as follows: • WebEx Link: https://himss.webex.com/himss/j.php?MTID=m1f0b7fff1dc2e04990e4f4053aa9e58a • Dial In: 1-650-429-3300 I Access Code: 921 401 168 I Meeting Password: meeting • This information is also posted on the DAF Wiki homepage
Data Elements • http://wiki.siframework.org/file/view/SIFramework_Consented_UC_Local_DAF_V30_12.11.2013.docx/494066132/SIFramework_Consented_UC_Local_DAF_V30_12.11.2013.docx • http://wiki.siframework.org/file/view/SIFramework_UC_Targeted_DAF_V6_02.05.2014_ConsensusApproved.docx/487531872/SIFramework_UC_Targeted_DAF_V6_02.05.2014_ConsensusApproved.docx
Query Analysis • Query Analysis: Determine the constructs that we want to allow in Data Element Based queries. • Limitations on Number of Data Elements to be included in the formation of a single query • A Query can be constructed using multiple data elements • For e.g “Get patients between ages 16 and 65, with diabetes and having a hbA1C lab result of > 7%”.
Query Analysis Cont’d • Comparators allowed in Query Specifications • Numbers, Dates >, >=, <=, and < • Strings • From FHIR: Search is case-insensitive and accent-insensitive. May match just the start of a string. String parameters may contain spaces. • Exact matches also required • Quantities • Values which are numeric • Units which are strings • Coded Concepts • May be used to search through the text, displayname, code and code/codesystem
Query Analysis Cont’d • Concept of Named Queries ? • Similar to Document Queries with ability to vary the parameters for the queries.
Query Analysis Cont’d • Logical Operators • AND • OR • NOT
Query Analysis Cont’d • Missing Information • Allow queries on missing information or presence of information ? • Specifying the data elements to be included in response • Should we allow for this in the queries ? • Responders may choose not to include all requested elements
Query Result Analysis • Query Result Analysis: Determine the constructs that we want to allow in Data Element Based queries. • Limitations on Number of Data Elements to be included in the formation of a single query • A Query Result can be constructed using multiple data elements • For e.g: Query Results may contain Patient Demographics, Problems and Meds all as a result of a single query
Query Result Analysis • Do Query Results need to allow for • Summaries ? • Paging ? • Counts ?
Query Result Analysis • Other aspects that we are missing ?
Candidate Standards • SOAP Query Stack • IHE QED and IHE CM profiles • RESTful Query Stack • FHIR DSTU • No existing profiles • Other standards for specific parts of the queries/results • HQMF V2 for Queries and QRDA category III for Results • HL7 vMR Data Model • HL7v2 Stack • QBP/RSP messages • Implementation Languages in Use • SQL, Xquery,
Data Access Framework Resources • DAF Standards, Harmonization and Implementation Activities • http://wiki.siframework.org/DAF+Standards+Harmonization+and+Implementation • DAF Wiki Homepage • http://wiki.siframework.org/Data+Access+Framework+Homepage • Become a Community Member • http://wiki.siframework.org/Data+Access+Framework+Join+the+Initiative • DAF Charter • http://wiki.siframework.org/Data+Access+Framework+Charter+and+Members • Standards and Interoperability(S&I) Framework • http://wiki.siframework.org/Introduction+and+Overview • S & I Calendar of Events • http://wiki.siframework.org/Calendar
Initiative Support Leads • For questions, please feel free to contact your support leads: • Initiative Coordinator: John Feikema john.feikema@siframework.org • ONC Sponsors: Mera Choi mera.choi@hhs.gov • Support Team: • Project Management: • GayathriJayawardenagayathri.jayawardena@esacinc.com • Technical Support: • Dragon (Nagesh) Bashyam nagesh.bashyam@drajer.com • Standards SME: • Ed Larsen ed_larsen@comcast.net • Standards Support: • Angelique Cortez angelique.j.cortez@accenture.com • Vocabulary and Terminology Subject Matter Expert: • Mark Roche, MD mrochemd@gmail.com