observation_type_concept_id for HCUP-NIS ETL

CDM Builders
7

@jenniferduryea et al:

Let’s finish this up, I feel like we have rolled this problem back and forth for too long. But: I am going to grill you a little bit for the use cases. Forgive me for the pain that will cause, but we need to have that to keep the CDM clean:

  • Observation recorded from claims data: What observations do we record from claims? The hospital file of the HCUP, like the statistical weight? Is that patient-level data? In other words: does every weight entry of a person have such a weight attached?
  • If yes: we would create (or pick) a concept and put that into the observation_table, with a fact_relationship record linking it to the weight record in the MEASUREMENT table (!!!)
  • If not: What person_id did you plan on filling, and what observation_date? I would say the right place would be a care_site addendum table.
  • Observation recorded from survey questionnaire: Makes sense to me.
  • Stratum: Again, if it is not patient related, can’t go into the Observation table. It sounds like in the HCUP it is hospital-dependent, so it could go into the proposed care_site addendum table. But if you mention NHANES I feel it has nothing to do with a hospital necessarily, either.
  • The hospital admissions: The fact that there was a hospital admission is not an observation. It should consitute a inpatient hospital visit. Or are you trying to capture that it was elective/emergeny/birth that got the patient into the hospital? If yes, you could use those concepts, and again make a fact_relationship to the visit.
  • Cost-to-charge ratio: Same thing. Not patient-level data, hence no observation. Don’t litter the “garbage can”. :smile:
  • CCS: Let me take a look at it again. We have a lot better ICD9 to SNOMED mapping now, maybe we could swallow them now, and fix the links up a bit. And I agree, they are condition classes, not observations.

Bottom line: For the hospital-specific stuff we could create a non-standard addendum table. Let me know what you want in there, and we put it into the sandbox we are planning on building. We can also then get the right Concepts for it.