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
- Billing
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.
Thoughts?