LAPTOP i7

Its quite useful displaying the bell schedule info of the day on the admin and teachers pagess header in PowerSchool. Here is how to do it:

1. Go to PS Administrator >> Custom Pages

2. Add this following code to wildcards/admin_header_css.txt and wildcards/teacher_header_css.txt

<span id="ssis-date" style="padding-right:20px;">
~[tlist_sql; select b.name as name, listagg(p.ABBREVIATION || ,) WITHIN GROUP ( ORDER BY bi.START_TIME) AS periods
    from ps.calendar_day c inner join ps.BELL_SCHEDULE b on c.BELL_SCHEDULE_ID = b.ID
        inner join ps.BELL_SCHEDULE_ITEMS bi on bi.BELL_SCHEDULE_ID = b.ID
        inner join ps.PERIOD p on p.ID = bi.PERIOD_ID
    where TO_CHAR(c.DATE_VALUE, DD-MM-YYYY) = TO_CHAR(CURRENT_DATE, DD-MM-YYYY)
        and c.SCHOOLID = ~(curschoolid)
    group by b.name; ]
    <span style="color:#195f7d">~(name):</span> ~(periods)
[/tlist_sql]
</span>

Requirement:  you have to setup the calendar for the day with a bellschedule (https://your.ps.addr/admin/schoolsetup/calendarsetup/calendarsetup.html)