Pasted

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