Dear shashank.k@piramalswasthya.org, We identified the data level issue for Digwal MMU in recent days. There is no data reflecting properly from April 2025 onwards.

Queries:

select year(CreatedDate) As Year,month(CreatedDate) As Month,date(CreatedDate),count(distinct visitcode)
 from t_phy_vitals where ProviderServiceMapID=4 and 
 CreatedDate between '2025-01-01 00:00:00' and '2026-01-12 23:59:59'
 group by 1,2,3 order by CreatedDate desc;
 
 select year(CreatedDate) As Year,month(CreatedDate) As Month,count(distinct visitcode)
 from t_prescription where ProviderServiceMapID=4 
 and CreatedDate between '2025-01-01 00:00:00' and '2026-01-12 23:59:59'
 group by 1,2;
 
  select year(CreatedDate) As Year,month(CreatedDate) As Month,count(distinct visitcode)
 from t_benvisitdetail where ProviderServiceMapID=4 
 and CreatedDate between '2025-01-01 00:00:00' and '2026-01-12 23:59:59'
 group by 1,2 order by CreatedDate desc;

1. Vitals data not reflecting from month of April 2025.
2. 

2. Lab Test prescribed, Diagnosis, prescribed drug, NCD diagnosis, Comorbid, Drug issue not reflecting from month of April 2025.

3. Only Visit details and Lab Test results only reflecting for all the months.