Are you new to the eduTrac SIS online user's manual? If so, click here for a starting point. If you are looking for technical documentation, then check out the Wiki.
Use the example query in order to run a final grade report.
Release 6.3.x and above
SELECT stac.stuID AS 'Student ID', CONCAT(person.lname,', ',person.fname) AS 'Student Name', stac.courseSection AS 'Course Section', stac.shortTitle AS 'Course Title', stac.grade AS 'Final Grade' FROM stac LEFT JOIN person ON stac.stuID = person.personID WHERE stac.termCode = '2013/FA';
Release 4.4 => 6.2.x
SELECT a.stuID AS 'Student ID', CONCAT(b.lname,', ',b.fname) AS 'Student Name', a.courseSection AS 'Course Section', a.shortTitle AS 'Course Title', a.grade AS 'Final Grade' FROM stu_acad_cred a LEFT JOIN person b ON a.stuID = b.personID WHERE a.termCode = '13/FA';
Release 4.3 and below
SELECT a.stuID AS 'Student ID', CONCAT(b.lname,', ',b.fname) AS 'Student Name', CONCAT(a.termCode,'-',a.courseSecCode) AS 'Course Section', c.secShortTitle AS 'Course Title', a.grade AS 'Final Grade' FROM stu_acad_cred a LEFT JOIN person b ON a.stuID = b.personID LEFT JOIN course_sec c ON a.courseSecCode = c.courseSecCode AND a.termCode = c.termCode WHERE a.termCode = '13/FA';
Last Modified: