deeejay

SQL - Query Cerner Person Identifiers

Apr 13th, 2015
457
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.50 KB | None | 0 0
  1. SELECT E.ENCNTR_ID, P.NAME_FULL_FORMATTED, MRN.ALIAS AS MRN, FIN.ALIAS AS FIN
  2. FROM AH_ANALYTICS.RCI_ENCOUNTER E
  3. LEFT OUTER JOIN AH_ANALYTICS.RCI_ENCNTR_ALIAS MRN
  4. ON E.ENCNTR_ID = MRN.ENCNTR_ID
  5. AND MRN.ALIAS_POOL_CD = 629723681 -- MRN
  6. LEFT OUTER JOIN AH_ANALYTICS.RCI_ENCNTR_ALIAS FIN
  7. ON E.ENCNTR_ID = FIN.ENCNTR_ID
  8. AND FIN.ALIAS_POOL_CD = 706841 -- FIN NBR
  9. LEFT OUTER JOIN AH_ANALYTICS.RCI_PERSON P
  10. ON E.PERSON_ID = P.PERSON_ID
  11. WHERE E.ORGANIZATION_ID IN (1234, 5678)
  12. AND FIN.ALIAS = '1234567890';
Advertisement
Add Comment
Please, Sign In to add comment