Four new primary teacher related extended fields are added to Aeries Query that will only be available for schools that have the Track Primary Classes option enabled. These fields evaluate each student's class schedule and finds the current Primary Class with the corresponding Primary Teacher from section staff (SSE).
These extended query fields are: PRIMARYTEACHERNAME, PRIMARYTEACHERID (Staff ID of the primary teacher), PRIMARYCOURSENAME, PRIMARYCOURSEID, and PRIMARYSECTIONNO.
Primary Teacher Extended Fields ↑
|Extended Query Name||Description||Notes|
|PRIMARYTEACHERNAME||Displays full name as displayed on the section staff record||From the SSE (MST) or SSM (SMS) table|
|PRIMARYTEACHERID||Displays the staff id for the section staff record||From the SSE (MST) or SSM (SMS) table|
|PRIMARYCOURSENAME||Displays the course name||From the CRS table|
|PRIMARYCOURSEID||Displays the course number||From the CRS table|
|PRIMARYSECTIONNO||Displays section number||From the MST.SE or SMS.SE field|
Query Commands ↑
LIST - Extended Fields can be included in the column list like any other field. Example: List all students' primary teacher or section information.
LIST STU ID NM GR PRIMARYTEACHERNAME
LIST STU ID LN FN GR PRIMARYTEACHERID PRIMARYTEACHERNAME PRIMARYCOURSEID PRIMARYCOURSENAME PRIMARYSECTIONNO
TOTAL - Total number of students per primary teacher
TOTAL STU PRIMARYTEACHERNAME BY PRIMARYTEACHERNAME
SKIP - Skip students for a specific teacher id or teacher name
SKIP STU IF PRIMARYTEACHERID = 200378171
SKIP STU IF PRIMARYTEACHERNAME : ACOSTA
KEEP - Keep students for a specific teacher
KEEP STU IF PRIMARYTEACHERNAME : ACOSTA
NOTE: CHANGE or Query Change functions do not modify the extended field data. These fields are read-only.