Dear balamurugan.kariyaraj@piramalswasthya.org : We have identified visitcode null value under benchiefcomplaint table for NiramayHWC project. For your reference please find the below screenshot and query.

Query:

select * from t_benchiefcomplaint where ProviderServiceMapID=1720 
and CreatedDate between '2025-06-01 00:00:00' and '2025-07-15 23:59:59' and ChiefComplaintID is not null and visitcode is null;