{"id":9346,"date":"2026-09-28T14:22:17","date_gmt":"2026-09-28T18:22:17","guid":{"rendered":"https:\/\/sites.bu.edu\/sis-training\/?p=9346"},"modified":"2026-09-29T14:54:28","modified_gmt":"2026-09-29T18:54:28","slug":"admissions-queries","status":"publish","type":"post","link":"https:\/\/sites.bu.edu\/sis-training\/admissions-queries\/","title":{"rendered":"Queries: Admissions"},"content":{"rendered":"<p>This resource provides information and instructions for running common Admissions-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>Introduction<\/h4>\n<p>Queries in MyBU Student are reports. This resource describes queries identified as frequently used for staff needs and processes in the Admissions functional area. This typically includes data related to application materials and details, application status, and matriculation rosters.<\/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\">Admissions Checklist<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>This is a report based on the status of checklist items. It is used to determine if students are missing certain credentials or application materials.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0019O_AD_CHECKLIST<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Admissions Checklist<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Admit Term,  Checklist, List Status, Chklist Itm, and Item Status.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/ad_queries_4.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/ad_queries_4.png\" alt=\"Example of an Admissions Checklist query window.\" width=\"387\" height=\"362\" class=\"aligncenter size-full wp-image-9238\" style=\"border: 2px solid black;\"\/><\/a><\/p>\n<p>In the example shown above, the report will run for Admit Term: Fall 2025 (2258). Results will narrow by Checklist Item: ACT Scores (ADACTS) with List Status: Completed.  <\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tr>\n<td>ID<\/td>\n<td>Function<\/td>\n<td>Checklist<\/td>\n<td>Checklist Descr<\/td>\n<\/tr>\n<tr>\n<td>Chklist Itm<\/td>\n<td>Stat Dt<\/td>\n<td>Status<\/td>\n<td>Descr<\/td>\n<\/tr>\n<tr>\n<td>Career<\/td>\n<td>Acad Prog<\/td>\n<td>Admit Term<\/td>\n<td>Status<\/td>\n<\/tr>\n<tr>\n<td>Prog Actn<\/td>\n<td>Action Rsn<\/td>\n<td>Admit Type<\/td>\n<td>Notificatn<\/td>\n<\/tr>\n<tr>\n<td>Appl Meth<\/td>\n<td>Citizenship 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\">Contact List of Admitted Students<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>This report creates a contact list for reaching out to the admitted undergraduate students included in the search. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_R0019F_AD_CONTACT_REPORT<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Contact List Admitted Students<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Admit Term, *Career, Acad Prog or %Col%, and Institution.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/ad_queries_5.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/ad_queries_5.png\" alt=\"Example of a Contact List of Admitted Students query window.\" width=\"375\" height=\"281\" class=\"aligncenter size-full wp-image-9239\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the report will run for Admit Term: Fall 2025 (2258), Career: Undergraduate, and Acad Prog: UCOM.<\/p>\n<table class=\"redTable\" wdith=\"100%\" style=\"margin-top:0;\">\n<tbody>\n<tr>\n<td>Admit Term<\/td>\n<td>Admit Type<\/td>\n<td>First Name<\/td>\n<td>Middle<\/td>\n<\/tr>\n<tr>\n<td>Last<\/td>\n<td>ID<\/td>\n<td>Appl Meth<\/td>\n<td>Acad Prog<\/td>\n<\/tr>\n<tr>\n<td>Notificatn<\/td>\n<td>Prog Actn<\/td>\n<td>Actn Rsn<\/td>\n<td>Acad Plan<\/td>\n<\/tr>\n<tr>\n<td>Descr<\/td>\n<td>Type<\/td>\n<td>Country<\/td>\n<td>Phone<\/td>\n<\/tr>\n<tr>\n<td>Ext<\/td>\n<td>Type<\/td>\n<td>Email<\/td>\n<td>Partnership<\/td>\n<\/tr>\n<tr>\n<td>Partnership Descr<\/td>\n<td>US Citizenship Status<\/td>\n<td>1<sup>st<\/sup> Gen Ind<\/td>\n<td>&nbsp;<\/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\">All Applications By Admit Term<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A report of all admission applications by admit term range prompt. Report will include applications of any status (Active in Program, Admitted, Cancelled).<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_AD_APPL_ALL_STATUS<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: All applications by admit term<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Institution, *Academic Career, and *Admit Term (From\/To).<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/ad_queries_6.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/ad_queries_6.png\" alt=\"Example of an All applications by admit term query window.\" width=\"374\" height=\"280\" class=\"aligncenter size-full wp-image-9240\" style=\"border: 2px solid black;\" srcset=\"https:\/\/sites.bu.edu\/sis-training\/files\/2026\/09\/ad_queries_6.png 499w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/09\/ad_queries_6-496x373.png 496w\" sizes=\"(max-width: 374px) 100vw, 374px\" \/><\/a><\/p>\n<p>In the example above, the report will run for Academic Career: Graduate, and Admit Term From\/To: Fall 2025 (2258).<\/p>\n<p><strong>Additional Info &#038; Tips:<\/strong><br \/>\nRunning this report from Query Viewer may produce results that exceed maximum result size for the application server. It\u2019s recommended to schedule these runs rather than use Query Viewer.<\/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>Academic Career<\/td>\n<td>Academic Program<\/td>\n<td>Academic Plan<\/td>\n<td>Admit Term<\/td>\n<\/tr>\n<tr>\n<td>Academic Program Status<\/td>\n<td>Effective Date<\/td>\n<td>Action Date<\/td>\n<td>Program Action<\/td>\n<\/tr>\n<tr>\n<td>Program Action Description<\/td>\n<td>Action Reason<\/td>\n<td>Action Reason Description<\/td>\n<td>Country of Citizenship<\/td>\n<\/tr>\n<tr>\n<td>Current Address Line 1, 2, 3, 4<\/td>\n<td>Current City<\/td>\n<td>Current State<\/td>\n<td>Current Postal Code<\/td>\n<\/tr>\n<tr>\n<td>Current Country<\/td>\n<td>Home Address Line 1, 2, 3, 4<\/td>\n<td>Home City<\/td>\n<td>Home State<\/td>\n<\/tr>\n<tr>\n<td>Home Postal Code<\/td>\n<td>Home Country<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/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\">UGRD Admissions Detail Query<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>A report of multiple admissions details by admit 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_R0006_AD_UG_APPL_DTL_QRY<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Detailed Undergraduate Application Report<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Admit Term, Admit Term 2, School\/College, FRS or TRN, Notification Plan, and CEEB.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/ad_queries_8.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/ad_queries_8.png\" alt=\"Example of an UGRD Application Details Query window.\" width=\"352\" height=\"355\" class=\"aligncenter size-full wp-image-9241\" style=\"border: 2px solid black;\" srcset=\"https:\/\/sites.bu.edu\/sis-training\/files\/2026\/09\/ad_queries_8.png 469w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/09\/ad_queries_8-150x150.png 150w, https:\/\/sites.bu.edu\/sis-training\/files\/2026\/09\/ad_queries_8-100x100.png 100w\" sizes=\"(max-width: 352px) 100vw, 352px\" \/><\/a><\/p>\n<p>In the example above, the report will run for Admit Term: Spring 2026 (2261), narrowed to School\/College: UCAS and Notification Plan: Regular Admission Decision.<\/p>\n<p><strong>Additional Info &#038; Tips:<\/strong><br \/>\nTo narrow the report to show only first-year or transfer student Admit Types, enter FRS or TRN, respectively, in the relevant search field. <\/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>Birthdate<\/td>\n<\/tr>\n<tr>\n<td>US Citizenship<\/td>\n<td>Admit Term<\/td>\n<td>Admit Type<\/td>\n<td>Notification Plan<\/td>\n<\/tr>\n<tr>\n<td>Appl Meth<\/td>\n<td>Academic Program<\/td>\n<td>Academic Plan<\/td>\n<td>Plan Description<\/td>\n<\/tr>\n<tr>\n<td>Academic Subplan<\/td>\n<td>Fac\/Staff<\/td>\n<td>Prog Actn<\/td>\n<td>Action Rsn<\/td>\n<\/tr>\n<tr>\n<td>Decision\/Status Date<\/td>\n<td>WITHDRAW \/ DEFER DATE<\/td>\n<td>WITHDRAW \/ DEFER REASON<\/td>\n<td>Honors College Admit<\/td>\n<\/tr>\n<tr>\n<td>Last School Attended<\/td>\n<td>CEEB<\/td>\n<td>HS State<\/td>\n<td>HS Country<\/td>\n<\/tr>\n<tr>\n<td>Visa Type<\/td>\n<td>App Fee Status<\/td>\n<td>First Gen<\/td>\n<td>Financial Aid Interest<\/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\">CEEB Not Assigned Audit<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>This query generates a report of last school attended and external education values by applicant.<\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_AD_UG_CEEB_NA_AUDIT<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: CEEB Not Assigned Audit<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Admit Term,  Admit Term 2.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/ad_queries_9.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/ad_queries_9.png\" alt=\"Example of a CEEB Not Assigned Audit query window.\" width=\"340\" height=\"233\" class=\"aligncenter size-full wp-image-9242\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the report will run for Admit Term: Fall 2026 (2268).<\/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>Admit Term<\/td>\n<td>Admit Type<\/td>\n<td>Notificatn<\/td>\n<\/tr>\n<tr>\n<td>Appl Meth<\/td>\n<td>Acad Prog<\/td>\n<td>Prog Actn<\/td>\n<td>Action Rsn<\/td>\n<\/tr>\n<tr>\n<td>Last School Attended<\/td>\n<td>LSA School Type<\/td>\n<td>Education<\/td>\n<td>Program Action Date<\/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\">Matriculated Non-withdrawn Applicants<\/h4><div class=\"bu_collapsible_section\" style=\"display: none;\"><\/p>\n<p>Report displays a current roster of matriculated applicants for a given term with prompts for Career and Academic Program. <\/p>\n<p style=\"padding-bottom:0px; margin-bottom:0px;\"><strong>System Details:<\/strong><\/p>\n<ul>\n<li><strong>Query Name<\/strong>: BU_AD_UG_MATR_DATABASE<\/li>\n<li><strong>Query Title\/Short Description<\/strong>: Matriculation Database<\/li>\n<li><strong>Search Prompts<\/strong> (asterisk indicates required field): *Career, *Admit Term, Admit Term 2, Academic Program, Academic Program 2, Exclude Academic Program, FRS or TRN, and Notification Plan.<\/li>\n<\/ul>\n<p><a href=\"\/sis-training\/files\/2026\/09\/ad_queries_10.png\"><img loading=\"lazy\" src=\"\/sis-training\/files\/2026\/09\/ad_queries_10.png\" alt=\"Example of an Undergrad Matriculation Database query window.\" width=\"424\" height=\"444\" class=\"aligncenter size-full wp-image-9243\" style=\"border: 2px solid black;\" \/><\/a><\/p>\n<p>In the example above, the report will run for Career: Undergraduate and Admit Term: Fall 2026 (2268). The search is also narrowed by Notification Plan: Guaranteed Transfer.<\/p>\n<p><strong>Additional Info &#038; Tips:<\/strong><br \/>\nIS&#038;T staff distribute this report to school\/colleges weekly through the summer to ensure they have an updated listing of their incoming students.<\/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>Preferred First Name<\/td>\n<td>Last Name<\/td>\n<td>Gender<\/td>\n<\/tr>\n<tr>\n<td>International<\/td>\n<td>First Generation<\/td>\n<td>Address<\/td>\n<td>City<\/td>\n<\/tr>\n<tr>\n<td>State<\/td>\n<td>Postal<\/td>\n<td>Country<\/td>\n<td>Home Phone<\/td>\n<\/tr>\n<tr>\n<td>Cell Phone<\/td>\n<td>Application Email<\/td>\n<td>BU Email<\/td>\n<td>Academic Program<\/td>\n<\/tr>\n<tr>\n<td>Academic Plan<\/td>\n<td>Academic Subplan<\/td>\n<td>Program\/Plan Change Date<\/td>\n<td>Honors College<\/td>\n<\/tr>\n<tr>\n<td>Admit Term<\/td>\n<td>Admit Type<\/td>\n<td>Notification Plan<\/td>\n<td>Program Action<\/td>\n<\/tr>\n<tr>\n<td>Action Reason<\/td>\n<td>Status Date<\/td>\n<td>Description<\/td>\n<td>QuestBridge Applicant<\/td>\n<\/tr>\n<tr>\n<td>Scholarships Awarded<\/td>\n<td>Previously Deferred<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/div>\n<\/div>\n\n<p>Page last updated September 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 Admissions-focused queries using Query Viewer. Introduction Queries in MyBU Student are reports. This resource describes queries identified as frequently used for staff needs and processes in the Admissions functional area. This typically includes data related to application materials and details, application status, and matriculation rosters. \u24d8 [&hellip;]<\/p>\n","protected":false},"author":1183,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[52,47,43],"_links":{"self":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9346"}],"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\/1183"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/comments?post=9346"}],"version-history":[{"count":29,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9346\/revisions"}],"predecessor-version":[{"id":9386,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/posts\/9346\/revisions\/9386"}],"wp:attachment":[{"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/media?parent=9346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/categories?post=9346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.bu.edu\/sis-training\/wp-json\/wp\/v2\/tags?post=9346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}