![\"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
This resource contains instructions on how to navigate to and run queries. It includes processes originating from the Reporting Center folder in the left MyBU Student menu as well as how to use the Query Viewer<\/a> page. <\/p>\n Each report in the Frequently Used Reports<\/a> section lists the prompts<\/strong> used for running the report and the data fields<\/strong> included in the results. This is meant to guide staff in quickly identifying what report might be helpful depending on the search criteria that\u2019s needed and\/or the information that\u2019s desired to review. <\/p>\n TIP! <\/strong>Try using the Ctrl+f keyboard shortcut to search this resource for a particular field.<\/p>\n All queries have a unique identifier, called the Query Name. The Query Name is not meant to be a user-friendly title but a system identifier composed of keywords and abbreviations separated by underscores (for example: BU_R0010M_SR_CPP_HIST). Since the Query Name doesn’t always give a clear indication of the full description\/scope of the report, it may be helpful to add relevant queries to Favorites. Refer to the Query Viewer section below for more information about running queries and saving favorites.<\/p>\n Please be sure to review the Support Process<\/a> in the Appendix of this resource if looking for a particular report or encountering an issue.<\/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 \u24d8 Appropriate security is required to access this folder and the reports included here may change. <\/strong><\/p>\n A list of common queries for staff will display. <\/p>\n Prompt fields are the initial set of criteria that are entered to run the report. Each report\u2019s prompts will vary depending on the content of the report.<\/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 PROCEED WITH PROMPTS<\/strong><\/p>\n Depending on the criteria entered, the report may take some time to compile. Look for the processing icon to confirm; this may be displayed in the top right corner of the page if running the report was accessed directly from the menu.<\/p>\n The report will compile. <\/p>\n The following steps will display views from both navigation methods, directly from the left Reporting Center menu or via Query Viewer. Refer to the Query Viewer<\/a> section of this resource to see how to search for reports in that page. <\/p>\n Report columns, or Field Names, display the data associated to the compiled results. Each report will display different data depending on the content of the report.<\/p>\n The results can be downloaded or reviewed directly in the MyBU Student page.<\/p>\n <\/div>\n<\/div>\n\n Note that Query Viewer will only display reports that staff have been given access to.<\/p>\n Query results matching the search values will be listed. Commonly used options to compile the report include:<\/p>\n Once the Run<\/strong> option has been selected, entering prompt criteria to run a report follows the same process as if the report was accessed directly from the Reporting Center folder. Refer to the Run a Query<\/a> section in this resource for details.<\/p>\n To mark the query as a Favorite for easier access later, click Favorite<\/strong>. When the Query Viewer page is opened, any queries that have been saved as favorites will automatically display.<\/p>\n Once the Run<\/strong> option has been selected, entering prompt criteria to run a report follows the same process as if the report was accessed directly from the Reporting Center folder. Refer to the Run a Query<\/a> section in this resource for details.GLOSSARY & QUERY REPORT LIBRARY<\/h5>\n
\n
Run a Query<\/h4>
\n<\/a><\/p>\n\n
\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-2-636x397.png\")
<\/a>\n<\/li>\n<\/ol>\nENTER PROMPTS<\/a><\/h5>\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-3-636x282.png\")
<\/a><\/p>\n\n
\n
\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-4-636x256.png\")
<\/a>
\nThis may be helpful if you want to narrow down Plans to just those associated to a certain Program.\n<\/li>\n<\/ul>\n\n
\n
\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-5-636x102.png\")
<\/a>\n<\/ul>\n<\/li>\n\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-6-636x102.png\")
<\/a>\n<\/ul>\n<\/li>\n<\/ol>\n\n
\n
REVIEW REPORT ACTIONS & DATA FIELDS <\/h5>\n
\n
\n
\n
\n
\n
Query Viewer<\/h4>
\n<\/a>Navigate to Query Viewer to search for and run reports that are not listed in the Reporting Center folder. Reports that are in the folder can still be run via Query Viewer. Favorite queries can also be saved in Query Viewer, for quick access later. <\/p>\n\n
\n
![\"Query](\"\/sis-training\/files\/2025\/06\/queries-for-advising-2-636x227.png\")
<\/a><\/li>\n\n
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-9-636x142.png\")
<\/a><\/p>\n
\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>\n
\n<\/div>\n<\/div>\n\nFrequently Used Staff Reports<\/h4>
![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-12-636x422.png\")
<\/a><\/p>\n![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-13-636x177.png\")
<\/a><\/p>\n![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-14-636x266.png\")
<\/a><\/p>\n![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-15-636x271.png\")
<\/a><\/p>\n![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-16-636x400.png\")
<\/a><\/p>\n![\"This](\"\/sis-training\/files\/2025\/08\/query-manual-administrative-staff-17-636x261.png\")
<\/a><\/p>\n