~[tlist_sql;
select
attendance_code.att_code,
listagg( distinct attendance_code.description, ' / ' ) within group ( order by 1 ) description
from
attendance_code
where
attendance_code.yearid = ~(curyearid)
and attendance_code.calculate_ada_yn = 1
group by
attendance_code.att_code
order by
attendance_code.att_code nulls first
;]
(~(att_code;Html)) ~(description;Html)
[/tlist_sql]
~[tlist_sql;
select distinct
terms.portion,
case when terms.portion = 1 then 'Year' else '1/' || terms.portion end description
from
terms
where
terms.yearid = ~(curyearid)
and ~(curschoolid) in (0, terms.schoolid)
order by
portion
;]
~(description;Html)
[/tlist_sql]