Skip to content

UCOP IRAP Data Dictionary

UCB Student

The IRAP Online Data Dictionary provides a concise guide to understanding and using the University of California Data Warehouse (UCDW) data. The information is divided into the following three sections:

  1. Input File Definitions - The file specifications provides characteristics and layout of expected input data from UC campus locations. It defines the individual data fields, expected formats and constraints associated with each input record. Following these specifications is critical to the accurate processing of campus location data.
  2. Star-Schema Table Definitions - A star schema architecture is the data warehouse schema employed in the creation of the University of California Data Warehouse (UCDW). It is called a star schema because the layout of the tables resembles a star, with points radiating from a center. The center of the star consists of fact table and the points of the star are the dimension tables. The definitions lists all tables that are associated with a specific content area, e.g. degree. Each table represents where data collected from based on the input file specifications are stored. Each content area will be associated with multiple fact and dimension tables that are interconnected via table join constraints.
  3. Data Mart Table Definitions - Data marts are created as subset of the data contained within the data warehouse and are specifically created to meet a business need.