Dear kumark@piramalswasthya.org ,

Please find the below mentioned 72 no.of beneficiary data not available in the beneficiary personal information and transaction data level for Digwal MMU and TMC. Kindly update the missing data.

Queries:

select * from db_identity.i_beneficiarymapping where benregid in (38737,
38742,
38762,
38763,
38768,
38775
);

Query2 Transaction:

select * from db_iemr.t_phy_vitals where BeneficiaryRegID in (732652575,
732652576,
732652577,
732652578,
732652579,
732652580,
732652581,
732652582,
732652583,
732652584,
732652585,
732652586,
732652587);Dgwal MMU-TMC beneficiary missing data.xlsx