| person_id | patient_deiden_id | | |
| visit_occurrence_id | merged_enc_id | | |
| visit_detail_id | encounter_deiden_id | | |
| condition_occurrence_id | | | Auto-increment |
| condition_concept_id | diag_icd_typediag_code | | |
| condition_start_date | start_date | | |
| condition_start_datetime | start_date | | |
| condition_end_date | end_date | | |
| condition_end_datetime | end_date | | |
| condition_type_concept_id | | | fill ‘32817' for EHR source, '32844' for Facility Claim, '32871' for Professional claim, '32810' for claim |
| condition_status_concept_id | poaimputed_poa | | |
| condition_poa | poaimputed_poa | | |
| condition_status_source_value | problem_list_status | | |
| provider_id | | | Not Populated |
| stop_reason | | | Not Populated |
| condition_source_value | | | Populated based on diag_icd_type and diag_code. |
| condition_source_concept_id | | | Populated based on diag_icd_type and diag_code. |
