Open markdanese opened 5 years ago
Options @markdanese and I discussed:
Tagging @markdanese @marc-outins @aguynamedryan for discussion.
There is a third option to consider, formulated after talking to @marc-outins ;
To implement this, we need an operator that is similar to co-reported but checks for the same collection_id.
Consequences to implementing this:
I like the idea of using 0450 and adding a "comment" column to the clinical code table. We would record a comment to the effect that we used 0450 because the specific code was not provided.
I suspect that there will be other cases where the ETL will need to provide a value that wasn't provided with sufficient detail. It might be nice to be able to store the comment about it with the data, and even output it into the analysis data set. We could even print out all of the unique comments as part of the ETL process for the data.
Again, we can discuss, but I think the logic of the ER algorithm makes it more reusable if we use the actual revenue code.
It is useful for finding ED visits. Should this be added to the cost table? Or should we include this elsewhere. It seems very specific to the Medicare MEDPAR file.
Background: We are creating ER visit algorithms using Venkatesh 2017 and need to include the ResDac definition of finding ER visits. ResDac suggests checking the medpar file for emergency room charge > $0. Medpar does not give revenue codes to users and use variables that roll up charge amounts based on revenue codes values. For ER payments (variable ER_AMT), Medpar rolls up the charge amounts for revenue codes 045x (specifying emergency room charges). Currently GDM does not store this variable. It does currently store revenue codes in the clinical_codes table. We need to store this variable to complete ResDac's ER visit algorithm.
needed for ticket https://github.com/outcomesinsights/conceptql/issues/196.