This view is NOT joined with:
- SAH-Demographics-View
- SAH-StudentStudentsStatsPerTerm-View
Does NOT Includes:
- Current, Historical data
Key Fields:
Key Fields to use as filters:
Fields | Folder | Note |
|---|---|---|
| Application ID - Application | Apply UC Application | |
| Applied Count - Admission | SIS Application Flag Measure | |
| Applicant Decision / Applicant Decision Code | Term 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 Application | |
| Student Level ID - Admission | SIS Application | |
| Student PID - Admission | SIS Applicant | |
| Student PID - Admission | Apply UC Applicant | |
| First Choice Major / First Choice Major Code | First Choice UG Major | |
| First Choice Major Department / First Choice Major Department Code | First Choice UG Major | |
| Second Choice Major / Second Choice Major Code | Second Choice UG Major | |
| Second Choice Major Department / Second Choice Major Department Code | Second 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 Applicant | |
| Ethnicity EDI Broad - Admission | SIS Applicant | |
| Ethnicity EDI Narrow - Admission | SIS Applicant | |
| Gender Derived Code - Admission | SIS Applicant | |
Gender Identity - Admission Gender Identity Code - Admission | SIS Applicant | |
| Military Status - Admission | SIS Applicant | |
| AHI Cleared Count | Application Flag Major | |
| ELWR Cleared Count | Application Flag Major | |
| First Generation Count | Application Flag Major | |
| Is Freshman Summer Program Count | Application Flag Major | |
| Winter Alta Back To Fall Count | Application Flag Major | |
| IGETC Certification Flag | Current Student Flags | |
| IGETC Certification Count | Current Student Flag Measures | |
| IGETC Partial Certification Flag | Current Student Flags | |
| IGETC Partial Certification Count | Current Student Flag Measures |
Additional Notes:
- All - Application fields come from ApplyUC which is for year 2016 and forward
- All - Admission fields come from ISIS
- If an applicant declines an offer or if an application has been declined / canceled then all Admission fields would be Null
- 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)
- 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