ADT data coming in from the source CDM should be mapped to VISIT_DETAIL domain

[stephanieshong]

Add VISIT_DETAIL domain to all CDM pipeline

OMOP: VISIT_DETAIL map to VISIT_DETAIL

pk should be mapped to newly generated n3c ids pk should exist in the payload, if not they should be added to rejected_visit_detail

done

PCORNet : map OBS_GEN to VISIT_DETAIL IF obsgen_type == UD_ADTEVENT

• OBSGEN_CODE contains the VISIT_DETAIL_CONCEPT_ID, see below obgen_code = visit_detail_concept_id, should be one of the three values: ICU maps to OMOP concept ID 581379 "Inpatient Critical Care Facility" ED maps to OMOP concept ID 8870 "Emergency Room - Hospital" OMOP concept ID 8717 "Inpatient Hospital"

• patid should match the site_person_id

• Need to confirm if encounterid should match the site_visit_occurrence_id

• place the source value in the VISIT_DETAIL_SOURCE_VALUE field. obsgen_source | raw_obsgen_name | raw_obsgen_code | raw_obsgen_type

• the encounterid in obs_gen be found in the encounter table and if it is not found, separately build reject4visit_detail dataset should be created for the site. And it should not be added to the visit_detail domain. The obgen_id will be used as reference id for site_visit_detail_id. The encounteid is used to set the site_visit_occurrence_id.

  done

ACT: map observation_fact to VISIT_DETAIL if concept_cd contains one of the following: N3C:ADT_ED, N3C:ADT_ICU, N3C:ADT_OTHER.

• encounter_num should match the site_visit_occurrence_id
• patient_num should match the site_person_id
• concept_cd = if N3C:ADT_ED then 8870, if N3C:ADT_ICD then 581379, if N3C:ADT_OTHER should be map to 8717.
• in observation_fact, when concept_cd contains one of the following N3C:ADT_ED, N3C:ADT_ICU, N3C:ADT_OTHER. should I be able to join the encounter number found in the encounter_num column in the VISIT_DIMENSION? Yes. Additionally, if not found should not be added to the VISIT_DETAIL. The pk fields of the observation_fact table should be used as the reference id for the site_visit_detail_id.

done

TriNetX : more information is needed to map ADT event data to VISIT_DETAIL domain from TriNetX CDM

waiting on further documentation

[stephanieshong]

OMOP pipeline has been updated. Plans are in place to create a new template version that includes the VISIT_DETAIL and deploy to all OMOP sites for this week's build. included in the build.

[stephanieshong]

ADT enhancement code is in with PCORnet and ACT unit test sites. Once the unit test code is validated then we can roll them out to the template source.

[stephanieshong]

ADTEvent PR to PCORNet template source, done.

[stephanieshong]

ADTEvent PR for ACT CDM done. PR merged to build visit_detail.

[stephanieshong]

• [x] OMOP
• [x] PCORNet
• [x] ACT
• [x] TriNetX

[stephanieshong]

Waiting on TriNetX data design documentation. All other CDMs are complete.

[stephanieshong]

5/25/22 -Received ADT documentation today with one site's data submission. Adding code changes to build visit_detail dataset based on today's spec.

[stephanieshong]

Completed TriNetX CDM ADT transformation code to build the visit_detail dataset.