SSRS - Requesting Access

This document describes the process of asking for access to SSRS and who the request needs to come through.

Requesting access to a report or group of reports needs to come through the data owner for that folder.  Employees will need to work with their direct supervisor to determine the folder access they need.  The employee or supervisor will then need to contact the data owner of that folder.  Data owners are listed below for quick reference.  The data owner and registrar will approve or deny the request and then create an ITS ticket requesting access for the employee.  ITS then grants access to the employee for the folder request. 

Summary of the steps:

1.  Employee or Supervisor request access from the data owner.
2.  Data owner and Registrar will approve or deny request and if approved, will create an ITS ticket asking for access for the employee.
3.  ITS grants access after verifying the correct data owner made the request.


New employees will no longer be copied the SSRS access of the previous employee.  Supervisors will need to request the SSRS folder access in the new employee form that is filled out upon hiring.  The folder access should be entered in "Needs Access To" field in the new employee form.


Folder Data Owner Name of Data Owner
Admissions Registrar Danielle Seippel
Basic Ed Director of Precollege Programs Julie Pluemer
Billing Controller Kelly Kelly
BIS Business & Industry Manager Amy Charles
Budgets Controller Kelly Kelly
Career Connections Career Services Manager Heather Fifrick
Career Prep Career Prep Coordinator Mary Johannesen
Club Advisor Student Life Coordinator Robbin Hamel
College Advancement College Advancement Director Holly Clendenen
College Effectiveness Exec Director of College Effectiveness Barb Tucker
Data Team Data Team Chair Mandy Henkel
Deans & Admins Administrative Assistant Jody Millin
Financial Aid Financial Aid Manager CoraBeth Halverson
FTE Reports Controller Kelly Kelly
Health Human Patient Simulator Assistant Denise Janssen
Housing Resident Life Manager Stephanie Brown
Human Resources Human Resources Director Krista Weber
Knox Learning Center Academic Services Supervisor Melissa Klinkhammer
Master Salary Human Resources Director Krista Weber
Nursing Health Division Administrative Assistant Denise Janssen
Online Learning Flexible Learning Coordinator Beth Cummins
Prospects Registrar Danielle Seippel
PTA Physical Therapist Assistant Program Director Denise Janssen
Public Safety Public Safety Administrative Assistant Haylee Freymiller
Records Registrar Danielle Seippel
SAS Academic Services Supervisor Melissa Klinkhammer
State Reporting State Reporting and Curriculum Coordinator Lisa Riley
Workload Administrative Assistant Jody Millin



Keywords:ssrs,mrs,reports,access,data owner   Doc ID:91604
Owner:John T.Group:Southwest Wisconsin Technical College
Created:2019-05-07 10:15 CSTUpdated:2019-05-08 09:43 CST
Sites:Southwest Wisconsin Technical College
Feedback:  0   1