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, Fellowship, Degree Planning, Graduate Exams, Graduation, Student Financials.

Graduate Forms

Category:

Search:

Acad Standing /Grading

Query Name	Description
SIS_GRAD_ACAD_STAND	For one student, shows all of the students academic standing actions along with the students current academic standing status.
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.
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

Query Name	Description
SIS_GRAD_COND_ADM_CHECK	Students in an academic organization who are currently enrolled but were provisional admissions
GRAD_TST_SCORE_SUPN_BDAY_TOEFL	This query is used to search by date of birth to find unmatched TOEFL scores
GRAD_TST_SCORE_SUPN_BDAY_GRE	This query is used to search by date of birth to find unmatched GRE scores
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.
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.
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.
SIS_GRAD_DEFR	View a list of students whose term of admission was deferred and the term deferred to.
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).
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
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 applicants most recent undergrad and grad institution

Degrees Conferred

Query Name	Description
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
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).
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.
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.
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 1990s.
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 1990s.
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.)
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

Query Name	Description
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.
SIS_GRAD_PROG_STATUS	Returns an alphabetic list of students for a user-selected academic program and academic program status.
SR_STUDENT_DROPS_AFTER_DATE_X	All students who dropped a course after a specific date.
SIS_GRAD_TERMINATED	View a list of graduate students who have been terminated from their program from start to end prompted terms.
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
SIS_GRAD_LOA	View a list of students currently on leave of absence for the user identified program.
SIS_GRAD_LEAV	Provides the name, emplID, and return term for students on Leave of Absence
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
SIS_GRAD_DISCONTINUED_BY_PROG	This query returns a list of grads with a "discontinued" program action by userselected academic program.
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 bachelors degree. The user enters their college code (11-20) to get the list by college.
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.
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.
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.
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)
SIS_GRAD_ACAD_STRUC_BY_PROGRAM	Active graduate academic plans, programs, and subplans with descriptions and subplan type by user-selected graduate program
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
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.
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.
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.
SIS_GRAD_NO_PRELIM_6YRS	List of all current doctoral students who have not scheduled their prelim 6 or more years after they started.
SIS_GRAD_NEW_ADMIT_TERM_BY_PGM	New graduate students (per admit term from program stack) for the current term by user-selected program.
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).
SIS_GRAD_CENSUS_ENROLLMENT	List of students registered as of census date in a user selected term.
SIS_GRAD_DE_FOR_STDNT	View all courses in which a student has been enrolled. Distance education courses are identified
SIS_GRAD_ENROLLED_FULBRIGHT	Returns a list of Fulbright students for a user-selected career, current or future term, and academic program.
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.
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.
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.
SIS_GRAD_STATUS	List of all current graduate students who are active in the user-selected academic program and their Plan of Work status.
SIS_NC_SUPEREXT_GRADS	List of students active in a current or future term.
SIS_GRAD_CNSS_ENRL_COLL	List of students registered as of census date in a user selected term and college
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

Query Name	Description
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

Query Name	Description
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

Query Name	Description
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.
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.
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.
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.
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.
SIS_GRADUATE_FAC_CMTEE_ROLES	Displays all committee memberships for graduate faculty in a prompted program.
SIS_GRADUATE_FAC_BY_PROGRAM	List of active members of the Graduate Faculty by user selected program.
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).
SIS_GRADUATE_FAC_PGMS_BY_ID	View a list of programs assigned to a member of the Graduate Faculty by user selected employee ID.
SIS_GRADUATE_FACULTY_LIST	List of all active members of the Graduate Faculty
SIS_GRAD_TRANSFER_PENDING	Returns a list of students, prompted by academic program, with pending internal transfer credit.
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.

Fellowship

Query Name	Description
NC_FA_FELLOWSHIP_BY_COLLEGE	List fellowships for selected college with start-end dates in selected academic year.
NC_FA_FELLOWSHIP_BY_DEPTID	List fellowships for selected Department ID OUC with start and end dates within the selected academic year.
NC_FA_FELLOWSHIP_BY_PROJECT	List fellowships for selected Project ID with start and end dates within the selected academic year.
NC_FA_FELLOWSHIP_BY_STUDENT	List fellowships for selected student as of a selected date.
NC_FA_FELLOWSHIP_BY_TERM	List active fellowships for selected term.
NC_FA_FSHP_PAY_BY_COLLEGE	For given college and academic-year, list fellowship payments and future payments for each student.
NC_FA_FSHP_PAY_BY_STU	List fellowship payments and future payments for selected student.

Degree Planning

Query Name	Description
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 havent submitted an application.
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.
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 students 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.
DEGREE_AUDIT_REPORT	Returns active graduate students for a prompted academic program and degree level (i.e. MR). Shows students' first term in the program, GPA, and a breakdown of the credit hours in their degree audit (units toward degree vs. non-degree). Note: "Non-degree" is referring to the 99-Additional Courses section at the bottom of the degree audit.
NC_GRAD_COMM_STATUS	Returns active graduate students for a prompted academic term and academic program and shows students' overall committee status. (Note: In the report, blank/no committee status means a committee hasn't been submitted for approval.)
SIS_GRAD_CMT_HISTORY	View a list of all members of a grad students GPOW committee, including members who are no longer on the committee.

Graduate Exams

Query Name	Description
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.
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).
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.
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.
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.
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.
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.
NC_LIAISON_GSR	List of students who have clicked the schedule exam button, but their exam hasnt been scheduled yet.

Graduation

Query Name	Description
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.
SIS_GRAD_MLSTN_CMPLT_NOGC	List of students who have completed all of their milestones but who are not on the Graduation Approval List.
SIS_GRAD_GRADUATION_APRVL	View a list of students on the Graduation approval list for a prompted term and graduation approval status.
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.
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.
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.
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).
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).
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.
NC_GRAD_COMPLETE_NO_GCO_PROG	Returns active graduate students for a prompted academic program and plan having a complete graduate degree audit but no application to graduate on file. Includes students email addresses.

Student Financials

Query Name	Description
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.