This is a collection of queries related to Scheduling that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

SSS:  List of Teachers with Section Information on Teams/Groups and Grade Levels

Provides a list of the High Grade and Low Grade range from Scheduling Master Schedule including scheduling team/group information, sorted by Teacher Name


LIST SMS TCH TCH.TE SMS.SE SMS.CN SMS.PD SMS.BL SMS.SG SMS.CG SMS.TM SMS.LO SMS.HI BY TCH.TE


SSS:  List of Sections with Scheduling Team/Group Designation

Provides a list of Sections with Scheduling Team/Group designation


LIST SMS TCH TCH.TE SMS.SE SMS.PD SMS.BL SMS.SG SMS.CG SMS.TM BY TCH.TE


SSS:  List of Students with a Specific Course in Scheduling Master Schedule

List of students who have requested a specific course in Scheduling Master Schedule


LIST STU SSS CRS STU.ID STU.NM STU.GR SSS.CN CRS.CO IF SSS.CN = XXXX


SSS:  List of Students with a Specific Grade Missing a Course from a Specific Numeric Range in Scheduling Master Schedule

List of current students in a specific Grade who do not have a Course Number within a specific numeric range in Scheduling Master Schedule (For Example, All English courses are numbered in the 3000 range)


1.  Skip the student who have a Course Number withing the specific numeric range and are in the specific Grade

     SKIP STU SSS IF ( SSS.CN > #### AND SSS.CN < #### ) AND STU.GR = XX
2.  List the student information on the students who do not have a Course Number withing the specific numeric range        and are in the specific Grade

     LIST STU ID NM GR IF GR = ##


SSS:  List of Course Information on Students if Scheduled in a Class that Meets After a Specific Period in Scheduling Master Schedule

List with Student's Name, ID Number, Course and Section Number if scheduled in a class after a designated Period sorted by Period 


LIST STU SSS SMS STU.ID STU.NM SSS.CN SSS.SE SMS.PD BY SMS.PD IF SMS.PD > #


SSS:  List of Students with a Preferred Teacher Not Scheduled with Preferred Teacher

List of students who have a Preferred Teacher but have not been scheduled with the Preferred Teacher


LIST STU SSS SMS STU.NM SSS.SE SMS.SE SMS.TN SSS.TN IF SSS.TN # SMS.TN AND SSS.TN # 0


MST:  List of Students without a Specific Course in Transcript or Class Schedule

List of students who have not taken nor are scheduled in a specific course


1.  Skip students who have the specific course listed in Transcripts

     SKIP STU HIS IF HIS.CN = XXXX

2.  Skip students who are enrolled or scheduled in the specific course

     SKIP STU SEC MST IF MST.CN = XXXX

3.  List the Student Name and Grade

     LIST STU ID NM GR


MST:  List of Section Numbers and Periods Offered for a Specific Course 

List of Section Numbers and Periods for a specific Course


LIST MST CRS MST.SE MST.PD MST.CN CRS.CO IF MST.CN = ####


MST:  List of Classes with Credits Not Equal to a Specific Value 

List of classes with Credits not equal to a specific Credit value sorted by Course Number


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 # "#.##"


MST:  List of Students with Section Number and Teacher Name of the 1st Period Class by Teacher Name

List of students with Section Number and Teacher Name of 1st period class sorted by Teacher name


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


MST:  List of Students if Attendance Teacher Does Not Match the Class Schedule Teacher for the Designated Attendance Period - Elementary with Master Schedule

Verifies that the Student Demographic Teacher matches the Class Schedule Teacher for Attendance Period in Elementary with Master Schedule


LIST STU SEC MST STU.ID STU.NM STU.GR STU.CU MST.TN IF MST.PD = # AND MST.TN # STU.CU


MST:  List of Students with Course Information for Specific Teachers

List of students with Course Number, Course Name, Teacher Name, Period for specific Teachers sorted by Teacher Name and Period


LIST STU SEC MST CRS TCH STU.ID STU.NM CRS.CO CRS.CN TCH.TE MST.PD BY TCH.TE MST.PD IF MST.TN = ### OR MST.TN = ### OR MST.TN = ###


MST:  List of Students not Scheduled in a Specific Course

List of students not scheduled in a specific Course sorted by Grade


LIST STU SEC MST STU.ID STU.NM STU.GR BY STU.GR IF MST.CN = ####


MST:  List of Student Gender Counts in a Class During a Specific Period and Term

List of males and female student counts Teachers during specific Period and Term sorted by Teacher Name


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 = #

(change term if needed)


MST:  Course Attendance (CAR) Data for First 20 Days of School

List sorted 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)


LIST STU CAR STU.ID CAR.CN CAR.DS CAR.DE CAR.D1 CAR.D2 CAR.SE IF CAR.SE = #### AND ( CAR.D2 = 0 OR CAR.D2 > 21 )


MST:  Course Attendance (CAR) List with Student ID, Student Name, Section Number and Start and End Date Course Changes During a Specific Date Range

List from CAR of Student ID and Name with Course changes during a specific Date Range including from CAR:  Period, Course Number, Section Number and the CAR Start and End Dates


LIST STU CAR STU.ID STU.NM CAR.PD CAR.CN CAR.SE CAR.DS CAR.DE IF CAR.DS > ##/##/20## OR CAR.DE < ##/##/20##


MST:  Course List of Courses by Course Number

List of Courses sorted by Course Number including:  Non Academic/ Academic Code, Subject Area Codes and College Prep Coded


LIST CRS CN CO NA S1 S2 S3 CP BY CN


MST:  Course List of CSF Codes by CSF Code

List of Courses with CSF code sorted by CSF Code


LIST CRS CN CO C1 BY C1 IF C1 # " "


MST:  List of Teachers with a Multiple Teacher Status Code on Sections

Lists Teachers with a Multiple Teacher Status Code and the additional Teacher Numbers from the Master Schedule Sections (MST.SE)


LIST MST SE TN MTS TN2 TN3


MST:  List of Teacher Educational Service, Language of Instruction and Instructional Strategy Codes

Lists Teacher Educational Service, Language of Instruction and Instruction Strategy codes from the Master Schedule Sections (MST.SE)


LIST MST TCH MST.SE TCH.TE MST.ESR MST.LI MST.INS


CRS:  List of Courses Designated as Meets Algebra 1 Requirement

Provides a list of courses that have been identified as Meets Algebra 1 Requirement and Credit Values


LIST CRS CN CO ALC ALR CCG BY CCG IF ALC > 0 OR ALR = 1 OR CCG > " "


CRS:  List of Courses with Academic Honor Designation

Provides list of Course with the Academic Honor field designation


LIST CRS CN CO NA BY NA IF NA = N OR NA = H


CRS:  List of Advanced Placement (AP) or International Baccalaureate (IB) Courses

Provides a list from the Course table of AP or IB Courses


LIST CRS CN CO CL IF CL = 30 OR CL = 37


SSR: List of Students with Summer School Course Requests - District Level 

Provides a student list of Summer School Course Requests and School information


LIST STU IDN SSR SSC CRS STU.NM SSR.SSC STU.SC SSR.CN CRS.CO SSR.TM SSR.TG SSR.PF BY SSR.SSC STU.SC SSR.TM IF SSR.CN > ' '


SSR:  List of Students with Summer School Course Requests - School Level

Provides a student list of Summer School Course Requests and School information from the school that the students are currently attending


LIST STU IDN SSR SSC CRS STU.NM STU.GR SSR.CN CRS.CO SSR.SSC SSR.TM SSR.TG SSR.PF IF SSR.CN > ' '


Keep/Skip Queries

SSS:  Identifies students with Specific Courses to "SKIP" - Remaining Students can be Mass Assigned Course Requests

This query identifies students with specific Courses to exclude so that the remaining students can be given Course Requests


SKIP STU SSS IF SSS.CN = #### OR SSS.CN = ####


SSS:  Identifies students with a Specific Course and Next Grade to "SKIP" - Remaining Students can be Mass Assigned Course Requests

This query identifies students with a specific Course and their Next Grade level to exclude so that the remaining students can be given Course Requests


SKIP STU SSS IF SSS.CN = #### AND NG = #


MST:  Identifies students with a Specific Course and Grade to "KEEP" and Mass Assign Course Requests

This query identifies students in a specific Grade that are currently enrolled in a specific Course so that the students can be given Course Requests for the next Course in the next Grade level


KEEP STU SEC MST IF MST.CN = #### AND GR = #


Total Queries

SSR: Total Counts of Summer School Course Requests with Course and School Information - District Level

Provides counts of request courses at Summer Schools


TOTAL STU IDN SSR SSC CRS SSR.SSC STU.SC SSR.CN CRS.CO SSR.TM BY SSR.SSC STU.SC SSR.CN CRS.CO SSR.TM


SSR: Total Counts of Summer School Course Requests with Course and School Information - School Level

Provides counts of request courses at Summer Schools from the school that the students are currently attending


TOTAL STU IDN SSR SSC CRS SSR.SSC STU.SC SSR.CN CRS.CO SSR.TM BY SSR.SSC STU.SC SSR.CN CRS.CO SSR.TM


Label Queries

MST:  Labels from Master Schedule with Custom Text and Class information for a Specific Period and Term

Labels with custom text and including Student Name, class information for a specific period and term


LIST STU SEC MST TCH "add custom text" \ STU.NM \ "SECTION:" MST.SE "GR:" STU.GR "PD:" MST.PD \ "TCH:" TCH.TE "RM:" MST.RM BY TCH.TE IF MST.SM = F AND MST.PD = #

(change term if needed)


Change Queries

SSS:  Change to Lock All Sections in Scheduling Master Schedule for a Specific Next Grade

Change to lock all Sections for students in Scheduling Master Schedule for a specific Next Grade


CHANGE STU SSS SSS.RT TO * IF STU.NG = ##  AND SSS.SE > 0


SSS:  Change to Lock All Sections in Scheduling Master Schedule for a Specific Grade

Change to lock all Sections for students in Scheduling Master Schedule for a specific Grade


CHANGE STU SSS SSS.RT TO * IF STU.GR = # AND SSS.SE > 0


SSS:  Change to Unlock Sections in Scheduling Master Schedule for a Specific Course

Change to unlock Sections for students in Scheduling Master Schedule for a specific Course


CHANGE SSS RT TO " " IF RT = "*" AND CN = ####


MST:  Change Language of Instruction to Blank if Erroneously Populated with code 00 - English or 37 - Sign Language for a Teacher with an Educational Service Code of 4 - ELD and SDAIE Not Primary Language

Mass removes the erroneously codes because a Language of Instruction is Blank if the Education Service Code is 4 - ELD and SDAIE Not Primary Language from the Master Schedule Sections (MST.SE)


CHANGE MST LI TO " " IF LI = 00 OR LI = 37 AND ESR = 4