Students Eligible for Tuition Remission

The purpose of the document is to explain the features of the Students Eligible for Tuition Remission query.


Students Eligible for Tuition Remission
  • File folder path: MADISON/Student/Graduate/Grad Assistants,Fellow, and Trainees
  • Query to be used by graduate coordinators in compiling a list of students eligible for tuition remission for a given Dept id, with output to be copied and pasted into the document found at http://www.bussvc.wisc.edu/bursar/RemissionForm.xls.

What answers can I find?

Reports available in this query:

  • Which of the graduate students currently working in my department are eligible for tuition remission this semester?
report_list_24
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:

Query_Parameters_24

Sample Report:
Table Employee Job-Student Information

sample_report_Table_Employee_Job-Student_Information

Notes:

About the Query
This query will be used by graduate coordinators in compiling a list of students eligible for tuition remission (for a given Deptid input). The output from this query could be used to copy and paste into the document found at http://www.bussvc.wisc.edu/bursar/RemissionForm.xls.

About the Data
This query is bringing back HRS job data using the following filters:
Business Unit = UWMSN
HR Status = A
Fte >= 0.33
Jobcode = Y21NN,Y26NN,Y30NN,Y33ND,Y33NN,Y41NN,Y41ND,Y42ND,Y42NN,Y43ND,Y43NN
Most current Action Not Equal to "SBK" (short work break).
Deptid (required input) uses a "begins with" condition.
Jobcode Description (optional input).

The report output titled "Table No PVI Match on ID Crosswalk Table" indicates there is an HRS Emplid record for a student, but a record matching the employee record to a student ISIS record cannot be found. The issue may reflect an international student where SSN is missing from their record.

The query is also finding student academic program and term information for the current and future terms for the list of employee records found.

Data views used:

  • PS UW HR ALLJOB VW
  • PS UW P NAMES VW
  • ID_CROSSWALK_UWMSN
  • STDNT_TERM_CODES
  • STDNT_PROGRAM_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,tuition,remission,bursar Query Data Library   Doc ID:41685
Owner:Ali K.Group:Query Library
Created:2014-07-07 21:02 CSTUpdated:2014-07-29 14:59 CST
Sites:Query Library
Feedback:  0   0