We have identified the variation between  householdid information between i_beneficiary_RMNCH table and i_householddetails tables.

Note: Added one day data for reference.

Variation between RMNCH and Household tables date wise.csv

For your reference we are sharing the query:

Query1:

select distinct date(rm.createddate) As date,rm.houseoldid As Household_rmnch,hh.houseoldid As Household
– 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-11-01';

Query2:

select  date(rm.createddate) As Date,-- rm.houseoldid As Household_rmnch,hh.houseoldid As Household
 count(distinct rm.houseoldId) As RMNCH_Count,count(distinct hh.houseoldId) As Household_Table_Count
from db_identity.i_beneficiarydetails_rmnch rm
left join db_identity.i_householddetails hh on hh.houseoldId=rm.houseoldId where date(rm.CreatedDate)>='2026-09-01'
group by 1;

Variation between RMNCH and Household tables.csv