We have identified the SyncedBy name and Van Name are different in the database level for Vanid=536 and Vanid=537. For your reference we are adding the screenshot, query and validated data.

[^Syncedby and Vanname are getting different on single Vanid=537.csv]

Query:

select m.CreatedDate,m.CreatedBy,m.BenRegId,m.SyncedDate,m.SyncedBy,m.VanID,mv.VanName

from db_identity.i_beneficiarymapping m
left join db_iemr.m_van mv on mv.vanid=m.VanID
where m.vanid=536 and date(m.createddate)='2026-11-02';