Lexicon: UCSF Data Catalog

Lexicon is the UCSF data catalog, or metadata repository. The first release contains information on over 250,000 items, including:

Data Warehouses / Data Marts / Data Tables / Data Dictionaries

  • Campus Operational Data Store
  • Clarity
  • Clinical Data Warehouse
  • Decision Analytics Reporting Tool (DART)
  • Decision Support’s UCAll
  • Financial and Administrative Data Warehouse
  • Observational Medical Outcomes Partnership (OMOP)
  • Office of Population Health and Accountable Care (OPHAC) Data Warehouse
  • Student Information System Database
  • Qlikview data stores


  • HL7, API and ESB interfaces between applications

Measures / Metrics / Dimensions

  • Over 1,000 metrics displayed on dashboards

Reports / Dashboards

  • APeX Reports
  • Dashboards
  • Indirect Cost Recovery Reports
  • MyReports

Take Lexicon for a spin. (Please note that you must be on the UCSF network or using a UCSF VPN.)

Read the documentation.