![\"Glossary](\"\/sis-training\/files\/2025\/06\/Glossary-icon.png\"){kind=icon}
<\/a>![\"Video](\"\/sis-training\/files\/2025\/05\/Video-icon.png\"){kind=icon}
<\/a><\/a><\/p>\nIntroduction<\/h4>\n
Queries pull data from across the Student Information System (MyBU Student) and its integrated systems. They support a variety of informational and operational purposes across the University. This resource focuses on queries used to generate reports for informational purposes.<\/p>\n
Explore the sections below for additional information and instructions on how to navigate to and run queries using the Reporting Center folder<\/strong> in MyBU Student, as well as the Query Viewer<\/strong> page.<\/p>\n Note that access to certain queries is limited by user security. Available data may also restricted.<\/p>\n \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 MyBU Student has hundreds of available queries, with improvements and additional queries developed regularly. Given the expansive options, it may be helpful to use the tools described below to find the right query for a particular need. Remember that access to certain queries is limited by user security.<\/p>\n Please be sure to review the Support Process<\/a> section of this resource if looking for a particular report, requesting a report modification, or encountering an issue.<\/p>\n <\/div>\n<\/div>\n\n The look and feel of queries varies slightly between those found in the Reporting Center folder and those run in Query Viewer. <\/p>\n To access a query in the Reporting Center folder<\/strong>:<\/p>\n \u24d8 NOTE<\/strong>: Some users will also see a \u2018Reporting Center\u2019 tile on the Full Site\/Staff Homepage. This is different from the Reporting Center folder described herein, though it does contain shortcuts to reports for specific functional areas. All queries accessed via this tile can also be accessed via the Query Viewer page.<\/p>\n \u24d8 The queries included in the Reporting Center folder may vary by user and are subject to change. <\/strong><\/p>\n The Query Viewer page can be accessed a few different ways:<\/p>\n To pull up a query:<\/p>\n Query Viewer allows users to mark a query as a favorite, for easier access later.<\/p>\n After searching for a particular query, click Favorite<\/strong>.<\/p>\n When the Query Viewer page is opened, any queries that have been saved as favorites will automatically display.<\/p>\n A query can be removed from My Favorite Queries by clicking the minus sign under the \u2018Remove\u2019 column. Clicking \u2018Clear Favorites List\u2019 will remove all saved queries. <\/p>\n <\/div>\n<\/div>\n\n <\/a>Once a Query has been opened, the search prompts<\/strong> must be entered to run the report. Each query’s prompt fields will vary depending on the content of the report.<\/p>\n The following instructions and screenshots will use the Students by Prgm\/Plan\/Subplan<\/strong> report (BU_R0010M_SR_CPP_PROG_BY_TERM) to demonstrate running a query. This query is available in the Reporting Center folder, labeled ‘By Career\/Program\/Plan\/SubPlan’.<\/p>\n GENERAL TIPS<\/strong><\/p>\n LOOKUP TIPS<\/strong><\/p>\n %COLLEGE% TIPS<\/strong><\/p>\n A field with the label, Acad Prog or %College%<\/strong>, indicates that a specific Academic Program value can be entered or selected. This can be performed by looking up in that field or entering a known value.<\/p>\n \u24d8 NOTE<\/strong>: If using the %College% search option, enter the needed value directly into the field without performing a lookup. Performing a lookup may cause confusion as the window will display no results. This is ok – proceed with the desired report prompts and the results compilation will still be successful.<\/p>\n For example:<\/p>\n TIP! <\/strong>Some reports include clickable drill-down links, which will appear in blue when viewing the results on the page. For example, in the ‘Students by Prgm\/Plan\/Subplan’ results example shown above, clicking on a student’s UID will open a sub-report of that student’s CPP history in a new window.<\/p>\n <\/div>\n<\/div>\n\n The List of Queries report provides a list of all available MyBU queries, including both their Short Description\/Title and a helpful longer description. <\/p>\n<\/p>\n The search prompts allow users to search by keyword(s) contained in the Query Name, Short Description, or Long Description. For example, searching for \u201cschedule of classes\u201d or \u201cgraduation\u201d will return queries containing those terms.<\/p>\n \u24d8 NOTE<\/strong>: This report is intended to complement – not replace – the Query Report Library<\/a> tool in PowerBI, which provides a more comprehensive search experience. Refer to the Query Report Library Guide<\/a> for more information. <\/li>\n<\/ul>\n Navigation:<\/strong> From the MyBU Student Dashboard, the List of Queries can be found in the Reporting Center<\/strong> folder in the left-side navigation menu. Search Prompts:<\/strong> Keyword Search 1, Keyword Search 2, Keyword Search 3<\/p>\n \u24d8 Results are not security-based. Users may see queries they do not have access to run.<\/strong><\/p>\n Example search and results:<\/strong> To run a query found in the results:<\/strong><\/p>\n Direct links to the queries are not currently available from the results (as of June 2026).<\/p>\n <\/div>\n<\/div>\n\n The queries listed below are available to most users in the MyBU Student Dashboard left-side menu Reporting Center folder. For each query, the system\u2019s Query Name, Title\/Short Description, prompts, and data fields are listed, along with additional helpful details and screenshots. Note that any identifying data has been blurred in screenshots.<\/p>\n TIP!<\/strong> Use the Ctrl+f keyboard shortcut to search the below content for a particular keyword or data field.<\/p>\n \u24d8 The queries included in the Reporting Center folder may vary by user and are subject to change. <\/strong><\/p>\n This query allows the user to look up a student\u2019s UID by searching for them by name, primary program, and\/or email address.<\/p>\n System Details:<\/strong><\/p>\n \u24d8 NOTE<\/strong>: If searching by email address, enter it in ALL CAPS.<\/p>\n Additional Info & Tips:<\/strong><\/p>\n Data Fields Displayed In Results<\/strong>:<\/p>\nQUERY FOUNDATIONS<\/h4>
COMPONENTS OF A QUERY<\/h5>\n
\n
\n
FINDING THE RIGHT QUERY<\/h5>\n
\n
\n
NAVIGATION & QUERY VIEWER<\/h4>
\nThere are two primary methods for staff to access reports:<\/p>\n\n
REPORTING CENTER<\/h5>\n
\n
\n
![\"A](\"\/sis-training\/files\/2026\/07\/Reporting-Center-folder-vs-tile-comparison-636x234.png\")
<\/a><\/p>\nQUERY VIEWER<\/h5>\n
\n
\n
\n
![\"Query](\"\/sis-training\/files\/2025\/06\/queries-for-advising-2-636x227.png\")
<\/a><\/p>\n![\"Example](\"\/sis-training\/files\/2026\/07\/Query-Viewer-advanced-search-example-636x293.png\")
<\/a>\n<\/ol>\n\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-9-636x142.png\")
<\/a>\n<\/li>\n<\/ol>\nSAVING FAVORITES<\/h5>\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-10-636x144.png\")
<\/a><\/p>\n![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-11-636x228.png\")
<\/a><\/p>\nRUN A QUERY & VIEW RESULTS<\/h4>
ENTER PROMPTS<\/h5>\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-3-636x282.png\")
<\/a><\/p>\n\n
\n
\n
![\"Example](\"\/sis-training\/files\/2026\/07\/Example-of-recent-search-suggestions-636x143.png\")
<\/a><\/p>\n\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-4-636x256.png\")
<\/a><\/p>\n\n
\n
\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-5-636x102.png\")
<\/a><\/li>\n\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-6-636x102.png\")
<\/a><\/li>\n<\/ol>\nVIEW REPORT: ACTIONS & DATA FIELDS<\/h5>\n
\n
\n
\n
![\"Example](\"\/sis-training\/files\/2026\/07\/Query-Results-example-636x508.png\")
<\/a>\n<\/ol>\n<\/li>\n\n
\n
\n
'LIST OF QUERIES' REPORT<\/h4>
\n![\"Menu](\"\/sis-training\/files\/2025\/08\/List-of-Queries-nav-and-prompts-636x213.png\")
<\/a><\/p>\n\n
\n
\n![\"Example](\"\/sis-training\/files\/2026\/07\/List-of-Queries-results-example-636x307.png\")
<\/a><\/p>\n\n
REPORTING CENTER QUERIES<\/h4>
STUDENT ID LOOKUP<\/h5>\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-12-636x422.png\")
<\/a><\/p>\n\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-13-636x177.png\")
<\/a><\/p>\n