Student Assistant Enrollment Status for 8 Week Summer Session

The purpose of the document is to explain the features of the Student Assistant Enrollment Status for 8 Week Summer Session query.


Student Assistant Enrollment Status for 8 Week Summer Session
  • File folder path: MADISON/Student/Graduate/Grad Assistants,Fellow, and Trainees
  • Verifies enrollment and job status for SA titles Y26NN, Y21NN, Y41NN, and Y23NN. Query can be used to determine if students are enrolled for enough credits at the grad level to meet the student asst employment criteria.

What answers can I find?

Reports available in this query:

  • How many credits are the graduate assistants/fellows/trainees payrolled on my UDDS enrolled in?
  • Which ones are dissertators?
report_list_22
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:

Query_Parameters_22

Sample Report:
Sort by NAME Student Assistant Enrollment Credit Load Check

sample_report_Sort_by_NAME_Student_Assistant_Enrollment_Credit_Load_Check

Notes:

About the Query Criteria for Student Appointments: Deptid 8 Week Summer Session Job Code = Y21NN, Y23NN, Y26NN, Y41NN Retrieves current employees with an employee status of A (Active and P(Leave with Pay);

This query can be used to determine if a student assistant is enrolled for enough credits at the graduate level to meet the student assistant employment criteria.

About the Data All Fellow, Trainee, Advanced Opportunity Fellow and Research Assistant appointments of the selected UDDS are retrieved.

Eligible Credits - total credits for the 8-week summer session at the 300 level or above, minus audit courses.

Non-Dissertators must have a minimum of 2 credits and Dissertators a mimimum of 3 credits of Eligible Credits.

When the fields Unt Taken Prgrss, Grading Basis (we're looking for NCA or PF), and Status (looking for E to avoid dropped courses) from the ISIS student data are added to an Infoaccess data view, eligible credits will need to be re-evaluated.

Project/Program Assistants (PAs) and Teaching Assistants (TAs): Non-dissertators must enroll for at least 2 graduate-level credits during the fall and spring terms; dissertators for 3 graduate-level credits. The Graduate School has no enrollment requirement for the summer session, but individual departments/programs may, so students should contact their department/program if they are PAs in the summer.

Research Assistants (RAs), Fellows, Trainees: Non-dissertators must enroll for at least 8 graduate level credits during the fall and spring terms, and 2 graduate-level credits during the eight week summer session; dissertators must enroll for 3 graduate-level credits during the fall, spring and the eight-week summer session.

Courses numbered below 300, audits, and pass/fail do not satisfy any of the above enrollment requirements.

Schools, colleges, departments and programs may establish more stringent minimum enrollment criteria. International graduate students may have additional requirements.

Data is updated daily.

Data views used:

  • Stdnt Multiterm - Infoaccess
  • ID Crosswalk Uwmsn - Infoaccess
  • Stdnt Crse Roster Multiterm-Infoaccess
  • Ps Uw Hr Curjob Vw - HRS EPM
  • Ps Uw Hr Ns Per Vw - HRS EPM

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, enrollment, job status, SA, Y26NN, Y21NN, Y41NN, Y23NN, registration, udds, dissertator Query Data Library   Doc ID:41631
Owner:Meg S.Group:Query Library
Created:2014-07-07 12:20 CSTUpdated:2014-07-29 14:59 CST
Sites:Query Library
Feedback:  0   0