Sidebar
projects:workgroups:themis:focusgroup3
Group Leader: Asha Mahesh
THEMIS Bi-weekly Meeting (Skype Meeting) Occurs every other Tuesday from 10:00 AM to 11:00 AM.
Join Skype Meeting https://meet.lync.com/quintiles-quintilesims/mui.vanzandt/7Z24VJ8Z
Join by phone Toll number: +1 (646) 838-2458,,88328055# (Dial-in Number) English (United States) Conference ID: 88328055
Meeting Minutes:
Meeting notes from Nov 29th:
- Team discussed several items on the issue list
- Schedule follow up meeting for further discussion. Observe the efficiency of remote/webex meeting and make a decision to meet in-person as needed
- Please review the spreadsheet and socialize discussed topics on OHDSI forums to gather input
| Issue | Options |
|---|---|
| Generic | |
| Low quality records, e.g. CPRD “researchable patient” flag | Kick out/create variable for CDM WG |
| Data inclusion | Create summary guideline, report % loss |
| Start Date before Observation Period | History of/First date of Observation Period |
| End Date - same day issue | Special times (0.00 and 23.59)/Blank |
| Socioeconomic, marital, language Concepts | Create conventions for Concepts |
| Flavors of 0 | Document |
| Source Value combo code+vocab | Concatenate/Leave blank and use Source Concept |
| Source Value combo more than one | Concatenate/Leave blank and use Source Concept |
| Source Value combo code+name | Concatenate/Leave blank and use Source Concept |
| Source Concepts for local variables | Abolish SOURCE_TO_CONCEPT_MAP and develop guidelines for creating Source Concepts >2B |
| Source Concept=0 for Achilles | make not nullable for OMOP CDM |
| Negative integers | Develop guideline |
| Invalid numbers | Develop guidelines |
| CONDITION | |
| Concepts privacy issues | Data deleted for privacy in record/Mark deletions in metadata/Establish Black List/Remove patients entirely/Set to 0 |
| Convert data from surveys? | Keep in Observation/Add, with explicit Type Concept |
| Dedup? | Pick the highest Type Concept |
| Clean up Type Concepts | Keep precedence, drop visit type |
| Derive pregnancies? | Introduce |
| Visit_occurrence_id mandatory? | |
| ICD Source value: With or without dots | Irrelevant with mandatory Source Concepts |
| DRUG | |
| Duplicates for same day | Don't dedup |
| End date guessing for prescribed, administered, mail-ordered | |
| Sig | Clean up and develop standard |
| Contradiction between Sig, end date, days supply, amount | ETLer's problem |
| Dose Era logic | |
| Patient reported drugs | Use |
| Stop reason | Consider abolishing after polling |
| Link between orders, administration, dispensing and filling | Publish guidelines |
| HCPCS and NDC on same line | Consider heuristic for picking |
| J code units | Consider placing in quantity field |
| NDC9 to 11 mapping contradictions | Consider polling and vocab fix |
| NDC non-unique Concepts over time | Create Black List |
projects/workgroups/themis/focusgroup3.txt · Last modified: 2018/10/31 14:45 by galiat
