Table of Contents
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.
Flex Queries: If a query needs a conversion for Flex Scheduling, it is displayed below the original query in blue.
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 TCH TCH.TE SMS.SE SMS.CN SMS.PD SMS.BL SMS.SG SMS.CG SMS.TM SMS.LO SMS.HI BY TCH.TE
LIST SMS SSM STF STF.FN STF.LN SMS.SE SMS.FSQ 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 TCH TCH.TE SMS.SE SMS.PD SMS.BL SMS.SG SMS.CG SMS.TM BY TCH.TE
LIST SMS SSM STF STF.FN STF.LN SMS.SE SMS.CN SMS.FSQ 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 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 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 Exculsion 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 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
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
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 TCH TCH.TE SMS.SE SMS.CN SMS.PD SMS.BL SMS.SG SMS.CG SMS.TM SMS.LO SMS.HI BY TCH.TE
LIST SMS SSM STF STF.FN STF.LN SMS.SE SMS.FSQ SMS.SG SMS.CG SMS.TM SMS.LO SMS.HI BY STF.FN STF.LN 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 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 first 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 TCH MST.TN TCH.TE MST.RM MST.SE CRS.CO BY TCH.TE IF MST.PD = #
LIST MST CRS SSE STF MST.FSQ STF.ID STF.LN STF.FN MST.RM MST.SE CRS.CO BY STF.LN STF.FN SSE.PR IF FTF.STI = "XXX" 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 MST.SE MST.PD 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 TCH STU.ID STU.NM STU.GR CRS.CO TCH.TE MST.PD BY STU.LN IF CRS.CN > 4500 AND CRS.CN < 4700 AND MST.SM # “F” AND STU.GR < ##
LIST STU SEC MST CRS SSE STF STU.LN STU.FN STU.GR CRS.CO STF.LN STF.FN MST.FSQ BY STF.LN STF.FN IF CRS.CN > 4500 AND CRS.CN < 4700 AND MST.SM # “F” AND STU.GR < ## 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 TCH MST.SE MST.PD MST.CN CRS.CO TCH.TE MST.ST MST.TS MST.CR BY MST.CN IF MST.CR # "###"
LIST MST CRS SSE STF MST.SE MST.FSQ MST.CN CRS.CO STF.LN STF.FN MST.ST MST.CR BY STF.LN STF.FN IF MST.CR # "###" AND SSE.PR = 1
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
LIST STU SEC MST SSE STF STU.LN STU.FN STU.GR MST.SE STF.LN STF.FN BY STF.LN STF.FN IF MST.FSQ = XXX 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 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 = ###
LIST STU SEC MST CRS SSE STF STU.ID STU.LN STU.FN CRS.CO CRS.CN STF.LN STF.FN MST.FSQ 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 = ####
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
LIST MST SSE STF MST.SE MST.FSQ STF.ID STF.LN STF.FN MST.TB MST.TG MST.SM BY STF.LN STF.FN IF MST.SM = F AND MST.FSQ = XXX AND SSE.PR = 1
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
LIST MST SSE STF MST.SE STF.ID STF.LN STF.FN SSE.PR BY MST.SE IF MST IF MST.MTS # " "
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
LIST MST SSE STF MST.SE STF.LN STF.FN MST.ESR MST.LI MST.INS 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
Run this query at each school site. After obtaining the LIST results click the Change button.
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: Course Attribute Queries for 2019/2020 Transition
See this article: Course Attribute Queries for 2019/2020 Transition
CRS: List of Courses with High and Low Grade values
Lists Course Number, Course Name, Low and High Grade levels for active courses
LIST CRS CN CO LO HI TG IF TG < I
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
CRS: List of Courses currently matched to CALPADS State codes
Lists each Course Number, Course Name, 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 CN CO C3 C3? IF C3 > " " AND C3 # 6012
CRS: List of Courses still matched to retired CALPADS State codes
Lists each Course Number, Course Name, CALPADS State ID Number, CALPADS State Description, and Next State Course Code for all courses if the CALPADS State ID Number is greater than 1000 and less than 7000, but excludes courses using a State ID code of 6012 sorted by State ID Number
LIST CRS CN CO C3 C3? NC3 BY C3 IF C3 > 1000 AND C3 < 7000 AND C3 # 6012
CRS: List of Specific Course Information
Provides Course Number, Course name, Non-Academic/Honors Indicator, Subject Area, Long Course Description, Low Grade, High Grade and CSU Requirement
LIST CRS CN CO NA S1 DE LO HI E1
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
CRS: List of Middle School Courses missing a Middle School Core Indicator
Lists each Course Number, Course Name, CALPADS State ID Number, CALPADS State Description, Content Subcategory, Standards Grade Range, Content Standards Alignment, Charter Non-Core, Advanced State Course Code and Middle School Core for all courses if the Middle School Core is missing and the CALPADS State ID Number is greater than or equal to 7000 and the Low Grade Range is from 5 to 8 and the High Grade Range is from 5 to 8 sorted by State ID Number
LIST CRS CN CO C3 C3? CSC SGR CSA CNC ACC MSC BY C3 IF C3 >= 7000 AND MSC = " " AND ( ( LO >= 5 AND LO <= 8 ) OR ( HI >= 5 AND HI <= 8 ) )
CRS: List of Courses missing a Standards Grade Range
Lists each Course Number, Course Name, CALPADS State ID Number, CALPADS State Description, Content Subcategory, Standards Grade Range, Low Grade, High Grade, Content Standards Alignment, Charter Non-Core, Advanced State Course Code and Middle School Core for all courses if the Standards Grade Range is missing and CALPADS State ID Number is equal to 1000 or is greater than or equal to 7000 sorted by State ID Number
LIST CRS CN CO C3 C3? CSC SGR LO HI CSA CNC ACC MSC BY C3 IF ( C3 = 1000 OR C3 >= 7000 ) AND SGR = " "
CRS: List of Courses missing a Content Standards Alignment
Lists each Course Number, Course Name, CALPADS State ID Number, CALPADS State Description, Content Subcategory, Standards Grade Range, Content Standards Alignment, Charter Non-Core, Advanced State Course Code and Middle School Core for all courses if the Content Standards Alignment is missing and CALPADS State ID Number is equal to 1000 or is greater than or equal to 7000 sorted by State ID Number
LIST CRS CN CO C3 C3? CSC SGR CSA CNC ACC MSC BY C3 IF ( C3 = 1000 OR C3 >= 7000 ) AND CSA = " "
CRS: List of Courses missing a Charter Non-Core Indicator
Lists each Course Number, Course Name, CALPADS State ID Number, CALPADS State Description, Content Subcategory, Standards Grade Range, Content Standards Alignment, Charter Non-Core, Advanced State Course Code and Middle School Core for all courses if the Charter Non-Core is missing and CALPADS State ID Number is equal to 1000 or is greater than or equal to 7000 sorted by State ID Number
LIST CRS CN CO C3 C3? CSC SGR CSA CNC ACC MSC BY C3 IF ( C3 = 1000 OR C3 >= 7000 ) AND CNC = " "
CRS: List of Courses missing an AP/IB Course Code Cross-Reference
Lists each Course Number, Course Name, CALPADS State ID Number, CALPADS State Description, Content Subcategory, Standards Grade Range, Content Standards Alignment, Charter Non-Core, Advanced State Course Code and Middle School Core for all courses if the Advanced State Course Code is missing and CALPADS State ID Number is equal to 1000 or is greater than or equal to 7000 sorted by State ID Number
LIST CRS CN CO C3 C3? CSC SGR CSA CNC ACC MSC BY C3 IF ( C3 = 1000 OR C3 >= 7000 ) AND ( CL = 30 OR CL = 37 OR CL = 38 ) AND ACC = " "
CRS: List of Specific Course Information
Provides Course Number, Course name, Non-Academic/Honors Indicator, Subject Area, Long Course Description, Low Grade, High Grade and CSU Requirement
LIST CRS CN CO NA S1 S2 S3 DE LO HI E1 U1
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 STU.NG = #
SSS: Identifies students with a Specific Course Request and Grade Level
This query identifies students scheduled a specific Course Request and specific Grade level
KEEP STU SSS IF SSS.CN = #### AND STU.GR = ##
SMS: Identifies students with a Specific Section in Scheduling Master Schedule
This query identifies students scheduled to be enrolled in a specific Section in Scheduling Master Schedule
KEEP STU SSS SMS IF SMS.SE = ###
MST: Identifies students with a Specific Section in Master Schedule
This query identifies students scheduled to be enrolled in a specific Section in Master Schedule
KEEP STU SEC MST IF MST.SE = ###
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 STU.GR = #
Total Queries ↑
SSS: Total of Alternate Course Request by Student's Next Grade
Provides a course tally of alternate course requests sorted by a student next grade level
TOTAL STU ACR CRS STU.NG ACR.CN CRS.CO BY STU.NG ACR.CN CRS.CO
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
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 MST.FSQ = XXX
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 = ####
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: Change the Homeroom to a specific period
Change the designated homeroom/attendance taking period to a specific period
CHANGE MST FSQ TO (Record ID from the Flex Period) IF MST.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
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
Run this query at each school site. After obtaining the LIST results click the Change button
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)