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