CDM Table name: visit_detail
Reading from tumour, treatment
| Destination Field | Source field | Logic | Comment field |
|---|---|---|---|
| visit_detail_id | Autogenerate | ||
| person_id | e_patid | ||
| visit_detail_concept_id | 38004268 - Ambulatory Health Care Facilities, Clinic / Center, Oncology | ||
| visit_detail_start_date | diagnosisdatebest eventdate | ||
| visit_detail_start_datetime | diagnosisdatebest eventdate | ||
| visit_detail_end_date | Set as visit_detail_start_date | ||
| visit_detail_end_datetime | Set as visit_detail_start_datetime | ||
| visit_detail_type_concept_id | 32879-Registry | ||
| provider_id | |||
| care_site_id | |||
| visit_detail_source_value | SOURCE_TABLE_NAME | ‘Tumour’ / ‘Treatment’ | |
| visit_detail_source_concept_id | 0 | ||
| admitted_from_concept_id | |||
| admitted_from_source_value | |||
| discharged_to_source_value | |||
| discharged_to_concept_id | |||
| preceding_visit_detail_id | Put the visit_detail_id of the last VISIT_DETAIL | ||
| parent_visit_detail_id | |||
| visit_occurrence_id | Put the visit_occurrence_id of the VISIT_OCCURRENCE record that the VISIT_DETAIL record belongs to |