Pasted

SELECT E.ENCNTR_ID, P.NAME_FULL_FORMATTED, MRN.ALIAS AS MRN, FIN.ALIAS AS FIN
FROM AH_ANALYTICS.RCI_ENCOUNTER E
LEFT OUTER JOIN AH_ANALYTICS.RCI_ENCNTR_ALIAS MRN
ON E.ENCNTR_ID = MRN.ENCNTR_ID
AND MRN.ALIAS_POOL_CD = 629723681 -- MRN
LEFT OUTER JOIN AH_ANALYTICS.RCI_ENCNTR_ALIAS FIN
ON E.ENCNTR_ID = FIN.ENCNTR_ID
AND FIN.ALIAS_POOL_CD = 706841 -- FIN NBR
LEFT OUTER JOIN AH_ANALYTICS.RCI_PERSON P
ON E.PERSON_ID = P.PERSON_ID
WHERE E.ORGANIZATION_ID IN (1234, 5678)
AND FIN.ALIAS = '1234567890';