Versions Compared

Old Version 3

changes.mady.by.user Saparnell

Saved on

compared with

New Version 4

changes.mady.by.user Saparnell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

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

Note

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


Ui expand
titleExpected Null Values
  • If an applicant declines an offer or if an application has been declined / canceled then all Admission fields would be Null.
  • Some Admissions fields are expected to be null prior to the Census date of the current term. Since some of the fields in this view come from the ThirdH tables, such as ethnicity and gender, there would be no values for those fields prior to the 3rd week of future terms. Instead the analysts can use that information from the applications (use - Application fields until ISIS / third week is populated).


Ui expand
titleTotal Number of Applications
  • To get the total number of application, use COUNTD([Application ID - Application]).