/
SAH-RetentionDetail-View and SAH-RetentionDetailCensus-View Quick Start Guide

SAH-RetentionDetail-View and SAH-RetentionDetailCensus-View Quick Start Guide

Add yourself as a Watcher to this page to be automatically emailed with any changes to this page.

Critical Concepts

Pre-Joined Data

  • 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

Additional Notes

  • The fields with current suffix will carry over the most recent values of those fields if a student graduates or drops out.

Steps to Take

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.