Queries

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. We appreciate it! 

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 and select PASTE. Then choose the RUN command to see the results. As always, you can then run REPORT or LABELS to get a nice output.

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:

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.

Notes: Replace the X's with your Course ID.

String:

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:

Name: TXT List students without required textbooks for a specific course

Description: List students without required textbooks for a specific course

String:

Name: TXT 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")

Notes: You could also limit by textbook number or MST period, etc.

String:

Name: TST List of Students who have passed Part 1 California High School Exit Exam

Description: Students who passed (TST.RS = 1) Part One (Math) of the CAHSEE (California High School Exit Exam) Test.

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

String:

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:

Name: TST 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:

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:

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:

Name: STU list of students and parents who have different last names

Description: List of students and parents who have different last names

String:

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:

Name: STU list with student name, birthdate and age

Description: List with student name, birthdate and age

String:

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:

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:

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:

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:

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:

Name: STU list of student data sorted by 1st period teacher

Description: List of student data sorted by 1st period teacher

String:

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:

Name: STU list of students with May birthdays

Description: List of students with a birthday in May (month 5)

String:

Name: SSS list of students who have requested course number 1000

Description: List of students who have requested course number 1000

String:

Name: SSS list of students who have a specific course

Description: List of students who have a specific course

String:

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:

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:

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:

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:

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:

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:

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:

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.

Notes: Thank you John Casey for supplying this Query.

String:

Name: LKR list for unassigned lockers

Description: List to show all unassigned lockers and their combinations

String:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

Name: GRD total number of comment 1 entries by code

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

String:

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:

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:

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:

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:

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:

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:

Name: Print Labels for Contacts

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

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

String:

Name: Print Birthdays

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

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

String:

Name: Class List for (Elementary Schools)

Description: Class list for Elementary Schools

String:

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:

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:

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:

Name: SSS change to unlock selected courses

Description: Change to unlock selected SSS courses by course number

String:

Name: SEC list students who have no classes

Description: List of students who have no classes from STU/MST

String:

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:

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:

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:

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:

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

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

String:

Name: COL labels for specific colleges

Description: Labels for specific colleges addressed to Director of Admissions

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.

String:

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:

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:

Name: COD list of home language code and descriptions

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

String:

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:

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:

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:

Name: ATT total 1st period absences

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

String:

Name: Authorizations in place on a given date

Description: Authorizations in place on a given date

String:

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:

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:

Name: ATT total of all day absences between specific dates

Description: Total of all day absences between specific dates

String:

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:

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:

Name: CRS list of CSF codes

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

String:

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:

Name: SSS change to lock classes for a selected grade level

Description: Change to lock SSS classes for a selected current grade level

String:

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:

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

Notes: Check to Include Inactives on Query screen

String:

Name: FEE - 8th Grade Students with Unpaid Fees

Description: List of grade 8 students who have an outstanding fee with the fee code and the amount owed.

String:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

Name: Finding students with/without CON links

Description: Finding students with/without CON links

Notes: Finding students with/without CON links

String:

Name: ADS/DSP Information for a Specific Disposition Entry and a Specific Disposition Start Date

Description: List of students with ADS/DSP info who received a specific disposition entry on a specific disposition start date

String:

Name: Students Who Received an ADS/DSP Transaction on a Specific Date

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

String:

Name: Students Suspended During the Current School Year with ADS/DSP Information

Description: List of students suspended with the ADS code description, the ADS/DSP disposition(s), and dates of suspension if the suspension occurred during the current year

String:

Name: ADS/DSP Information for a Specific Disposition Start Date

Description: List of students showing ADS/DSP info for a specific disposition start date

String:

Name: ADS/DSP List Identifying Students by ID Only Whose Disposition is Suspension Sorted by ADS Code

Description: List identifying students by ID only with ADS/DSP info for any student whose disposition was suspension sorted by ADS code for the current year

String:

Name: ADS/DSP List of Suspensions

Description: ADS/DSP List of Suspended Students Sorted by Student Name and ADS Date

String:

Orchard.DisplayManagement.Shapes.Shape