{"id":8692,"date":"2026-08-19T15:02:26","date_gmt":"2026-08-19T19:02:26","guid":{"rendered":"https:\/\/sites.bu.edu\/sis-training\/?p=8692"},"modified":"2026-10-05T10:14:02","modified_gmt":"2026-10-05T14:14:02","slug":"student-records-queries","status":"publish","type":"post","link":"https:\/\/sites.bu.edu\/sis-training\/student-records-queries\/","title":{"rendered":"Queries: Student Records"},"content":{"rendered":"<p>This resource provides information and instructions for running common Student Record-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 style=\"margin-block-start: 0px;\">Introduction<\/h4>\n<p>Queries in MyBU Student are reports. This resource describes some frequently used queries in the Student Records functional area. These reports typically include data related to academic career\/program\/plan (CPP), class enrollment, term activation, Student Groups, certain Service Indicators, and\/or transcripts\/degrees, for one or multiple students. <\/p>\n<p>\u24d8 <strong>New to queries?<\/strong> Be sure to check out the <a href=\"https:\/\/sites.bu.edu\/sis-training\/staff-queries\/\">Introduction to Queries<\/a> resource first for foundational concepts, detailed instructions on how to find and run a query, and support information. 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\/\" rel=\"noopener\" target=\"_blank\">Intro to Queries<\/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, Title\/Short Description, search prompts, and report 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\">STUDENT GROUPS<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><br \/>\nThis report lists students with associated Student Group(s). The list can be pulled by Academic Program and\/or by a particular Student Group.<\/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_STUDENT_GROUPS <\/li>\n<li><strong>Query Title\/Short Description:<\/strong> Students with Student Groups <\/li>\n<li><strong>Search Prompts<\/strong> (Asterisks indicate required field): Term*, Institution*, Student Group, Primary Acad Prog <\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/08\/Prompts-BU_SR_STUDENT_GROUPS.jpg\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/08\/Prompts-BU_SR_STUDENT_GROUPS.jpg\" alt=\"Example of filled out prompts for the BU_SR_STUDENT_GROUPS query.\" width=\"383\" height=\"282\" class=\"aligncenter size-full wp-image-9064\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example shown above, the results will list all Graduate Engineering students in the Fall 2026 term, with all applicable Student Groups for each student.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>If compiling a list of incoming first years, select the \u2018RIFY \u2013 Incoming UG First Year\u2019 value in the Student Group field (other options available \u2013 perform a lookup to review).<\/li>\n<li>The default format of the results are sorted by Student Group (and not by student, even though the student data appears in the left-most columns).<\/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>ID<\/td>\n<td>Last Name <\/td>\n<td>First Name <\/td>\n<td>Middle Name <\/td>\n<\/tr>\n<tr>\n<td>BU Email<\/td>\n<td>Pronouns <\/td>\n<td>Term <\/td>\n<td>Academic Career<\/td>\n<\/tr>\n<tr>\n<td>Primary Academic Program<\/td>\n<td>Study Agreement<\/td>\n<td>Student Group<\/td>\n<td>Student Group Description<\/td>\n<\/tr>\n<tr>\n<td>Withdrawal \\ Cancel<\/td>\n<td>Academic Level &#8211; Projected<\/td>\n<td>Academic Level &#8211; Term Start<\/td>\n<td>Academic Level &#8211; Term End<\/td>\n<\/tr>\n<tr>\n<td>Eligible to Enroll<\/td>\n<td>Enrollment Status<\/td>\n<td>Term Units in Progress<\/td>\n<td>Advisor(s)<\/td>\n<\/tr>\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\">PROGRAM\/PLAN BY UID<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><br \/>\nThis query searches for students by BUID and returns the associated Program\/Plan information at the time of the defined Term.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0010H_SR_CPP_BUID<\/li>\n<li><strong>Query Title\/Short Description:<\/strong> Program\/Plan by BUID<\/li>\n<p><a href=\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-19.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-19.png\" alt=\"This image shows the program\/ plan by build query, which searches for students by BUID and returns the associated Program\/Plan information at the time of the defined Term.\" width=\"193\" height=\"150\" class=\"alignright size-full wp-image-2875\" srcset=\"https:\/\/sites.bu.edu\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-19.png 605w, https:\/\/sites.bu.edu\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-19-600x470.png 600w, https:\/\/sites.bu.edu\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-19-400x308.png 400w\" sizes=\"(max-width: 193px) 100vw, 193px\" \/><\/a><\/p>\n<li><strong>Search Prompts<\/strong> (Asterisks indicate required field): ID, *Term <\/li>\n<\/ul>\n<p>In the example shown, any student\u2019s BUID entered into the \u2018ID\u2019 prompt will pull up that student\u2019s academic Program\/Plan information for the Spring 2025 term.<\/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>BU ID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>Career Nbr<\/td>\n<td>Academic Career<\/td>\n<td>Academic Program<\/td>\n<td>Descr<\/td>\n<\/tr>\n<tr>\n<td>Eff Date<\/td>\n<td>Eff Sequence<\/td>\n<td>Admit Term<\/td>\n<td>Admit Term<\/td>\n<\/tr>\n<tr>\n<td>Req Term<\/td>\n<td>Req Term (Catalog Year)<\/td>\n<td>Exp Grad<\/td>\n<td>Exp Grad Term<\/td>\n<\/tr>\n<tr>\n<td>Joint Program Indicator<\/td>\n<td>Dual Program<\/td>\n<td>Plan Sequence<\/td>\n<td>Academic Plan Code<\/td>\n<\/tr>\n<tr>\n<td>Academic Plan Description<\/td>\n<td>Academic Plan Type<\/td>\n<td>Degree Type<\/td>\n<td>Academic SubPlan Code<\/td>\n<\/tr>\n<tr>\n<td>Academic SubPlan Description<\/td>\n<td>Academic SubPlan Type<\/td>\n<td>Completion Term<\/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\">STUDENTS ON LEAVE OR WITHDRAWN<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>This query generates a report of students who have either taken a leave of absence or withdrawn in a particular Term, along with relevant data about the leave or withdrawal. The report can be run for all students across the University, or narrowed to a particular academic career, program, college, or even a single student UID.<\/p>\n<p style=\"padding-bottom: 0px; margin-bottom: 0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name:<\/strong> BU_R0010N_SR_LOA_WD<\/li>\n<li><strong>Query Title\/Short Description:<\/strong> Students on LOA or W\/D<\/li>\n<li><strong>Search Prompts<\/strong> (asterisks indicate required field):*Institution, *Term, Academic Career, Academic Program or %Col%, ID<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/08\/BU_R0010N_SR_LOA_WD-prompts.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/08\/BU_R0010N_SR_LOA_WD-prompts.png\" alt=\"Example of search prompt inputs for Students on Leave\/Withdrawn query\" width=\"385\" height=\"293\" class=\"aligncenter size-full wp-image-9319\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example shown above, the report will pull all graduate students in Questrom (QST) who are on leave or withdrawn for the Spring 2026 term.<\/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>ID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>BU Email<\/td>\n<td>Term<\/td>\n<td>Term Description<\/td>\n<td>Academic Career<\/td>\n<\/tr>\n<tr>\n<td>Academic Program<\/td>\n<td>Dual Academic Program<\/td>\n<td>Approved Academic Load<\/td>\n<td>Academic Load<\/td>\n<\/tr>\n<tr>\n<td>Academic Level &#8211; Projected<\/td>\n<td>Academic Level &#8211; Term Start<\/td>\n<td>Academic Level &#8211; Term End<\/td>\n<td>Academic Program Status<\/td>\n<\/tr>\n<tr>\n<td>Program Action<\/td>\n<td>Action Reason<\/td>\n<td>Action Reason Description<\/td>\n<td>Effective Date<\/td>\n<\/tr>\n<tr>\n<td>Withdrawal \\ Cancel<\/td>\n<td>Withdrawal \\ Cancel Reason<\/td>\n<td>Withdrawal \\ Cancel Date<\/td>\n<td>Last Date of Attendance<\/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\">GRADUATION REPORT<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>This query generates a report displaying student academic information and graduation-related data. Prompts allow for application of specific graduation filters to find desired student populations.<\/p>\n<p style=\"padding-bottom: 0px; margin-bottom: 0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name:<\/strong> BU_R0046L_SR_GRADUATION<\/li>\n<li><strong>Query Title\/Short Description:<\/strong> Graduation Report<\/li>\n<li><strong>Search Prompts<\/strong> (asterisks indicate required field): Institution, Career, *Acad Prog or %Col%, Exp Grad Term, Grad Review Status, ID, Acad Plan<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/08\/Graduation-Report-prompts.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/08\/Graduation-Report-prompts.png\" alt=\"Example of search prompt inputs for the Graduation Report query.\" width=\"385\" height=\"417\" class=\"aligncenter size-full wp-image-9329\" style=\"border: 2px solid black;\"\/><\/a><\/p>\n<p>In the example shown above, the report will generate a list of all undergraduate students in Sargent College (SAR) with an expected Grad Term of Spring 2026, Summer 2026, or Fall 2026.<\/p>\n<p style=\"padding-bottom: 0px; margin-bottom: 0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>This query is identical in prompts and result fields to BU_R0046L_SR_GRADUATION_STNT, which has also been used by staff for similar purposes.<\/li>\n<li>Related Resource: <a href=\"https:\/\/sites.bu.edu\/sis-training\/graduation-tracking\/\" rel=\"noopener\" target=\"_blank\">Graduation Tracking<\/a><\/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>ID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>Last Name (Diploma)<\/td>\n<td>First Name (Diploma)<\/td>\n<td>BU Email<\/td>\n<td>Personal Email<\/td>\n<tr>\n<td>FERPA<\/td>\n<td>International Student Indicator<\/td>\n<td>Visa\/Permit Type<\/td>\n<td>Country<\/td>\n<\/tr>\n<tr>\n<td>Academic Career<\/td>\n<td>Academic Program<\/td>\n<td>Academic Plan<\/td>\n<td>Academic Plan Description<\/td>\n<\/tr>\n<tr>\n<td>Academic Sub-Plan<\/td>\n<td>Academic Sub-Plan Description<\/td>\n<td>Degree<\/td>\n<td>Academic Program Status<\/td>\n<\/tr>\n<tr>\n<td>Admit Term<\/td>\n<td>Expected Graduation Term<\/td>\n<td>Graduation Review Status<\/td>\n<td>Graduation Review Status Date<\/td>\n<\/tr>\n<tr>\n<td>Degree Checkout Status<\/td>\n<td>Academic Degree Status<\/td>\n<td>Completion Term<\/td>\n<td>Confer Date<\/td>\n<\/tr>\n<tr>\n<td>Honors Code<\/td>\n<td>Honors Code Description<\/td>\n<td>Term (of Last Enrollment)<\/td>\n<td>Online Indicator<\/td>\n<\/tr>\n<tr>\n<td>Total Units Attempted<\/td>\n<td>Total Units Earned<\/td>\n<td>Total Cumulative Units<\/td>\n<td>Cumulative GPA<\/td>\n<\/tr>\n<tr>\n<td>Advisor(s)<\/td>\n<td>Advisor Email(s)<\/td>\n<td> <\/td>\n<td> <\/td>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<p>Page last updated October 2026. For a PDF copy, print this webpage as a PDF. Other resource formats can also be accessed via the relevant icons below.<\/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> <a href=\"https:\/\/mymedia.bu.edu\/media\/t\/1_qfgfka2a\" target=\"_blank\" title=\"Overview Video\" rel=\"noopener noreferrer\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2025\/05\/Video-icon.png\" alt=\"Video Icon - Click here to view video resource.\" width=\"75px\" height=\"75px\" \/><\/a><a href=\"https:\/\/mymedia.bu.edu\/media\/t\/1_4q5i5zgq\" target=\"_blank\" title=\"Term Activated by Term Video\" rel=\"noopener noreferrer\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2025\/05\/Video-icon.png\" alt=\"Video Icon - Click here to view video resource.\" width=\"75px\" height=\"75px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This resource provides information and instructions for running common Student Record-focused queries using Query Viewer. Introduction Queries in MyBU Student are reports. This resource describes some frequently used queries in the Student Records functional area. These reports typically include data related to academic career\/program\/plan (CPP), class enrollment, term activation, Student Groups, certain Service Indicators, and\/or [&hellip;]<\/p>\n","protected":false},"author":13327,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[47,45],"_links":{"self":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/8692"}],"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\/13327"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/comments?post=8692"}],"version-history":[{"count":33,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/8692\/revisions"}],"predecessor-version":[{"id":9465,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/8692\/revisions\/9465"}],"wp:attachment":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/media?parent=8692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/categories?post=8692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/tags?post=8692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}