Student Load for a Particular Term

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.

 

Student load is automatically created and calculated for every student. You can retrieve a student’s term load by running the following query:

Release 6.3.x and above

SELECT sttr.stuLoad, sttr.termCode, person.fname, person.lname
FROM sttr
LEFT JOIN person
ON sttr.stuID = person.personID
WHERE sttr.termCode = '2013/FA';

Release 6.2.x and below

SELECT a.stuLoad, a.termCode, b.fname, b.lname
FROM stu_term_load a
LEFT JOIN person b
ON a.stuID = b.personID
WHERE a.termCode = '13/FA';

 

Last Modified: Jun 23, 2017 @ 12:16 AM

Was this article helpful?

Related Articles