Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This view is joined with:

  • SAH-Demographics-View 

Includes:

Table of Contents

Summary

  • Current / most recent information about students

...

  • from SAH-Demographics-View
  • 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.

...

Fields

...

Folder

...

Note

...

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.

Note

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

RetentionCohort Category Only Current
RetentionCohort Group
Retention Flags
Flags about a student's years of progress, retention, and graduation
Retention Flag Measures
Student years of progress, retention, and graduation


Additional Notes

Ui expand
titleDropping Out/Graduating
  • The fields with current suffix will carry over the most recent values of those fields if a student graduates or drops out.