Batch Registration Query

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.

 

When you need to batch register a group of students into a course section, there are two ways you can create a saved query.

Use this first query example if you need to grab a list of student ID’s from a course section that is going to be cancelled and you need to re-register them into a new course section. This query selects all students based on a certain criteria that have a registration status of  ‘A’ and ‘N’.

Release 6.3.x and above

SELECT stuID
FROM stcs
WHERE courseSection = '2013/FA-EMATH-1001-01'
AND status IN('A','N');

Use this second query example if you have a list of student ID’s and want them registered into a particular course section if they are active students.

SELECT stuID
FROM student
WHERE stuID IN('1221','3423','1834')
AND status = 'A';

Release 4.4 -> 6.2.x

SELECT stuID
FROM stu_course_sec
WHERE courseSection = '13/FA-EMATH-1001-01'
AND status IN('A','N');

Release 4.3 & Below

SELECT stuID
FROM stu_course_sec
WHERE courseSecCode = 'EMATH-1001-01'
AND termCode = '13/FA'
AND status IN('A','N');

 

 

Last Modified: Jul 16, 2019 @ 8:22 AM

Was this article helpful?

Related Articles