Dear Avinash,

We have identified the multiple services against one beneficiary under 1097 service mapping table.
For your reference i am adding the one sample scenario: On 7th September we identified one beneficiary against 74 no.of records. Please find the below query and screenshot for your reference.

Query:
select BenCallID,count(BenCallID) from m_bencall1097servicesmapping
where CreatedDate>='2024-09-01'
group by 1
order by CreatedDate desc limit 1000;

select BenCall97ServiceMapID,BenCallID,BeneficiaryRegID,CreatedDate,CreatedBy,SubServiceID,InstituteDirMapID
from m_bencall1097servicesmapping where bencallid=1807181;