Skip to main content
Registration and Records
Registration and Records

Query Repository

Many data requests can be pulled using a query

Below is a list of queries related to commonly requested information, by topic, which you can run in PeopleSoft.

After logging into PeopleSoft, navigate to: Main Menu>CS Tools>Query Viewer

Enter the query name below, including underscores, in the *Search By field. Click Search.

From the Search Results, select Excel to run to Excel. Enter any necessary information into prompts, if applicable. Click View Results. Save resulting excel file.

Please note that you must have the correct security access to run these queries. If you have any questions, contact Registration and Records at 317-840-9203 or Registrar@butler.edu.

List of Commonly Requested Queries
Topic Query Name Description Prompts
FERPA BU_SR_CURRENT_NO_FERPA List active students in a term who do NOT have a FERPA hold on record; directory information may be released Term
BU_SR_CURRENT_ONLY_FERPA List active students in a term who have a FERPA hold on record; directory information may not be released Term
CLASS SCHEDULES BU_SCH_CLASS_SCHEDULE Class schedule listing for a specific term Term
BU_SCH_CLASS_SCHEDULE_SUBJECT Class schedule listing for a specific term and subject area Term & Subject area
CLASS ROSTERS BU_SR_CLASS_ROSTER Class roster for a specific term and course Term, Subject, Catalog, Section
BU_SR_CLASS_ROSTER_HOME_ADDRESS Class roster for a specific term and course with student's Home address. EXCLUDES students who have a FERPA hold on their account. Term, Subject, Catalog, Section
ADDRESS LISTS BU_SR_CUR_STDNT_HOME_ADDRESS Home address of all students enrolled in a specific term. Term, Remove lines where FERPA='Y'
BU_SR_CLASS_ROSTER_HOME_ADDRESS Class roster for a specific term and course with student's Home address. EXCLUDES students who have a FERPA hold on their account. Term, Subject, Catalog, Section
BU_SR_BULLDOG_DINNER_ADDR Lists Home address of all students enrolled in a specific term who are from a specific state. Term, State
ENROLLMENT BU_SR_CURRENT_ENROLLED_ALL Lists all students enrolled in a specific term. Includes campus email. Term
BU_SR_CUR_STD_MAJOR_W_ALL_PLAN Lists all students enrolled in a term, along with all declared majors and minors. Note: Each separate major and minor will list on a separate line, so students pursuing more than one plan will list in multiple lines. Term, Academic Program (% for all), Academic Plan (% for all)
COMMENCEMENT BU_SR_COMPLETED_ALL_MAJ_MIN Lists all graduates for a commencement date. Includes primary and secondary majors and minors. Date prompt returns anyone who graduated after the date entered in the prompt, so watch for multiple commencement dates. Enter date PRIOR TO Commence date (i.e., enter '05/01/2016' for those who graduated after May 7, 2016.