Skip to content

Welcome Message

Welcome to the UCOP Data Operations Hub! Questions, comments and suggestions regarding this site can be forwarded via email to irap@ucop.edu. 

 

New Common Chart of Accounts [CCoA]

The University of California is implementing a new chart of accounts across all locations. This affects all downstream systems that rely on financial data. Short-term and long-term retrofit work is ongoing for the Financial Aid [FAI] and Contracts and Grants [SPX] content areas.

Accessing the Tableau Validation Reports

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 any of these email addresses:

Data Releases

  • Undergraduate Admissions - June 2024
  • Undergraduate Admissions Data Mart - June 2024
  • Course Enrollment - Spring 3WK 2023-24
  • Student Enrollment - Spring 3WK 2023-24
  • Enrollment Data Mart - Spring 3WK 2023-24
  • Graduate Admissions - 2024 Annual File
  • Financial Aid - May 2024 
  • Degrees Awarded - Summer 2023
  • Degree Data Mart - Summer 2023
  • Contracts & Grants - 2nd Quarter - 2024

Enrichment Data Sources

PCSSC & File Transfer

If you are having trouble submitting a file through GoA, send a trouble ticket via email to ess-tickets@ucop.edu. See also the list of files, file names and accurate Go Anywhere directory paths.

Tableau

Both the Tableau UAT and production servers has been upgraded to 2023.3.5 successfully. You can now upgrade your desktop installation to version 2023.3. To download this specific desktop version, visit the Tableau Desktop Product Downloads & Release Notes.

 

Recent File Specification Updates

Financial Aid - Beginning with the January 2025 financial aid submission, UCOP is requesting the addition of two new fields in the demographic portion of the CSS Financial Support input file (academic and summer) files. Details of changes made can be found in the Letter transmitted to Financial Aid Directors and CIO Council members.

USAP File - Beginning with the November 2024 USAP submission, UCOP is requesting the addition of two new fields Student Aid Index (SAI) and Total Assets. Details of changes can be found in the USAP file specifications.

 

 

View history of letters and file specification changes

NOTICE: Required Campus Input File Lengths

File lengths for all subject areas (excluding Course Enrollment) must be strictly adhered to. Any files that do not meet the required record length will be rejected and the data will not be loaded. To see full file specifications for all subject areas and the requirements regarding field lengths, visit: https://data.ucop.edu/file-submissions/file-specifications.html.

If you have any questions, send an email to irapdatainfrastructure@ucop.edu or irap@ucop.edu. 

File  Byte Size
Degree Conferred 441
Student Enrollment 3WK (F,W, SP) 660
Student Enrollment EOT (F, W, SP) 660
Student Enrollment 3WK (summer)  660
Student Enrollment EOT (summer) 660
Course Enrollment 3WK, EOT (F, W, SP, S) N/A
Health Science Resident (fall only) 660
Graduate Admission 253
Student Financial Support 242
Undergraduate Admissions 450
University Student Aid Program (USAP) 167
Contracts & Grants [Award File] 842
Contracts & Grants [Proposal] 681