Cost table spec improvement and interest in health economics

[katy-sadowski]

Indicating my interest, and linking these 2 other relevant threads for reference (both of which I’ve followed with interest but haven’t had time to fully process/respond). I think this all rolls up into a larger discussion around better support for health economics research in OMOP.

Vocab Request - Additional Type Concepts for Claims Provenance

Hello all, this is my first time requesting vocab modifications (but it does tie back to some previous forum conversations, linked below), so I apologize if I’m missed anything, posted in the wrong place, etc. Please see below and advise on next steps. My goal: Annotate records with provenance showing that they are from a particular claim type and include the “open”/“closed” adjudication status. As an example, a specific record may come from a “closed professional claim line” or an “open dent…

How to Differentiate Closed Claims data sets from Open Claims data sets

I’m working on the modelling / etl for healthcare claims data to OMOP. The data set has a mix of open claims (claims submitted by the providers, pre-adjudication) and closed claims (adjudicated claims provided by the payers). I’m stuck on how to differentiate the open claims vs closed claims data in OMOP, which is important information to provide to researchers because closed claims are generally viewed as higher quality. 1st plan: I was initially thinking that I could use the cost_type_conc…

Regarding:

@Vojtech_Huser

If a cost row does not have a corresponding event in CDM (e.g., row in procedure table) - we need guidance on how to deal with cost_event_id being required.

We’ve also experienced issues related to representing cost for source records with one-to-many standard concept mappings. Properly modeling this data feels like a scenario in which a many-to-many relationship is unavoidable, and/or in which we fundamentally rethink the objects at play.