Internal (B2E)Pool Co-Teaching Scheduling System
Co-teaching slots compiled by hand every month, replaced by online submission from coaches and central assignment by HR
The monthly job of compiling coach availability on paper and in Excel replaced by online submission and central assignment.
- Outcome
- Coaches look up schedules in self-service; the monthly manual compilation is gone
- Role
- Taken over from a prototype: LINE coach identity mapping, schedule push notifications
- Period
- Launched 2025.09
- Tech
- PostgreSQL · Drizzle ORM
Problem Coach availability compiled by hand on paper and in Excel every month
Every month, coach availability and cross-venue information had to be compiled by hand on paper and in Excel.
Approach and role Coaches submit online, HR assigns in one place
Coaches submit available teaching slots online. HR no longer asks for shifts one by one and assigns courses in one place.
Role: taken over from an existing prototype; completed LINE coach identity mapping and schedule push notifications.
User flow Coaches submit slots and check schedules from LINE
- Coaches enter and log in from LINE.
- Available teaching slots are submitted online.
- HR assigns courses in one place.
- Coaches view individual schedules; the system supports schedule push notifications.
LINE integration Coach login, submission and schedule push
Coaches enter and sign in from LINE, submit available teaching slots and check personal schedules; the system supports schedule push notifications.
Impact Coaches look up schedules in self-service, no more monthly manual compilation
Coaches can look up schedules in self-service, removing the monthly manual compilation.
Scale 84 API routes, 16 database tables
Code size: 84 API routes and 16 database tables (counted from the GitHub main branch). Automated tests have not been set up yet; source code is company property and no link is provided here.