Details
-
Bug
-
Resolution: Done
-
High
-
None
-
None
-
AMRIT Sprint 18
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);