{"id":9839,"date":"2026-11-09T15:39:48","date_gmt":"2026-11-09T20:39:48","guid":{"rendered":"https:\/\/sites.bu.edu\/sis-training\/?p=9839"},"modified":"2026-11-09T15:39:48","modified_gmt":"2026-11-09T20:39:48","slug":"queries-auto-graduation","status":"publish","type":"post","link":"https:\/\/sites.bu.edu\/sis-training\/queries-auto-graduation\/","title":{"rendered":"Queries: Auto-graduation"},"content":{"rendered":"<p>This resource provides information and instructions for running common Auto-graduation-related 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 specific to the auto-graduation process. School\/College staff can use these queries to monitor the progression of student statuses related to their Degree Progress Reports and Degree Status. <\/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\">DPR Status at Career<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>Use to view the Career level status (i.e., Completed, Failed, Exempted) of the Degree Progress Report.<\/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_GRDN_DPR_RESULTS_CAREER<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: 2 DPR Status at Career<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Advisement Report Type, *Report Identifier, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, UID, Item Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/11\/ag_queries_1.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_1.png\" alt=\"Example of a DPR Status at Career search in Query Viewer.\" width=\"272\" height=\"318\" class=\"aligncenter size-full wp-image-9828\" style=\"border: 2px solid black;\"\/><\/a><\/p>\n<p>In the example above, the report will pull status data per Career for Undergraduate COM students with an Expected Grad Term of Spring 2026. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Advisement Report Type: select GRDI.<\/li>\n<li>Report Identifier will auto-populate as \u201cBATCH.\u201d<\/li>\n<li>Item Status dropdown options: Complete; Exempted; Fail.<\/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>UID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>Report Date\/Time Stamp<\/td>\n<td>Academic Career<\/td>\n<td>Academic Program<\/td>\n<td>Academic Plan(s)<\/td>\n<\/tr>\n<tr>\n<td>Academic Plan Description(s)<\/td>\n<td>Career Report Status<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\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\">DPR Status at All Levels<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>Use to view the Degree Progress Report requirement statuses (i.e., Completed, Failed, Exempted) per Requirement Group (RG), Requirement (RQ), and Requirement Line (LN) levels.<\/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_GRDN_DPR_RESULTS_DTL_ALL<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: 2a DPR Status at All Levels<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Academic Institution, Academic Career, *Acad Program or %College%, Academic Plan, *Exp Grad Term, *Advisement Report Type, *Report Identifier, UID, Item Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/11\/ag_queries_2.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_2.png\" alt=\"Example of a DPR Status at All Levels search in Query Viewer.\" width=\"289\" height=\"325\" class=\"aligncenter size-full wp-image-9829\" style=\"border: 2px solid black;\"\/><\/a><\/p>\n<p>In the example shown, the report will pull all degree progress status data (Requirement Group, Requirement, and Requirement Line) for Undergraduate COM students with an Expected Grad Term of Fall 2026. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Advisement Report Type: select GRDI.<\/li>\n<li>Report Identifier will auto-populate as \u201cBATCH.\u201d<\/li>\n<li>Item Status dropdown options: Complete; Exempted; Fail.<\/li>\n<li>Note that all of each student\u2019s applicable data will display in the report, so it\u2019s common for a single student to have over a hundred data rows in this report. In the abbreviated example data set below, all 132 data rows shown are for the same student:<br \/>\n<a href=\"\/sis-training\/files\/2026\/11\/ag_queries_8.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_8-636x436.png\" alt=\"Example of a data set returned for a DPR Status at All Levels search, showing 132 rows of data for a single student.\" width=\"636\" height=\"436\" class=\"aligncenter size-medium wp-image-9836\" style=\"border: 2px solid black;\" srcset=\"https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_8-636x436.png 636w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_8-1024x702.png 1024w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_8-768x526.png 768w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_8.png 1183w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a>\n<\/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>UID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>Report Date\/Time Stamp<\/td>\n<td>Report Entry Seq<\/td>\n<td>Report Career<\/td>\n<td>Report Program<\/td>\n<\/tr>\n<tr>\n<td>Report Plan<\/td>\n<td>RG#<\/td>\n<td>RG Description<\/td>\n<td>RQ#<\/td>\n<\/tr>\n<tr>\n<td>RQ Description<\/td>\n<td>LN#<\/td>\n<td>LN Description<\/td>\n<td>Requirement Item Status<\/td>\n<\/tr>\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\">DPR Status at Requirement Group Level<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>Use to view the Degree Progress Report requirement status (i.e., Completed, Failed, Exempted) at the Requirement Group (RG) level.<\/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_GRDN_DPR_RESULTS_DTL_RG <\/li>\n<li><strong>Query Title\/Short Description<\/strong>: 2b DPR Status at RG Level<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): ): *Academic Institution, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, *Advisement Report Type, *Report Identifier, Item Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/11\/ag_queries_3.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_3.png\" alt=\"Example of a DPR Status at Requirement Group Level search in Query Viewer.\" width=\"278\" height=\"290\" class=\"aligncenter size-full wp-image-9830\" style=\"border: 2px solid black;\"\/><\/a><\/p>\n<p>In the example shown, the report will pull Requirement Group status data for Undergraduate COM students with an Expected Grad Term of Spring 2026. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Advisement Report Type: select GRDI.<\/li>\n<li>Report Identifier will auto-populate as \u201cBATCH.\u201d<\/li>\n<li>Item Status dropdown options: Complete; Exempted; Fail.<\/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>UID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>Report Date\/Time Stamp<\/td>\n<td>Report Entry Seq<\/td>\n<td>Report Career<\/td>\n<td>Report Program<\/td>\n<\/tr>\n<tr>\n<td>Report Plan<\/td>\n<td>RG#<\/td>\n<td>RG Description<\/td>\n<td>RG Status<\/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\">DPR STATUS AT REQUIREMENT LEVEL<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>Use to view the Degree Progress Report requirement status (i.e., Completed, Failed, Exempted) at the Requirement (RQ) level.<\/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_GRDN_DPR_RESULTS_DTL_RQ<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: 2c DPR Status at RQ Level<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Academic Institution, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, *Advisement Report Type, *Report Identifier, UID, Item Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/11\/ag_queries_4.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_4.png\" alt=\"Example of a DPR Status at Requirement Level search in Query Viewer.\" width=\"276\" height=\"317\" class=\"aligncenter size-full wp-image-9831\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example shown, the report will pull Requirement status data for Undergraduate COM students with an Expected Grad Term of Fall 2026. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Advisement Report Type: select GRDI.<\/li>\n<li>Report Identifier will auto-populate as \u201cBATCH.\u201d<\/li>\n<li>Item Status dropdown options: Complete; Exempted; Fail.<\/li>\n<li>Note that all of each student\u2019s applicable Requirement data will display, so it\u2019s common for a single student to have several data rows in this report. In the abbreviated example data set below, all 30 data rows shown are for the same student:<br \/>\n<a href=\"\/sis-training\/files\/2026\/11\/ag_queries_9.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_9-636x274.png\" alt=\"Example of a data set returned for a DPR Status at Requirement Level search, showing 30 rows of data for a single student.\" width=\"636\" height=\"274\" class=\"aligncenter size-medium wp-image-9837\" style=\"border: 2px solid black;\" srcset=\"https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_9-636x274.png 636w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_9-768x331.png 768w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_9.png 921w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/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<tbody>\n<tr>\n<td>UID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>Report Date\/Time Stamp<\/td>\n<td>Report Entry Seq<\/td>\n<td>Report Career<\/td>\n<td>Report Program<\/td>\n<\/tr>\n<tr>\n<td>Report Plan<\/td>\n<td>RG#<\/td>\n<td>RG Description<\/td>\n<td>RQ#<\/td>\n<\/tr>\n<tr>\n<td>RQ Description<\/td>\n<td>RQ Status<\/td>\n<td><\/td>\n<td><\/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\">DPR Status at Requirement Line Level<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>Use to view the Degree Progress Report requirement status (i.e., Completed, Failed, Exempted) at the Requirement Line (LN) level.<\/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_GRDN_DPR_RESULTS_DTL_LN<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: 2d DPR Status at LN Level<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Academic Institution, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, *Advisement Report Type, *Report Identifier, UID, Item Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/11\/ag_queries_5.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_5.png\" alt=\"Example of a DPR Status at Requirement Line Level search in Query Viewer.\" width=\"272\" height=\"322\" class=\"aligncenter size-full wp-image-9832\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example shown, the report will pull Requirement Line status data for Undergraduate COM students with an Expected Grad Term of Fall 2026. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Advisement Report Type: select GRDI.<\/li>\n<li>Report Identifier will auto-populate as \u201cBATCH.\u201d<\/li>\n<li>Item Status dropdown options: Complete; Exempted; Fail.<\/li>\n<li>Note that all of each student\u2019s applicable Requirement Line data will display in this report, so it\u2019s common for a single student to have dozens of data rows. In the abbreviated example data set below, all 39 data rows shown are for the same student:<br \/>\n<a href=\"\/sis-training\/files\/2026\/11\/ag_queries_10.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_10-636x269.png\" alt=\"xample of a data set returned for a DPR Status at Requirement Line Level search, showing 39 rows of data for a single student.\" width=\"636\" height=\"269\" class=\"aligncenter size-medium wp-image-9835\" style=\"border: 2px solid black;\" srcset=\"https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_10-636x269.png 636w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_10-1024x433.png 1024w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_10-768x325.png 768w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/11\/ag_queries_10.png 1063w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a>\n<\/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>UID<\/td>\n<td>Last Name<\/td>\n<td>First Name<\/td>\n<td>Middle Name<\/td>\n<\/tr>\n<tr>\n<td>Report Date\/Time Stamp<\/td>\n<td>Report Entry Seq<\/td>\n<td>Report Career<\/td>\n<td>Report Program<\/td>\n<\/tr>\n<tr>\n<td>Report Plan<\/td>\n<td>RG#<\/td>\n<td>RG Description<\/td>\n<td>RQ#<\/td>\n<\/tr>\n<tr>\n<td>RQ Description<\/td>\n<td>LN#<\/td>\n<td>LN Description<\/td>\n<td>LN Status<\/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\">Degree Checkout Status<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>Use to view students&#8217; Degree Checkout Status value.<\/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_GRDN_DEGR_CHKOUT_STATUS<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: 3 Degree Checkout Status\/Stdnt<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Academic Institution, Academic Career, *Acad Prog or %Col%, *Expected Grad Term, Degree Checkout Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/11\/ag_queries_6.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_6.png\" alt=\"Example of a Degree Checkout Status search in Query Viewer.\" width=\"397\" height=\"289\" class=\"aligncenter size-full wp-image-9833\" style=\"border: 2px solid black;\"\/><\/a><\/p>\n<p>In the example shown, the report will pull Undergraduate COM students with an Expected Grad Term of Spring 2026 with all possible Degree Checkout Statuses (except for Degree Awarded). <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Degree Checkout Status dropdown options: Applied for Graduation; Approved; Degree Awarded; Denied; Eligible for Graduation; Needs to Finish Pending Work; Program in Review; Withdrawn.\n<ul style=\"margin-left:1rem;\">\n<li>To view all possible Degree Checkout Statuses (except for Degree Awarded), do not make a selection in the dropdown (as shown in the previous image).<\/li>\n<\/ul>\n<\/li>\n<li>Note the two-letter code that will display for Checkout Status (refer to the <a href=\"https:\/\/sites.bu.edu\/sis-training\/files\/__restricted\/entire-bu-community\/Auto-Graduation-Process-for-Staff.pdf\">Auto-Graduation Process<\/a> resource for more information on statuses):\n<ul style=\"margin-left:1rem;\">\n<li>PN \u2013 Approved, Pending Final Grades<\/li>\n<li>WD \u2013 Deferred Graduation<\/li>\n<li>AW \u2013 Degree Awarded (won\u2019t display in this report)<\/li>\n<li>DN \u2013 Not Approved<\/li>\n<li>IR \u2013 Graduation in Review<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u24d8 NOTE:<\/strong> Students with a Degree Checkout Status of Degree Awarded will not display in this report. Awarding the degree completes their Program\/Plan record, therefore removing them from this data set. Review the next query, Graduation Report, to confirm the status of students who have been awarded. <\/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>UID<\/td>\n<td>Career<\/td>\n<td>Career Nbr<\/td>\n<td>Eff Date<\/td>\n<\/tr>\n<tr>\n<td>Sequence<\/td>\n<td>Institution<\/td>\n<td>Acad Prog<\/td>\n<td>Checkout Status<\/td>\n<\/tr>\n<tr>\n<td>Expected Grad Term<\/td>\n<td>Program Action<\/td>\n<td>Name<\/td>\n<td><\/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>Use to view data related to student program\/plan completion, compiled by expected grad term and other criteria. Can review data including Degree Status, Completion Term, and Confer Date. Report includes awarded students. <\/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_STNT<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Student list w\/Graduation info<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): Institution, Career, *Acad Prog or %Col%, *Exp Grad\/Comp Term (From), *Exp Grad\/Comp Term (To), ID, Acad Plan, Grad Review Status, Degree Checkout Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/11\/ag_queries_7.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/11\/ag_queries_7.png\" alt=\"Example of a Graduation Report search in Query Viewer.\" width=\"305\" height=\"318\" class=\"aligncenter size-full wp-image-9827\" style=\"border: 2px solid black;\"\/><\/a><\/p>\n<p>In the example shown, the report will pull Undergraduate QST students with an Expected Grad Term between Spring 2025 and Spring 2026 (do not use the Grad Review Status criteria). <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>Additional Info &#038; Tips:<\/strong><\/p>\n<ul>\n<li>Includes all students in the prompted program and expected graduation term range.<\/li>\n<li>Single row per student.<\/li>\n<li><strong>\u24d8 NOTE:<\/strong> When compiling this query for auto-graduation purposes, do NOT include Grad Review Status criteria in the search.<\/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>Middle Name (Diploma)<\/td>\n<td>BU Email<\/td>\n<\/tr>\n<tr>\n<td>Personal Email<\/td>\n<td>FERPA<\/td>\n<td>International Indicator<\/td>\n<td>Visa\/Permit Type(s)<\/td>\n<\/tr>\n<tr>\n<td>Country<\/td>\n<td>Academic Career<\/td>\n<td>Academic Program(s)<\/td>\n<td>Academic Plan(s)<\/td>\n<\/tr>\n<tr>\n<td>Academic Plan Description(s)<\/td>\n<td>Academic Sub-Plan(s)<\/td>\n<td>Acad Sub-Plan Description(s)<\/td>\n<td>Dual Academic Program <\/td>\n<\/tr>\n<tr>\n<td>Joint Program Approved<\/td>\n<td>Degree(s)<\/td>\n<td>Academic Program Status<\/td>\n<td>Admit Term(s)<\/td>\n<\/tr>\n<tr>\n<td>Requirement Term(s) (Program)<\/td>\n<td>Requirement Term(s) (Plan)<\/td>\n<td>Expected Graduation Term(s)<\/td>\n<td>Graduation Review Status<\/td>\n<\/tr>\n<tr>\n<td>Grad Review Status Date(s)<\/td>\n<td>Degree Checkout Status<\/td>\n<td>Academic Degree Status<\/td>\n<td>Completion Term<\/td>\n<\/tr>\n<tr>\n<td>Confer Date<\/td>\n<td>Honors Code<\/td>\n<td>Honors Code Description<\/td>\n<td>Term (of Last Enrollment)<\/td>\n<\/tr>\n<tr>\n<td>Online Indicator<\/td>\n<td>Total Units Attempted<\/td>\n<td>Total Units Earned<\/td>\n<td>Total Cumulative Units<\/td>\n<\/tr>\n<tr>\n<td>Cumulative GPA<\/td>\n<td>Advisor(s)<\/td>\n<td>Advisor Email(s)<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<p>Page last updated November 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 Auto-graduation-related queries using Query Viewer. Introduction Queries in MyBU Student are reports. This resource describes queries specific to the auto-graduation process. School\/College staff can use these queries to monitor the progression of student statuses related to their Degree Progress Reports and Degree Status. \u24d8 New to [&hellip;]<\/p>\n","protected":false},"author":25577,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[51,55,43,45],"_links":{"self":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9839"}],"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\/25577"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/comments?post=9839"}],"version-history":[{"count":1,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9839\/revisions"}],"predecessor-version":[{"id":9840,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9839\/revisions\/9840"}],"wp:attachment":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/media?parent=9839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/categories?post=9839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/tags?post=9839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}