MelaniePhilofsky
MelaniePhilofsky
Colorado is on DQD v1.3.1, so this might already be available in v1.4 of the DQD. Add a check for duplicate Death.death_id Add a check for duplicate Death.person_id Add a...
The Measurement.value_as_number guidance states "If there is a negative value coming from the source, set the VALUE_AS_NUMBER to NULL, with the exception of the following Measurement" and then lists 7...
Per this [Themis issue](https://github.com/OHDSI/Themis/issues/29), the following guidance has been given on how to properly bring family history into the Observation table. The observation_concept_id should be ‘4210989', Family history with explicit...
The OutPatient visit definition in the conventions section of the Visit Occurrence table isn't very clear. Per the forum post [here]([Outpatient Visit](https://athena.ohdsi.org/search-terms/terms/9202): Person visiting dedicated ambulatory healthcare institution, at a...
As stated in the title, the Specimen table lacks a FK to the Visit Occurrence (VO) and Visit Detail (VD) tables. All other clinical event tables have a FK to...
The historical event for a person should be recorded in the Observation table using the following as guidance to properly populate the observation_concept_id field: (i) an all-in-one bucket [History of...
The [Visit Occurrence CDM v5.4 specifications 1](https://ohdsi.github.io/CommonDataModel/cdm54.html#VISIT_OCCURRENCE) suggest the following: "For Inpatient Visits ongoing at the date of ETL, put date of processing the data into visit_end_datetime and visit_type_concept_id with...
Currently, the country_concept_id [guidance](https://ohdsi.github.io/CommonDataModel/cdm54.html#Health_System_Data_Tables) for CDM v5.4 points us to [standard concept_ids WHERE domain_id = 'Geography'](https://athena.ohdsi.org/search-terms/terms?domain=Geography&standardConcept=Standard&page=1&pageSize=15&query=&boosts). However, it should point us to [WHERE standard_concept = 'S' AND vocabulary_id = 'OSM'...
I am not sure if this is a DQD issue or a CDM documentation issue. But the check doesn't match the conventions. Let me know if this is a DQD...
It would be helpful if the Athena download page had a flag for each Vocabulary if the Vocabulary contains standard concept_ids. Example: CPT4 immunization codes can map to standard concepts...