In atlas, if I want to limit cohort entry to a set of visits with a specific care_site_id, how do I do that?
Trying to do something like this: SELECT * FROM omop.visit_detail where care_site_id = 397812221;
Truly appreciate any guidance.
You’ll have to write custom sql from that. Typically, we don’t support criteria based on the ID of a record since that doesn’t have utility in the context of a network study. Instead, you’d use attributes of the care site/ place of service to be more specific about a care site, and if you notice any missing attributes from the criteria builder, then make it known and it’s possible the tools can be extended.
That’s what it seemed like but I wanted to ensure I wasn’t being obtuse. Thanks much!
Could you be more specific on how I can add care site attributes? I want to use the care_site of a measurement in the inclusion criteria. Each measurement has a visit detail with the corresponding care site. However, I cannot find where I can add those care site attributes.
Thank you very much for your help!