Overview 

Security 

Primary Teacher Extended Fields 

Query Commands


Overview 

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.


More information on all Extended Student Fields for Query can be found in the following document. 

Extended Student Fields for Query


Security  

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 NameDescriptionNotes
PRIMARYTEACHERNAMEDisplays full name as displayed on the section staff recordFrom the SSE (MST) or SSM (SMS) table
PRIMARYTEACHERIDDisplays the staff id for the section staff recordFrom the SSE (MST) or SSM (SMS) table
PRIMARYCOURSENAMEDisplays the course nameFrom the CRS table
PRIMARYCOURSEIDDisplays the course numberFrom the CRS table
PRIMARYSECTIONNODisplays section numberFrom 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.