| Table of Contents |
|---|
Summary
- This view
...
- is NOT
...
- joined with
...
- SAH-Demographics-
...
- View or SAH-StudentStudentsStatsPerTerm-View
...
Does NOT Includes:
- Current, Historical data
Key Fields:
Key Fields to use as filters:
Additional Notes:
...
- 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.
| 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. |
| Level | Key (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 | ||
|---|---|---|
| ||
|
...
|
| Ui expand | ||
|---|---|---|
| ||
|
...
Fields
...
Folder
...
Note
...
Application Decision - Admission
Application Decision Code - Admission
...
Admit Term ID - Admission
Admit Term Code - Admission
...
Applied Term ID - Admission
Applied Term Code - Admission
...
College Accepted - Admission
College Accepted Code - Admission
...
College Preferred - Admission /
College Code Preferred - Admission
...
Primary Major - Admission
Primary Major Code - Admission
...
Registration Status - Admission
Registration Status Code - Admission
...
Parent 1 Education Level - Admission
Parent 1 Education Level - Admission Code
...
Parent 2 Education Level - Admission
Parent 2 Education Level - Admission
...
Sex Assigned At Birth - Admission
Sex Assigned At Birth Code - Admission
...
Gender Identity - Admission
Gender Identity Code - Admission
...