Uploaded image for project: 'AMRIT'
  1. AMRIT
  2. AMM-849

One visit code against multiple Benreferral ids- Sehat ok Project

    XMLWordPrintable

Details

    Description

      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);

      Attachments

        1. image-2024-07-25-21-16-13-375.png
          165 kB
          Venkatesh Bojja
        2. image-2024-08-21-15-58-01-991.png
          127 kB
          Avinash Sharma

        Forms

          Activity

            People

              venkatesh.bojja@piramalswasthya.org Venkatesh Bojja
              venkatesh.bojja@piramalswasthya.org Venkatesh Bojja
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: