Progression Eligibility

exam.progression_eligibility · every change is kept in the audit log

Fields

Every record also has id, created_at and updated_at.

Field	Label	Type	Rules
student	student	link → core.student	required
college	college	link → core.college
programme	programme	link → core.programme	required
eligibility_type	eligibility type	select	one of: Next Year, Honours Fourth Year; default "Next Year"
academic_year	academic year	link → core.academic_year
current_year	current year	number
current_semester	current semester	select	one of: Sem-1, Sem-2, Sem-3, Sem-4, Sem-5, Sem-6, Sem-7, Sem-8, Sem-9, Sem-10, Sem-11, Sem-12
eligible_year	eligible year	number
eligible_academic_year	eligible academic year	link → core.academic_year
eligible_semester	eligible semester	select	one of: Sem-1, Sem-2, Sem-3, Sem-4, Sem-5, Sem-6, Sem-7, Sem-8, Sem-9, Sem-10, Sem-11, Sem-12
student_type	student type	select	one of: Regular, Dropout; default "Regular"
semesters	semesters	table of eligibility_semester
cgpa	cgpa	decimal	min 0; max 10
total_credits_earned	total credits earned	decimal
is_honours	is honours	check	default false
is_honours_with_research	is honours with research	check	default false
selected_specialization	selected specialization	select	one of: Honours, Honours with Research
base_college	base college	link → core.college
fourth_year_college	fourth year college	link → core.college
is_eligible	is eligible	check	default false
status	status	select	one of: Active, On Probation, Graduated, Dropped; default "Active"
remarks	remarks	longtext
evaluated_at	evaluated at	datetime
evaluated_by	evaluated by	link → core.user

Unique together: student + eligibility_type + academic_year

Permissions

Role	Can
exam:super_admin	read, create, update, delete
exam:admin	read, create, update, delete
exam:operator	read, create, update, delete
exam:college	read — only rows in the user's scope (via college)
exam:student	read, update — only own rows (via student)

API

GET    /api/exam/progression_eligibility?<field>=<value>&limit=100&offset=0
POST   /api/exam/progression_eligibility
GET    /api/exam/progression_eligibility/:id
PATCH  /api/exam/progression_eligibility/:id
DELETE /api/exam/progression_eligibility/:id