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

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

Student Financial Support File - Beginning with the October 2018 financial aid data submission, UCOP is expanding the length of some fields in the demographic and award portions of the CSS Financial Support input (academic and summer) files. Details of the changes made can be found in the ITLC letter transmitted to ITLC members and Financial Aid Directors.

Health Science Residents File - UCOP is requesting the addition of 2 new data elements to collect data for Specialty Type – Residents (H1004) and Hospital Affiliation Type (H1005) on the Health Sciences Residents file. In addition to this, data for the existing elements Hospital Category Code-Residents (H270) and Previous MD Degree School Code (H290) are no longer needed. These changes are effective for the Health Science Residents file due November 8, 2018. Details of the changes made can be found in the ITLC letter transmitted to ITLC members and Registrars.

Tableau

Make sure that the version of Tableau Desktop that you are running is 10.5. We are currently in the middle of server upgrades from 10.5 to 2018.1.3. All upgrades to QA, UAT and Production servers will be completed between 8/4/2018 and 8/10/2018. Visit http://www.tableau.com/support/esdalt to upgrade your installation accordingly when you receive the notice to do so.

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 - Spring 3WK 2018
  • Degrees Awarded -  Summer 2017 
  • Degree Data Mart - Summer 2017
  • Enrollment Data Mart - Fall 2017
  • Financial Aid - 2018 MAY
  • Graduate Admissions - 2017 Annual File
  • Student Enrollment - Spring 3WK 2018
  • Undergraduate Admissions - OCT file: Fall 2017 (Final)  
  • Undergraduate Admissions Data Mart - Fall 2017