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 APL 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);