Yeah, it's confusing. Here is what is on the table.
condition_type_concept_id: where the record was taken from.
- EHR - problem list, chief complaint, referral, observation, diagnostic test, billing diagnosis, encounter diagnosis
- Claim - header, detail
condition_status_concept_id: When the diagnosis in the process of healthcare was derived (Rimma's proposal):
- Admitting diagnosis: 4203942
- Final or discharge diagnosis: 4230359
- Preliminary diagnosis: 4033240
Now we need to bake the primary, first, second ... 34th into it. What's the difference between first and primary?
Somebody at some point said we only need primary, first, second-and-all-others. We could permute these with the 3 above and be done.
Inpatient and outpatient should not be here at all. That's in the VISIT.