SAH-Admission-View Quick Start Guide

Owned by De Silva Jayasinghe, Kevin (Deactivated)
Last updated: May 10, 2022

Summary

  • This view is NOT joined with SAH-Demographics-View or SAH-StudentStudentsStatsPerTerm-View
  • All fields ending with "Application" come from ApplyUC which is for year 2016 and forward
  • All fields ending with "Admission" come from SIS

Data Loads

Data is loaded nightly from oracle.  To see when the data completed being loaded by UCSD into SAH see this report:  Tableau > Public > AH Data Load Status Report

Granularity

Granularity is the scale or level of detail present in a set of data.  It identifies where levels of uniqueness exists in the data.  The data lives in the view at the lowest level, but each BI tool totals the levels differently.

Please note:  The Level of Detail (LOD) calculations listed here for Tableau developers are a baseline and do not necessary include all of the LOD equations needed for your report.


LevelKey (uniqueness / group by)Measures








Key Fields to View

  • Applicant Decision
  • Applicant Decision Date
  • Application Decision
  • Application Decision Date
  • Application Type

Key Fields to Filter on

  • Application Type

Additional Notes