Skip to content

Welcome Message

Welcome to the UC Data Operations Hub! This site is aimed at providing information on the UC Data Warehouse (UCDW) and its components which include the UC Information Center website, Business Intelligence and Reporting and Data Validation process. 

All questions, comments and suggestions regarding this site can be forwarded via email to irap@ucop.edu.

NOTICE: Campus Input File Re-Submissions

The data being provided to UCOP for systemwide reporting from UC campuses must be validated for accuracy from both a content and format perspective prior to transmission to the systemwide office for processing. UCOP will be able to reload a file only if a subsequent file has not been applied to the data warehouse. If a subsequent file has been loaded into the warehouse, retracting the erroneous information will not be performed.

What's New?

  • The upgrade to the UC Report Center has been completed. If you have any problems gaining access to the Cognos reports, contact data.services@ucop.edu
  • All UCOP file transfers have been migrated off the old VSFTP.UCOP.EDU server and the process is now being handled using Go Anywhere [GoA] by PCSSC at UC Berkeley. For more information on the PCSSC at UCB, visit their website at https://pcssc.berkeley.edu/. If you are having trouble submitting a file, send a trouble ticket via email to UC-PCSSC-Tickets@Berkeley.edu. See also the list of files, file names and accurate Go Anywhere directory paths.
  • Traveling abroad? Check out the Security Awareness Toolkit for Travel Cybersecurity information by visiting the Systemwide Information Security webpage at: https://security.ucop.edu/.
  • Question on multi-factor authentication? Visit the Office of the President Multi-Factor Authentication webpage at: https://www.ucop.edu/information-technology-services/multifactor-authentication/.
  • IRAP now has a new database environment called the IRAP Digital Commons created specifically for the IRAP team to facilitate the creation of adhoc datasets based on University of California Data Warehouse (UCDW) production data in combination with externally sourced enrichment data. For more information, visit the database management page on the data dictionary website.

NOTICE: Required Campus Input File Lengths

File lengths must be strictly adhered to. Any files that do not meet the required record length will be rejected.

File  Byte Size
Degree Conferred 405
Student Enrollment 3WK (F,W, SP) 610
Student Enrollment EOT (F, W, SP) 610
Student Enrollment 3WK (summer)  610
Student Enrollment EOT (summer) 610
Course Enrollment 3WK, EOT (F, W, SP, S) N/A
Health Science Resident (fall only) 610
Graduate Admission 202
Student Financial Support 166
Undergraduate Admissions 405
University Student Aid Program (USAP) 124

Recent File Specification Updates

Degree File - Beginning with the September 2019 degree data submission, UCOP is including certain unit-related fields to both the annual degree data (due September 2019) and the summer degree data (due December 2019). Details of the changes made can be found in the ITLC letter transmitted to ITLC members and Campus Registrars.

Course Enrollment File - UCOP is requesting the addition of 2 new data elements to the Course Enrollment thrid week and end of term data submissions - Units Attempted Current Term Graded End of Term (equivalent to H420 on the Student Enrollment file) and a course flag. Details of the changes made can be found in the ITLC letter transmitted to ITLC members and Registrars.

Tableau

Both the Tableau QA and UAT servers have now been upgraded to Tableau Server version 2019.2.3. The production server upgrade is currently scheduled for 9/21/2019. Take the necessary steps to upgrade your Tableau Desktop installation to 2019.2.3 as soon as possible. To download the required version, visit https://www.tableau.com/support/releases

We now have the ability to use Tableau Prep for data preparation and profiling for free until 12/31/2020! For more information and to download Tableau Prep for free, visit: https://www.tableau.com/products/prep. Tableau has provided a registration key for UC for this tool. If you need assistance with the Tableau Prep key, please contact Diane.Lombardo@ucop.edu.

To leverage the UC systemwide Tableau license agreement, contact Thomas.Trappler@ucop.edu.

The UC Information Center

The UC Information Center website is open to the entire UC community and the general public. The site is continually being updated with new content as more data comes online and new participants join the collaborative effort. Find out more about the UC Information Center.

New on the Information Center

Data Releases

The following data is now available for reporting:

  • Course Enrollment - Winter EOT 2018-19
  • Degrees Awarded - Summer 2018
  • Degree Data Mart - Summer 2018 
  • Enrollment Data Mart - Fall 3WK 2018
  • Financial Aid - May 2019 
  • Graduate Admissions - 2018 Annual File 
  • Student Enrollment - Spring 3WK 2019 
  • Undergraduate Admissions - Winter, June 2019
  • Undergraduate Admissions Data Mart - Winter, June 2019