Summary
- Historical records of students (Term based information) joined with SAH-Demographics-View
- Current / most recent information about students.
- First recorded activities and information about students, such as students' first college, their first enrolled term, and their first major
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.
Fields | Folder | Note |
|---|---|---|
| Student Classification Code / Student Classification | Term Based Student | Some values include: FR, SO, JR, MA, D1, ... Freshman, Sophomore, ... |
| Registration Status / and Code | Term Based Student | Registration status per term Note: The difference between Enrolled and Registered is the payment. |
| Visa Type / Visa Type Code | Term Based Student | |
| Student Level | Term Based Student | |
| DFW Count Term | Term Based Measures | Count of student or class section where student received a grade of D, F or W value for the selected Term. Limited to Letter Grade Option only. |
| Permanent Address Home / Code / Region | Term Based Student Contact | |
| Admissions Term | Term Based Student | |
| Ethnicity EDI Broad / Narrow | Term Based Student | Top level of a two-level hierarchy for a person’s social group. Bottom and more detailed level of a two-level hierarchy for a person’s social group. |