~[text:psx.htmlc.idmFOTM.school_setup_title]
This school is not authorized to use this plugin.
~[x:insertfile;/admin/schoolsetup/idM_autoTardyPlusSettingsDistrict.html]
~[x:insertfile;/admin/schoolsetup/idM_autoTardyPlusSettingsSchool.html]
~[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 ~(curschoolid) in (0, attendance_code.schoolid)
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]
~[tlist_sql;
select
period.period_number,
period.abbreviation,
period.name
from
period
where
period.year_id = ~(curyearid)
and period.schoolid = ~(curschoolid)
;]
~(abbreviation;Html) (~(name;Html))
[/tlist_sql]