Created by Corina C Larsen on Jan 30, 2018 
may need '0912' single quotes if STRM is text

/*+ SEMESTER SORT FOR PIVOT TABLES 03.27.17 */	
CASE
WHEN A.STRM = 0303 THEN '001 - 1980 Spring'
WHEN A.STRM = 0305 THEN '002 - 1980 Summer'
WHEN A.STRM = 0306 THEN '003 - 1980 Fall'
WHEN A.STRM = 0307 THEN '004 - 1981 Spring'
WHEN A.STRM = 0309 THEN '005 - 1981 Summer'
WHEN A.STRM = 0310 THEN '006 - 1981 Fall'
WHEN A.STRM = 0311 THEN '007 - 1982 Spring'
WHEN A.STRM = 0313 THEN '008 - 1982 Summer'
WHEN A.STRM = 0314 THEN '009 - 1982 Fall'
WHEN A.STRM = 0315 THEN '010 - 1983 Spring'
WHEN A.STRM = 0317 THEN '011 - 1983 Summer'
WHEN A.STRM = 0318 THEN '012 - 1983 Fall'
WHEN A.STRM = 0319 THEN '013 - 1984 Spring'
WHEN A.STRM = 0321 THEN '014 - 1984 Summer'
WHEN A.STRM = 0322 THEN '015 - 1984 Fall'
WHEN A.STRM = 0323 THEN '016 - 1985 Spring'
WHEN A.STRM = 0325 THEN '017 - 1985 Summer'
WHEN A.STRM = 0326 THEN '018 - 1985 Fall'
WHEN A.STRM = 0327 THEN '019 - 1986 Spring'
WHEN A.STRM = 0329 THEN '020 - 1986 Summer'
WHEN A.STRM = 0330 THEN '021 - 1986 Fall'
WHEN A.STRM = 0331 THEN '022 - 1987 Spring'
WHEN A.STRM = 0333 THEN '023 - 1987 Summer'
WHEN A.STRM = 0334 THEN '024 - 1987 Fall'
WHEN A.STRM = 0335 THEN '026 - 1988 Spring'
WHEN A.STRM = 0336 THEN '027 - 1988 Summer'
WHEN A.STRM = 0338 THEN '028 - 1988 Fall'
WHEN A.STRM = 0339 THEN '029 - 1989 Spring'
WHEN A.STRM = 0340 THEN '030 - 1989 Summer'
WHEN A.STRM = 0342 THEN '031 - 1989 Fall'
WHEN A.STRM = 0343 THEN '032 - 1990 Spring'
WHEN A.STRM = 0344 THEN '033 - 1990 Summer'
WHEN A.STRM = 0346 THEN '034 - 1990 Fall'
WHEN A.STRM = 0347 THEN '035 - 1991 Spring'
WHEN A.STRM = 0348 THEN '036 - 1991 Summer'
WHEN A.STRM = 0350 THEN '037 - 1991 Fall'
WHEN A.STRM = 0351 THEN '038 - 1992 Spring'
WHEN A.STRM = 0352 THEN '039 - 1992 Summer'
WHEN A.STRM = 0354 THEN '040 - 1992 Fall'
WHEN A.STRM = 0355 THEN '041 - 1993 Spring'
WHEN A.STRM = 0356 THEN '042 - 1993 Summer'
WHEN A.STRM = 0358 THEN '043 - 1993 Fall'
WHEN A.STRM = 0359 THEN '044 - 1994 Spring'
WHEN A.STRM = 0360 THEN '045 - 1994 Summer'
WHEN A.STRM = 0362 THEN '046 - 1994 Fall'
WHEN A.STRM = 0363 THEN '047 - 1995 Spring'
WHEN A.STRM = 0364 THEN '048 - 1995 Summer'
WHEN A.STRM = 0366 THEN '049 - 1995 Fall'
WHEN A.STRM = 0367 THEN '050 - 1996 Spring'
WHEN A.STRM = 0368 THEN '051 - 1996 Summer'
WHEN A.STRM = 0370 THEN '052 - 1996 Fall'
WHEN A.STRM = 0371 THEN '053 - 1997 Spring'
WHEN A.STRM = 0372 THEN '054 - 1997 Summer'
WHEN A.STRM = 0374 THEN '055 - 1997 Fall'
WHEN A.STRM = 0375 THEN '056 - 1998 Spring'
WHEN A.STRM = 0376 THEN '057 - 1998 Summer'
WHEN A.STRM = 0378 THEN '058 - 1998 Fall'
WHEN A.STRM = 0379 THEN '059 - 1999 Spring'
WHEN A.STRM = 0380 THEN '060 - 1999 Summer'
WHEN A.STRM = 0381 THEN '061 - 1999 Summer2'
WHEN A.STRM = 0382 THEN '062 - 1999 Fall'
WHEN A.STRM = 0383 THEN '063 - 2000 Spring'
WHEN A.STRM = 0384 THEN '064 - 2000 Summer'
WHEN A.STRM = 0385 THEN '065 - 2000 Summer2'
WHEN A.STRM = 0386 THEN '066 - 2000 Fall'
WHEN A.STRM = 0387 THEN '067 - 2001 Spring'
WHEN A.STRM = 0388 THEN '068 - 2001 Summer'
WHEN A.STRM = 0389 THEN '069 - 2001 Summer2'
WHEN A.STRM = 0390 THEN '070 - 2001 Fall'
WHEN A.STRM = 0391 THEN '071 - 2002 Spring'
WHEN A.STRM = 0392 THEN '072 - 2002 Summer'
WHEN A.STRM = 0393 THEN '073 - 2002 Summer2'
WHEN A.STRM = 0394 THEN '074 - 2002 Fall'
WHEN A.STRM = 0395 THEN '075 - 2003 Spring'
WHEN A.STRM = 0397 THEN '076 - 2003 Summer'
WHEN A.STRM = 0399 THEN '077 - 2003 Summer2'
WHEN A.STRM = 0410 THEN '078 - 2003 Fall'
WHEN A.STRM = 0420 THEN '079 - 2004 Spring'
WHEN A.STRM = 0430 THEN '080 - 2004 Summer'
WHEN A.STRM = 0440 THEN '081 - 2004 Summer2'
WHEN A.STRM = 0510 THEN '082 - 2004 Fall'
WHEN A.STRM = 0520 THEN '083 - 2005 Spring'
WHEN A.STRM = 0530 THEN '084 - 2005 Summer'
WHEN A.STRM = 0540 THEN '085 - 2005 Summer'
WHEN A.STRM = 0610 THEN '086 - 2005 Fall'
WHEN A.STRM = 0620 THEN '087 - 2006 Spring'
WHEN A.STRM = 0630 THEN '088 - 2006 Summer'
WHEN A.STRM = 0710 THEN '089 - 2006 Fall'
WHEN A.STRM = 0720 THEN '090 - 2007 Spring'
WHEN A.STRM = 0730 THEN '091 - 2007 Summer'
WHEN A.STRM = 0810 THEN '092 - 2007 Fall'
WHEN A.STRM = 0820 THEN '093 - 2008 Spring'
WHEN A.STRM = 0830 THEN '094 - 2008 Summer'
WHEN A.STRM = 0910 THEN '095 - 2008 Fall'
WHEN A.STRM = 0920 THEN '096 - 2009 Spring'
WHEN A.STRM = 0930 THEN '097 - 2009 Summer'
WHEN A.STRM = 1010 THEN '098 - 2009 Fall'
WHEN A.STRM = 1020 THEN '099 - 2010 Spring'
WHEN A.STRM = 1030 THEN '100 - 2010 Summer'
WHEN A.STRM = 1110 THEN '101 - 2010 Fall'
WHEN A.STRM = 1120 THEN '102 - 2011 Spring'
WHEN A.STRM = 1130 THEN '103 - 2011 Summer'
WHEN A.STRM = 1210 THEN '104 - 2011 Fall'
WHEN A.STRM = 1220 THEN '105 - 2012 Spring'
WHEN A.STRM = 1230 THEN '106 - 2012 Summer'
WHEN A.STRM = 1310 THEN '107 - 2012 Fall'
WHEN A.STRM = 1320 THEN '108 - 2013 Spring'
WHEN A.STRM = 1330 THEN '109 - 2013 Summer'
WHEN A.STRM = 1410 THEN '110 - 2013 Fall'
WHEN A.STRM = 1420 THEN '111 - 2014 Spring'
WHEN A.STRM = 1430 THEN '112 - 2014 Summer'
WHEN A.STRM = 1510 THEN '113 - 2014 Fall'
WHEN A.STRM = 1520 THEN '114 - 2015 Spring'
WHEN A.STRM = 1530 THEN '115 - 2015 Summer'
WHEN A.STRM = 1610 THEN '116 - 2015 Fall'
WHEN A.STRM = 1620 THEN '117 - 2016 Spring'
WHEN A.STRM = 1630 THEN '118 - 2016 Summer'
WHEN A.STRM = 1710 THEN '119 - 2016 Fall'
WHEN A.STRM = 1720 THEN '120 - 2017 Spring'
WHEN A.STRM = 1730 THEN '121 - 2017 Summer'
WHEN A.STRM = 1810 THEN '122 - 2017 Fall'
WHEN A.STRM = 1820 THEN '123 - 2018 Spring'
WHEN A.STRM = 1830 THEN '124 - 2018 Summer'
WHEN A.STRM = 1910 THEN '125 - 2018 Fall'
WHEN A.STRM = 1920 THEN '126 - 2019 Spring'
WHEN A.STRM = 1930 THEN '127 - 2019 Summer'
WHEN A.STRM = 2010 THEN '128 - 2019 Fall'
WHEN A.STRM = 2020 THEN '129 - 2020 Spring'
WHEN A.STRM = 2030 THEN '130 - 2020 Summer'
WHEN A.STRM = 2110 THEN '131 - 2020 Fall'
WHEN A.STRM = 2120 THEN '132 - 2021 Spring'
WHEN A.STRM = 2130 THEN '133 - 2021 Summer'
ELSE 'ADD TO EXPRESSION'
END