Dear ~kumark_piramalswasthya.org#EXT#@kefindia.onmicrosoft.com /balamurugan.kariyaraj@piramalswasthya.org, For SJVN MMU project we are missing 238 beneficiaries demographic and transactional data, For your reference we are adding the below queries and screenshots.

Query for Demographic:

select * from db_identity.i_beneficiarymapping where benregid in (732821989,
732821990,
732821991,
732821992,
732821993,
732821994,
732821995,
732821996,
732821997,
732821998,
732821999,
732822000,
732822001,
732822002,
732822003,
732822004,
732822005,
732822006,
732822007,
732822008,
732822009,
732822010,
732822011,
732822012,
732822013,
732822014,
732822015,
732822009,
732822016,
732822017,
732822018,
732822019,
732822020,
732822021,
732822022,
732822023,
732822024,
732822025,
732822026,
732822027,
732822028,
732822029,
732822030,
732822031,
732822032,
732822033,
732822034,
732822035,
732822036,
732822037,
732822038,
732822039,
732822040,
732822041,
732822042,
732822043,
732822044,
732822045,
732822046,
732822047,
732822048,
732822049,
732822050,
732822051,
732822052,
732822053,
732822054,
732822055,
732822056,
732822057,
732822058,
732822059,
732822060,
732822061,
732822062,
732822063,
732822064,
732822065,
732822066,
732822067,
732822068,
732822069,
732822070,
732822071,
732822111,
732822112,
732822113,
732822114,
732822115,
732822116,
732822117,
732822118,
732822119,
732822120,
732822121,
732822122,
732822123,
732822124,
732822125,
732822126,
732822127,
732822128,
732822129,
732822130,
732822131,
732822132,
732822133,
732822134,
732822135,
732822136,
732822137,
732822138,
732822139,
732822140,
732822141,
732822142,
732822143,
732822144,
732822145,
732822146,
732822147,
732822148,
732822149,
732822150,
732822151,
732822152,
732822153,
732822154,
732822155,
732822156,
732822157,
732822158,
732822159,
732822160,
732822161,
732822162,
732822163,
732822164,
732822165,
732822166,
732822167,
732822168,
732822169,
732822170,
732822171,
732822172,
732822173,
732822174,
732822175,
732822176,
732822177,
732822178,
732822179,
732822184,
732822185,
732822186,
732822187,
732822188,
732822189,
732822190,
732822191,
732822192,
732822193,
732822194,
732822195,
732822196,
732822197,
732822198,
732822199,
732822200,
732822201,
732822202,
732822203,
732822204,
732822205,
732822206,
732822207,
732822208,
732822209,
732822210,
732822211,
732822212,
732822213,
732822214,
732822215,
732822216,
732822217,
732822218,
732822219,
732822220,
732822221,
732822222,
732822223,
732822243,
732822244,
732822245,
732822246,
732822247,
732822248,
732822249,
732822250,
732822251,
732822252,
732822253,
732822254,
732822255,
732822256,
732822257,
732822258,
732822259,
732822260,
732822261,
732822262,
732822263,
732822264,
732822265,
732822266,
732822267,
732822278,
732822279,
732822280,
732822281,
732822282,
732822283,
732822284,
732822285,
732822286,
732822287,
732822288,
732822289,
732822290,
732822291,
732822292,
732822293,
732822294,
732822295,
732822296,
732822297);

Query for Transaction sampleSJVN missing 237 beneficiary details.xlsx:

select * from db_iemr.t_lab_testorder where beneficiaryregid in (732821989,
732821990,
732821991,
732821992);