Dear madhava.ramu@piramalswasthya.org : As we discussed, for Niramaya-II project we identified Abha count mismatches between below two tables.

t_healthid

m_benhealthidmapping

For your reference, I am adding below queries:

select count(distinct HealthIDNumber) from m_benhealthidmapping where BeneficiaryRegID is not null and ProviderServiceMapID=1718 and CreatedDate between '2025-05-15 00:00:00' and '2025-05-15 23:59:59';-- 8501 – 532
select count(distinct mp.HealthIDNumber) from m_benhealthidmapping mp 
inner join t_healthid hd on hd.HealthIDNumber=mp.HealthIDNumber
where mp.BeneficiaryRegID is not null and mp.ProviderServiceMapID=1718 and mp.CreatedDate between '2025-05-15 00:00:00' and '2025-05-15 23:59:59'; – 4034
select count(distinct HealthIdNumber) from t_healthid where ProviderServiceMapID in (1718) and CreatedDate between '2025-05-15 00:00:00' and '2025-05-15 23:59:59' and isNewAbha!=1; – 1841
select count(distinct HealthIdNumber) from t_healthid where ProviderServiceMapID=34; – 2591