observation_type_concept_id for HCUP-NIS ETL

[jenniferduryea (Jen Duryea)]

@Christian_Reich

The types are not attributes. The are the provenance.

We understand that observation_type_concept_id captures the origin of the data, but there don’t appear to be concepts for “Observation recorded from claims data” or, in our case “Observation recorded from survey questionnaire”. Those are two concepts we’d like added.

As for the observations we’re trying to capture, most of them are statistical weights, not patient measurements. Please see the documentation from HCUP about how these weights are used to create national estimates from survey data: Overview to the HCUP Nationwide Inpatient Sample (NIS), 2001 Please see specific responses to your reply below.

@Christian_Reich

So, “discharge weight” is a concept that should go into the observation_concept_id (actually measurement_concept_id) as weight, and the Observation Type should be “Observation recorded from EHR”. If you want to specifically make sure it is clear that it is in a separate discharge record we could add “Discharge Record”. Is it? Where are you getting that information from?

See DISCWT variable in HCUP documentation listed above. I have not found a good CONCEPT_ID for this. As you can see, @Mark_Danese asked about this in another post ( Survey weights (statistical weights) in CDM ) but the answers there do not seem satisfactory. Not sure what was done for NHANES.

@Christian_Reich

Stratum: don’t know what that is.

See NIS_STRATUM variable in HCUP documentation listed above. This is specific to statistical analysis - not patient related. I have not found a good CONCEPT_ID for this, similar to the Discharge Weight variable.

@Christian_Reich

Admission type: again, where is this coming form? EHR record? Say so. And put the actual admission type into the observation_concept_id.

I have found the following concept_ids for admission status: 4079617 , 4331002 , 4314435 , 4046034, 8715

@Christian_Reich

Discharge status: We have that already.

I found the concept_ids for discharge status as well.

@Christian_Reich

Cost-to-charge ratio: Isn’t that specific to a specific cost?

HCUP reports the cost-to-charge ratio on a per hospital basis. The hospital reports their overall cost-to-charge ratio for the survey questionnaire. I have no found a good CONCEPT_ID for this. I have asked the community for their assistance in this forum post ( Observation_concept_id for Cost-to_Charge ratios ) but no one has responded. Probably because there isn’t a good one. And I’m not sure how to solve this problem.

@Christian_Reich

CCS codes: We had them as its own vocabulary with mostly Condition concepts, but we kicked them out. Too messy. Do you need them? if they are not chief complaint, just put them in as EHR record, and fine.

I would love to put CCS codes in the Condition table as their own vocabulary. I see these used a lot in survey data, and sometimes in claims data. But, since that option is not available anymore, I was going to put them in the Observation table. I’ll try to find relevant CONCEPT_IDs for them. I’ll let you know what I find.

@Christian_Reich

Hospital information: We don’t have that in the CDM. Do you want to add it to your Provider table?

I would love to add this information to the care_site table (not the Provider table, since that is for physicians). But these fields (hospital bed size and teaching facility status, specifically) are not available in the care_site table. So I was adding these to the Observation table because it doesn’t fit anywhere else. I’m not finding viable CONCEPT_IDs for these fields either. Suggestions?

Thanks!