UCDW Support and Resources

The University of California Data Warehouse (UCDW) is an enterprise data warehouse that unifies and holds UC business information from several content areas in an organized and integrated manner. Data within UCDW 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.

UCDW 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.

UCDW Subject Areas

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

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

UCDW Testing and Data Validation

• Data Warehouse Testing
• Data Validation Framework

Training Materials

• Introduction to UCDW Star Schema and Data Marts
• Introduction to UCDW 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