Skip to main content

Error message

Notice: Undefined index: bundle in fieldable_panels_panes_load_from_subtype() (line 995 of /var/www/html/sites/all/modules/contrib/fieldable_panels_panes/fieldable_panels_panes.module).
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

BU_SR_CURRENT_ONLY_FERPA

List active students in a term who do NOT have a FERPA hold on record; directory information may be released

List active students in a term who have a FERPA hold on record; directory information may not be released

Term

Term

CLASS SCHEDULES

BU_SCH_CLASS_SCHEDULE

BU_SCH_CLASS_SCHEDULE_SUBJECT

Class schedule listing for a specific term

Class schedule listing for a specific term and subject area

Term

Term & Subject area

CLASS ROSTERS

BU_SR_CLASS_ROSTER

BU_SR_CLASS_ROSTER_HOME_ADDRESS

Class roster for a specific term and course

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

Term, Subject, Catalog, Section

ADDRESS LISTS

BU_SR_CUR_STDNT_HOME_ADDRESS

BU_SR_CLASS_ROSTER_HOME_ADDRESS

BU_SR_BULLDOG_DINNER_ADDR

Home address of all students enrolled in a specific term.

Class roster for a specific term and course with student's Home address. EXCLUDES students who have a FERPA hold on their account.

Lists Home address of all students enrolled in a specific term who are from a specific state.

Term, Remove lines where FERPA='Y'

Term, Subject, Catalog, Section

Term, State

ENROLLMENT

BU_SR_CURRENT_ENROLLED_ALL

BU_SR_CUR_STD_MAJOR_W_ALL_PLAN

Lists all students enrolled in a specific term. Includes campus email.

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

Term, Academic Program (% for all), Academic Plan (% for all)

FACE-TO-FACE and REMOTE STUDENTS

BU_AA_CLASS_ROSTER_F2F 

BU_AA_CLASS_ROSTER_F2F_BY_INST

Identifies face-to-face or remote student status for all students enrolled in a term.

Definitions of each Student Group and their descriptions are:

  • One+ Classes at Butler (IFBU/ISBU): Graduate and Undergraduate students enrolled in at least one In-Person class 
  • Grad Enrolled Online Program (IFGE/ISGE): Graduate students in one of the fully on-line graduate programs and enrolled in classes 
  •  Grad Online courses Only (IFGO/ISGO): Graduate Students who by virtue of their individual class enrollments, happen to be enrolled in ONLY on-line classes
  • Undergrad Online Only (IFUO/ISUO): Undergraduate Students who by virtue of their individual class enrollments, happen to be enrolled in ONLY on-line classes, but are NOT a Remote Student 
  • Undergrad Remote Semester (IFUR/ISUR): Undergraduate Students fully approved to be remote only
Term, Subject, Catalog, Section, Student Group (IF% for Fall terms and IS% for Spring terms)
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.