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. 

Questions, comments and suggestions regarding this site can be forwarded via email to irap@ucop.edu. For specific questions about UC campus input file specifications, send an email to irapfilesubmission@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.

For all questions regarding UC campus input file specifications, send an email to irapfilesubmission@ucop.edu

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 175
Undergraduate Admissions 405
University Student Aid Program (USAP) 124

Recent File Specification Updates

Financial Aid FileBeginning with the January 2020 financial aid submission, UCOP is requesting the addition of two fields -SHIP Waiver and SHIP Term - in the demographic portion of the CSS Financial Support input (academic and summer) files. The SHIP Waiver (R290) will capture the dollar amount of the SHIP waiver award and the SHIP Term (R300) will capture all of the terms in the academic year when a student is enrolled in SHIP. The R300 field will be cumulative and a student enrolled in SHIP in all terms will have a value of FWS in the final academic year submission.

Details of changes made can be found in the ITLC letter transmitted to ITLC members and Campus Registrars.

 

Tableau

The Tableau QA, UAT and production servers are now at Tableau Server version 2019.2.3. To upgrade your Tableau Desktop installation to 2019.2.3, download the required version at https://www.tableau.com/support/releases

We 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 - Fall 3WK 2019-20
  • Degrees Awarded - Annual Degree 2018-19
  • Degree Data Mart - Annual Degree 2018-19
  • Enrollment Data Mart - Fall 3WK 2019-20
  • Financial Aid - November 2019 
  • Graduate Admissions - 2018 Annual File 
  • Student Enrollment - Fall 3WK 2019-20
  • Undergraduate Admissions - Fall, October 2019
  • Undergraduate Admissions Data Mart - Fall, October 2019