Security  

Primary Teacher Extended Fields  

Query Commands 

Letter Text Editor  


Overview 

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


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.


Letter Text Editor  ↑


The extended fields: PRIMARYTEACHERNAME and PRIMARYTEACHERID are supported in several letters in a flex school where primary class tracking is enabled.

  • Asset Letter

  • Attendance Letter

  • Discipline Letter 

  • Fee Letter

  • Graduation Status Letter

  • Physical Fitness Letter

  • Query Letter

  • Suspension Letter

  • Course Request Letter

  • Scheduling Letter