# Student Clearance Self-Service Update

## Student functions

- A linked Student account can initiate its own clearance request.
- The request is restricted to the logged-in student's admission number.
- The student selects the clearance purpose, academic session, module/semester and academic year.
- Existing requests for the same student and period are reopened instead of duplicated.
- The student can track every configured clearance office, status, remarks, processing officer and date.
- A progress bar shows the number and percentage of offices cleared.
- Finance and library clearance steps refresh from the live fee and library records.
- The final clearance form remains locked until the overall status is `Cleared`.
- After final approval, the student can print the institution-formatted clearance form.

## Privacy and access control

- Students cannot open the staff clearance management page.
- Student request lists are filtered by the logged-in admission number.
- A student cannot view another student's clearance by changing the request ID.
- A student cannot print another student's form.
- A student cannot print an incomplete clearance form.
- Authorized staff retain access to the existing clearance management and print pages.

## Deployment

Existing installations can import:

`database_updates/student_clearance_self_service.sql`

The application also checks and creates the required clearance tables and columns at runtime.
