we have identified the Boradi (56429) village household information is blank under {}i_beneficiarydetails_rmnch  and {}i_householddetails tables on 30th October.

This village is belongs to State of Maharastra and District Dhule and TBunit of Shirpur under Shirpur Van1.

For your reference we are adding the Query and data.

Query:1

select * from db_identity.i_beneficiarymapping m
inner join db_identity.i_beneficiarydetails_rmnch rm on rm.BeneficiaryRegID=m.benregid
where m.vanid=536 and date(m.createddate)='2026-10-30';

Query2:

select m.CreatedDate,m.CreatedBy,m.BenRegId,m.SyncedDate,m.VanID,rm.houseoldId from db_identity.i_beneficiarymapping m
left join db_identity.i_beneficiarydetails_rmnch rm on rm.BeneficiaryRegID=m.benregid
where m.vanid=536 and date(m.createddate)='2026-10-30';

Shirpur Van1 Boradi village Household null 30th October.csv