Board of Trustees Burton School District Contact Us Superintendent's Message
Our Schools District Boundary Map SARCs
Parent Links Calendars Lunch Menus District English Learner Committee Local Control Funding Formula & Local Control and Accountability Plan
Directory Business Services District Administration Educational Services Human Resources Information Technology Maintenance, Operations and Transportation Nutrition Services Student Support / Special Education
Aesop Webmail
Elementary Queries

Type of Query: LIST Command 

 

Name: Student list by Grade
String: LIST STU ID NM SX GR BD BY GR

Name: Class list of students by teacher and by sex
String: LIST STU TCH STU.SN STU.LN STU.FN STU.GR STU.SX TCH.TE BY TCH.TE STU.SX

Name: ELL Students
String: LIST STU TCH STU.NM STU.LF TCH.TE BY TCH.TE IF STU.LF = L

 Name: Gate Students
String: LIST STU PGM STU.NM STU.ID PGM.CD IF PGM.CD = "127"

Name: Last name First name student ID and Teacher
String: LIST STU LN FN ID TCH TCH.TE

Name: Address verification
String: LIST STU FN LN AD BY AD

Name: Looking for students with names that contain….. If last name contains:
String: LIST STU FN LN GR BY GR IF LN : HERNANDEZ

Name: Language Proficiency
String: LIST STU TCH STU.NM STU.LF TCH.TE BY TCH.TE IF STU.LF

Name: List of 6th grade students by next year school
String: LIST STU LN FN ID GR NS BY NS IF GR = 6

Name: Rsp/SPED/Speech
String: LIST STU TCH STU.LN STU.FN STU.U1 STU.U2 STU.U3 TCH.TE IF STU.U1 = X  OR STU.U2 = X OR STU.U3 = X

Name: Students sorted by Grade
String: LIST STU FN LN ID GR BD BY GR

Name: Alpha/student teacher/grade
String: LIST STU LN FN TCH  TCH.TE STU.GR

Name: EL Mailing Labels
String: LIST STU PG \ STU.NM \ AD \ CY ST ZC IF LF = "L"

Name: El Student info for labels
String: LIST STU STU.NM AD CY ST ZC IF LF = "L"

Name: Mailing Labels English
String: LIST STU "To the Parents of." \  FN LN \ AD \ CY ST ZC
Note: The backslash adds a new line

Name: Mailing Labels Spanish
String: LIST STU "Para los Padres de:" \ NM \ AD \ CY ", " ST "  " ZC IF HL = 01

Name: Subgroup RSP SDC
String: LIST STU TCH STU.ID STU.LN STU.FN STU.GR STU.U1 STU.SP TCH.TE BY TCH.TE IF STU.GR 2 AND STU.U1 = X OR STU.SP = S

Name: Next Year Teacher Labels 
String: LIST STU LN FN NT \ AD \ CY ST ZC BY NT

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

Name: List of students with red flags under Contacts
String: LIST FLG STU STU.NM STU.GR STU.ID STU.RC1 FLG.CO IF FLG.TC = "CON"

Name: List of students with red flags under Supplemental
String: LIST FLG STU STU.NM STU.GR STU.ID STU.RC1 FLG.CO IF FLG.TC = "SUP"

Name: List of all teachers who teacher 6th grade students. This query pulls all 6th grade (U1 = 019) and 5th/6th grade (U1 = 018) teachers.
String: LIST TCH TLN TF SC BY SC U1 IF U1 = "018" OR U1 = "019"

 

Name: List students with Release to Press (photos) marked "Yes"
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = Y
Name: List students with Release to Press (photos) marked "No"
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = N
Name: List students with Release to Press (photos) field left blank
String: LIST STU SUP STU.NM STU.GR SUP.R2 IF SUP.R2 = " "

 


Type of Query: TOTAL Command 

Name: Total students by grade
String: TOTAL STU GR BY GR


Type of Query: SKIP Command 

Name: Skip inactive students for class rosters
String: SKIP STU IF TG # '' "
Note: This will skip all student records with a status that’s not blank (e.g. “I” or “N”).  Then run the Class Rosters.

Name: Skip Students in Grades 4-6
String: SKIP STU IF GR (use greater than symbol) 3

Type of Query: KEEP Command 

Name: Display only female students
String: KEEP STU IF SX = F

Name: Using parenthesis with a KEEP statement
String: KEEP STU IF SX = F AND ( GR = 3 OR GR = 4 )

 

IMPORTANT NOTE: When complete with running queries and/or reports, you must RESET query by clicking the RESET button in the lower right corner of the Query form. “Records Are Being Skipped” will no longer display and further queries or accessing data will include all students. If reset is not performed, the only data accessible will be the query entered for the SKIP or KEEP command.