Skip to content

Welcome Message

Welcome to the UC 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.

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 - October 2023
  • Undergraduate Admissions Data Mart - October 2023
  • Course Enrollment - Fall 3WK 2023-24
  • Student Enrollment - Fall 3WK 2023-24
  • Enrollment Data Mart - Fall 3WK 2023-24
  • Graduate Admissions - 2022 Annual File
  • Financial Aid - November 2023 
  • Degrees Awarded - Summer 2023
  • Degree Data Mart - Summer 2023
  • Contracts & Grants - 4th Quarter - 2023

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 2022.3.8 successfully. You can now upgrade your desktop installation to version 2022.3.8. To download this specific desktop version, visit the Tableau Desktop Product Downloads & Release Notes.

 

Recent File Specification Updates [ITLC]

Contracts & Grants File - Beginning with the file submission for Q1 FY 2023-24, UCOP is adding two new fields to the Contracts and Grants, award and proposal SPX file submissions. Details of changes made can be found in the ITLC letter transmitted to ITLC members and Contrants and Grants Data Stewards.

Student Enrollment File and Health Residents File - Beginning with the file submission of September of 2023, UCOP has requested the addition of one new field for 3WK and EOT input file. Details of changes can be found in the ITLC letter transmitted to Registrars and ITLC members.

Course Enrollment File - Beginning with the file submission of September of 2023, UCOP has requested the addition of one new field for 3WK and EOT input file. Details of changes can be found in the ITLC letter transmitted to Registrars and ITLC members.

Financial Aid File - Beginning with the file submission of October of 2023, UCOP has requested the addition of one new field, clarifying the definition of of an existing field in the demographic portion, and the addition of three new fields in the award portion of the CSS Financial Support input file (academic and summer). Details of changes can be found in the ITLC letter transmitted to Financial Aid Directors and ITLC members.

 

View history of ITLC 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) 149
Contracts & Grants [Award File] 842
Contracts & Grants [Proposal] 681