Description

A data count mismatch has been observed in the Utprerona application for the user mapped to Balupather under OIL INDIA Project

As per the attached screenshot:

• All Household: 44
• All Beneficiaries: 65
• Beneficiary – Synced: 85

The All Beneficiaries count is showing 65, whereas the Beneficiary – Synced count is 85, resulting in a difference of 20 records.

Expected Result

The dashboard/home screen counts should accurately reflect the corresponding beneficiary/household records available for the user and should be consistent with the synced data.

Actual Result

The All Beneficiaries dashboard count is 65, while the Beneficiary – Synced count is 85.

Request

Please verify the source/query logic used for the All Beneficiaries and Beneficiary – Synced counts and identify why there is a difference of 20 records.