Table name: observation
Reading from stem_table
| Destination Field | Source field | Logic | Comment field |
| observation_id | id | | |
| person_id | person_id | | |
| observation_concept_id | concept_id | 0 if concept_id is empty | |
| observation_date | start_date | | |
| observation_datetime | start_datetime | | |
| visit_occurrence_id | visit_occurrence_id | | |
| observation_type_concept_id | type_concept_id | | |
| value_as_number | value_as_number | | |
| value_as_string | value_as_string | | |
| value_as_concept_id | value_as_concept_id | | |
| qualifier_concept_id | qualifier_concept_id | | |
| unit_concept_id | unit_concept_id | | |
| provider_id | provider_id | | |
| visit_detail_id | | | |
| observation_source_value | source_value | | |
| observation_source_concept_id | source_concept_id | | |
| unit_source_value | unit_source_value | | |
| qualifier_source_value | qualifier_source_value | | |