Navigate to Queries

1. MyPack Portal
2. ‘Student Information System’ homepage
3. Reporting Tools
4. Query Tools
5. Query Viewer
   • Search by Query Name
6. Select either HTML or EXCEL for the query. Both options will allow you to view the results of the query in your web browser
   • Choose EXCEL if you want to download the report

IN Grading Query

To find a listing of students/courses with incomplete (IN) grades in a specific term, search:

1. Query Name: RR_IN_GRADE_BASIS_BY_TERM
2. Term: Click on magnifying glass for Term and choose your preferred semester
3. Advisor ID (optional): enter ID number or click on the magnifying glass
   • Academic Advisor: search by Advisor ID number > click on the ID number > Click Look Up > click View Results
   • Name: click Advanced Lookup > search by Name > enter Last Name > click Look Up > click on the advisor’s name > click View Results
4. Student College (optional): click on the magnifying glass
   • Academic Program: search by college abbreviation > click Look Up > click View Results
5. Academic Plan (optional): select plan if interested in data from a particular concentration

IN Grading Query Definitions

Column Name	Definition
ID	Student ID Number
Career	UGRD = Undergraduate GRAD = Graduate AGI = Agricultural Institute
LN, FN	Student last name, first name
Term	Semester that was selected when the query was created
Student College	College that the student is currently enrolled
Total GPA	Cumulative NC State GPA
Subject	Course name abbreviation
Catalog	Course number
Section	Course section number
Grade Base	GRD = Graded SUS = S/U Credit Only
Official Grade	IN (Incomplete)
First Enrolled in Graded Cr	Date that the student enrolled in the course
Advisor Name	Student’s assigned academic advisor
Email	Student’s assigned academic advisor’s email address
Academic Plan	Major code
Plan Descr	Major name
Sub-Plan	Concentration code
Sub-Plan Type Descr	Concentration, if applicable
Email	Student’s NC State email address

Stop-out Data Query

List of students who were enrolled in 1 term and not enrolled in the following term.

1. Query Name: RR_STOP_OUT_DATA
2. Census Term Start: click on magnifying glass for Term and choose your preferred semester
3. Census Term (Not Enrolled): click on magnifying glass for the Term following the on selected in #2
4. Acad Prog: select college using abbreviation (CALS, COD, CED, etc)
5. Acad Plan (optional): select plan if interested in data from a particular concentration

Stop-Out Data Query Definition

Column Name	Definition
ID	Student ID Number
LN, FN	Student last and first name
Career	UGRD = Undergraduate GRAD = Graduate AGI = Agricultural Institute
Term	Census term start
Reg Enroll Stat	1 indicates that the student was enrolled
Acad Prog	College
Acad Plan	Major
Sub-Plan	Concentration, if applicable
BOT Level Dscr	Academic Level (Freshman, Sophomore, etc)
Gender	Male or Female
Eth Summary	Race
Acad Load Dscr	Course load (full-time, 3/4 time, etc)
Email	Email on file during Term 1
Stdng at End of Term	Good, suspended, warning
Acad Stdng Dscr End of Term	Good Standing , Suspended, Academic Warning
Total GPA End of Term	Cumulative NC State GPA
Wdraw Code End of Term	NWD = Did not Withdraw WDR = Withdrew
Term	If student withdrew from Census Term, it is listed (ex. 2218)
Reg Enroll Stat	If student withdrew from Census Term, W is listed
Advisor Hold – ADV	Currently enrolled student who has a term advertisement hold on their account
Active Term	Term in which the student has a term advisement hold
Units Total	Total number of credits completed
Units Remaining	Total number of credits needed to earn a degree

S/U Grading Query

To find a listing of students who have courses with S/U Grading, search:

1. Query Name: RR_SUS_GRADE_BASIS_BY_TERM
2. Term: click on magnifying glass for Term and choose your preferred semester
3. Advisor ID: enter ID number or click on the magnifying glass
   • Academic Advisor: search by Advisor ID number > click on the ID number > Click Look Up > click View Results
   • Name: click Advanced Lookup > search by Name > enter Last Name > click Look Up > click on the advisor’s name > click View Results
   • Student College: click on the magnifying glass
   • Academic Program: search by college abbreviation > click Look Up > click View Results

S/U Grading Query Definitions

Column Name	Definition
ID	Student ID Number
LN, FN	Student last and first names
Career	UGRD = Undergraduate GRAD = Graduate AGI = Agricultural Institute
Term	Semester that was selected when the query was created
Student College	College that the student is currently enrolled
Total GPA	Cumulative NC State GPA
Subject	Course name abbreviation
Catalog	Course number
Section	Course section number
Change to S/U Grade Base	Course is being evaluated as credit only (SUS)
Official Grade	Final grade in the course S = Received credit U = Did not receive credit
Change to SU Date	Date that the student changed the course to SU in MyPack Portal
First enrolled in Graded Cr	Date that the student officially enrolled in the course
Grade Base	Format of the course when student officially enrolled. GRD means that the course was Graded
Advisor name	Student’s assigned academic advisor
Email	Student’s assigned academic advisor’s email address
Acad Plan	Student’s major code
Plan Dscr	Student’s major name
Sub-Plan	Student’s concentration code, if applicable
Subplan TP Dscr	Concentration, if applicable
Email	Student’s NC State email address