Current Funding for Graduate and Professional Students IDE

Last Updated
08/12/2022
Description

This Tableau workbook exports an Excel file listing currently active UW-Madison funding appointments held by graduate and professional students.

Report URL
https://tableau.wisconsin.edu/#/views/CurrentFundingforGraduateandProfessionalStudentsIDE_0/CurrentFundingforGraduateandProfessionalStudentsIDE?:iid=1
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/31071/versions/62464
Data Domain(s)
Employee Record, Student Record
Access Restrictions
Employee Record Data Internal, Student Record Data Restricted
Data Source Information
EPM, InfoAccess
Data View Information
Data come from the following views in the InfoAccess data warehouse and UW-Madison EPM: Stdnt Multiterm; Stdnt Plan Multiterm; Stdnt Subplan Multiterm; Stdnt Ethnic Reporting; Ps Uw Hr Curjob Vw; Ps Uw Fn Erddtx Vw.
Update Schedule
Data are refreshed nightly.
Responsible Office
Graduate School Office of Academic Analysis, Planning, & Assessment
Important Notes

The enrollment term filter returns all graduate and professional career students enrolled at the university in the selected term. The enrollment term filter is required, but all other filters are optional. Once a filter choice has been specified, other filters will automatically adjust to only display relevant selections. The data file produced by this query contains a separate row for each unique combination of student academic plan and funding appointment in the term.

Definitions

Name Functional Definition Data Domains
Campus ID

This is simply a unique student identifier (10 digits). It may occasionally change at the student's request. It is not the same as ID in the Student Information System (SIS) or ID in the Human Resources System (HRS).

Student Record
ID (SIS)

SIS personal identifier. It is also called a "student Empl ID." The ID will never be changed throughout the individual's relationship with the University. This is not the same as Campus ID. This is not the same as HR ID or the ID field from HRS or the Empl ID from HRS.

Student Record
ID (HRS)

A unique number assigned to each person in the Human Resource System.

Employee Record
Term

A period of instruction: Fall, Spring, or Summer.

University of Wisconsin - Madison
International Students

Non-immigrant visitors who come to the United States temporarily to take classes.

University of Wisconsin - Madison
Academic Plan

An area of study--such as a major, minor, or certificate--that is within an academic career.

Academic Planning, Student Record
Academic Subplan

An academic subplan distinguishes a strand of activity within an academic plan or type of major. Can be a named option or honors in a major.

Academic Planning, Student Record
Appointment

The action of an appointing authority to place a person in a position within the agency (UW-Madison) in accordance with the law and the Rules of the Administrator, Division of Merit Recruitment and Selection (DMRS). An appointment is effective when the employee reports for work or is in paid leave status on the agreed starting date and time.

Employee Record
UDDS

A UW System-wide, seven-character organizational code used to identify the Unit, Division, Department, Sub-department associated with a particular personnel, research, financial, or other activity or transaction.

University of Wisconsin - Madison
Department (UDDS)

A two-character numeric designation for each department (academic or budgetary) within a Division (UDDS). Department is the fourth and fifth characters of a UDDS.

University of Wisconsin - Madison
Job Code

A five-character code that identifies the employee's job classification/title. For University Staff and student hourly positions it's a numeric code. Unclassified positions have alpha-numeric codes.

Employee Record
Employee Record Number

Identifies each job at a particular point in time. For most employees, the number will be zero. Employees with multiple concurrent jobs will have a unique record number for each job, assigned sequentially based on date of hire for each job. For most employees, the number will be zero. Per UW policy,after a job ends, the employee record number will be reused for future jobs.

Employee Record
FTE (HRS)

Full time job equivalent. Calculated as the number of expected work hours per week divided by 40. In HRS, FTE has a value of .00025 if the true FTE is 0.

Employee Record
Account Code

A code assigned to classify each transaction on the general ledger (e.g., asset, liability, revenue, expense).

Finance
Pay Basis

Defines how compensation is structured. Values may be: Annual (A); Academic (C); Hourly (H); Lump (L); No Pay Basis (N); Summer Session (S); Summer Service (V).

Employee Record
Compensation Rate

The full-time annual pay rate, full-time academic-year pay rate or hourly pay rate.

Employee Record
Earnings Percent of Distribution

Denotes the percentage of 100% assigned to a combination code or funding for earnings.

Employee Record
Effective Date (HRS)

Date on which an action such as job, funding, or termination becomes effective.

Employee Record
Expected End Date (HRS)

Anticipated last day the employee will be in the job. Only applies for fixed-term positions.

Employee Record
Career (Academic Structure)

A broad grouping of students related to their degree objectives and admitting office. Used for tuition charges, awarding financial aid, grading scales and other operational functions.

Academic Planning, Student Record