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: