Student Academic Record

The purpose of the document is to explain the features of the Student Academic Record query.


Student Academic Record
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • Individual student record for a selected student. The report includes current and past courses, grades and other academic indicators.

What answers can I find?

Reports available in this query:

  • For a particular student, what are his/her current courses in progress?
  • What are his/her past courses taken and grades earned?
  • How many cumulative credits has he/she earned, and what is his/her GPA?
  • What is his/her EMPLID and academic program, and is there a FERPA flag?
report_list_15
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:

Query_Parameters_15

Sample Report:
General Report

sample_report_General_Report

Notes:

Record of current and past terms of a student who has a record in the current term, in one of the two past terms or in one of the available future terms.

About the Query:
You will need to enter either a student's Campus Id

About the Data:
Extract Date is from the Stdnt Crse Roster Multiterm and the Retention Semester History dataviews

Data views used:

  • RETENTION COURSE HISTORY
  • RETENTION SEMESTER HISTORY
  • STDNT MULTITERM
  • STDNT PLAN MULTITERM
  • STDNT CRSE ROSTER MULTITERM
  • STDNT STUDY ABROAD
  • STDNT DIRECTORY MULTITERM
  • STDNT TIMETABLE MULTITERM

Search either the InfoAccess Data View page or the Enterprise Performance Management (EPM) Data Warehouse page for data definitions to the data views used in the Query Library.




Keywords:graduate,enrolled,current student,student record,current courses,past courses,grades,in progress,credits,GPA,program,FERPA Query Data Library   Doc ID:41682
Owner:Harriet A.Group:Query Library
Created:2014-07-07 16:28 CSTUpdated:2014-07-29 14:59 CST
Sites:Query Library
Feedback:  0   0