Graduate School Query Library

The Graduate School Query Library contains MyPack Portal (PeopleSoft) queries helpful for managing graduate services. All queries can be found by searching for the “Query Name” in the SIS Query Viewer (SIS > Reporting Tools > Query Tools > Query Viewer). The Library is organized into the following major categories:

• Acad Standing/Grading
• Admissions
• Degrees Conferred
• Enrollment
• Enrollment/GSSP
• ETD
• Faculty
• GPOW
• Graduate Exams
• Graduation
• Student Financials

Category	Query Name	Description
Acad Standing /Grading	SIS_GRAD_ACAD_STAND	For one student, shows all of the student?s academic standing actions along with the student?s current academic standing status.
Acad Standing /Grading	SIS_GRAD_U_GRADES_PROG	Returns active graduate students for a prompted academic term and academic program having a "U" grade in any course. Shows active program and course information.
Acad Standing /Grading	SIS_GRAD_GPA_DROP_PROG	Returns active graduate students for a prompted academic term and academic program whose current GPA is >0.75 lower than their cumulative GPA.
Admissions	SIS_GRAD_COND_ADM_CHECK	Students in an academic organization who are currently enrolled but were provisional admissions
Admissions	GRAD_TST_SCORE_SUPN_BDAY_TOEFL	This query is used to search by date of birth to find unmatched TOEFL scores
Admissions	GRAD_TST_SCORE_SUPN_BDAY_GRE	This query is used to search by date of birth to find unmatched GRE scores
Admissions	SIS_GRAD_APPL_HIST_TERM_PGM	A list of applicants for a user-selected career, historical admit term, historical snapshot term, and academic program, along with GRE scores and gender/ethnic data. Select terms back to fall 2009.
Admissions	SIS_GRAD_APPL_HIST_TERM_COLL	A list of applicants for a user-selected career, historical admit term, historical snapshot term, and two-digit academic college code, along with GRE scores and gender/ethnic data. Select terms back to fall 2009.
Admissions	SIS_GRAD_APPL_HST_TERM_PGM_SCH	This query returns a list of historical applications (by user-selected Career, snapshot term, Admit Term, and academic program) from the historical admissions denorm table. Columns include GRE scores and most recent undergrad & grad self-reported previous institutions.
Admissions	SIS_GRAD_DEFR	View a list of students whose term of admission was deferred and the term deferred to.
Admissions	SIS_GRAD_APPL_WITH_GRE_SCORES	A list of applicants for a user selected career, current or future term, and program along with their most recent GRE scores (all components with percentiles included).
Admissions	SIS_GRAD_PROVISIONAL_ADMITS	Provides a list of all grad students for a user-selected academic program who are currently on conditional (a.k.a. provisional) admission and are eligible to enroll in the current term. Includes registration status, cumulative hours passed, and cumulative GPA as of the current term
Admissions	SIS_GRAD_APPL_WITH_SCHOOLS	Current or future applications from admissions denorm table joined with education denorm to pick up self-reported education history information for each applicant's most recent undergrad and grad institution
Degrees Conferred	SIS_GRAD_GCERT_COMPLETED	Returns people who completed graduate certificate (GCERT academic program) for a user-selected completion term. Shows emplid, name, and academic plan
Degrees Conferred	SIS_GRAD_DEGREES_WITH_CHAIR	Query is based on a user-selected graduate program and will return approved graduate students for whom degrees were conferred. Also included is the name/ID of their chair, co-chair, or vicechair (per GPoW screen).
Degrees Conferred	SIS_GRAD_DEGREES_BY_PROG	Returns list of approved grads with graduate degrees conferred in graduate majors for all terms after fall 2008 by userselected academic program.
Degrees Conferred	SIS_ALL_GRAD_DEGREES_BY_PROG	Returns list of approved grads with graduate degrees conferred in graduate majors for all terms after summer 1995 (both Legacy and SIS in one query) by userselected academic program.
Degrees Conferred	SIS_ALL_GRAD_DEGREES_BY_COLL	Returns a list of all graduate students with a graduate degree conferred (both legacy and SIS academic terms) by user-selected college code (02, 11-20). Includes an Option B flag for those with completed Option B milestone on their record. Some records date back to the late 1990's.
Degrees Conferred	SIS_GRAD_DEGR_PROG_GPOW_TRM	Returns a list of all graduate students with a graduate degree conferred (both legacy and SIS academic terms) by user-selected college code (02, 11-20). Includes an Option B flag for those with completed Option B milestone on their record. Some records date back to the late 1990's.
Degrees Conferred	SIS_ALL_GRD_DEG_BY_PGM_W_TITLE	Union query returns all graduate students with a graduate degree conferred (both legacy and SIS) by user-selected program code. Includes an Option B, gender, ethnicity, and thesis/dissertation titles for masters & doctoral students who have one.)
Degrees Conferred	SIS_GRAD_DEGR_BY_PROG_W_TITLES	Graduation Checkout View (NC_GCO_VW) joined with ACAD_DEGR (Student Degree Table) for graduate majors, all terms after fall 2008, by user-selected academic program, to get approved grads for whom degrees were actually conferred. Includes an Option B, gender, ethnicity, and thesis/dissertation titles for masters & doctoral students who have one.)
Enrollment	SIS_GRAD_MR_EN_ROUTE_BY_PROG	Returns a list of students in a user-selected academic program with GMOR (Grad Master On Route) program reason.
Enrollment	SIS_GRAD_PROG_STATUS	Returns an alphabetic list of students for a user-selected academic program and academic program status.
Enrollment	SR_STUDENT_DROPS_AFTER_DATE_X	All students who dropped a course after a specific date.
Enrollment	SIS_GRAD_TERMINATED	View a list of graduate students who have been terminated from their program from start to end prompted terms.
Enrollment	SIS_GRAD_PGM_PLAN_CHANGE	List of students who have any instances of a Program Change or Plan Change program action between beginning and end dates which are input by the query user
Enrollment	SIS_GRAD_LOA	View a list of students currently on leave of absence for the user identified program.
Enrollment	SIS_GRAD_LEAV	Provides the name, emplID, and return term for students on Leave of Absence
Enrollment	SIS_GRAD_ENR_MLSTN_ACAD_LOAD	Returns list of masters students enrolled in the current or future term for a user selected academic program with flags for option B milestone, thesis milestone, approved GPoW, minimum GPoW hour requirement, enrollment hours, and if they have received the insurance benefit from the GSSP
Enrollment	SIS_GRAD_DISCONTINUED_BY_PROG	This query returns a list of grads with a "discontinued" program action by userselected academic program.
Enrollment	SIS_GRAD_ACTIVE_WITH_PREV_BACH	Returns graduate students active in the current term and displays the school name where the student reported receiving their bachelor's degree. The user enters their college code (11-20) to get the list by college.
Enrollment	SIS_GRAD_ACTIVE_BY_COLLEGE	Active students (enrolled or eligible to be enrolled) with demographic information for a user-selected academic career, current or future enrolled term, and college code.
Enrollment	SIS_GRAD_3_PLUS_X_BY_COLL	This query returns active 3+X students by college and provides their home institution, current program and plan and term first enrolled.
Enrollment	SIS_GRAD_3_PLUS_X	This query returns active 3+X students and provides their home institution, current program and plan and term first enrolled.
Enrollment	SIS_GRAD_ACAD_STRUC_BY_COLLEGE	Active graduate academic plans, programs, and subplans with descriptions and subplan type by user-selected two-digit college code (02, then 11-20)
Enrollment	SIS_GRAD_ACAD_STRUC_BY_PROGRAM	Active graduate academic plans, programs, and subplans with descriptions and subplan type by user-selected graduate program
Enrollment	SIS_GRAD_LOW_GRADES_PROG	Returns active graduate students for a prompted academic term and academic program having a C- or lower grade in any course. Shows active program and course information
Enrollment	SIS_GRAD_DR_AT_9PLUS_YRS_PROG	List of all current doctoral students in the user-selected academic program who have been in the program 9 or more years.
Enrollment	SIS_GRAD_DR_AT_9PLUS_YRS	List of all current doctoral students in the user-selected academic college who have been in the program 9 or more years.
Enrollment	SIS_GRAD_DR_AT_9PLUS_YRS_COLL	List of all current doctoral students in the user-selected academic college who have been in the program 9 or more years.
Enrollment	SIS_GRAD_NO_PRELIM_6YRS	List of all current doctoral students who have not scheduled their prelim 6 or more years after they started.
Enrollment	SIS_GRAD_NEW_ADMIT_TERM_BY_PGM	New graduate students (per admit term from program stack) for the current term by user-selected program.
Enrollment	SIS_GRAD_CENSUS_ENR_MINOR	Returns a list of students enrolled as of census in a user-selected minor plan (shows student emplid, name, minor plan, major program, and latest term enrolled).
Enrollment	SIS_GRAD_CENSUS_ENROLLMENT	List of students registered as of census date in a user selected term.
Enrollment	SIS_GRAD_DE_FOR_STDNT	View all courses in which a student has been enrolled. Distance education courses are identified
Enrollment	SIS_GRAD_ENROLLED_FULBRIGHT	Returns a list of Fulbright students for a user-selected career, current or future term, and academic program.
Enrollment	SIS_GRAD_PRELIM_SCHED	List of students who have not been scheduled for a doctoral prelim six or more years after the beginning of the term of the first class in their graduate POW.
Enrollment	SIS_GRAD_CERTIF_MINOR_PLANS	List of all graduate students enrolled in current or future terms that are also enrolled in a minor or certificate in a userselected academic plan.
Enrollment	SIS_GRAD_PRELIM_SCHED_BY_PROG	List of students who have not been scheduled for a doctoral prelim six or more years after the beginning of the term of the first class in their graduate POW in a specific academic program.
Enrollment	SIS_GRAD_STATUS	List of all current graduate students who are active in the user-selected academic program and their Plan of Work status.
Enrollment	SIS_NC_SUPEREXT_GRADS	List of students active in a current or future term.
Enrollment	SIS_GRAD_CNSS_ENRL_COLL	List of students registered as of census date in a user selected term and college
Enrollment	SIS_NC_SUPEREXT_BY_TERM_CAR_PG	A list of students for a user-selected current or future term, career, and academic program.
Enrollment /GSSP	MIN_FULL_TIME_UNITS	Returns a list of students from a user-selected program and the minimum number of enrollment hours needed to be considered full-time.
ETD	SIS_GRAD_COMPLETED_THESIS	A complete record including thesis title is returned if the student has a completed thesis. No values are returned if the student does not have a completed thesis.
Faculty	GRAD_ARCHIVE_COMM_SVC_BY_PGM	GARS committee service records from archive tables (pre-SIS) by user-selected academic program. (Grad date will be blank for people who changed legacy curriculum code after census date.) Some data goes back as far as December 2001.
Faculty	GRAD_ARCHIVE_COMM_SVC_BY_ID	This query allows personnel, upon input of a graduate faculty ID, to obtain a list of all graduate committee on which a faculty member has served. Some data goes back as far as December 2001.
Faculty	SIS_GRAD_INSTR_ADV_CRS_BY_PRF	This query returns a list of people from the instructor advisor table along with the courses they have been authorized to teach by user-selected course prefix. The list is filtered to exclude graduate faculty.
Faculty	DGP_GSC_SECURITY_ALL_NOTALL_PG	View a list of all users having the DGP or Grad Secretary security roles with an "ALL" row AND with explicit program rows in the program security table.
Faculty	SIS_GRAD_REP	List of committees on which a Graduate Representative has served and the attempted dates for the preliminary oral and final oral exams.
Faculty	SIS_GRADUATE_FAC_CMTEE_ROLES	Displays all committee memberships for graduate faculty in a prompted program.
Faculty	SIS_GRADUATE_FAC_BY_PROGRAM	List of active members of the Graduate Faculty by user selected program.
Faculty	SIS_GRADUATE_FAC_BY_PLAN	View a list of active members of the Graduate Faculty by user selected plan. (Typically best used for minor-type plans).
Faculty	SIS_GRADUATE_FAC_PGMS_BY_ID	View a list of programs assigned to a member of the Graduate Faculty by user selected employee ID.
Faculty	SIS_GRADUATE_FACULTY_LIST	List of all active members of the Graduate Faculty
Faculty	SIS_GRAD_TRANSFER_PENDING	Returns a list of students, prompted by academic program, with pending internal transfer credit.
Faculty	NC_GRAD_FACULTY_EDIT_BY_COL	Returns a list of all graduate level courses within a college that do not have an appropriate graduate faculty member teaching them.
GPOW	GRAD_HRS PASSED	Returns active graduate students for a prompted academic term and academic program. Shows students overall hours & graduation application status, to assist depts in determining students who are eligible to graduate and haven't submitted an application.
GPOW	SIS_GRAD_OUTSTANDING_PATENT_AG	Outstanding patent agreement (checklist item "GPATEN" not received, completed, or waived) for registered grads in current or future term by user-selected academic program.
GPOW	SIS_GRAD_STU_CMTEE_PUB	View a list for a prompted emplid for a GPOW committee member, of all students on which they serve as a member of their GPOW committee. Displays the student?s name, EMPLID, acad prog, acad plan, faculty role on committee, whether they have accepted membership on the committee, and if they approved the GPOW for the student. The last two columns (Degree Status and Degr Status Dt) are populated if the person was awarded a degree in the same academic plan.
GPOW	SIS_GRAD_POW_WORKLIST TILE_STAT	List of all pending or open items on a DGP?s Worklist Tile.
GPOW	SIS_GRAD_DR_RESID	Query allows the user to determine, for a doctoral student, at what term in the GPOW the student has met the requirements for residence credit.
GPOW	SIS_GRAD_ADVISOR_WITH_GPOW	For a user-selected current or future term & academic program, it returns a list of grads enrolled in that program, showing the overall status of their GPoW (approved, denied, etc.), along with the term first enrolled in the grad career. It also shows the name & ID of each student's advisor & includes a flag that shows if the chair, vice-chair, or co-chair has approved the GPoW.
GPOW	SIS_GRAD_ACTIVE_MULTIPLE_GPOW	Returns an alphabetized list of active grad students having more than one Graduate Plan of Work (GPoW) in the active program for a user-selected college code. Shows emplid, name, acad prog, acad plan, GPoW status, and GPoW status date.
GPOW	SIS_GRAD_CENSUS_ENR_WITH_GPOW	For a user-selected career, previous term, and academic program, it returns a list of grads enrolled as of census in that term and program, showing the overall status of their GPoW (approved, denied, etc.) and status date, along with the term first enrolled in the grad career. It also includes a flag that shows if the chair, vice-chair, or co-chair has approved the GPoW.
GPOW	SIS_GRAD_CMT_HISTORY	View a list of all members of a grad student's GPOW committee, including members who are no longer on the committee.
GPOW	SIS_GRAD_GPOW_STATUS	Returns a list of all students in a user selected academic program, and their graduate plan of work status.
GPOW	SIS_GRAD_GPW_GS_APRVL_PUB	View a list of all students in a program whose graduate POW has been either approved or denied by the Graduate School (uses a prompted starting date for search).
GPOW	SIS_GRAD_POW_WORKFLOW_HISTORY	View a complete Plan of Work workflow history for a student.
GPOW	SIS_GRAD_GPOW_NOT_APPRVD	List of all current active master's or doctoral students having more than 17 cumulative hours and Graduate Plan of Work not approved.
GPOW	SIS_GRAD_GPOW_NOT_APPRVD_PROG	List of all current master's or doctoral students active in the user-selected academic program having more than 17 cumulative hours and Graduate Plan of Work not approved.
GPOW	SIS_GRAD_GPOW_NOT_APPRVD_COLL	List of all current master's or doctoral students active in the user-selected academic college code having more than 17 cumulative hours and Graduate Plan of Work not approved.
Graduate Exams	SIS_GRAD_EXAM_STATUS_LIST	This query returns a list of active students with doctoral prelim, doctoral final, or masters final exam milestones; shows bio/demo type data plus complete status (i.e., conditional pass, unconditional pass, fail, blank, etc.) for a user-selected academic program and user-selected current or future term.
Graduate Exams	SIS_GRAD_EXAM_RPTS_PROG_STATUS	Returns list of students having a master exam milestone, a doctoral prelim exam milestone, or a doctoral final exam milestone (with milestone status and date attempted) for a user-selected academic program. Results also show the most recent acad program status (active, completed, LOA, etc).
Graduate Exams	SIS_GRAD_COND_PASS_6_MO	A list of all students who have a 6 month or older conditional pass for their MR final oral or DR preoral or final oral.
Graduate Exams	SIS_GRAD_COND_PASS_4_MO	A list of students for whom a conditional pass was entered (DR PREORAL, MR FINORAL or DR FINORAL) and the date of the exam is older than four months.
Graduate Exams	SIS_GRAD_PRELIM_PASS_BY_PROG	This query returns a list of doctoral students by user-selected academic program who passed their doctoral prelim exam (doctoral prelim milestone with either conditional pass or unconditional pass status) showing the latest "attempted date" from milestone attempt table.
Graduate Exams	SIS_GRAD_NO_PRELIM_6YRS_COLL	List of all current doctoral students in the user-selected academic college code who have not scheduled their prelim 6 or more years after they started.
Graduate Exams	SIS_GRAD_NO_PRELIM_6YRS_PROG	List of all current doctoral students in the user-selected academic program who have not scheduled their prelim 6 or more years after they started.
Graduation	SIS_GRAD_COMP_REV_THES_DISSERT	Returns list of grads with thesis or dissertation milestone (and milestone level of acceptance, review, or committee approval) for user-selected graduation term. Shows graduation checkout status.
Graduation	SIS_GRAD_MLSTN_CMPLT_NOGC	List of students who have completed all of their milestones but who are not on the Graduation Approval List.
Graduation	SIS_GRAD_GRADUATION_APRVL	View a list of students on the Graduation approval list for a prompted term and graduation approval status.
Graduation	SIS_GRAD_CHKLST_WRONG_DR_DRC	View a list of students on the graduation list who have a masters plan but a doctoral checklist and who have an application status of Approved, College Cleared, College Hold or Dept. Review Complete for a prompted term.
Graduation	SIS_GRAD_CHKLST_WRONG_MR_DRC	View a list of students on the graduation list who have a doctoral plan but a Masters checklist and who have an application status of Approved, College Cleared, College Hold or Dept. Review Complete for a prompted term.
Graduation	SIS_GRAD_CHKLST_CMPLT_NOGC	List of students who have completed all of their checklist items but who are not on the Graduation Approval List.
Graduation	SIS_GRAD_A2G_BELOW_B	Returns a list of all grads from a userselected program whose graduation checkout status = "applied to graduate" having any graduate classes with a grade lower than a B- (excludes AU, S, and TR).
Graduation	SIS_GRAD_A2G_ETD_CHECKLISTS	All applied to graduate (all stats except Dept Denied, College Denied, and app Withdrawn) for prompted term, showing status of their Graduate ETD checklist items (GDRCKM, GDRDAF, GDRGAL, GDRSED, GDRDPO).
Graduation	SIS_GRAD_THESIS_IN_REVIEW_PUB	View a list of all masters and doctoral students who appear on the graduation approval list for a prompted term, have an application status of College Cleared, College Hold, Complete ? Accepted or Departmental Review Complete, and who have submitted a thesis or dissertation that is still in ?Review? status.
Student Financials	SIS_GRAD_ALL_SVC_IND_TERM_PROG	Returns a list of students and their service indicator data (all service indicators) for a user-selected academic career, academic program, and active service indicator term. Shows academic program status.