Queries: Auto-graduation
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.
ⓘ New to queries? Be sure to visit the Introduction to Queries for Staff 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.
All the queries included in this resource are run using Query Viewer 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 Introduction to Queries for Staff resource for a breakdown of the queries found in the Reporting Center folder.
For each query included below, the system’s Query Name, Short Description, prompts, and data fields are listed, along with additional helpful details and screenshots.
⚠︎ 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.
DPR Status at Career
Use to view the Career level status (i.e., Completed, Failed, Exempted) of the Degree Progress Report.
System Details:
- Query Name: BU_SR_GRDN_DPR_RESULTS_CAREER
- Query Title/Short Description: 2 DPR Status at Career
- Search Prompts (asterisk indicates required field): *Institution, *Advisement Report Type, *Report Identifier, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, UID, Item Status.
In the example above, the report will pull status data per Career for Undergraduate COM students with an Expected Grad Term of Spring 2026.
Additional Info & Tips:
- Advisement Report Type: select GRDI.
- Report Identifier will auto-populate as “BATCH.”
- Item Status dropdown options: Complete; Exempted; Fail.
Data Fields Displayed in Results:
| UID |
Last Name |
First Name |
Middle Name |
| Report Date/Time Stamp |
Academic Career |
Academic Program |
Academic Plan(s) |
| Academic Plan Description(s) |
Career Report Status |
|
|
DPR Status at All Levels
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.
System Details:
- Query Name: BU_SR_GRDN_DPR_RESULTS_DTL_ALL
- Query Title/Short Description: 2a DPR Status at All Levels
- Search Prompts (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.
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.
Additional Info & Tips:
- Advisement Report Type: select GRDI.
- Report Identifier will auto-populate as “BATCH.”
- Item Status dropdown options: Complete; Exempted; Fail.
- Note that all of each student’s applicable data will display in the report, so it’s 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:
Data Fields Displayed in Results:
| UID |
Last Name |
First Name |
Middle Name |
| Report Date/Time Stamp |
Report Entry Seq |
Report Career |
Report Program |
| Report Plan |
RG# |
RG Description |
RQ# |
| RQ Description |
LN# |
LN Description |
Requirement Item Status |
DPR Status at Requirement Group Level
Use to view the Degree Progress Report requirement status (i.e., Completed, Failed, Exempted) at the Requirement Group (RG) level.
System Details:
- Query Name: BU_SR_GRDN_DPR_RESULTS_DTL_RG
- Query Title/Short Description: 2b DPR Status at RG Level
- Search Prompts (asterisk indicates required field): ): *Academic Institution, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, *Advisement Report Type, *Report Identifier, Item Status.
In the example shown, the report will pull Requirement Group status data for Undergraduate COM students with an Expected Grad Term of Spring 2026.
Additional Info & Tips:
- Advisement Report Type: select GRDI.
- Report Identifier will auto-populate as “BATCH.”
- Item Status dropdown options: Complete; Exempted; Fail.
Data Fields Displayed in Results:
| UID |
Last Name |
First Name |
Middle Name |
| Report Date/Time Stamp |
Report Entry Seq |
Report Career |
Report Program |
| Report Plan |
RG# |
RG Description |
RG Status |
DPR STATUS AT REQUIREMENT LEVEL
Use to view the Degree Progress Report requirement status (i.e., Completed, Failed, Exempted) at the Requirement (RQ) level.
System Details:
- Query Name: BU_SR_GRDN_DPR_RESULTS_DTL_RQ
- Query Title/Short Description: 2c DPR Status at RQ Level
- Search Prompts (asterisk indicates required field): *Academic Institution, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, *Advisement Report Type, *Report Identifier, UID, Item Status.
In the example shown, the report will pull Requirement status data for Undergraduate COM students with an Expected Grad Term of Fall 2026.
Additional Info & Tips:
- Advisement Report Type: select GRDI.
- Report Identifier will auto-populate as “BATCH.”
- Item Status dropdown options: Complete; Exempted; Fail.
- Note that all of each student’s applicable Requirement data will display, so it’s 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:
Data Fields Displayed in Results:
| UID |
Last Name |
First Name |
Middle Name |
| Report Date/Time Stamp |
Report Entry Seq |
Report Career |
Report Program |
| Report Plan |
RG# |
RG Description |
RQ# |
| RQ Description |
RQ Status |
|
|
DPR Status at Requirement Line Level
Use to view the Degree Progress Report requirement status (i.e., Completed, Failed, Exempted) at the Requirement Line (LN) level.
System Details:
- Query Name: BU_SR_GRDN_DPR_RESULTS_DTL_LN
- Query Title/Short Description: 2d DPR Status at LN Level
- Search Prompts (asterisk indicates required field): *Academic Institution, *Academic Career, *Academic Program, Academic Plan, *Exp Grad Term, *Advisement Report Type, *Report Identifier, UID, Item Status.
In the example shown, the report will pull Requirement Line status data for Undergraduate COM students with an Expected Grad Term of Fall 2026.
Additional Info & Tips:
- Advisement Report Type: select GRDI.
- Report Identifier will auto-populate as “BATCH.”
- Item Status dropdown options: Complete; Exempted; Fail.
- Note that all of each student’s applicable Requirement Line data will display in this report, so it’s 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:
Data Fields Displayed in Results:
| UID |
Last Name |
First Name |
Middle Name |
| Report Date/Time Stamp |
Report Entry Seq |
Report Career |
Report Program |
| Report Plan |
RG# |
RG Description |
RQ# |
| RQ Description |
LN# |
LN Description |
LN Status |
Degree Checkout Status
Use to view students’ Degree Checkout Status value.
System Details:
- Query Name: BU_SR_GRDN_DEGR_CHKOUT_STATUS
- Query Title/Short Description: 3 Degree Checkout Status/Stdnt
- Search Prompts (asterisk indicates required field): *Academic Institution, Academic Career, *Acad Prog or %Col%, *Expected Grad Term, Degree Checkout Status.
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).
Additional Info & Tips:
- Degree Checkout Status dropdown options: Applied for Graduation; Approved; Degree Awarded; Denied; Eligible for Graduation; Needs to Finish Pending Work; Program in Review; Withdrawn.
- 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).
- Note the two-letter code that will display for Checkout Status (refer to the Auto-Graduation Process resource for more information on statuses):
- PN – Approved, Pending Final Grades
- WD – Deferred Graduation
- AW – Degree Awarded (won’t display in this report)
- DN – Not Approved
- IR – Graduation in Review
- ⓘ NOTE: 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.
Data Fields Displayed in Results:
| UID |
Career |
Career Nbr |
Eff Date |
| Sequence |
Institution |
Acad Prog |
Checkout Status |
| Expected Grad Term |
Program Action |
Name |
|
Graduation Report
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.
System Details:
- Query Name: BU_R0046L_SR_GRADUATION_STNT
- Query Title/Short Description: Student list w/Graduation info
- Search Prompts (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.
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).
Additional Info & Tips:
- Includes all students in the prompted program and expected graduation term range.
- Single row per student.
- ⓘ NOTE: When compiling this query for auto-graduation purposes, do NOT include Grad Review Status criteria in the search.
Data Fields Displayed in Results:
| ID |
Last Name |
First Name |
Middle Name |
| Last Name (Diploma) |
First Name (Diploma) |
Middle Name (Diploma) |
BU Email |
| Personal Email |
FERPA |
International Indicator |
Visa/Permit Type(s) |
| Country |
Academic Career |
Academic Program(s) |
Academic Plan(s) |
| Academic Plan Description(s) |
Academic Sub-Plan(s) |
Acad Sub-Plan Description(s) |
Dual Academic Program |
| Joint Program Approved |
Degree(s) |
Academic Program Status |
Admit Term(s) |
| Requirement Term(s) (Program) |
Requirement Term(s) (Plan) |
Expected Graduation Term(s) |
Graduation Review Status |
| Grad Review Status Date(s) |
Degree Checkout Status |
Academic Degree Status |
Completion Term |
| Confer Date |
Honors Code |
Honors Code Description |
Term (of Last Enrollment) |
| Online Indicator |
Total Units Attempted |
Total Units Earned |
Total Cumulative Units |
| Cumulative GPA |
Advisor(s) |
Advisor Email(s) |
|
Page last updated November 2026. For a PDF copy, print this webpage as a PDF.
