Dear Avinash,

As we discussed in the last meeting, we are adding the below observations from our side.
Condition: Visitcode is available but there is no Beneficiary registration ID under t_benvisitdetail Table, same we verified at i_ben_flow_outreach table based on visitcode but there is no data available.
For your reference we adding the below query for Sanofi Project.
Query:
select * from db_iemr.i_ben_flow_outreach where beneficiary_visit_code in
(select visitcode from db_iemr.t_benvisitdetail where beneficiaryregid is null);