Aeries Sample 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 choose 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:	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 whose disposition is suspension 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:	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 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 # T AND DT > 12/01/2008 AND DT < 12/15/2008
	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 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:	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 \ "DIRECTOR OF ADMISSIONS" \ AD \ CY ST ZC IF ID = ####
	Notes:	Replace the #'s with the Aeries college ID number. Run the query, close the output box, click on the 'Labels' button on the right side of the Query form.

	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 IF 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 > " "
	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 08-09
	Description:	List of HIS students grades for all courses from the 1st term of the 08-09 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 = 08
	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 STU.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 courses
	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 :
	Notes:

	Name:	HIS list of students by spring term teacher with math grades
	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 =
	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 = CST AND ( TST.PT = ## OR TST.PT = ## OR TST.PT = ## )
	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 \ STU.AD \ STU.CY STU.ST STU.ZC IF IMM.A2 = NULL OR IMM.I1 = NULL OR IMM.I2 = NULL OR IMM.I3 = NULL
	Notes:

	Name:	LKR assigned 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 if the locker field on STU is populated
	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 course
	Description:	Labels for students in a specific class with their name, grade, track, course number, course title, teacher name and period sorted by teacher name
	String:	LIST STU SEC MST CRS TCH STU.NM \
	Notes:

	Name:	MST List of students with their course number, course name, teacher name
	Description:	List of students with their course number, course name, teacher name, mst period if they have specific teachers sorted by teacher name and mst period
	String:	LIST STU SEC MST CRS TCH STU.SN STU.NM CRS.CO CRS.CN TCH.TE MST.PD BY TCH.TE MST.PD IF MST.TN = 100 OR MST.TN = 80 OR MST.TN = 214
	Notes:

	Name:	SEC list students who have no classes
	Description:	List of students who have no classes from STU/MST
	String:	LIST STU SEC STU.NM STU.GR SEC.SE IF SEC.SE = "NULL"
	Notes:

	Name:	SSS list with student's name, student number, SSS course number and section number, SMS period sorted by period if the period is higher than 6
	Description:	List with student's name, student number, SSS course number and section number, SMS period sorted by period if the period is higher than 6
	String:	LIST STU SSS SMS STU.SN STU.NM SSS.CN SSS.SE SMS.PD BY SMS.PD IF SMS.PD > 6
	Notes:

	Name:	SSS change to unlock selected courses
	Description:	Change to unlock selected SSS courses by course number
	String:	CHANGE SSS RT TO " " IF RT = "*" AND CN = ####
	Notes:

	Name:	SSS list of students who have a specific course
	Description:	List of students who have a specific course
	String:	LIST STU SSS STU.SN STU.NM STU.GR SSS.CN IF SSS.CN = ####
	Notes:

	Name:	SSS change to lock classes for a selected grade level
	Description:	Change to lock SSS classes for a selected current grade level
	String:	CHANGE STU SSS SSS.RT TO "*" IF SSS.SE > 0 AND STU.GR = 7
	Notes:

	Name:	SSS list of students who have requested course number 1000
	Description:	List of students who have requested course number 1000
	String:	LIST STU SSS CRS STU.LN STU.FN SSS.CN CRS.CO IF SSS.CN = 1000
	Notes:

	Name:	SSS change to lock all section numbers for students in next grade 12
	Description:	Change to lock all section numbers for students in next grade 12
	String:	CHANGE STU SSS SSS.RT TO "*" IF STU.NG = 12 AND SSS.SE > 0
	Notes:

	Name:	SSS list of current 10th grade students who do not have a course number within a specific range
	Description:	List of current 10th grade students who do not have a course number within a specific range (possibly English if all English courses are in the 3000 range)
	String:	1.SKIP STU SSS IF ( SSS.CN > 2999 AND SSS.CN < 4000 ) AND STU.GR = 10 2. LIST STU SN NM GR IF GR = 10
	Notes:

	Name:	STU total GPA higher than 3.0 or tagged in U8
	Description:	List of students who have a GT (total weighted GPA from the current marking period) 3.0 or higher OR if they are tagged in U8 with an O
	String:	LIST STU SN NM GR GT U8 QT IF GT > 2.99 OR U8 = O
	Notes:

	Name:	STU total of 6th grade males and females if the status tag has an * sorted by grade and sex
	Description:	Total of 6th grade males and females if the status tag has an * sorted by grade and sex
	String:	TOTAL STU GR SX BY GR SX IF GR = 6 AND TG = "*"
	Notes:

	Name:	STU list of students with May birthdays
	Description:	List of students with a birthday in May (month 5)
	String:	LIST STU SN NM GR BD IF BD : 5//
	Notes:

	Name:	STU labels with student's name on the 3rd line down
	Description:	Labels with the student's name on the 3rd line down
	String:	LIST STU " " \ " " \ FN LN
	Notes:

	Name:	STU list of students who entered after a certain date
	Description:	List of students who entered after a certain date with their teacher/counselor name
	String:	LIST STU TCH STU.NM TCH.TE STU.GR STU.ED IF STU.ED > 09/06/2005
	Notes:

	Name:	STU list of students who left after a certain date
	Description:	List of students who left after a certain date with their teacher/counselor name
	String:	LIST STU TCH STU.NM TCH.TE STU.GR STU.LD IF STU.TG # " " AND STU.LD > 11/10/2004
	Notes:	Check to Include Inactives on Query screen

	Name:	STU list of students with their last school's number and name
	Description:	List of students with their last school's number and name
	String:	LIST STU SN NM LS LS?
	Notes:

	Name:	STU list of student data sorted by 1st period teacher
	Description:	List of student data sorted by 1st period teacher
	String:	LIST STU SEC MST TCH STU.SN STU.LN STU.FN STU.AD STU.CY STU.ZC STU.TL TCH.TE BY TCH.TE IF PD = 1
	Notes:

	Name:	STU list of student info with blank line for data entry sorted by teacher name and period
	Description:	List of student info with blank line for data entry sorted by teacher name and period
	String:	LIST STU SEC MST CRS TCH STU.SN STU.NM STU.GR TCH.TE "___________________________" BY TCH.TE MST.PD
	Notes:

	Name:	STU list of students whose birthday is in October sorted by teacher name
	Description:	List of students whose birthday is in October sorted by teacher name
	String:	LIST STU TCH STU.NM STU.GR STU.SX STU.BD TCH.TE BY TCH.TE IF STU.BD : 10//
	Notes:

	Name:	STU list of student's birthdays sorted by their teacher's name and the student's birthday
	Description:	List of student's birthdays sorted by their teacher's name and the student's birthday
	String:	LIST STU TCH STU.NM STU.BD TCH.TE BY TCH.TE STU.BD
	Notes:

	Name:	STU change user code 8 to tag citizenship
	Description:	Change STU U8 to tag students who received an N, S, U or no mark in citizenship
	String:	CHANGE STU GRD STU.U8 TO X IF GRD.CI = " " OR GRD.CI = N OR GRD.CI = S OR GRD.CI = U
	Notes:

	Name:	STU list of student's info sorted by their teacher name and the student's sex
	Description:	List of student's info sorted by their teacher name and the student's sex
	String:	LIST STU TCH STU.NM STU.GR STU.SX STU.TL TCH.TE BY TCH.TE STU.SX
	Notes:

	Name:	STU list of students with their enter date who have entered school since ...
	Description:	List of students with their enter date who have entered school since 09/07/2004 sorted by grade and enter date
	String:	LIST STU SN NM GR ED LD SP TR BY GR ED IF ED > 09/07/2004
	Notes:

	Name:	STU list of students with their leave date who have left school since ...
	Description:	List of students with their leave date who have left school since 11/10/2004 sorted by grade and leave date
	String:	LIST STU SN NM GR ED LD SP TR BY GR LD IF LD > 11/10/2004
	Notes:

	Name:	STU change the graduation date field to the date of graduation if the student is in grade 12
	Description:	Change the graduation date field to the date of graduation if the student is in grade 12
	String:	CHANGE STU DG TO 6/##/#### IF GR = 12
	Notes:

	Name:	STU change students next grade field to 1 grade higher than their grade field
	Description:	Change students next grade field to 1 grade higher than their grade field
	String:	CHANGE STU NG TO (( GR + 1 ))
	Notes:

	Name:	STU list with student name, birthdate and age
	Description:	List with student name, birthdate and age
	String:	LIST STU NM BD BD?
	Notes:

	Name:	STU list of students with a blank space in the first or last name field
	Description:	List of students with a blank space in the first or last name field
	String:	STU SN LN FN IF LN : " " OR FN : " "
	Notes:

	Name:	STU list of students and parents who have different last names
	Description:	List of students and parents who have different last names
	String:	LIST STU PG LN IF PG ; LN
	Notes:

	Name:	TST list of students with test info from CST part 22 who are tagged in U5
	Description:	List of students with test info from CST part 22 who are tagged in U5
	String:	LIST STU TST CTL STU.SN STU.NM STU.GR STU.U5 TST.ID TST.PT CTL.NM TST.SS TST.RS BY STU.U5 IF TST.ID = CST AND TST.PT = 22 AND ( STU.U5 = S OR STU.U5 = R )
	Notes:

	Name:	TST list of students with test data from CST part 1 ...
	Description:	List of students with test data from CST part 1 if the student is tagged in U5 with an S OR from test part 5 if the student is tagged in U5 with an R (including the test part description)
	String:	LIST STU TST CTL STU.SN STU.NM STU.GR STU.U5 TST.ID TST.PT CTL.NM TST.PC BY STU.U5 IF TST.ID = CST AND ( STU.U5 = S AND TST.PT = 1 )OR ( STU.U5 = R AND TST.PT = 5 )
	Notes:

	Name:	TST list of students with data who received less than a scale score of 350 on CAHSEE test part 1 OR ...
	Description:	Description: List of students with TST data who received less than a scale score of 350 on CAHSEE test part 1 OR test part 21 for the test taken 03/04, sorted by grade level
	String:	LIST STU TST STU.SN STU.NM STU.GR TST.DT TST.PT TST.SS BY STU.GR IF TST.ID = CAHSEE AND TST.SS < 350 AND TST.DT = 0304 AND ( TST.PT = 1 OR TST.PT = 21 )
	Notes:

	Name:	TST list of students with their competency test results sorted
	Description:	List of students with their competency test results sorted by teacher and period for all students taking an English class (S1 is subject code in CRS, C is the code for English classes)
	String:	LIST STU SEC MST CRS TCH STU.SN STU.NM STU.GR STU.T1 STU.T3 MST.PD CRS.CO TCH.TE BY TCH.TE MST.PD IF CRS.S1 = "C"
	Notes:

	Name:	TST Keep students if they received a raw score less than 10 on part 4 of the CAT-6 test
	Description:	Keep students if they received a raw score less than 10 on part 4 of the CAT-6 test
	String:	KEEP STU TST IF TST.ID = CAT-6 AND TST.PT = 4 AND TST.RS < 10
	Notes:

	Name:	TST list of non-seniors with a high GPA
	Description:	List of non-seniors with a high GPA (from the current marking period) and a raw score less than 550 in parts 1, 2, 4 of CAT-6 sorted first by grade
	String:	LIST STU TST CTL STU.NM STU.GR CTL.NM STU.TP TST.PT TST.RS BY STU.GR STU.NM IF STU.GR # 12 AND STU.TP > 2.999 AND TST.ID = CAT-6 AND TST.RS < 550 AND ( TST.PT = 1 OR TST.PT = 2 OR TST.PT = 4 )
	Notes:

	Name:	VIS list of student's VIS or CNF entries...
	Description:	List of student's VIS (or CNF) entries for a specific code entry within a specific date range sorted by counselor number. (If querying from CNF substitute CNF for VIS.)
	String:	LIST STU VIS STU.NM VIS.CD STU.CU BY STU.CU IF VIS.CD = "MB" AND ( VIS.DT > 09/07/2004 AND VIS.DT < 04/15/2005 )
	Notes:

	Name:	MHS list by teacher by period of only those students who have a comment in MHS
	Description:	Yields a health list by teacher by period of only those students who have a health comment. Can be used as a confidential health list to all teachers of students assigned to them.
	String:	LIST MHS STU SEC MST TCH TCH.TE MST.PD STU.NM STU.GR MHS.CO BY TCH.TE
	Notes:	Thank you John Casey for supplying this Query.

	Name:	Emergency Student List
	Description:	This query will give you a list of students by room for any period during the day. It will print parent information including telephone numbers and names.
	String:	LIST STU SEC MST STU.SN STU.LN STU.FN MST.PD MST.RM STU.PG STU.TL STU.FW STU.FX STU.MW STU.MX BY MST.RM STU.LN STU.FN STU.SN
	Notes:

	Name:	California High School Exit Exam
	Description:	Students who passed (TST.RS = 1) Part One (Math) of the CAHSEE (California High School Exit Exam) Test.
	String:	LIST STU TST STU.SN STU.LN STU.FN STU.TG? TST.ID TST.PT TST.RS IF TST.ID = CAHSEE AND TST.RS = 1 AND TST.PT = 1
	Notes:	The query of course could then be changed for Part 21 (English) or any other Part needed. Sharon Puett Information Systems Technician Fallbrook Union High School

	Name:	TXT List students without required textbooks for a specific course
	Description:	List students without required textbooks for a specific course
	String:	1. KEEP STU SEC MST IF MST.CN = #### 2. SKIP STU TBC IF TBC.TN = #### 3. LIST STU SN NM
	Notes:

	Name:	Checked-out Textbooks by Class
	Description:	It will display textbooks checked out to students. Sorting by student#, text# and period with the student's English class(es) (course department = "E")
	String:	LIST STU TBC SEC MST CRS STU.SN STU.NM SEC.SE MST.PD TBC.TN TBC.CY MST.TN CRS.CO CRS.DC BY STU.SN TBC.TN MST.PD IF CRS.DC =
	Notes:	You could also limit by textbook number or MST period, etc.

	Name:	Students who have not taken a specific course
	Description:	This query will give you a list of students who have not taken a specific course. The 1st query skips students based upon HIS records. The 2nd query skips students who are currently enrolled in the course. The 3rd query will give you the list.
	String:	SKIP STU HIS IF HIS.CN = XXXX SKIP STU SEC MST IF MST.CN = XXXX LIST STU SN NM GR
	Notes:	Replace the X's with your Course ID.

	Name:	Students with CAPA Scores - from District DB
	Description:	List of students including CSE disability code with CAPA scores sorted by School Code, Student Name, Test Part, Test Date
	String:	LIST STU IDN TST CSE STU.SC STU.ID STU.NM STU.GR CSE.DI TST.PL TST.PT TST.SS TST.DT BY STU.SC STU.NM TST.PT TST.DT IF TST.ID = CAPA
	Notes:

	Name:	List of Students with their Math Course Sorted by 1st Period Teacher
	Description:	This query will give you a list of students with their math course sorted by their 1st period teacher. The math course is identified by the department code, CRS.DC = M. This query is very useful for pre-id purposes.
	String:	LIST STU SEC MST CRS TCH STU.LN STU.FN STU.MN STU.GR MST.PD TCH.TE CRS.DC CRS.DE IF CRS.DC = "M" OR MST.PD = 1
	Notes: