HDC
Who suggested the Kratos moniker?
Michelle
What's the fully specified phrase of the acronym CDM?
Common Data Model
You can find all visits in CDW in the visit_occurrence table. T or F.
False: canceled visits, no shows and other non-events are excluded from OMOP
Where are the Medical History data located in OMOP?
Observation table
What's the fully specified phrase of the acronym OLI?
OMOP Learning Initiative
What's the fully specified phrase of the acronym OMOP?
Observational Medical Outcomes Partnership
What are the 4 major sources of data for drug_exposure?
MedicationOrderFact, MedicationAdministrationFact, MedicationDispenseFact, and ImmunizationEventFact
What integers are reserved for custom coding concept_ids?
> 2 billion
Where are the Blood transfusion data located in OMOP?
Device Exposure table
What OMOP version is our Kratos?
v5.3.1
What's the fully specified phrase of the acronym OHDSI?
Observational Health Data Sciences and Informatics
How do you get a lab result in OMOP?
Look for the lab result in the value_as_number, value_source_value and value_as_concept_id fields of the Measurement table
What is/are the standard vocabulary/s for drug data?
RxNorm, RxNorm Extension, CVX
Where are the Family History data located in OMOP?
It's not :)
How many tables do we have in Kratos? Excluding Vocabulary tables
16: Care Site, Condition Era, Condition Occurrence, Death, Device, Drug Era, Drug Exposure, Location, Measurement, Observation, Observation Period, Person, Procedure Occurrence, Provider, Visit Detail, Visit Occurrence
OHDSI published a book. What is the name of the book?
The Book of OHDSI
How do you find all patients with ICD10CM code = R63.5 in the OMOP CDM? Describe the process
1. Find the concept_id Where Concept.concept_code = 'R63.5' Where vocabulary_id = 'ICD10CM'
2. Map the concept_id from step 1 to a standard concept_id via the Concept Relationship table Where concept_id_1 = answer from step 1 AND relationship_id = 'Maps to'.
3. Use the standard concept_id to look up the distinct Condition_Occurrence.person_id where condition_concept_id = answer from step 2
Which table do you use to find all child concepts for a drug ingredient?
Concept Ancestor
Where are the Chief Complaint data located in OMOP?
Observation table
Kratos is the Greek god of _____
The divine personification of strength
What government agency called for the creation of a “Postmarket Risk Identification and Analysis” system? (This is the basis for OMOP)
FDA
Why would a device have a NULL start date?
The Person already had the device upon entering our healthcare system/data stream
Approximately (within 5%) how many custom concept_ids has Melanie created?
7462, 7089 - 7835
Where are the ADT (admissions, discharge, transfers) data located in OMOP?
Visit Detail table