The SAH-StudentStatsPerTerm-View and SAH-StudentStatsPerTermCensus-View Quick Start Guide will soon be moving to the Service Now (SNOW) Knowledge Base Article (KBA) and can be found here: SAH-StudentStatsPerTerm-View & SAH-StudentsStatsPerTerm-View Quick Start Guide
Why?
- So you can provide feedback directly to BIA on the Quick Start Guide
- So all UC Campus' can use the Quick Start Guides
- To integrate Quick Start Guide feedback directly into BIA ticketing processes
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.
| Level | Key (uniqueness / group by) | Measures | |
|---|---|---|---|
| 1 | Student | Student PID Tableau report developers: {FIXED[Student PID]:MIN([Field Name...])} | Measures in the following folders:
|
| 2 | Term | Student PID + Term ID | Measures in the following folders:
|
Folder | Fields | Note |
|---|---|---|
| Term Based Student | Student Classification Code / Student Classification | Some values include: FR, SO, JR, MA, D1, ... Freshman, Sophomore, ... |
| Term Based Student | Registration Status / and Code | Registration status per term Note: The difference between Enrolled and Registered is the payment. |
| Term Based Student | Visa Type / Visa Type Code | |
| Term Based Student | Student Level | |
| Term Based Measures | DFW Count Term | 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. |
| Term Based Student Contact | Permanent Address Home / Code / Region | |
| Term Based Student | Admissions Term | |
| Term Based Student | Ethnicity EDI Broad / Narrow | 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. |