Versions Compared

Old Version 2

changes.mady.by.user De Silva Jayasinghe, Kevin (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user De Silva Jayasinghe, Kevin (Deactivated)

Saved on

Key

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

Table of Contents

Summary

  • This view is NOT
 joined
  • joined with
: 
  • SAH-Demographics-View View or SAH-StudentStudentsStatsPerTerm-View

Does NOT Includes:

  • Current, Historical data

Key Fields:

Key Fields to use as filters:

Fields

Folder

Note

Application ID - ApplicationApply UC ApplicationApplied Count - AdmissionSIS Application Flag MeasureApplicant Decision / Applicant Decision CodeTerm Based Students

Application Decision - Admission 

Application Decision Code - Admission

SIS Application

Admit Term ID - Admission

Admit Term Code - Admission

SIS Application

Applied Term ID - Admission

Applied Term Code - Admission

SIS Application

College Accepted - Admission

College Accepted Code - Admission

SIS Application

College Preferred - Admission /

College Code Preferred - Admission

SIS Application

Primary Major - Admission

Primary Major Code - Admission

SIS Application

Registration Status - Admission

Registration Status Code - Admission

SIS ApplicationStudent Level ID - AdmissionSIS ApplicationStudent PID - AdmissionSIS ApplicantStudent PID - AdmissionApply UC ApplicantFirst Choice Major / First Choice Major CodeFirst Choice UG MajorFirst Choice Major Department / First Choice Major Department CodeFirst Choice UG MajorSecond Choice Major / Second Choice Major CodeSecond Choice UG MajorSecond Choice Major Department / Second Choice Major Department CodeSecond Choice UG Major

Parent 1 Education Level - Admission 

Parent 1 Education Level - Admission Code

SIS Applicant

Parent 2 Education Level - Admission

Parent 2 Education Level - Admission

SIS Applicant

Sex Assigned At Birth - Admission

Sex Assigned At Birth Code - Admission

SIS ApplicantEthnicity EDI Broad - AdmissionSIS ApplicantEthnicity EDI Narrow - AdmissionSIS ApplicantGender Derived Code - AdmissionSIS Applicant

Gender Identity - Admission

Gender Identity Code - Admission

SIS ApplicantMilitary Status - AdmissionSIS ApplicantAHI Cleared CountApplication Flag MajorELWR Cleared CountApplication Flag MajorFirst Generation CountApplication Flag MajorIs Freshman Summer Program CountApplication Flag MajorWinter Alta Back To Fall CountApplication Flag MajorIGETC Certification FlagCurrent Student FlagsIGETC Certification CountCurrent Student Flag MeasuresIGETC Partial Certification FlagCurrent Student FlagsIGETC Partial Certification CountCurrent Student Flag Measures

Additional Notes:

  • All - Application fields come from ApplyUC which is for year 2016 and forward
  • All - Admission fields come from ISISAll 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.

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]).
In order to see the applicants' information including their applied majors, use "Application ID - Application" with the desired fields