~[wc:commonscripts] ~[wc:admin_header_css] ~[wc:admin_navigation_css]

~[text:psx.htmlc.admin.busnotes.reports.Todays_Bus_Notes] - ~[short.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=] [/tlist_sql]
~[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]
No Bus Notes Found
~(last_name) ~(first_name) ~(home_room) ~(note;ReplaceCRLFWithBR) ~(no_days) ~(start_date) ~(end_date)
~[wc:admin_footer_css]