Eagle Software Customer Support Center

End User Queries


Aeries Query page. This page is a resource for users to share their queries with one another. Please forward your favorite query statements to Eagle at support@aeries.com Thank you! NOTE: Use your mouse to highlight the Query statement (called STRING), Right click with the mouse and select COPY, go into your Aeries Query, use your mouse and position the cursor into the statement area, right click the mouse and select PASTE, then chose the Query RUN command and see the results. As always, you can then run REPORT or LABELS to get a nice output.

	Name:	Class List for (Elementary Schools)

	Description:	Class list for Elementary Schools

	String:	LIST STU TCH STU.NM STU.GR STU.SX STU.PG STU.TL STU.FW STU.MW TCH.TE BY TCH.TE

	Notes:


	Name:	Print Labels for Contacts

	Description:	To print labels for Contacts identified with an 'A' in the mail tag to receive All Mailings

	String:	LIST STU CON CON.NM \ 'RE:' STU.NM \ CON.AD \ CON.CY CON.ST CON.ZC IF CON.MT = A

	Notes:	Run this statement, when list appears use the X on the output to close, then click on LABELS to create the label format.


	Name:	Parent / Student name differences

	Description:	Will yield a list of students and parents who have different names.

	String:	LIST STU PG LN IF PG ; LN

	Notes:


	Name:	Print Birthdays

	Description:	To print birthdays for a particular month, by teacher (Elementary Schools)

	String:	LIST STU TCH STU.NM STU.BD TCH.TE BY TCH.TE IF BD : 12//

	Notes:	Close select query, click on Report and page break by teacher.


	Name:	ADS code and dates of suspension

	Description:	List of students suspended with the ADS code and dates of suspension

	String:	LIST STU ADS STU.NM ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DS :

	Notes:


	Name:	ADS info for a specific disposition date

	Description:	List of students showing all ADS info for a specific disposition date

	String:	LIST STU ADS STU.NM STU.GR ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DD = 11/10/2004

	Notes:


	Name:	ADS info for a specific disposition entry & date

	Description:	List of students with ADS info for a specific disposition entry for a specific disposition date

	String:	LIST STU ADS STU.NM STU.GR ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DD = 11/10/2004 AND ADS.DS : "ASD"

	Notes:


	Name:	ADS list of students, who received a discipline transaction

	Description:	List of students with ADS info who received a discipline transaction on a specific date

	String:	LIST STU ADS STU.NM STU.GR ADS.DT ADS.CD ADS.DS ADS.DD ADS.ED IF ADS.DT = 6/15/2005

	Notes:


	Name:	ADS List identifying students by Student Number only

	Description:	List identifying students by SN only with all ADS info for any student whose disposition was suspension sorted by ADS code

	String:	LIST STU ADS STU.SN ADS.DT ADS.CD ADS.DS ADS.DY ADS.DD ADS.ED BY ADS.CD IF ADS.DS : SUSP

	Notes:


	Name:	ADS info for any student whose disposition was suspension sorted by student number

	Description:	List identifying students by SN only with all ADS info for any student whose disposition was suspension sorted by student number

	String:	LIST STU ADS STU.SN ADS.DT ADS.CD ADS.DS ADS.DY ADS.DD ADS.ED BY STU.SN IF ADS.DS : "SUSP"

	Notes:


	Name:	ATT code change

	Description:	Change to clear ATT code of "I" to a blank for all of the students in a specific class (section 7) for attendance period 1 on a specific date.

	String:	CHANGE STU SEC ATT ATT.A1 TO " " IF SEC.SE = 7 AND ATT.DT = 6/15/2005 AND ATT.A1 = I

	Notes:


	Name:	ATT data if student enter date is before 6/15/2005 ...

	Description:	List of student data and ATT data if their enter date is before 6/15/2005 OR their leave date was before or after 6/15/2005 BUT NOT INCLUDING 6/15/2005 sorted by the ATT tch# and the STU cns/tch#

	String:	LIST STU ATT STU.TG STU.NM STU.GR STU.CU ATT.TN STU.ED STU.LD ATT.DT ATT.CD BY ATT.TN STU.CU IF ATT.DT < 6/15/2005 AND ATT.CD = E OR ATT.CD = L AND ( ATT.DT < 6/15/2005 OR ATT.DT > 6/15/2005 )

	Notes:


	Name:	ATT absence dates, calendar day#, enter/leave codes

	Description:	List of ATT absence dates, calendar day#, enter/leave codes, absence all day codes for a specific student

	String:	LIST STU ATT STU.SN STU.TG STU.NM ATT.DT ATT.DY ATT.CD ATT.AL IF ATT.SN = 1234

	Notes:


	Name:	ATT total 1st period absences

	Description:	Total 1st period absences (not including tardies) for a specific period of time

	String:	TOTAL ATT IF A1 > " " AND A1 < Z AND A1 # T AND DT > 6/01/2005 AND DT < 6/15/2005

	Notes:


	Name:	ATT list of absence entries for specific day

	Description:	List of student's absence entries for every period for a specific day with their home telephone number and parent's work numbers

	String:	LIST STU ATT STU.SN STU.NM STU.GR STU.TL STU.MW STU.FW ATT.A0 ATT.A1 ATT.A2 ATT.A3 ATT.A4 ATT.A5 ATT.A6 ATT.A7 ATT.A8 ATT.A9 IF ATT.DT = 6/15/2005

	Notes:


	Name:	ATT list with section number, date and code

	Description:	List of students with their section number, attendance date, attendance code (if any) from 1st period for a specific section on a specific date

	String:	LIST STU SEC ATT STU.SN STU.NM SEC.SE ATT.DT ATT.A1 IF SEC.SE = 7 AND ATT.DT = 6/15/2005

	Notes:


	Name:	ATT total of all day absences between specific dates

	Description:	Total of all day absences between specific dates

	String:	TOTAL ATT IF AL > " " AND DT > 6/01/2005 AND DT < 6/15/2005

	Notes:


	Name:	ATT list of students with all day code

	Description:	List of students with their all day absence code if they were absent on a specific date sorted by grade

	String:	LIST STU ATT STU.NM STU.GR ATT.DT ATT.AL BY STU.GR IF ATT.DT = 6/15/2005 AND ATT.AL > " "

	Notes:


	Name:	ATT absence code list if students were absent within a specific period of time

	Description:	List of students with their ATT absence code if they were absent within a specific period of time

	String:	LIST STU ATT STU.LN STU.FN ATT.DT ATT.AL IF ATT.AL > "" AND ( ATT.DT > 6/01/2005 AND ATT.DT < 6/15/2005 )

	Notes:


	Name:	ATT List of 9th grade students who were absent within the first 20 days

	Description:	List of 9th grade students who were absent within the first 20 days of the school calendar with their absence codes and any special program designation sorted by the special program code, attendance day and attendance code

	String:	LIST STU ATT STU.SN STU.NM STU.SP STU.GR ATT.DY ATT.AL BY STU.SP ATT.DY ATT.AL IF ATT.DY < 21 AND ATT.AL > " " AND STU.GR = 9

	Notes:


	Name:	STU list of students with a blank line for data entry

	Description:	List of students with a blank line for data entry for each teacher's classes sorted by teacher name and period not including semester classes identified with an "S"

	String:	LIST STU SEC MST CRS TCH STU.LN STU.FN STU.GR MST.PD MST.SM CRS.CO "_________________________" TCH.TE BY TCH.TE MST.PD IF MST.SM # S

	Notes:


	Name:	ATT possible no show list

	Description:	List to find students who show as entering and leaving on the same day (possible no show list if date is the 1st day of school)

	String:	LIST STU ATT STU.LN STU.FN STU.TG ATT.DT ATT.CD IF ATT.CD = B

	Notes:


	Name:	ATT enter date and teacher number mismatches

	Description:	List to find teacher number mismatches between student counselor number (STU.CU) and attendance teacher number on the attendance enter date line

	String:	LIST STU ATT STU.SN STU.NM STU.CU ATT.DY ATT.CD ATT.TN IF STU.CU # ATT.TN AND ATT.CD = "E"

	Notes:


	Name:	ATT change teacher number to match enter or leave info.

	Description:	Change the students ATT teacher number to match the STU counselor/teacher number on either the ATT enter, leave or enter and leave date line

	String:	CHANGE STU ATT ATT.TN TO STU.CU IF ATT.CD = E OR ATT.CD = L OR ATT.CD = B

	Notes:


	Name:	ATT absence code list for specific day

	Description:	List of students with their ATT absence code for each day they were absent within a specific period of time sorted by absence code

	String:	LIST STU ATT STU.SN STU.GR ATT.AL ATT.DT BY ATT.AL IF ATT.AL > " " AND ATT.DT > 6/01/2005 AND ATT.DT < 6/15/2005

	Notes:


	Name:	CAR list with names and numbers of students' course changes

	Description:	List from CAR of student's names and student number whom have course changes after a certain date including CAR period, course number, section number and the CAR date

	String:	LIST STU CAR STU.SN STU.NM CAR.PD CAR.CN CAR.SE CAR.DS CAR.DE IF CAR.DS > 6/01/2005 OR CAR.DE > 6/15/2005

	Notes:


	Name:	CAR enrollment data for first 20 days of school

	Description:	List by student number of students enrolled in a specific section with their start date and end date for a specific period of time (in this query for the first 20 days of school)

	String:	LIST CAR SN CN DS DE D1 D2 SE IF SE = 169 AND D1 < 21 AND ( D2 = 0 OR D2 < 21 )

	Notes:


	Name:	CAR totals for specific date range and specific section

	Description:	Total from CAR of students who were enrolled in a specific section for a specific period of time (in this query for the first 20 days of school)

	String:	TOTAL CAR IF SE = 192 AND D1 < 21 AND D2 = 0 OR SE = 192 AND D1 < 21 AND D2 > 21

	Notes:


	Name:	COD list of home language code and descriptions

	Description:	List of all home language descriptions from the code table

	String:	LIST COD CD DE IF TC = STU AND FC = HL

	Notes:


	Name:	COL labels for specific colleges

	Description:	Labels for specific colleges addressed to Director of Admissions

	String:	LIST COL NM \

	Notes:


	Name:	CON lables to contacts

	Description:	Labels addressed to contacts re: students who are tagged with an A in the CON mail tag field

	String:	LIST STU CON CON.NM \ "RE:" STU.NM \ CON.AD \ CON.CY CON.ST CON.ZC IF CON.MT = "A"

	Notes:	Select Run, select the X and then choose labels to put this in the label format.


	Name:	CRS list of CSF codes

	Description:	List of courses with CSF code sorted by CSF code

	String:	LIST CRS CN CO C1 BY C1

	Notes:


	Name:	CRS list of courses by course number

	Description:	List of courses by course number, non academic/academic code, subject area codes, college prep code

	String:	LIST CRS CN CO NA S1 S2 S3 CP BY CN

	Notes:


	Name:	CRS change to add "A" before all course numbers

	Description:	Change to add "A" before all course numbers

	String:	CHANGE CRS CN TO (( "A" + CN ))

	Notes:


	Name:	FRM change FRM.SN to match the STU.SN

	Description:	Change the FRM.SN to match the STU.SN if the free & reduced student # is blank

	String:	CHANGE STU FRM FRM.SN TO STU.SN IF FRM.SN = NULL

	Notes:


	Name:	GRD list all O's in citizenship from grade table

	Description:	List of students who have all O's in citizenship from the grade table ignoring homeroom which is period Zero

	String:	Query #1: SKIP STU GRD IF GRD.CI = NULL Query #2: SKIP STU GRD IF GRD.CI # O Query #3: LIST STU GRD CRS STU.LN STU.FN STU.GR GRD.PD CRS.CO GRD.CI IF GRD.PD > 0

	Notes:


	Name:	GRD total number of comment 1 entries by code

	Description:	Total Number of GRD Comment 1 entries sorted by comment code

	String:	TOTAL GRD C1 BY C1

	Notes:


	Name:	GRD missing marks, Citizenship, Work Habits, Comment 1

	Description:	List of students who have missing marks in either M2, Citizenship, Work Habits, Comment 1 sorted alpha by teacher

	String:	LIST STU GRD TCH STU.NM STU.GR TCH.TE GRD.PD GRD.M2 GRD.CI GRD.WH GRD.C1 BY TCH.TE IF GRD.M2 = " " OR GRD.CI = " " OR GRD.WH = " " OR GRD.C1 = " " AND STU.TG = " "

	Notes:


	Name:	GRD list all grades by specific teacher

	Description:	List of students with all grades given by specific teachers sorted by teacher and course

	String:	LIST STU GRD CRS TCH STU.SN STU.NM GRD.CN CRS.CO GRD.M1 GRD.M2 GRD.M3 GRD.M4 TCH.TE BY TCH.TE GRD.CN IF GRD.TN = ### OR GRD.TN = ### OR GRD.TN = ###

	Notes:


	Name:	GRD list M2 grades and course number if M2 is not blank

	Description:	List of all students with their grades from M2 and the course number if M2 is not blank

	String:	LIST STU GRD STU.SN STU.NM GRD.CN GRD.M2 IF GRD.M2 > " " AND GRD.M2 < "Z"

	Notes:


	Name:	GRD total marks for specific courses by number

	Description:	Total of each grade mark given for specific courses sorted by crs# and mark

	String:	TOTAL GRD CN MK BY CN MK IF CN = #### OR CN = ####

	Notes:


	Name:	GRD list of D, F, or I grades for selected courses

	Description:	List of D, F, or I grades for selected courses from GRD table

	String:	LIST STU GRD STU.SN STU.NM STU.GR GRD.PD GRD.CN GRD.TN GRD.M1 BY GRD.CN IF ( GRD.CN = #### OR GRD.CN = #### OR GRD.CN = #### OR GRD.CN = #### ) AND ( GRD.M1 : D OR GRD.M1 : F OR GRD.M1 : I )

	Notes:


	Name:	HIS grade for all courses 1st term 04-05

	Description:	List of HIS students grades for all courses from the 1st term of the 04-05 year

	String:	LIST STU HIS CRS STU.SN STU.NM STU.GR HIS.CN CRS.CO HIS.TE HIS.YR HIS.MK IF HIS.TE = 1 AND HIS.YR = 04

	Notes:


	Name:	HIS list student’s grade, mark, term, year if mark is higher than C for both terms

	Description:	List of students with their grade, their mark, the term and year from HIS whom received a mark higher than a C for both 1st and 2nd terms for a specific course number

	String:	1.CHANGE STU QT TO “ “ 2.CHANGE STU HIS QT TO X IF HIS.CN = #### AND HIS.YR = 04 AND HIS.TE = 1 AND HIS.MK < C 3.CHANGE STU HIS STU.QT TO Z IF STU.QT = X AND HIS.CN = #### AND HIS.YR = 04 AND HIS.TE = 2 AND HIS.MK < C 4. LIST STU HIS STU.NM STU.GR HIS.YR HIS.TE HIS.CN HIS.MK IF STU.QT = Z AND HIS.CN = ####

	Notes:


	Name:	HIS list students with credits attempted, completed, GPA, rank, etc.

	Description:	List of students with their credits attempted, completed, total non-weighted GPA (cumulative from HIS), class rank, 10-12 academic non-weighted GPA (from HIS), UC rank, and class size, sorted by grade and class rank

	String:	LIST STU SN NM SX GR CA CC TPN CR CPN UR CS BY GR CR

	Notes:


	Name:	HIS data in a selected subject area sorted by grade

	Description:	List of students and their HIS data in a selected subject area sorted by grade. Also to identify students deficient in a given subject area

	String:	LIST STU HIS CRS STU.NM STU.GR HIS.CN CRS.CO CRS.S1 HIS.MK HIS.CR HIS.CC BY STU.GR IF CRS.S1 = "E"

	Notes:


	Name:	HIS change credits completed to match the credits attempted

	Description:	Change the HIS credits completed to match the credits attempted if a student received a specific mark

	String:	CHANGE HIS CC TO CR IF MK : "A" OR MK : "B" OR MK : "C" OR MK : "D" OR MK : "P"

	Notes:


	Name:	HIS list of student's various GPA's

	Description:	List of student's various GPA's, from HIS and the current marking period, along with class ranking and credit standing sorted by grade and class rank

	String:	LIST STU SN NM GR TP CR CS GP CP UR CA CC GG GT GK GS BY GR CR

	Notes:


	Name:	HIS list of 9th and 10th graders who have an F in specific course

	Description:	List of current 9th and 10th graders from HIS file who have received an F in specific course numbers

	String:	LIST STU HIS STU.SN STU.NM HIS.CN HIS.MK IF STU.GR < 11 AND HIS.MK : "F" AND ( HIS.CN = #### AND HIS.CN = #### OR HIS.CN = #### )

	Notes:


	Name:	HIS list of students by teacher with math grades from spring term

	Description:	List for a current teacher of all of his students math grades from HIS showing grade course was taken, year, term sorted by student name, HIS year, HIS term

	String:	1.KEEP STU SEC MST TCH IF MST.TN = ### AND MST.SM = "S" 2. LIST STU HIS CRS STU.LN STU.GR HIS.GR HIS.YR HIS.TE CRS.CO HIS.MK BY STU.NM HIS.YR HIS.TE IF HIS.S1 = B

	Notes:


	Name:	HIS list of student’s math marks and total math scores from STAR

	Description:	List of students math marks from HIS and their total math scores from STAR

	String:	LIST STU TST HIS CRS STU.NM CRS.CO HIS.YR HIS.TE HIS.MK TST.ID TST.TD TST.PT TST.SS BY STU.NM HIS.YR HIS.TE IF CRS.S1 = B AND TST.ID = CAT-6 AND TST.PT = 4

	Notes:


	Name:	IMM List of students who need either their 2nd MMR shot or any of their hepatitis shots from IMM

	Description:	List of students who need either their 2nd MMR shot or any of their hepatitis shots from IMM

	String:	LIST STU IMM STU.LN STU.FN IMM.A2 IMM.I1 IMM.I2 IMM.I3 IF IMM.A2 = NULL OR IMM.I1 = NULL OR IMM.I2 = NULL OR IMM.I3 = NULL

	Notes:


	Name:	IMM labels to parents

	Description:	Labels to parents of students who need either their 2nd MMR shot or any of their hepatitis shots from IMM

	String:	LIST STU IMM STU.PG \

	Notes:


	Name:	LKR all lockers in the locker file to students no longer in STU file

	Description:	List that shows all lockers in the locker file assigned to student numbers which are no longer in the STU file, sorted by locker number

	String:	LIST LKR STU LKR.LK LKR.SN STU.SN STU.GR STU.LK BY LKR.LK IF STU.SN = NULL

	Notes:


	Name:	LKR change locker file SN to 0 for students no longer in STU file

	Description:	Change the locker file SN to 0 for those lockers with student numbers no longer in the student file

	String:	CHANGE LKR STU LKR.SN TO 0 IF STU.SN = NULL

	Notes:


	Name:	LKR list for unassigned lockers

	Description:	List to show all unassigned lockers and their combinations

	String:	LIST LKR LK CM SN BY LK IF SN = 0

	Notes:


	Name:	LKR change student numbers to match

	Description:	Change to have student number in the locker table match the student number in STU data locker field

	String:	CHANGE LKR STU LKR.SN TO STU.SN IF STU.LK > " "

	Notes:


	Name:	MST labels

	Description:	Labels for informational purposes for 1st period, fall semester teachers: custom info on 1st line, student name on 2nd, MST section number, STU grade and MST period on 3rd, TCH name and MST room# on 4th sorted by teacher name

	String:	LIST STU SEC MST TCH "ARENA 06/15/2005" \ STU.NM \ "SEC:" MST.SE "GRADE:" STU.GR "PD:" MST.PD \ "TCH:" TCH.TE "RM" MST.RM BY TCH.TE IF MST.SM = "F" AND MST.PD = 1

	Notes:


	Name:	MST list of students not in a specific course

	Description:	List of students who are not in a specific course sorted by grade

	String:	1.SKIP STU SEC MST IF MST.CN = #### 2. LIST STU SN LN FN GR BY GR

	Notes:


	Name:	MST list total boys and girls for each teacher...

	Description:	List to get total number of boys and girls for each teacher who has a 6th period class that is not a fall class

	String:	LIST MST TCH MST.SE MST.PD MST.TN TCH.TE MST.TB MST.TG MST.SM BY TCH.TE IF MST.SM # F AND MST.PD = 6

	Notes:


	Name:	MST List of all section numbers and periods a specific course is offered

	Description:	List of all section numbers and periods a specific course is offered

	String:	LIST MST CRS MST.SE MST.PD MST.CN CRS.CO IF MST.CN = ####

	Notes:


	Name:	MST list all students with section number and teacher name of their 1st period class sorted by teacher name

	Description:	List of all students with section number and teacher name of their 1st period class

	String:	LIST STU SEC MST TCH STU.LN STU.FN STU.GR MST.SE TCH.TE BY TCH.TE IF MST.PD = 1

	Notes:


	Name:	MST Change the student's counselor/teacher number to match the MST teacher number for period 6 for all grade levels but 6

	Description:	Change the student's counselor/teacher number to match the MST teacher number for period 6 for all grade levels but 6

	String:	CHANGE STU SEC MST STU.CU TO MST.TN IF MST.PD = 6 AND GR # 6

	Notes:


	Name:	MST List of classes in the MST file with incorrect credit values sorted by course number

	Description:	List of classes in the MST file with incorrect credit values sorted by crs#

	String:	LIST MST CRS TCH MST.SE MST.PD MST.CN CRS.CO TCH.TE MST.ST MST.TS MST.CR BY MST.CN IF MST.CR # 5

	Notes:


	Name:	MST labels for students in a specific class