This is an old revision of the document!
Issue | Options |
---|---|
Generic | |
Low quality records | 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 | |
Socioeconomic, marital, language | Create conventions for Concepts |
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 |