OHDSI Home | Forums | Wiki | Github

Data in the care_site table

Developers
#1

Hi All,

I am trying to populate inpatient synpuf file into care_site table.

I am trying to validate the data generate with the count in the care_site table from OHDSI box.

There are only 1048 records in the box, where are there are 2675 distinct provider in the inpatient file.

select place_of_service_concept_id,place_of_service_source_value, count(*) from care_site group by place_of_service_concept_id,place_of_service_source_value.

Please let me know if the data is fully populated in the OHDSI box, and is it the right way to compare the data.

Thanks,
Dirk

t