Education Record

sfc.education · every change is kept in the audit log

Fields

Every record also has id, created_at and updated_at.

Field	Label	Type	Rules
application	application	link → sfc.application	required
student	student	link → core.student	required
entered_by	entered by	link → core.user
prn	prn	text	personal data
seat_no	seat no	text	personal data
programme	programme	link → core.programme
college	college	link → core.college
course_name	course name	text
college_name	college name	text
specialisation	specialisation	text
course_type	course type	select	one of: Regular, External
sem_year	sem year	select	one of: First Year, Second Year, Third Year, Fourth Year, Fifth Year, Sixth Year, Seventh Year, Eighth Year, Ninth Year, Tenth Year, Semester 1, Semester 2, Semester 3, Semester 4, Semester 5, Semester 6, Semester 7, Semester 8, Semester 9, Semester 10
pattern	pattern	text
medium	medium	select	one of: English, Marathi, Hindi, Gujarati
passing_date	passing date	text	max 20 characters
result_class	result class	text
grade	grade	text	max 10 characters
sgpa	sgpa	decimal	min 0; max 10
percentage	percentage	decimal	min 0; max 100
verification_type	verification type	text
attestation_type	attestation type	text
remark	remark	longtext
transcript_subjects	transcript subjects	table of transcript_subject
college_confirmation	college confirmation	select	one of: Accepted, Rejected, On hold
verified	verified	check	default false
errata	errata	check	default false
errata_notes	errata notes	text
upload_status	upload status	select	one of: Default, Requested, Updated; default "Default"
marksheet	marksheet	link → exam.marksheet
fetched_from_exam	fetched from exam	check	default false
extra_fields	extra fields	json

Permissions

Role	Can
sfc:admin	read, create, update, delete
sfc:verifier	read, update
sfc:signatory	read
sfc:printer	read
sfc:student	read, create, update — only own rows (via student)
sfc:agent	read, create, update — only own rows (via entered_by)

API

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