SAH-RetentionDetail-View and SAH-RetentionDetailCensus-View Quick Start Guide
- De Silva Jayasinghe, Kevin (Deactivated)
Summary
- Current / most recent information about students from SAH-Demographics-View
- Includes 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.
Folder | Fields | Note |
|---|---|---|
| Retention | Cohort Category | Only Current |
| Retention | Cohort Group | |
| Retention Flags | Flags about a student's years of progress, retention, and graduation | |
| Retention Flag Measures | Student years of progress, retention, and graduation | |
| Retention Detail Flags | Enrolled Flag | Yes, when student has Registration Status of Registered or Enrolled |
| Retention Detail Flags | Graduated Flag | |
| Retention Detail Flags | Progressed Flag | |
| Retention Detail Flags | Retained Flag | |
| Retention Detail Flags | Graduated or Retained Flag | |
| Term Set - RetentionDetail | Term, Term Code, Term ID, ... | A portion of time within a year where studies are performed. A term code could represent a starting or ending point when associated or applied to a particular Course, Wait-List, Academic Status, etc. Each term has a term code and a term ID which is a unique number associated with each term established in the system that's used to indicate the sequential order all terms relative to each other. |