UC-IRAP Support and Resources

The UCOP Institutional Research & Academic Planning data warehouse (UC-IRAP) is an enterprise data warehouse that unifies and holds UC business information from several content areas in an organized and integrated manner. Data within UC-IRAP is classified according to subject area and access is provided according to these content areas and agreed permissions.  It is envisioned that the creation of this data warehouse will make all the data constantly available for analyzing and planning purposes.

UC-IRAP uses specific abbreviations and naming conventions that are unique to its design. Access to the naming convention is available to UCOP staff only via this link.

UC-IRAP Subject Areas

All major student-related subject areas have been migrated into UC-IRAP. Subjects areas within the infrastructure include:

• Contracts & Grants
• Course Enrollment
• Student Enrollment
• Student Financial Support
• Degree
• Undergraduate Admissions
• Graduate Admissions

UC-IRAP Testing and Data Validation

• Data Warehouse Testing
• Data Validation Framework

Training Materials

• Introduction to UC-IRAP Star Schema and Data Marts
• Introduction to UC-IRAP Star Schema and Data Marts - Demonstration
• Business Rules - UC and IPEDS Ethnicity

Support Resources by Content Area

• Undergraduate Admissions (UCOP/UC Only)
  • Data Models (Star-Schema)
  • Data Dictionaries (Star-Schema)
  • Data Models & Data Dictionary (Data Mart)
  • Available Training Materials
• Student and Course Enrollment (UCOP Only)
  • Data Models (Staging)
  • Data Models (Base)
  • Data Models (BI)
  • Data Dictionary
  • Available Training Materials
    • Enrollment Star Schema Training Exercises
    • Enrollment Star Training - SQL
• Degree (UCOP Only)
  • Data Models (Staging)
  • Data Models (Base)
  • Data Models (BI)
  • Data Dictionary
• Student Financial Support (UCOP Only)
  • Data Models (Staging)
  • Data Models (Base)
  • Data Models (BI)
  • Data Dictionaries
  • Data Models and Data Dictionaries (Data Marts)
• Contracts and Grants (UCOP Only)
  • Stage, Base, BI & Data Mart Data Model Reports
  • Stage, Base, BI & Data Mart Data Dictionaries Reports

• Annual Wage/State Controller’s Office Submission (UCOP Only)
  • Data Models (Public Schema)
  • Data Models (Bi Schema)
  • Data Models (Staging Schema)
  • Data Dictionaries
• Payroll/Personnel (UCOP Only)
  • Data Models (Staging Schema)
  • Data Models (BI Schema)
  • Data Dictionaries
• Graduate Admissions (UCOP Only)
  • Data Models (Stage)
  • Data Models (Base)
  • Data Models (BI)
  • Data Dictionary (Star-Schema)
  • Data Model and Dictionary (Data Mart)
  • Available Training Materials
• UC Undergraduate Experience Survey (UCUES)
  • Data Dictionary
• Undergraduate Cost of Attendance Survey (UCOAS)
  • Data Dictionary
• Graduate Student Support Survey
  • Data Dictionary
• PhD Career Pathways Alumni Survey
  • Codebook
• UC Graduate Student Experience Survey (UCGSES)
  • Codebook
• Undergraduate Longitudinal Data (ULONG)
  • Data Dictionary