Issue with PatientsPartnersPatients table?
Hello,
When I enter in the following code, it only lists CDPHO as having about 1500 patients. I believe CDPHO should have about 40000 patients? For example, when a query on just the wellness registry linked to the primary roster table is run by ReportGroup, it generates about 40000 patients for CDPHO. Is there an issue with the PatientPartnersPatients View?
SELECT ReportGroupCD, count(*) FROM [UserWork].[EAViewLibrary].[PatientPartnersPatients] group by ReportGroupCD