Skip to main content

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
  • Enrollment
  • ETD
  • Faculty
  • GPOW
  • Graduate Exams
  • Graduation
  • GSSP/Student Financials
CategoryQuery NameDescription
Acad Standing /GradingSIS_GRAD_ACAD_STANDFor one student, shows all of the student?s academic standing actions along with the student?s current academic standing status.
Acad Standing /GradingSIS_GRAD_U_GRADES_PROGReturns 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 /GradingSIS_GRAD_GPA_DROP_PROGReturns active graduate students for a prompted academic term and academic program whose current GPA is >0.75 lower than their cumulative GPA.
AdmissionsSIS_GRAD_COND_ADM_CHECKStudents in an academic organization who are currently enrolled but were provisional admissions
AdmissionsGRAD_TST_SCORE_SUPN_BDAY_TOEFLThis query is used to search by date of birth to find unmatched TOEFL scores
AdmissionsGRAD_TST_SCORE_SUPN_BDAY_GREThis query is used to search by date of birth to find unmatched GRE scores
AdmissionsSIS_GRAD_APPL_HIST_TERM_PGMA 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.
AdmissionsSIS_GRAD_APPL_HIST_TERM_COLLA 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.
AdmissionsSIS_GRAD_APPL_HST_TERM_PGM_SCHThis 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.
AdmissionsSIS_GRAD_DEFRView a list of students whose term of admission was deferred and the term deferred to.
AdmissionsSIS_GRAD_APPL_WITH_GRE_SCORESA 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).
AdmissionsSIS_GRAD_PROVISIONAL_ADMITSProvides 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
AdmissionsSIS_GRAD_APPL_WITH_SCHOOLSCurrent 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 ConferredSIS_GRAD_GCERT_COMPLETEDReturns people who completed graduate certificate (GCERT academic program) for a user-selected completion term. Shows emplid, name, and academic plan
Degrees ConferredSIS_GRAD_DEGREES_WITH_CHAIRQuery 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 ConferredSIS_GRAD_DEGREES_BY_PROGReturns list of approved grads with graduate degrees conferred in graduate majors for all terms after fall 2008 by userselected academic program.
Degrees ConferredSIS_ALL_GRAD_DEGREES_BY_PROGReturns 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 ConferredSIS_ALL_GRAD_DEGREES_BY_COLLReturns 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 ConferredSIS_GRAD_DEGR_PROG_GPOW_TRMReturns 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 ConferredSIS_ALL_GRD_DEG_BY_PGM_W_TITLEUnion 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 ConferredSIS_GRAD_DEGR_BY_PROG_W_TITLESGraduation 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.)
EnrollmentSIS_GRAD_MR_EN_ROUTE_BY_PROGReturns a list of students in a user-selected academic program with GMOR (Grad Master On Route) program reason.
EnrollmentSIS_GRAD_PROG_STATUSReturns an alphabetic list of students for a user-selected academic program and
academic program status.
EnrollmentSR_STUDENT_DROPS_AFTER_DATE_XAll students who dropped a course after a specific date.
EnrollmentSIS_GRAD_TERMINATEDView a list of graduate students who have been terminated from their program from start to end prompted terms.
EnrollmentSIS_GRAD_PGM_PLAN_CHANGEList 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
EnrollmentSIS_GRAD_LOAView a list of students currently on leave of absence for the user identified program.
EnrollmentSIS_GRAD_LEAVProvides the name, emplID, and return term for students on Leave of Absence
EnrollmentSIS_GRAD_ENR_MLSTN_ACAD_LOADReturns 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
EnrollmentSIS_GRAD_DISCONTINUED_BY_PROGThis query returns a list of grads with a "discontinued" program action by userselected academic program.
EnrollmentSIS_GRAD_ACTIVE_WITH_PREV_BACHReturns 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.
EnrollmentSIS_GRAD_ACTIVE_BY_COLLEGEActive students (enrolled or eligible to be enrolled) with demographic information for a user-selected academic career, current or future enrolled term, and college code.
EnrollmentSIS_GRAD_3_PLUS_X_BY_COLLThis query returns active 3+X students by college and provides their home institution, current program and plan and term first enrolled.
EnrollmentSIS_GRAD_3_PLUS_XThis query returns active 3+X students and provides their home institution, current program and plan and term first enrolled.
EnrollmentSIS_GRAD_ACAD_STRUC_BY_COLLEGEActive graduate academic plans, programs, and subplans with descriptions and subplan type by user-selected two-digit college code (02, then 11-20)
EnrollmentSIS_GRAD_ACAD_STRUC_BY_PROGRAMActive graduate academic plans, programs, and subplans with descriptions and subplan type by user-selected graduate program
EnrollmentSIS_GRAD_LOW_GRADES_PROGReturns 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
EnrollmentSIS_GRAD_DR_AT_9PLUS_YRS_PROGList of all current doctoral students in the user-selected academic program who have been in the program 9 or more years.
EnrollmentSIS_GRAD_DR_AT_9PLUS_YRSList of all current doctoral students in the user-selected academic college who have been in the program 9 or more years.
EnrollmentSIS_GRAD_DR_AT_9PLUS_YRS_COLLList of all current doctoral students in the user-selected academic college who have been in the program 9 or more years.
EnrollmentSIS_GRAD_NO_PRELIM_6YRSList of all current doctoral students who have not scheduled their prelim 6 or more years after they started.
EnrollmentSIS_GRAD_NEW_ADMIT_TERM_BY_PGMNew graduate students (per admit term from program stack) for the current term by user-selected program.
EnrollmentSIS_GRAD_CENSUS_ENR_MINORReturns 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).
EnrollmentSIS_GRAD_CENSUS_ENROLLMENTList of students registered as of census date in a user selected term.
EnrollmentSIS_GRAD_DE_FOR_STDNTView all courses in which a student has been enrolled. Distance education courses are identified
EnrollmentSIS_GRAD_ENROLLED_FULBRIGHTReturns a list of Fulbright students for a
user-selected career, current or future
term, and academic program.
EnrollmentSIS_GRAD_PRELIM_SCHEDList 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.
EnrollmentSIS_GRAD_CERTIF_MINOR_PLANSList of all graduate students enrolled in current or future terms that are also enrolled in a minor or certificate in a userselected academic plan.
EnrollmentSIS_GRAD_PRELIM_SCHED_BY_PROGList 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.
EnrollmentSIS_GRAD_STATUSList of all current graduate students who are active in the user-selected academic program and their Plan of Work status.
EnrollmentSIS_NC_SUPEREXT_GRADSList of students active in a current or future term.
EnrollmentSIS_NC_SUPEREXT_BY_TERM_CAR_PGA list of students for a user-selected current or future term, career, and academic program.
ETDSIS_GRAD_COMPLETED_THESISA 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.
FacultyGRAD_ARCHIVE_COMM_SVC_BY_PGMGARS 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.
FacultyGRAD_ARCHIVE_COMM_SVC_BY_IDThis 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.
FacultySIS_GRAD_INSTR_ADV_CRS_BY_PRFThis 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.
FacultyDGP_GSC_SECURITY_ALL_NOTALL_PGView 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.
FacultySIS_GRAD_REPList of committees on which a Graduate Representative has served and the attempted dates for the preliminary oral and final oral exams.
FacultySIS_GRADUATE_FAC_CMTEE_ROLESDisplays all committee memberships for graduate faculty in a prompted program.
FacultySIS_GRADUATE_FAC_BY_PROGRAMList of active members of the Graduate Faculty by user selected program.
FacultySIS_GRADUATE_FAC_BY_PLANView a list of active members of the Graduate Faculty by user selected plan. (Typically best used for minor-type plans).
FacultySIS_GRADUATE_FAC_PGMS_BY_IDView a list of programs assigned to a member of the Graduate Faculty by user selected employee ID.
FacultySIS_GRADUATE_FACULTY_LISTList of all active members of the Graduate Faculty
GPOWSIS_GRAD_OUTSTANDING_PATENT_AGOutstanding patent agreement (checklist item "GPATEN" not received, completed, or waived) for registered grads in current or future term by user-selected academic program.
GPOWSIS_GRAD_STU_CMTEE_PUBView 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.
GPOWSIS_GRAD_POW_WORKLIST TILE_STATList of all pending or open items on a DGP?s Worklist Tile.
GPOWSIS_GRAD_DR_RESIDQuery allows the user to determine, for a doctoral student, at what term in the GPOW the student has met the requirements for residence credit.
GPOWSIS_GRAD_ADVISOR_WITH_GPOWFor 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.
GPOWSIS_GRAD_ACTIVE_MULTIPLE_GPOWReturns 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.
GPOWSIS_GRAD_CENSUS_ENR_WITH_GPOWFor 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.
GPOWSIS_GRAD_CMT_HISTORYView a list of all members of a grad student's GPOW committee, including members who are no longer on the committee.
GPOWSIS_GRAD_GPOW_STATUSReturns a list of all students in a user selected academic program, and their graduate plan of work status.
GPOWSIS_GRAD_GPW_GS_APRVL_PUBView 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).
GPOWSIS_GRAD_POW_ACAD_PROGList of all graduate Plans of Work with a status of open or pending for all students in that academic program.
GPOWSIS_GRAD_POW_WORKFLOW_HISTORYView a complete Plan of Work workflow history for a student.
GPOWSIS_GRAD_GPOW_NOT_APPRVDList of all current active master's or doctoral students having more than 17 cumulative hours and Graduate Plan of Work not approved.
GPOWSIS_GRAD_GPOW_NOT_APPRVD_PROGList 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.
GPOWSIS_GRAD_GPOW_NOT_APPRVD_COLLList 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 ExamsSIS_GRAD_EXAM_STATUS_LISTThis 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 ExamsSIS_GRAD_EXAM_RPTS_PROG_STATUSReturns 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 ExamsSIS_GRAD_COND_PASS_6_MOA 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 ExamsSIS_GRAD_COND_PASS_4_MOA 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 ExamsSIS_GRAD_PRELIM_PASS_BY_PROGThis 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 ExamsSIS_GRAD_NO_PRELIM_6YRS_COLLList 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 ExamsSIS_GRAD_NO_PRELIM_6YRS_PROGList of all current doctoral students in the user-selected academic program who have not scheduled their prelim 6 or more years after they started.
GraduationSIS_GRAD_COMP_REV_THES_DISSERTReturns 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.
GraduationSIS_GRAD_MLSTN_CMPLT_NOGCList of students who have completed all of their milestones but who are not on the Graduation Approval List.
GraduationSIS_GRAD_GRADUATION_APRVLView a list of students on the Graduation approval list for a prompted term and graduation approval status.
GraduationSIS_GRAD_CHKLST_WRONG_DR_DRCView 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.
GraduationSIS_GRAD_CHKLST_WRONG_MR_DRCView 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.
GraduationSIS_GRAD_CHKLST_CMPLT_NOGCList of students who have completed all of their checklist items but who are not on the Graduation Approval List.
GraduationSIS_GRAD_A2G_BELOW_BReturns 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).
GraduationSIS_GRAD_A2G_ETD_CHECKLISTSAll 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).
GraduationSIS_GRAD_THESIS_IN_REVIEW_PUBView 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.
GSSP/Student FinancialsUCO_SERVICE_IND_REASN_TERM_PGMReturns a list of students having a userselected Service Indicator reason code for a user-selected academic term and academic program.
GSSP/Student FinancialsSIS_GRAD_ALL_SVC_IND_TERM_PROGReturns 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.
GSSP/Student FinancialsGSSP_DEPT_APPRV_BY_PROG_TERMReturns all information from first tab on Graduate Tuition Support screen by user selected term and academic program (for students who are active in that program) where the departmental approval flag has been checked.
GSSP/Student FinancialsSIS_GRAD_GSSP_TERM_LMT_JOBSReturns a list of grads enrolled in userselected acad prog and term. Shows student id, name, prog, degree, prev master's flag, # of terms enrolled, whether or not student is within allowed # of GSSP terms (Within) or beyond (Beyond), and a flag to show if the person has either an active primary fellowship or an active assistantship with an annual rate of at least $8000.
GSSP/Student FinancialsSIS_GRAD_OVER_ENROLLEDReturns a list of degree-seeking grads
(masters & doctorate; non-GCERT) for a user-selected current or future term who are taking more hours than the minimum required hours for completion of their program. Results also show a 'Y' for any student who received GSSP
GSSP/Student FinancialsSIS_GRAD_DROPS_AFTER_DATE_GSSPThis query returns a list of graduate students, by user selected term and academic program, who dropped a course after a user-selected date (one row per person, per course dropped). It also shows the academic load and indicates those who received GSSP tuition and/or insurance benefits in the same term. The results from this query can be used to monitor students that drop out of GSSP eligibility because they have dropped or changed a course to audit after census (or a user selected date) causing them to drop below the full-time requirement.
GSSP/Student FinancialsGSSP_INS_SUMMERPREPAYSReturns a list of GSSP students flagged for summer health insurance coverage prepayment
GSSP/Student FinancialsGSSP_MTHLY_INSURANCEReturns a list of students in a selected term and month that were/are continuing, being dropped and added
EnrollmentSIS_GRAD_CNSS_ENRL_COLLList of students registered as of census date in a user selected term and college