NOTE: 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 ↑
SED: List of Students with Scheduling Exclusions
Provides a list of students with Scheduling Exclusions including Exclusion Type and the associated Exclusion Student, Teacher or Period
LIST STU IDN SED STU.ID STU.NM SED.EID SED.TY? SED.ID2 IF SED.TY > 0
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 SSM FTF STF STF.FN STF.LN SMS.SE FTF.STI SMS.SG SMS.CG SMS.TM SMS.LO SMS.HI BY STF.FN STF.LN IF SSM.PR = 1
SSS: List of Sections with Scheduling Team/Group Designation
Provides a list of Sections with Scheduling Team/Group designation
LIST SMS SSM STF FTF STF.FN STF.LN SMS.SE SMS.CN FTF.STI SMS.SG SMS.CG SMS.TM BY STF.FN STF.LN SMS.SE IF SSM.PR = 1
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 within 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 within the specific numeric range and are in the specific Grade
LIST STU ID NM GR IF GR = ##
SSS: List of Sections Missing a Flex Period, Class Calendar or any Section with a Scheduling Exclusion.
List of sections that contain Staff First Name, Staff Last Name, Section, Flex Period, Class Calendar, Scheduling Exclusion if Flex Period or Class Calendar is missing or Scheduling Exclusion is turned on by Staff First Name Staff Last Name
LIST SMS SSM STF STF.FN STF.LN SMS.SE SMS.FSQ SMS.CSQ SMS.ES BY STF.FN STF.LN IF ( SSM.PR = 1 AND SMS.FSQ < 1 ) OR ( SSM.PR = 1 AND SMS.CSQ < 1 ) OR ( SSM.PR = 1 AND SMS.ES = 1 )
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 SSM STF STU.NM SSS.SE SMS.SE SSM.ID SSS.PS IF SSS.PS # STF.ID AND SSS.PS # 0 AND SSM.PR = 1
SSS: Display ONLY sections with Class Link turned on, grouped together
LIST SMS SSM STF STF.FN STF.LN SMS.SE SMS.CN SMS.FSQ SMS.CL BY SMS.CL IF SSM.PR = 1 AND SMS.CL # " "
SMS: List of Teachers and Section Information by Teacher from Scheduling Master Schedule
List of sections with course grade level and team/course groups from Scheduling Master Schedule by teacher
LIST SMS SSM FTF STF STF.FN STF.LN SMS.SE FTF.STI SMS.SG SMS.CG SMS.TM SMS.LO SMS.HI BY STF.FN STF.LN IF SSE.PR = 1
SMS: List of Students with Teachers and Section Information for 1st Period by Teacher from Scheduling Master Schedule
List of Student's ID, Name, Grade Level, Staff ID, Teacher Last Name, Teacher First Name, Flex Short Title, Section Information if First Period sorted by Teacher Last Name Teacher First name
LIST STU SSS SMS CRS SSM STF FTF STU.ID STU.NM STU.GR STF.ID STF.LN STF.FN FTF.STI SMS.RM SMS.SE CRS.CO BY STF.LN STF.FN IF FTF.STI = "##" AND SSM.PR = 1
Enter Flex Short Title for 1st period
MST: List of Teachers and Course Information for a Specific Period
Provides a listing of Teachers and Course, Section and Room information for a specific period sorted by Teacher Name
LIST MST CRS SSE STF FTF FTF.STI STF.ID STF.LN STF.FN MST.RM MST.SE CRS.CO BY STF.LN STF.FN SSE.PR IF FTF.STI = "##" AND SSE.PR = 1
Enter Flex Short Title for period
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 FTF MST.SE FTF.STI MST.CN CRS.CO IF MST.CN = ####
MST: List of Students with Courses from a Specific Course Numeric Range, Not During a Specific Term and For a Specific Grade Level Range
List all students in less than a specific Grade Level that have Courses with a specific numeric range and are not being offered during a specific Term (In this example: Math courses range from 4501-4699 and excludes the Fall Term) sorted by Student Last Name
LIST STU SEC MST CRS SSE STF FTF STU.LN STU.FN STU.GR CRS.CO STF.LN STF.FN FTF.STI BY STF.LN STF.FN IF CRS.CN > 4500 AND CRS.CN < 4700 AND MST.SM # "F" AND STU.GR < 12 AND SSE.PR = 1
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 SSE STF FTF MST.SE FTF.STI MST.CN CRS.CO STF.LN STF.FN MST.ST MST.TS MST.CR BY MST.CN IF MST.CR # "###" AND SSE.PR = 1
Enter number of credits
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 SSE STF FTF STU.LN STU.FN STU.GR MST.SE STF.LN STF.FN BY STF.LN STF.FN IF FTF.STI = "###" AND SSE.PR = 1
Enter Flex Short Title for period
MST: List of Students with Section Information and Primary Class Teacher Name for a Specific Period
List of students with Section Information and Teacher Name of Primary Class Teacher for a specific period
LIST MST CRS SSE STF STF.ID STF.LN STF.FN FTF.STI MST.RM MST.SE CRS.CO BY STF.LN STF.FN IF FTF.STI = "###" AND SSE.PR = 1
Enter Flex Short Title for period
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 SSE STF FTF STU.ID STU.LN STU.FN CRS.CO CRS.CN STF.LN STF.FN FTF.STI BY STF.LN STF.FN IF ( STF.ID = ### OR STF.ID = ### OR STF.ID = ### ) AND SSE.PR = 1
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 # XX
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 SSE STF MST.SE FTF.STI STF.ID STF.LN STF.FN MST.TB MST.TG MST.SM BY STF.LN STF.FN IF MST.SM = F AND FTF.STI = "###" AND SSE.PR = 1
Change Term if Needed
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 SEC MST FTF CAR STU.ID STU.NM FTF.STI CAR.CN CAR.SE CAR.DS CAR.DE IF CAR.DS > ##/##/20## OR CAR.DE < ##/##/20##
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 SSE STF MST.SE STF.LN STF.FN MST.ESR MST.LI MST.INS BY STF.LN IF SSE.PR = 1
MST: List of Section and Course Information and the Newly Added Course Codes by Subject Area 1 Code
Lists the section and course information and the newly added course codes by Subject Area 1 Code so that the new fields can be populated
LIST MST CRS SSE STF MST.SE MST.CN CRS.CO CRS.C3 CRS.S1 CRS.S1? STF.LN STF.FN CRS.CSC CRS.SGR CRS.CSA CRS.ACC CRS.MSC CRS.CNC BY CRS.S1 IF SSE.PR = 1
Run this query at each school site. After obtaining the LIST results click the Change button.
CRS: List of Courses fields that should be populated
Lists each Course Tag, Course Number, Course Name, Course Long Description, CALPADS State ID Number and CALPADS State Description for all courses, but excludes courses using a State ID code of 6012 sorted by State ID Number
LIST CRS TG CN CO DE NA S1 S2 S3 DC CP CR MC TM LO HI E1 U1 CSE U2 CSH U3 CL TY ALR ALC CCG
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 SSE STF "add custom text " \ STU.NM \ "SECTION: " MST.SE "GR: " STU.GR "PD: " MST.PD \ "TCH: " STF.LN "," STF.FN "RM: " MST.RM BY STF.LN STF.FN IF MST.SM = F AND FTF.STI = "###"
Change Term if Needed
Enter Flex Short Title for period
Change Queries ↑
SMS: Change the Class Calendar on a Section and Flex Periods to match - select and apply a Class Calendar to a Specific Flex Period
Change the Class Calendar on a section to align with a specific Flex Period
CHANGE SMS SSM SMS.CSQ TO (Record ID of Class Calendar) IF SMS.FSQ = (Record ID of Flex Period)
MST: Populate the Newly Added Course Codes on MST Sections
Lists the section and course information and the newly added course codes by Subject Area 1 Code so that the new fields can be populated
LIST MST CRS SSE STF MST.SE MST.CN CRS.CO CRS.C3 CRS.S1 CRS.S1? STF.LN STF.FN CRS.CSC CRS.SGR CRS.CSA CRS.ACC CRS.MSC CRS.CNC BY CRS.S1 IF SSE.PR = 1
Run this query at each school site. After obtaining the LIST results click the Change button
MST: Populate the Counselor Field on Demographics with an Advisory Teacher or Specific Period Teacher
Changes the Counselor Field (STU.CNS) on the Demographics page to the teacher for a designated period or an advisory teacher
CHANGE STU SEC MST SSE STF STU.CNS TO SSE.ID IF MST.FSQ = (Record ID from the Flex Period)