CDM Table name: STEM
Reading from OPTUM_EHR.Prescriptions_Written
| Destination Field | Source Field | Logic | Comment |
|---|---|---|---|
| id | autogenerate | ||
| domain_id | This should be the domain_id of the standard concept in the CONCEPT_ID field. If a source code is mapped to CONCEPT_ID 0, put the domain_id as Observation. | ||
| person_id | ptid | ||
| visit_occurrence_id | |||
| visit_detail_id | |||
| provider_id | provid | Lookup the PROVIDER_ID in the PROVIDER table using provid | If provid is blank then leave PROVIDER_ID blank |
| start_date | rx_date | ||
| end_date | To find end_date, do start_date + days_supply-1 | ||
| start_datetime | rx_time | Combine rx_date and rx_time into a datetime | |
| end_datetime | Start_date + days_supply-1 and set time to midnight | ||
| concept_id | ndc | Use the SOURCE_TO_STANDARD query to map the code to standard concept(s) with the following filters: Where source_vocabulary_id = ‘NDC’ and Target_standard_concept = ‘S’ and target_invalid_reason is NULL and admin_date between valid_start_date and valid_end_date If there is no mapping available, set concept_id to zero. | When mapping a prescription drug, map the 11-digit NDC code to SOURCE_CODE in OMOP vocab first. If no mapping found, map the first 9 digits of NDC code to SOURCE_CODE. |
| source_value | ndc | ||
| source_concept_id | ndc | Use the SOURCE_TO_SOURCE query to map the code to standard concept(s) with the following filters: Where source_vocabulary_id = ‘NDC’ If there is no mapping available, set concept_id to zero. | |
| type_concept_id | 32838 | EHR Prescription | |
| operator_concept_id | 0 | ||
| unit_concept_id | |||
| unit_source_value | |||
| range_high | |||
| range_low | |||
| value_as_number | |||
| value_as_string | |||
| value_as_concept_id | |||
| value_source_value | |||
| verbatim_end_date | |||
| days_supply | days_supply | ||
| dose_unit_source_value | strength_unit | ||
| lot_number | |||
| modifier_concept_id | |||
| modifier_concept_id | |||
| modifier_source_value | |||
| quantity | quantity_per_fill | ||
| refills | num_refills | ||
| route_concept_id | route | Use the SOURCE_TO_STANDARD query to map the code to standard concept(s) with the following filters: Where source_vocabulary_id = ‘JNJ_OPTUM_EHR_ROUTE’ and Target_standard_concept = ‘S’ and target_invalid_reason is NULL If there is no mapping available, set concept_id to zero. | |
| route_source_value | route | ||
| sig | |||
| stop_reason | discontinue_reason | ||
| unique_device_id | |||
| anatomic_site_concept_id | |||
| disease_status_concept_id | |||
| specimen_source_id | |||
| anatomic_site_source_value | |||
| disease_status_source_value | |||
| condition_status_concept_id | |||
| condition_status_source_value |
Change Log:
07-Feb-2024
- Added 11-digit/9-digit NDC rule