OHDSI Home | Forums | Wiki | Github

Limit cohort entry event to visit with a specific care_site_id

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.

1 Like

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!

t