For pulling student priority in a readable format.

priority_level.sql

CASE PRIORITY.PRIORITY_LEVEL
    WHEN 0 THEN '0000 - Partial Acceptance'
    WHEN 1 THEN '0001 - Current Families'
    WHEN 2 THEN '0002 - Italian Bilingual School'
    WHEN 3 THEN '0003 - Ex-Student'
    WHEN 4 THEN '0004 - Catholic Student & School'
    WHEN 5 THEN '0005 - Catholic Student - Other'
    WHEN 6 THEN '0006 - Other'
    WHEN 10 THEN '0010 - Did not apply'
    WHEN 20 THEN '0020 - CF - C - CS'
    WHEN 21 THEN '0021 - CF - GO - CS'
    WHEN 22 THEN '0022 - CF - OC - CS'
    WHEN 23 THEN '0023 - CF - NC - CS'
    WHEN 24 THEN '0024 - CF - C - SS'
    WHEN 25 THEN '0025 - CF - GO - SS'
    WHEN 26 THEN '0026 - CF - OC - SS'
    WHEN 27 THEN '0027 - CF - NC - SS'
    WHEN 28 THEN '0028 - CF - C - OS'
    WHEN 29 THEN '0029 - CF - GO - OS'
    WHEN 30 THEN '0030 - CF - OC - OS'
    WHEN 31 THEN '0031 - CF - NC - OS'
    WHEN 40 THEN '0040 - IBS - C'
    WHEN 41 THEN '0041 - IBS - GO'
    WHEN 42 THEN '0042 - IBS - OC'
    WHEN 43 THEN '0043 - IBS - NC'
    WHEN 50 THEN '0050 - A - C - CS'
    WHEN 51 THEN '0051 - A - GO - CS'
    WHEN 52 THEN '0052 - A - OC - CS'
    WHEN 53 THEN '0053 - A - NC - CS'
    WHEN 54 THEN '0054 - A - C - SS'
    WHEN 55 THEN '0055 - A - GO - SS'
    WHEN 56 THEN '0056 - A - OC - SS'
    WHEN 57 THEN '0057 - A - NC - SS'
    WHEN 58 THEN '0058 - A - C - OS'
    WHEN 59 THEN '0059 - A - GO - OS'
    WHEN 60 THEN '0060 - A - OC - OS'
    WHEN 61 THEN '0061 - A - NC - OS'
    WHEN 70 THEN '0070 - OTH - C - CS'
    WHEN 71 THEN '0071 - OTH - GO - CS'
    WHEN 72 THEN '0072 - OTH - OC - CS'
    WHEN 73 THEN '0073 - OTH - NC - CS'
    WHEN 74 THEN '0074 - OTH - C - SS'
    WHEN 75 THEN '0075 - OTH - GO - SS'
    WHEN 76 THEN '0076 - OTH - OC - SS'
    WHEN 77 THEN '0077 - OTH - NC - SS'
    WHEN 78 THEN '0078 - OTH - C - OS'
    WHEN 79 THEN '0079 - OTH - GO - OS'
    WHEN 80 THEN '0080 - OTH - OC - OS'
    WHEN 81 THEN '0081 - OTH - NC - OS'
    ELSE '9999 - Empty'
END AS "PRIORITY_LEVEL_FULL"