Thanks @sravanthi17,
I got it working to some extent, not complete, so needs some more refinement.
select distinct concat(pn.given_name," “, pn.family_name) as name, pi.identifier as identifier, concat(”",p.uuid) as uuid, concat("",v.uuid) as activeVisitUuid, IF(va.value_reference = “Admitted”, “true”, “false”) as hasBeenAdmitted from visit v join person_name pn on v.patient_id = pn.person_id and pn.voided = 0 and v.voided=0 join patient_identifier pi on v.patient_id = pi.patient_id and pi.voided=0 and pi.identifier_type=3 join person p on p.person_id = v.patient_id and p.voided=0 join encounter en on en.visit_id = v.visit_id and en.voided=0 join relationship rs on rs.person_a = p.person_id join provider pr on pr.person_id=rs.person_b and pr.retired=0 left outer join visit_attribute va on va.visit_id = v.visit_id and va.voided = 0 and va.attribute_type_id = (select visit_attribute_type_id from visit_attribute_type where name=“Admission Status”) where v.date_stopped is null and date(en.encounter_datetime)=curdate() and v.voided = 0 and pr.uuid=${provider_uuid} order by en.encounter_datetime desc;