Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- C1.DISPLAY AS DRG_TYPE,
- D.SOURCE_IDENTIFIER AS DRG_CODE,
- D.DRG_CATEGORY,
- C2.DISPLAY AS MDC,
- D.GMLOS,
- D.AMLOS,
- D.DRG_WEIGHT,
- D.BEG_EFFECTIVE_DT_TM,
- D.END_EFFECTIVE_DT_TM,
- N.SOURCE_STRING AS DRG_DESC,
- EXTRACT(YEAR FROM D.BEG_EFFECTIVE_DT_TM) AS DRG_GROUPER
- FROM DRG_EXTENSION D
- LEFT OUTER JOIN NOMENCLATURE N
- ON D.SOURCE_IDENTIFIER = N.SOURCE_IDENTIFIER
- AND N.ACTIVE_IND = 1
- AND N.SOURCE_VOCABULARY_CD = 132858437 -- MS-DRG
- LEFT OUTER JOIN CODE_VALUE C1
- ON D.SOURCE_VOCABULARY_CD = C1.CODE_VALUE
- AND C1.ACTIVE_IND = 1
- LEFT OUTER JOIN CODE_VALUE C2
- ON D.MDC_CD = C2.CODE_VALUE
- AND C2.ACTIVE_IND = 1
- WHERE D.ACTIVE_IND = 1
- AND D.SOURCE_VOCABULARY_CD = 132858437 -- MS-DRG
- AND EXTRACT(YEAR FROM D.UPDT_DT_TM) = 2015
- --AND EXTRACT(YEAR FROM D.BEG_EFFECTIVE_DT_TM) = 2015
- ORDER BY D.BEG_EFFECTIVE_DT_TM ASC, D.SOURCE_IDENTIFIER ASC
Advertisement
Add Comment
Please, Sign In to add comment