-
Type:
Bug
-
Resolution: Done
-
Priority:
High
-
None
-
Affects Version/s: 3.4.1
-
MMU
-
Prod
Dear Avinash,
Please find the attachment of APL Vizag MMU2 dump data from 2nd June to 28th Oct. We have identified some duplicate records with different createdDate and sync dates, due to this we are getting more records. Actually records are 8177 but we have identified 11695 records due to different timings for the same beneficiary.
Query: Just for 0ne record reference.
select BenVisitID,BeneficiaryRegID,VisitCode,visitno,VisitCategory,CreatedDate,SyncedDate,vanid,Deleted,VanSerialNo
from t_benvisitdetail where visitcode=30002900007476;
