We have identified 1281 no.of Household ID getting blank under TBMJA at database level, we are included PlaceOfCurrentLiving is null values only.

For your reference we are adding query and validated data.

Query:

select rm.houseoldid,rm.createddate,rm.beneficiaryregid,rm.beneficiaryid,rm.placeOfCurrentLiving
– count(distinct rm.houseoldId),count(distinct hh.houseoldId) 
from db_identity.i_beneficiarydetails_rmnch rm
left join db_identity.i_householddetails hh on hh.houseoldId=rm.houseoldId 
where date(rm.CreatedDate)>='2026-08-01' and rm.houseoldid is null and rm.placeOfCurrentLiving is null;