[
    ~[tlist_sql;
        SELECT
            TERMS.DCID,
            TERMS.ID,
            TERMS.NAME,
            TERMS.ABBREVIATION,
            TERMS.YEARID,
            TERMS.ISYEARREC
        FROM PS.TERMS
        WHERE TERMS.SCHOOLID = ~(curschoolid)
            AND TERMS.YEARID > COALESCE('~[displaypref:coursearchiveyear]','~(curyearid)')
        ORDER BY TERMS.ISYEARREC DESC, TERMS.NAME ASC
    ;]
        {
            "dcid":             "~(DCID;JSON)",
            "id":               "~(ID;JSON)",
            "name":             "~(NAME;JSON)",
            "abbreviation":     "~(ABBREVIATION;JSON)",
            "yearid":           "~(YEARID;JSON)",
            "isyearred":        "~(ISYEARREC;JSON)"
        },
    [/tlist_sql]
    {}
]