Primary Teacher Extended Fields
Four primary teacher related extended fields are available in 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.
More information on all Extended Student Fields for Query can be found in the following document.
Extended Student Fields for Query
Users do not need any special permissions to use Extended Fields in their queries. The ability to use these extended fields in query are based on Read permissions to the STU table.
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.