Admin Spec — Reporting
Reporting
Domain 8 of the Enhanced Candidate A navigation structure. Contains: Student Report, Referrals, Specific Reports, Student Composition (NEW), Logs.
1. Domain Overview
Reporting consolidates all analytics and system logs. Most screens are relocated from the current Reports section. Logs moved here from Settings (system activity logs belong with analytics). TA Reports moved to Teacher Management domain. Payments report moved to Billing & Payments domain.
2. Screen: Student Report
2.1 Purpose
Track student performance metrics.
2.2 Entry Points
- Sidebar: Reporting > Student Report
- Dashboard: "Students Behind" tile click (pre-filtered)
2.3 Existing Capabilities (preserved)
- View student performance metrics
- Export selected students to CSV
- Export full student report
2.4 Key Changes
- Can now be accessed from Dashboard with pre-applied filters
- Row click → Student Detail Page (new navigation target)
2.5 Role Visibility
Admin: Full + export. View-Only: View + export.
3. Screen: Referrals
3.1 Purpose
Track referral program performance. Relocated from Reports.
3.2 Existing Capabilities (preserved)
- View referral data
3.3 Role Visibility
Admin: Full. View-Only: View only.
4. Screen: Specific Reports
4.1 Purpose
Run custom queries and edge-case reports. Relocated from Reports.
4.2 Existing Capabilities (preserved)
- Custom report generator
- Active students not in active semester
- Repeat students with email status
4.3 Role Visibility
Admin: Full. View-Only: View only.
5. Screen: Student Composition (NEW)
5.1 Purpose
Student body breakdown by type. Addresses interview need for "student body composition (new vs. repeat vs. graduating)."
5.2 Entry Points
- Sidebar: Reporting > Student Composition
5.3 Layout
Summary cards + detail table
5.4 Data Displayed
Summary cards:
| Card | Source | Format |
|---|---|---|
| Total Students | Count of active students (user_type=3, activation=1) | Number |
| New Students | Students in their first semester (one enrollment record) | Number + % |
| Returning Students | Students with 2+ enrollment records | Number + % |
| Graduating (Year 2 Complete) | Year 2 students with pass status | Number + % |
Detail table:
| Column | Source | Sortable |
|---|---|---|
| Level | level_tag.name | Yes |
| Total | Count per level | Yes |
| New | First-semester count per level | Yes |
| Returning | Multi-semester count per level | Yes |
| Retention Rate | Returning / (previous semester total at this level) | Yes |
Filters: Semester (default: current)
5.5 Actions
| Action | Trigger | Permission |
|---|---|---|
| Export | "Export" button | Admin |
| View Level Detail | Level click | All — expands to show student list for that level |
5.6 States
- Has data: Summary cards + table
- No data: "No enrollment data for [semester]."
5.7 Role Visibility
Admin: Full + export. View-Only: View only.
6. Screen: Logs
6.1 Purpose
View system activity logs. Relocated from Settings.
6.2 Entry Points
- Sidebar: Reporting > Logs
6.3 Existing Capabilities (preserved)
- View system logs
6.4 Role Visibility
Admin only.