diff --git a/erpnext/schools/api.py b/erpnext/schools/api.py
index f6ada4e..eb9aac2 100644
--- a/erpnext/schools/api.py
+++ b/erpnext/schools/api.py
@@ -74,15 +74,15 @@
 	:param course_schedule: Course Schedule.
 	:param status: Status (Present/Absent)
 	"""
-	student_attendance_list = frappe.get_list("Student Attendance", fields = ["name"], filters = {
+	student_attendance = frappe.db.get_value("Student Attendance", filters = {
 		"student": student,
 		"course_schedule": course_schedule,
 		"student_batch": student_batch,
 		"date": date
 	})
 		
-	if student_attendance_list:
-		student_attendance = frappe.get_doc("Student Attendance", student_attendance_list[0])
+	if student_attendance:
+		student_attendance = frappe.get_doc("Student Attendance", student_attendance)
 	else:
 		student_attendance = frappe.new_doc("Student Attendance")
 	student_attendance.student = student
@@ -293,4 +293,4 @@
 			email = frappe.db.get_value("Guardian", guard.guardian, "email_address")
 			if email:
 				email_list.append(email)	
-	add_subscribers(name, email_list)
\ No newline at end of file
+	add_subscribers(name, email_list)