Dear  kundan.srivastava@piramalswasthya.org : We have identified 321 beneficiary records demographic data was missing in the database level. Its happening due to vanserialno issue.

For your reference we are adding the 321 beneficiary list.

Query:

select * from db_identity.i_beneficiarymapping m 
inner join db_identity.m_beneficiaryregidmapping mm on mm.BenRegId=m.BenRegId
inner join db_identity.i_beneficiarydetails bd on bd.VanSerialNo=m.BenDetailsId and bd.vanid=m.vanid
where mm.BeneficiaryID in (895586999301,
583984579876,
800745087257,
764930094898,
370537379217,
264102157546,
477193877939,
323637575252,
752194921040,
414476989681,
929616996608,
840319372421,
235560379541,
697444171948,
597423922034,
393397017035,
825332583731,
581113382659,
626600593371,
668050332734,
423905525773,
940337268821,
967228039020,
760409415061,
473795277439,
457778199462,
544394512084,
384964497437,
686199077023,
229507494811,
438057234515,
955308828933,
474616337960,
546588190667,
508090002223,
324549365708,
364262647312,
687756553108,
315695318011,
583003756707,
250591165200,
231069128927,
751467447900,
372794414301,
749209575467,
615720357509,
791505558406,
320529792668,
775228590846,
466324179251,
218841818735,
609441722484,
268282210094,
819041605722,
645394079255,
382850576276,
787834237713,
326216208469,
287140485198,
704622466380,
380349599250,
669007535111,
229994281964,
369612374170,
685244292003,
725197402313,
307015240658,
935110484614,
774881893167,
207756640188,
310890111419,
742699275091,
280738003850,
823973581709,
367215256271,
957143465991,
491935133434,
592549129202,
318044492467,
556966924206,
782708453389,
787829809932,
696199425350,
540208839872,
330594873694,
755076836717,
489064763126,
964211092783,
386396500819,
588180701552,
365209373549,
402592316449,
742344538092,
658632343927,
927499628924,
992938323023,
634556854763,
905116552499,
401095032540,
553272998415,
683745899993,
279658901203,
201884866436,
395164988132,
393616270960,
294288274327,
600620147182,
637993951494,
712454089198,
800328509602,
629943449870,
259688584604,
672327211481,
796539242002,
854810836902,
932947527504,
413418872375,
310302097805,
659164564704,
964881669398,
986055137717,
448634539026,
587520118574,
456685099941,
203504971125,
213916254533,
861861449939,
744699826406,
226027417085,
897245330122,
201464955747,
841709442573,
645369899393,
659351877603,
629502529174,
400881988139,
247394490987,
662928427262,
600108141323,
246985097555,
734259266669,
816345660530,
783925168733,
882180653665,
571979229003,
601749344922,
860410054680,
872456398846,
710600004012,
355047124756,
689851144008,
596961837346,
483641320868,
362416117754,
459544591089,
228096693687,
934863450566,
381904571923,
307688034646,
553494708501,
480482637965,
396310439197,
213655454610,
385375486226,
875582907167,
633891833828,
630495331994,
915525676043,
938146017967,
273229338222,
953641388439,
274817219875,
887779462463,
840124250966,
498519105280,
776181285818,
559950982150,
583562293970,
378941195447,
271066706635,
201970355904,
355976663826,
382711792766,
829291391243,
958404985910,
904958274025,
713184022133,
825432797595,
379135877704,
899658307324,
296441672078,
731390833365,
973120925297,
937942997511,
524517183974,
458206161691,
347221229537,
481429083823,
939789603711,
498926739605,
457254031421,
955130070201,
902895079873,
514085525673,
947984739654,
664367795458,
434313434645,
685765033430,
700313337921,
389122485620,
917785163497,
262497118778,
284579112033,
620490580802,
551021642271,
444499089167,
253952587525,
273079361549,
861912923736,
297731457587,
561040405909,
924750931579,
619870624698,
747894705259,
463191296530,
437567242268,
735559366070,
361696767747,
327864875565,
644056906920,
255799856407,
401444328173,
707588902510,
803531545913,
462286769711,
430642935273,
298580995294,
540182348439,
583827895589,
650175953470,
562016106266,
603881681279,
492290081364,
377463290020,
770557568796,
885646947475,
931661181822,
608001360959,
311957148787,
571675605233,
894268313233,
705490131838,
858737017859,
334098774286,
581940350378,
452117698811,
632359583512,
659238246546,
785638990370,
775338182244,
935223938840,
471827441562,
823645705723,
661077869048,
232034960107,
769789728228,
893565848406,
898613548990,
969430113809,
905844927783,
639121032923,
640166677332,
393124824395,
962367782638,
564259494757,
373418944848,
304063583175,
804190558530,
643480497864,
861952827678,
489317346394,
835989399678,
624552261016,
274438723119,
759427801800,
656980680714,
298140008047,
582781843824,
726972440409,
576230713830,
403611518258,
722007944316,
997498222154,
687332400725,
296673465584,
322665622787,
467605813633,
910062553221,
813780533538,
885894469807,
272644579950,
261948960595,
972809070252,
704721306141,
939352400475,
849688000671,
960991629936,
264244794151,
722747495052,
343156892588,
275419168340,
352587039330,
944517538125,
661096013812,
264049562421,
304684362678,
768865624638,
292359019539,
793359463868,
342917914664);