Marksheet

exam.marksheet · every change is kept in the audit log · numbered MS-{YYYY}-{######}

Fields

Every record also has id, created_at and updated_at.

Field	Label	Type	Rules
exam	exam	link → exam.exam
exam_form	exam form	link → exam.exam_form
student	student	link → core.student	required
college	college	link → core.college	required
programme	programme	link → core.programme	required
semester	semester	select	required; 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
academic_year	academic year	link → core.academic_year
printed_name	printed name	text	required; personal data
seat_number	seat number	text
exam_month	exam month	select	one of: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec
exam_year	exam year	number
result_type	result type	select	required; one of: Regular, Repeater, Additional, Re-exam
result	result	select	one of: Successful, Unsuccessful
grade	grade	text
final_grade	final grade	text
grace_summary	grace summary	text
total_max	total max	decimal
total_obtained	total obtained	decimal
sgpa	sgpa	decimal	min 0; max 10
cgpa	cgpa	decimal	min 0; max 10
total_credits	total credits	decimal
credits_earned	credits earned	decimal
activity_credits	activity credits	decimal
activity_credits_allowed	activity credits allowed	check	default false
subjects	subjects	table of marksheet_subject
semester_history	semester history	table of marksheet_semester
attempt	attempt	number	min 0
has_backlog	has backlog	check	default false
version	version	number	default 0; min 0
is_revaluation	is revaluation	check	default false
is_revaluation_additional	is revaluation additional	check	default false
post_exam_month	post exam month	select	one of: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec
post_exam_year	post exam year	number
declaration_date	declaration date	date
gracing_academic_year	gracing academic year	link → core.academic_year
student_degree_type	student degree type	select	one of: Year Repeater, Dual Degree
pattern	pattern	select	one of: NEP 2023, NEP 2024, CBCS 2020
source	source	select	one of: Generated, Imported; default "Generated"
is_superseded	is superseded	check	default false
is_locked	is locked	check	default false
verification_code	verification code	text	unique
document	document	file

Permissions

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

API

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