wiki:DataEntryResolution

A list of issues that DEOs and Dev team should be aware of and should take appropriate actions:-

DEO DEV query
1. If incorrect student entry is done then make a note of the student id and assessment and send it to dev team delete the answer records for that student and assessment id delete from schools_answer where object_id=x and question_id in (select id from schools_question where assessment_id=y)
2 If an error is made in double entry make a note of the student id and assessment and send it to dev team mark the double entry status as 1 and ask DEO to do entry again update schools_answer set "doubleEntry"=1 where object_id=x and question_id in (select id from schools_question where assessment_id=y)
3 delete the students marked as TC or to be deleted by the field staff. This should be done at the time of assessment entry itself.
4 If duplicate students are found. Make a note of students that are duplicates and send it to the dev team. Check which student is a duplicate (not mapped to assessments before and hard delete (?) the student)
5 Mail the DEV team once assessment double entry is done At the end of assessment entry run a query to check if double entry is completed. If not send the list to the DEO supervisor to ensure it is done. select distinct p.name as programme_name,ass.name as assessment_name,
ass.id as assessment_id,b2.name as district,b1.name as block,b.name as cluster,s.name as schoolname,se.object_id as student_id,c."firstName" as firstname,
q.name as questionname,u.username
from auth_user u, schools_student_studentgrouprelation stusg,schools_studentgroup sg,
schools_institution s,schools_boundary b2,schools_boundary b1,schools_boundary b, schools_programme p,schools_answer se,schools_question q,schools_assessment ass,schools_student stu,schools_child c
where se.question_id=q.id and q.assessment_id=ass.id and ass."doubleEntry"=true
and se."doubleEntry"=1 and ass.programme_id=p.id and p.id in (programme_id) and se.object_id=stu.id and stu.child_id=c.id and stusg.student_id=se.object_id and stusg.student_group_id=sg.id and sg.institution_id=s.id and s.boundary_id=b.id
and b.parent_id=b1.id and b1.parent_id=b2.id and b2.id=boundary_id and stusg.active=2 and se.user1_id=u.id order by p.name,ass.id,b2.name,b1.name,b.name,s.name;
6 If student is mapped to incorrect center and incorrect entry is done. Then make a note of student id and assessment for which incorrect entry was done. The incorrect mapping should be deleted (status 0) and the assessment record should be deleted as well (hard delete) delete from schools_answer where object_id=1683712 and question_id in (select id from schools_question where assessment_id=149);
Last modified 5 years ago Last modified on 06/20/13 14:36:20