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.