Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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';
Advertisement
Add Comment
Please, Sign In to add comment