Queries

( Press the Ctrl and F keys on your keyboard to open a find text on this page)

authorizations (here)

Immunization exemptions

* you can run these in the school to get one school

all students with exemptions.

LIST STU IMM STU.ID STU.LN STU.FN STU.GR IMM.PE IMM.DE IMM.TE IMM.AE IMM.YE IMM.IE IMM.VE IMM.HAE IMM.HW IMM.TBE IMM.E1 IMM.E3

all student with medical exemptions

LIST STU IMM STU.ID STU.LN STU.FN STU.GR IMM.PE IMM.DE IMM.TE IMM.AE IMM.YE IMM.IE IMM.VE IMM.HAE IMM.HW IMM.TBE IMM.E1 IMM.E3 IF IMM.E1 = X

all students with personal beliefs exemptions

LIST STU IMM STU.ID STU.LN STU.FN STU.GR IMM.PE IMM.DE IMM.TE IMM.AE IMM.YE IMM.IE IMM.VE IMM.HAE IMM.HW IMM.TBE IMM.E1 IMM.E3 IF IMM.E3 = X

or run the queries below in the district interface you will get all enrolled students with what school they go to

all students with exemptions.

LIST STU IMM STU.SC STU.ID STU.LN STU.FN STU.GR IMM.PE IMM.DE IMM.TE IMM.AE IMM.YE IMM.IE IMM.VE IMM.HAE IMM.HW IMM.TBE IMM.E1 IMM.E3

all student with medical exemptions

LIST STU IMM STU.SC STU.ID STU.LN STU.FN STU.GR IMM.PE IMM.DE IMM.TE IMM.AE IMM.YE IMM.IE IMM.VE IMM.HAE IMM.HW IMM.TBE IMM.E1 IMM.E3 IF IMM.E1 = X

all students with personal beliefs exemptions

LIST STU IMM STU.SC STU.ID STU.LN STU.FN STU.GR IMM.PE IMM.DE IMM.TE IMM.AE IMM.YE IMM.IE IMM.VE IMM.HAE IMM.HW IMM.TBE IMM.E1 IMM.E3 IF IMM.E3 = X

__________________________________________________________________________________________________

Schools with master schedules List students with class and period

LIST STU SEC MST CRS TCH STU.ID STU.NM STU.GR CRS.CO TCH.TE MST.PD MST.SM BY STU.LN STU.FN MST.PD IF STU.GR = ##

Change ## to grade level

________________________________________________________________________________________________

Finding students with/without CON links

Finding students with or without CON (contact) links on the student data 1 page

(this has several options)

1. List STU with contact 1 link:

LIST STU CON STU.SN STU.NM CON.NM STU.FW CON.C1D IF CON.C1F > " "

2. List STU with contact 2 link:

LIST STU CON STU.SN STU.NM CON.NM STU.MW CON.C2D IF CON.C2F > " "

3. Keep students with either link:

KEEP STU CON IF CON.C1F > " " OR CON.C2F > " "

4. Skip students with links:

SKIP STU CON IF CON.C1F > " " OR CON.C2F > " "

_________________________________________________________________________________________________

ATT absence code list for specific day

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

Change dates to fit your needs:

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

__________________________________________________________________________________________________

List Campus interns

List all campus interns with name, id number, teacher and period

This query works at any high school

LIST STU SEC MST CRS TCH STU.ID STU.NM CRS.CO CRS.CN TCH.TE MST.PD BY TCH.TE MST.PD IF CRS.CN = 44012 OR CRS.CN = 44014 OR CRS.CN = 44010

________________________________________________________________________________________________

Cumulative Class Rank (HIS)

this query will list all students their grade level and current class rank and class size based on Course History (transcript)

The result will give you a listing that you could put into excel and sort in any way you like.

LIST STU STU.ID STU.GR STU.LN STU.FN STU.CR STU.CS

Or you could filter for a certain grade level and then sort by rank like this

LIST STU STU.ID STU.GR STU.LN STU.FN STU.CR STU.CS BY STU.CR IF STU.GR = "12"

_________________________________________________________________________________________________

GPA Type Aeries Query field

Academic GPA (w) STU.GP (Un weighted) STU.GPN

Total GPA (w) STU.TP (Un weighted) STU.TPN

10-12 GPA (w) STU.CP (Un weighted) STU.CPN

______________________________________________________________________________________________

How many parent accounts does my school have?

The following query can be run at your site to get a site count. Look at the bottom of the results to see how may records you have.

LIST PWA PWS STU PWS.ID STU.ID PWA.EM PWA.LDT PWA.LC PWA.CD STU.LN STU.FN IF STU.ID > 2

This query also shows how many times they have logged in when they last logged in and creation date (that is new and accounts added because of an email address in the system or prior to .NET will not have a date).

How can I find out who does not have an account?

Go to view all reports

Filter for Parent Accounts

Choose "OTH Print Students Without Parent Accounts"

Follow prompts

________________________________________________________________________________________________

Student Info Demographics

LIST STU STU.ID STU.GR STU.ETH STU.RC1 STU.RC1? STU.HL STU.HL? PGM.CD PGM.CD? CSE.IN

List student id, grade, ethnicity, race, home language, program, include in special education report

This query will give you the codes and the description on what each code is.

Language Proficiency Query:

LIST STU ID LF LF?

Student ID language fluency code

_________________________________________________________________________________________________

Truancy Rate

LIST STU NM DE DA DP (( LEFT( (( (( DE - DA )) / DE * 100 )), 5) )) BY DA REV IF DE

his query will give you YTD percentages per student.

Be sure to run the macro: Update student attendance/ enrollment totals;

!!!! if you have not ever run a macro in Aeries please call Tech support and I can guide you through the process.

_________________________________________________________________________________________________

Physical Fitness Testing Status (High Schools)

PLEASE NOTE THIS WILL SHOW ACTIVE STUDENTS ONLY. CHECK THE INACTIVE BOX TO SHOW ALL STUDENTS

this query will list all students PASS/FAIL regardless of grade

LIST STU TPS PFT STU.ID STU.FN STU.LN STU.GR PFT.TA TPS.PF TPS.PF?

This query will show you all students grade 9 and up PASS/FAIL or not taken

LIST STU TPS PFT STU.ID STU.FN STU.LN STU.GR PFT.TA TPS.PF TPS.PF? IF STU.GR > 8

This query will show you all students grade 9 and up who tested this spring

LIST STU TPS PFT STU.ID STU.FN STU.LN STU.GR PFT.TA TPS.PF TPS.PF? IF STU.GR > 8 AND PFT.TA = "SPRG13"

_________________________________________________________________________________________________

Medical History Query

LIST STU MHS STU.FN STU.LN STU.GR MHS.CD MHS.CD? MHS.DT MHS.SD MHS.ED MHS.TG MHS.CO MHS.PC

_________________________________________________________________________________________________

List 12th grade students and what teacher they have by period

LIST STU SEC MST TCH TCH.TE MST.PD STU.LN STU.FN STU.GR BY MST.PD IF STU.GR = 12

This will show teacher name, period, student name and grade sorted by period.