Link to University of Wisconsin-Madison home page


Repository for Administrative Data and Reports

Learning and Talent Development Training Audit

Last Updated

This workbook identifies individuals that have attended training in the OHR Registration System for help in reporting training for Learning and Talent Development courses

Report URL
Data Cookbook URL (requires authorization)
Data Domain(s)
Employee Record
Access Restrictions
Specific / Limited Audience
Data Source Information
HRS/EPM, InfoAccess, Other
Data View Information
Update Schedule
7am daily
Responsible Office
Learning and Talent Development
Important Notes

Explaining abbreviations:

LTD stands for Learning and Talent Development.

PSM stands for Principles of Management and Supervision.

Explaining tabs:

This workbook looks only at training data through the OHR Registration System. The student records are not included in the lists. No demographic information is added to the workbook.

This is the summary of data in different tabs:

- Training Population Comparison: This is all in one glance view to see various breakdowns of groups taking the courses. This tab has an aggregated percentage breakdown and whoever is considered a guest is also included. In other words, everyone who took the course is counted towards the aggregation.

- Training Attendance Historic List: Data showing time travel where historic employee record is tied to trainings.

- Courses Taken by Current Employee: Data shows all training together and links them to current employee data. 

- Supervisor Series Courses List: These series are setup differently than other courses and they are cohort-based and broken down into 'events'. That's why they cannot be mixed with other courses.


Name Functional Definition Data Domains
Business Email Address (HRS)

The email address designated by an employee in HRS and used by HRS for business purposes. At UW-Madison, this email address is synchronized with the DoIT primary email address. See Email Address (DoIT), Bus Email (HRS).

Employee Record
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
Division (UDDS)

A two-character numeric designation for each school/college or non-academic division within a Unit (UDDS). Division is the second and third characters of a UDDS.

University of Wisconsin - Madison
Employee Name (HRS)

The English format name for an employee entered in HRS. The name consists of Last Name, First Name and an optional Middle Initial.

Employee Record
Employment Class

A classification system used to group employees with common attributes; examples: FA = Faculty, SH = Student Hourly, CP = University Staff, etc.

Employee Record
Job Start Date

This is the start of a new Job Period.  

Employee Record
Job Title (HRS)

A unique description configured in HRS that corresponds to a job code.

Employee Record
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
Phone Person's phone number. Space
Reports To

Reporting to Managers' Position number
The position number to which this position reports.

Employee Record
Subdepartment (UDDS)

A two-character numeric designation for each subdepartment (primarily budgetary) within a Department (UDDS). Subdepartment is the sixth and seventh characters of a UDDS.

University of Wisconsin - Madison
Training (Canvas)

A specific module within Canvas for the delivery of information.

Employee Record
Training Completion Date

This is the date the training was completed.

Employee Record
Training Status

The level of progress for completing a training. The 3 levels are Completed (finished with a passing grade), Not Completed – (in progress, not yet completed, or completed but did not receive a passing grade), and Expired (completed beyond the expiration date).

Employee Record
Unit (UDDS)

A single letter representing each UW System institution (business unit). UW-Madison's unit designation is "A". Unit is the first character of a UDDS.

University of Wisconsin - Madison