One visit code against multiple Benreferral ids- Sehat ok Project

XMLWordPrintable

      Dear Avinash,

      We have identified one visitcode against multiple benreferral id's under Sehat ok project.
      For your reference please find the below and screenshot.

      Query:
      select date(CreatedDate),VisitCode,count(benReferID) from db_iemr.t_benreferdetails
      where deleted=0 group by 1,2 having count(benReferID)>2;

      SELECT BeneficiaryRegID,visitcode,benReferID,CreatedDate,CreatedBy,serviceID,serviceName,Deleted,ProviderServiceMapID
      from db_iemr.t_benreferdetails where VisitCode in (30007900767916,
      30007900766601,
      30007900730914,
      30007900730930,
      30008700567839);

              Assignee:
              Venkatesh Bojja
              Reporter:
              Venkatesh Bojja
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: