Data and Reports
Banner Data and Reports
iReport will continue to be available as UCR's report distribution and storage system. There will be new repositories, categories, and reports available for iReport users. View the list of available repositories, categories, and reports in iReport.
Student Data Query System (SDQS)
SDQS will continue to be available during and after the Banner implementation for departmental and college personnel, faculty, and staff directly involved in student academic advising.
SDQS "Criteria" and "Columns" tabs will be updated to accomodate changes in Banner data but will retain all of the current functionality as a secure, intuitive web interface that provides access to a query tool enabling users to send plain text targeted email communication to students on a variety of academic information.
UCR is using IBM Cognos to connect to the Banner Operationa Data Store, which refreshes nightly. Banner ODS is data from the Banner administrative system organized into a simplified format where users can execute operational and adhoc reports.
For go-live, access to Banner Cognos / ODS will be granted based on your role in Banner.
Staff and faculty who do not have access to Banner may also request access to Banner Cognos by submitting a Banner System Access request. Check "Banner Cognos" in the "Select Areas and/or Systems" section and choose the Banner Cognos Report Categories you need.
Access is granted based on a combination of job responsibilities, your organization, and/or your department.
Review the Banner Cognos Training document for information on how to connect to the test and production system and how to execute operational and adhoc reports.
If you would like hands-on training, email firstname.lastname@example.org and we will schedule a time with you after October 21. If there is enough interest, we will schedule labs in November.
Custom Data or Report Requests
Student Affairs Information Systems (SAIS) provides data and reports on students, provided the request meets applicable federal, state, and university privacy laws and policies.
- Complete and submit a Data/Report request in Workfront
- Workfront will send you an email alert confirming your request has been submitted. We review all requests to ensure they comply with the Family Educational Rights and Privacy Act (FERPA) and applicable University of California policies and State of California privacy laws. Please allow 2-3 business days to complete the review process.
- The Data Request Coordinator will notify you via email if your request is denied, to include why it was denied and suggest information to include if you resubmit your request. Approved requests take 7-10 days to process.
If this is your first time submitting a Data/Report request in Workfront, please review the Workfront Guide before submitting your request.
Non-UCR Affiliated Requests
If you're unaffiliated with UCR, we charge a $100 fee to process your request. Email the Data Request Coordinator and include the criteria and data fields needed. All files will be sent in excel format via UCR's secure file sharing system, iShare.
Reports and Statistics Available on the Web
Institutional Research maintains a variety of standard reports and statistics for the public. Visit their website for access to enrollment planning reports, head counts, degrees conferred, student/faculty workload, student (academic) profiles and more. Information for UC can also be found UCOP's Data Operations Hub.
Media Requests for Student Data
If you need student data that can be released to the public, direct your request to Institutional Research.
Banner Common Files
UCR IT groups can get data from Banner for local consumption. Go to Technical Resources section of the Training Resource page to review the Data Transmission Approach and list of available data.