| ~[text:psx.htmlc.admin.busnotes.reports.Last_Name] | ~[text:psx.htmlc.admin.busnotes.reports.First_Name] | ~[text:psx.htmlc.admin.busnotes.reports.Home_Room] | ~[text:psx.htmlc.admin.busnotes.reports.Note] | ~[text:psx.htmlc.admin.busnotes.reports.Number_of_Days] | ~[text:psx.htmlc.admin.busnotes.reports.Start_Date] | ~[text:psx.htmlc.admin.busnotes.reports.End_Date] | ~[tlist_sql; SELECT s.last_name last_name, s.first_name first_name,s.home_room, bn.note note, bn.no_days no_days, to_char(bn.start_date,'mm/dd/yy') start_date, to_char(bn.end_date,'mm/dd/yy') end_date FROM U_BUS_NOTES bn JOIN students s ON bn.studentsdcid = s.dcid WHERE s.schoolid = ~(curschoolid) AND trunc(sysdate) BETWEEN bn.start_date AND bn.end_date ORDER BY s.last_name, bn.start_date desc ;nonemessage=
|---|---|---|---|---|---|---|
| No Bus Notes Found | ||||||
| ~(last_name) | ~(first_name) | ~(home_room) | ~(note;ReplaceCRLFWithBR) | ~(no_days) | ~(start_date) | ~(end_date) |