CDM Table name: stem_table
The STEM table is a staging area where CPRD Aurum source codes will first be mapped to concept_ids. The STEM table itself is an amalgamation of the OMOP event tables to facilitate record movement. This means that all fields present across the OMOP event tables are present in the STEM table. After a record is mapped and staged, the domain of the concept_id dictates which OMOP table (Condition_occurrence, Drug_exposure, Procedure_occurrence, Measurement, Observation, Device_exposure) the record will move to. Please see the STEM -> CDM mapping files for a description of which STEM fields move to which STEM tables.
Fields in the STEM table
| Field |
|---|
| id |
| domain_id |
| person_id |
| visit_occurrence_id |
| provider_id |
| start_datetime |
| concept_id |
| source_concept_id |
| type_concept_id |
| operator_concept_id |
| unit_concept_id |
| unit_source_value |
| start_date |
| end_date |
| range_high |
| range_low |
| value_as_number |
| value_as_string |
| value_as_concept_id |
| value_source_value |
| end_datetime |
| verbatim_end_date |
| days_supply |
| dose_unit_source_value |
| lot_number |
| modifier_concept_id |
| modifier_concept_id |
| modifier_source_value |
| quantity |
| refills |
| route_concept_id |
| route_source_value |
| sig |
| stop_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 |