deeejay

SQL - Cerner MS-DRG Query

Jan 12th, 2016
397
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.86 KB | None | 0 0
  1. SELECT
  2.     C1.DISPLAY AS DRG_TYPE,
  3.     D.SOURCE_IDENTIFIER AS DRG_CODE,
  4.     D.DRG_CATEGORY,
  5.     C2.DISPLAY AS MDC,
  6.     D.GMLOS,
  7.     D.AMLOS,
  8.     D.DRG_WEIGHT,
  9.     D.BEG_EFFECTIVE_DT_TM,
  10.     D.END_EFFECTIVE_DT_TM,
  11.     N.SOURCE_STRING AS DRG_DESC,
  12.     EXTRACT(YEAR FROM D.BEG_EFFECTIVE_DT_TM) AS DRG_GROUPER
  13. FROM DRG_EXTENSION D
  14. LEFT OUTER JOIN NOMENCLATURE N
  15. ON D.SOURCE_IDENTIFIER = N.SOURCE_IDENTIFIER
  16. AND N.ACTIVE_IND = 1
  17. AND N.SOURCE_VOCABULARY_CD = 132858437 -- MS-DRG
  18. LEFT OUTER JOIN CODE_VALUE C1
  19. ON D.SOURCE_VOCABULARY_CD = C1.CODE_VALUE
  20. AND C1.ACTIVE_IND = 1
  21. LEFT OUTER JOIN CODE_VALUE C2
  22. ON D.MDC_CD = C2.CODE_VALUE
  23. AND C2.ACTIVE_IND = 1
  24. WHERE D.ACTIVE_IND = 1
  25. AND D.SOURCE_VOCABULARY_CD = 132858437 -- MS-DRG
  26. AND EXTRACT(YEAR FROM D.UPDT_DT_TM) = 2015
  27. --AND EXTRACT(YEAR FROM D.BEG_EFFECTIVE_DT_TM) = 2015
  28. ORDER BY D.BEG_EFFECTIVE_DT_TM ASC, D.SOURCE_IDENTIFIER ASC
Advertisement
Add Comment
Please, Sign In to add comment