{"id":9406,"date":"2026-10-02T11:23:56","date_gmt":"2026-10-02T15:23:56","guid":{"rendered":"https:\/\/sites.bu.edu\/sis-training\/?p=9406"},"modified":"2026-10-05T09:58:50","modified_gmt":"2026-10-05T13:58:50","slug":"scheduling-queries","status":"publish","type":"post","link":"https:\/\/sites.bu.edu\/sis-training\/scheduling-queries\/","title":{"rendered":"Queries: Scheduling"},"content":{"rendered":"<p>This resource provides information and instructions for running common Scheduling-focused queries using Query Viewer.<\/p>\n<p style=\"border-top: 10px solid #669999; text-align:right; margin-block-end: 0px;\"><a href=\"https:\/\/sites.bu.edu\/sis-training\/mybu-student-glossary\/\" rel=\"noopener noreferrer\" title=\"Glossary\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2025\/06\/Glossary-icon.png\" alt=\"Glossary Icon - Click here for MyBU Student Glossary.\" width=\"55px\" height=\"55px\" \/><\/a><\/p>\n<h4>Introduction<\/h4>\n<p>Queries in MyBU Student are reports. This resource describes queries identified as frequently used for staff needs and processes in the Scheduling functional area. This typically includes data related to class enrollments\/waitlists\/reserve capacities, class schedule details, academic calendar and exam dates, and instructor class lists.<\/p>\n<p>\u24d8 <strong>New to queries?<\/strong> Be sure to visit the <a href=\"https:\/\/sites.bu.edu\/sis-training\/staff-queries\/\">Introduction to Queries for Staff<\/a> resource first for foundational concepts, detailed instructions on how to find and run a query, and links to other functional area reports. Support and query request information is also available via that resource.<\/p>\n<p>All the queries included in this resource are run using <strong>Query Viewer<\/strong> in MyBU Student. Several other frequently used student record queries can be quickly accessed via the Reporting Center folder in the left-side menu from the MyBU Student Dashboard. Refer to the <a href=\"https:\/\/sites.bu.edu\/sis-training\/staff-queries\/\">Introduction to Queries for Staff<\/a> resource for a breakdown of the queries found in the Reporting Center folder.<\/p>\n<p>For each query included below, the system\u2019s Query Name, Short Description, prompts, and data fields are listed, along with additional helpful details and screenshots.<\/p>\n<p style=\"padding: 10px; margin: 20px 20px 20px 20px; line-height: 1.2; border: 1px solid black;\"> \u26a0\ufe0e Screen options, menus, and reports will vary by user; please note that displays may differ for you based on access that has been granted. All screens shown are for training purposes only.<\/p>\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Class Status & Reserve Capacity<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A list of classes prompted by Term and Academic Group. The report describes all requirement groups assigned to the class, including the number of seats used by students in the requirement group and the total number reserved and waitlisted.<\/p>\n<p>Used by scheduling and course management groups to monitor reserved seat usage and overall class enrollment. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0010A_SR_CLASS_STAT_RESERV<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Classes w\/ Reserve Capacity<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Term, *Academic Group, Subject Area, and Requirement Group.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_1.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_1.png\" alt=\"Example of a Class Status &amp; Reserve Capacity query window.\" width=\"350\" height=\"320\" class=\"aligncenter size-full wp-image-9248\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the report will generate results narrowed by Term: Fall 2026 (2268), Academic Group: CFA, and optional Subject Area: Applied Music Lessons (CFAML).<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Includes all active classes (closed and open) by Academic Group. Excludes any classes for the term that have been cancelled.\n<li>Multiple row: This report produces one row for each requirement group listed on a class. If there are no reserved seats, it reports one row and the requirement group info appears blank.<\/li>\n<\/ul>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tr>\n<td>Course ID<\/td>\n<td>Term<\/td>\n<td>Session<\/td>\n<td>Subject Area<\/td>\n<\/tr>\n<tr>\n<td>Catalog Nbr<\/td>\n<td>Class Section<\/td>\n<td>Course Component<\/td>\n<td>Description<\/td>\n<\/tr>\n<tr>\n<td>Class Nbr<\/td>\n<td>Class Status<\/td>\n<td>Type of Consent Required<\/td>\n<td>Enrollment Status<\/td>\n<\/tr>\n<tr>\n<td>Enrollment Capacity<\/td>\n<td>Enrollment Total<\/td>\n<td>Open Seats<\/td>\n<td>Wait List Capacity<\/td>\n<\/tr>\n<tr>\n<td>Wait List Total<\/td>\n<td>Requirement Group<\/td>\n<td>Requirement Group Description<\/td>\n<td>Reserve Capacity Sequence<\/td>\n<\/tr>\n<tr>\n<td>Reserve Start Date<\/td>\n<td>Reserve Capacity<\/td>\n<td>Reserve Seats Total<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Final Exam Schedule for a Term<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A list of classes prompted by Term and narrowed by other optional details, with their final exam schedule information such as day, time, room, room capacity, class enrollment, and instructor.<\/p>\n<p>Used by faculty and administrators to see the Final Exam Schedule.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0032C_SR_FINAL_EXAM_SCHDL<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Final Exam Schedule<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Term, Academic Group, Subject Area, Catalog Nbr, Course ID, Instructor, and Academic Org.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_2.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_2.png\" alt=\"Example of a Final Exam Schedule query window.\u00a0\" width=\"326\" height=\"452\" class=\"aligncenter size-full wp-image-9249\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the search will produce a report of the final exam schedule for Term: Spring 2026 (2261), optional Academic Group: CAS, and optional Subject Area: Astronomy (CASAS).<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Includes classes that have a final exam schedule during the university\u2019s final exam week.<\/li>\n<li>A single row per class with instructor and room information consolidated for the class.<\/li>\n<\/ul>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tbody>\n<tr>\n<td>Academic Career<\/td>\n<td>Academic Group<\/td>\n<td>Course ID<\/td>\n<td>Subject Area<\/td>\n<\/tr>\n<tr>\n<td>Catalog Nbr<\/td>\n<td>Class Section<\/td>\n<td>Description<\/td>\n<td>Session<\/td>\n<\/tr>\n<tr>\n<td>Enrollment Total<\/td>\n<td>Exam Time Code<\/td>\n<td>Exam Date<\/td>\n<td>Exam Start Time<\/td>\n<\/tr>\n<tr>\n<td>Exam End Time<\/td>\n<td>Facility ID(s)<\/td>\n<td>Room Capacity<\/td>\n<td>Combined Exam<\/td>\n<\/tr>\n<tr>\n<td>Instructor(s)<\/td>\n<td>Instructor\u2019s Email(s)<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Class Roster by Instructor<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A list of classes taught by the instructor prompted by Institution (required) and Instructor ID (required). Can also narrow results by  Term (optional). Report includes class information, class location, and enrollment. <\/p>\n<p>Used by faculty and administrators to look at the instructor teaching history for any semester.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0031_SR_INSTRUCTOR_SCHDL<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Class roster(s) by instructor<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, Instructor ID, and Term.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_3.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_3.png\" alt=\"Example of Class roster(s) by instructor query window. Institution is auto-populated to BU001, and there are search fields for Instructor ID and Term (Optional).\" width=\"319\" height=\"236\" class=\"aligncenter size-full wp-image-9250\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Includes all classes taught by the instructor in the prompted term (if specified) or for as long as the instructor has been teaching at BU (if the term is not specified).<\/li>\n<li>Single row per class section. By clicking on the linked columns, user can drill down to the class roster (BU-ROO31_SR_INSTRUCTORS_CLASS).<\/li>\n<\/ul>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tbody>\n<tr>\n<td>Course ID<\/td>\n<td>Effective Date<\/td>\n<td>Academic Organization<\/td>\n<td>Academic Group<\/td>\n<\/tr>\n<tr>\n<td>Academic Career<\/td>\n<td>Subject Area<\/td>\n<td>Catalog Nbr<\/td>\n<td>Status as of Effective Date<\/td>\n<\/tr>\n<tr>\n<td>Short Title<\/td>\n<td>Long Title<\/td>\n<td>Minimum Units<\/td>\n<td>Maximum Units<\/td>\n<\/tr>\n<tr>\n<td>Repeatable<\/td>\n<td>Total Units Allowed<\/td>\n<td>Total Completions Allowed<\/td>\n<td>Grading Basis<\/td>\n<\/tr>\n<tr>\n<td>Primary Component<\/td>\n<td>Final Exam<\/td>\n<td>Course Component<\/td>\n<td>Course Description<\/td>\n<\/tr>\n<tr>\n<td>Course Attributes<\/td>\n<td>Equivalent Course Group<\/td>\n<td>Equivalent Course Description<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Classes With All Schedule Fields<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A list of all classes prompted by Term, with almost all class schedule-related fields from the Maintain Schedule of Classes screens.<\/p>\n<p>Used for class scheduling and registration planning.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0012G_SR_SOC_EXTR<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Classes w\/ all schedule fields<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Term, Academic Group, Subject, Class Status, and Academic Org.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_4.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_4.png\" alt=\"Example of Classes w\/ all schedule fields query window.\u00a0\" width=\"419\" height=\"367\" class=\"aligncenter size-full wp-image-9251\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the search will produce a report on Term: Fall 2026 (2268), Academic Group: CAS, and Subject; Astronomy (CASAS).<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Includes all classes\/sections.<\/li>\n<li>One row per class\/section.<\/li>\n<\/ul>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tbody>\n<tr>\n<td>Course ID<\/td>\n<td>Class Nbr<\/td>\n<td>Term<\/td>\n<td>Term Description<\/td>\n<\/tr>\n<tr>\n<td>Type of Consent Required<\/td>\n<td>Schedule Print<\/td>\n<td>Consolidated Class Field<\/td>\n<td>Subject<\/td>\n<\/tr>\n<tr>\n<td>Catalog Number<\/td>\n<td>Class Section<\/td>\n<td>Description<\/td>\n<td>Component<\/td>\n<\/tr>\n<tr>\n<td>Associated Class<\/td>\n<td>Grading Basis<\/td>\n<td>Grading Basis Description<\/td>\n<td>Location<\/td>\n<\/tr>\n<tr>\n<td>Instruction Mode<\/td>\n<td>Minimum Units<\/td>\n<td>Maximum Units<\/td>\n<td>Course Contact Hours<\/td>\n<\/tr>\n<tr>\n<td>Session<\/td>\n<td>Academic Group<\/td>\n<td>Academic Career<\/td>\n<td>Enrollment Status<\/td>\n<\/tr>\n<tr>\n<td>Class Status<\/td>\n<td>Class Type<\/td>\n<td>Enrollment Capacity<\/td>\n<td>Minimum Enrollment Number<\/td>\n<\/tr>\n<tr>\n<td>Wait List Capacity<\/td>\n<td>Auto Enroll from Waitlist<\/td>\n<td>Enrollment Total<\/td>\n<td>Wait List Total<\/td>\n<\/tr>\n<tr>\n<td>Course Attributes<\/td>\n<td>Enrollment Capacity<\/td>\n<td>Academic Organization<\/td>\n<td>Session Start Date<\/td>\n<\/tr>\n<tr>\n<td>Session End Date<\/td>\n<td>Cancel Date<\/td>\n<td>Combined Section<\/td>\n<td>Combined Sections ID<\/td>\n<\/tr>\n<tr>\n<td>Combined Sections<\/td>\n<td>Combined Section Capacity<\/td>\n<td>Combined Section Enroll Total<\/td>\n<td>Exam Seat Spacing<\/td>\n<\/tr>\n<tr>\n<td>Class Meeting Pattern Nbr<\/td>\n<td>Building<\/td>\n<td>Room<\/td>\n<td>Room Capacity<\/td>\n<\/tr>\n<tr>\n<td>Meeting Days<\/td>\n<td>Meeting Start Time<\/td>\n<td>Meeting End Time<\/td>\n<td>Meeting Start Date<\/td>\n<\/tr>\n<tr>\n<td>Meeting End Date<\/td>\n<td>Standard Meeting Pattern<\/td>\n<td>Basic Data Topic ID<\/td>\n<td>Description<\/td>\n<\/tr>\n<tr>\n<td>Meetings Topic ID<\/td>\n<td>Meetings Topic Description<\/td>\n<td>Meetings Free Format Topic<\/td>\n<td>Meetings Print Topic<\/td>\n<\/tr>\n<tr>\n<td>Final Exam<\/td>\n<td>Class Notes<\/td>\n<td>Note Nbr<\/td>\n<td>Note Nbr Description<\/td>\n<\/tr>\n<tr>\n<td>Class\/Instructor Assign Seq #<\/td>\n<td>Instructor Role<\/td>\n<td>Instructor Type<\/td>\n<td>Grade Roster Access<\/td>\n<\/tr>\n<tr>\n<td>Print Instructor in Schedule<\/td>\n<td>ID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<\/tr>\n<tr>\n<td>Middle Name<\/td>\n<td>Email<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Course Catalog<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A list of courses prompted by Effective Date (On\/Before), with options to narrow by Academic Group, Academic Org, or Subject. Displays all course catalog fields such as course title, description, components, units, grading basis, final exam Yes\/No, etc.<\/p>\n<p>Used by class schedulers and course catalog administrators to review and manage all course catalog attributes.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0012L_SR_CRSE_CATALOG<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Course Catalog<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Effective Date (On or before),  Academic Group, Subject Area, Academic Organization, and Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_5.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_5.png\" alt=\"Example of Course Catalog query window.\u00a0\" width=\"425\" height=\"356\" class=\"aligncenter size-full wp-image-9244\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the search will produce a report narrowed by Effective Date on\/before: 12\/31\/2027, for Academic Group: COM.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Includes all requested courses. It is recommended to Select \u201cActive\u201d from the Status prompt for a list of only active courses.<\/li>\n<li>Single row per course.<\/li>\n<\/ul>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tr>\n<td>Course ID<\/td>\n<td>Effective Date<\/td>\n<td>Academic Organization<\/td>\n<td>Academic Group<\/td>\n<\/tr>\n<tr>\n<td>Academic Career<\/td>\n<td>Subject Area<\/td>\n<td>Catalog Nbr<\/td>\n<td>Status as of Effective Date<\/td>\n<\/tr>\n<tr>\n<td>Short Title<\/td>\n<td>Long Title<\/td>\n<td>Minimum Units<\/td>\n<td>Maximum Units<\/td>\n<\/tr>\n<tr>\n<td>Repeatable<\/td>\n<td>Total Units Allowed<\/td>\n<td>Total Completions Allowed<\/td>\n<td>Grading Basis<\/td>\n<\/tr>\n<tr>\n<td>Primary Component<\/td>\n<td>Final Exam<\/td>\n<td>Course Component<\/td>\n<td>Course Description<\/td>\n<\/tr>\n<tr>\n<td>Course Attributes<\/td>\n<td>Equivalent Course Group<\/td>\n<td>Equivalent Course Description<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Waitlisted Classes With Available Details<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>This query is used as drilling URL query by BU_SR_AVAIL_BY_WAITLIST_CLASS. Report provides a list of students waitlisted for classes that meet at requested days and times.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_SR_AVAIL_BY_WL_DETAILS<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Waitlisted class-Avail-Details<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Term, *Mon\/Tues\/Wed\/Thurs\/Fri\/Sat\/Sun, *Mtg Start, *Mtg End, and Class Nbr.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_6.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_6-343x636.png\" alt=\"Example of a Waitlisted class-Avail-Details query window.\" width=\"257\" height=\"477\" class=\"aligncenter size-medium wp-image-9245\" style=\"border: 2px solid black;\" srcset=\"https:\/\/sites.bu.edu\/sis-training\/files\/2026\/09\/sr_queries_6-343x636.png 343w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/09\/sr_queries_6.png 383w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/a><\/p>\n<p>In this example, the user is searching for waitlisted students in classes for Term: Spring 2026 (2261), that meet Tues\/Thurs, start at 12:30pm, and end at 1:45pm.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tbody>\n<tr>\n<td>ID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<td>BU Email<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Add\/Drop Withdrawal Dates<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>This report displays add, drop, and withdraw dates for classes.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_SR_SOC_DEADLINE_DATES<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Deadline Dates for Classes<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Term, Academic Group, Subject Area, Starting Catalog Nbr, and Session. Click checkbox (as shown in the image below) to Omit Cancelled Sections.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_7.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_7.png\" alt=\"Example of Deadline Dates for Classes query window.\u00a0\" width=\"415\" height=\"387\" class=\"aligncenter size-full wp-image-9246\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the user is running a report for Term: Fall 2026 (2268), Academic Group: ENG, and omitting any cancelled sections.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<p>The Search defaults to Omit Cancelled Sections, so be sure to uncheck the box if cancelled sections should appear in the report.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tr>\n<td>Term<\/td>\n<td>Session<\/td>\n<td>Class Nbr<\/td>\n<td>Subject Area<\/td>\n<\/tr>\n<tr>\n<td>Catalog Nbr<\/td>\n<td>Class Section<\/td>\n<td>Course Component<\/td>\n<td>Course Title<\/td>\n<\/tr>\n<tr>\n<td>Location Code<\/td>\n<td>Instruction Mode<\/td>\n<td>Enrollment Status<\/td>\n<td>Class Status<\/td>\n<\/tr>\n<tr>\n<td>Class Type<\/td>\n<td>Combined Section<\/td>\n<td>Class Start Date<\/td>\n<td>Class End Date<\/td>\n<\/tr>\n<tr>\n<td>Use Dynamic Class Dates<\/td>\n<td>Dynamic Date Rule<\/td>\n<td>Last Date to Add<\/td>\n<td>Withdraw Deadline No W Grade<\/td>\n<\/tr>\n<tr>\n<td>Drop Deadline (Retain Record)<\/td>\n<td>Withdraw Deadline w\/ W Grade<\/td>\n<td>Drop Deadline w\/ W Grade<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<div class=\"bu_collapsible_container \" aria-live=\"polite\" data-customize-animation=\"false\"><h4 class=\"bu_collapsible\" aria-expanded=\"false\"tabindex=\"0\" role=\"button\">Enrollment Requirement Groups<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A list of classes prompted by Term that displays fields related to course registration restrictions, Enrollment Requirement Group (ERG) rules, and Reserve Caps such as course, enrollment capacity, waitlist capacity, ERG rules (i.e. how each ERG is defined), etc.<\/p>\n<p>Used by course schedulers and anyone planning registration restrictions to review how each ERG is defined.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_RESERVED_RULES<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Classes w\/ Req. Grp definition<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Term, Acad Group, and Subject.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/sr_queries_8.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/sr_queries_8.png\" alt=\"Example of Classes w\/ Req. Grp definition query window.\" width=\"213\" height=\"273\" class=\"aligncenter size-full wp-image-9247\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Includes all classes in the prompted term and academic group or subject area.<\/li>\n<li>Multi-row per class: one line per aspect of the enrollment requirement group rule. For example, if an ERG is defined as \u201cany student in program UCAS, UQST, UENG, or UCOM,\u201d that rule will appear on four rows.<\/li>\n<\/ul>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Data Fields Displayed in Results<\/strong>:<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tr>\n<td>Course ID<\/td>\n<td>Term<\/td>\n<td>Session<\/td>\n<td>Subject<\/td>\n<\/tr>\n<tr>\n<td>Catalog<\/td>\n<td>Section<\/td>\n<td>Component<\/td>\n<td>Descr<\/td>\n<\/tr>\n<tr>\n<td>Class Nbr<\/td>\n<td>Cap Enrl<\/td>\n<td>Tot Enrl<\/td>\n<td>Open Seats<\/td>\n<\/tr>\n<tr>\n<td>Wait Cap<\/td>\n<td>Wait Tot<\/td>\n<td>Enrl Stat<\/td>\n<td>ReserveNbr<\/td>\n<\/tr>\n<tr>\n<td>Start Date<\/td>\n<td>Cap Enrl<\/td>\n<td>Rq Group<\/td>\n<td>Descr<\/td>\n<\/tr>\n<tr>\n<td>Consent<\/td>\n<td>Line<\/td>\n<td>Line Type<\/td>\n<td>Cond Code<\/td>\n<\/tr>\n<tr>\n<td>Operator<\/td>\n<td>Value<\/td>\n<td>Course ID<\/td>\n<td>Valid Beg<\/td>\n<\/tr>\n<tr>\n<td>Valid End<\/td>\n<td>Conn<\/td>\n<td>Parenth<\/td>\n<td>&#8212;&#8212;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<p>Page last updated September 2026. For a PDF copy, print this webpage as a PDF.<\/p>\n<p style=\"text-align:right; margin-block-end: 0px;\"><a href=\"https:\/\/sites.bu.edu\/sis-training\/mybu-student-glossary\/\" rel=\"noopener noreferrer\" title=\"Glossary\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2025\/06\/Glossary-icon.png\" alt=\"Glossary Icon - Click here for MyBU Student Glossary.\" width=\"75px\" height=\"75px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This resource provides information and instructions for running common Scheduling-focused queries using Query Viewer. Introduction Queries in MyBU Student are reports. This resource describes queries identified as frequently used for staff needs and processes in the Scheduling functional area. This typically includes data related to class enrollments\/waitlists\/reserve capacities, class schedule details, academic calendar and exam [&hellip;]<\/p>\n","protected":false},"author":1183,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[47,31,43],"_links":{"self":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9406"}],"collection":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/users\/1183"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/comments?post=9406"}],"version-history":[{"count":17,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9406\/revisions"}],"predecessor-version":[{"id":9459,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9406\/revisions\/9459"}],"wp:attachment":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/media?parent=9406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/categories?post=9406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/tags?post=9406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}