Versions Compared

Old Version 3

changes.mady.by.user De Silva Jayasinghe, Kevin (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Saparnell

Saved on

Key

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

Table of Contents
indent9px

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.

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.



LevelKey (uniqueness / group by)Measures
1Student

Student PID

Tableau report developers: {FIXED[Student PID]:MIN([Field Name...])}

Measures in the following folders:

  • Current Cumulative Measures
  • Current Student Flag Measures
  • Current Student Measures
  • First Student Flag Measures
2TermStudent PID + Term ID

Measures in the following folders:

  • Term Based Measures
  • Term Based Student Flag Measures
  • Term Cumulative Measures


Folder

Fields

Note

Term Based Student Student Classification Code / Student Classification

Some values include:

FR, SO, JR, MA, D1, ...

Freshman, Sophomore, ...

Term Based StudentRegistration Status / and Code

Registration status per term

Note: The difference between Enrolled and Registered is the payment.

Term Based StudentVisa Type / Visa Type Code 
Term Based StudentStudent Level 
Term Based MeasuresDFW 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 ContactPermanent Address Home / Code / Region
Term Based StudentAdmissions Term
Term Based StudentEthnicity 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.


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.


Ui expand
titleExpected Null Values
  • Transfer students will always have a null student level for their transfer records, but once they have UCSD records those records will be populated.


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


Ui expand
titleMajor/Minor for each Term
  • This view shows primary / secondary major for each term all in one row but separate fields. Therefore there should only be one row per student per term:
Data SourceTerm CodeStudentPrimary MajorSecondary Major Primary MinorSecondary Minor 
SAH-StudentStudentsStatsPerTerm-ViewFA20Student 1Primary Major 1Secondary Major 1

SAH-StudentStudentsStatsPerTerm-ViewFA20Student 2Primary Major 1
Primary Minor 1