Scenario

Recommended Views

Folder

For Graduate and Undergraduate Students:

Primary and Secondary Major, Minor, Department, Division, Degree Type, Degree Group

(Current and First Records)

• Current Graduate Primary Major
• First Graduate Primary Major
• Current UG Primary Major
• Current UG Primary Minor
• Current UG Secondary Major
• Current UG Secondary Minor
• First UG Primary Major for All Terms
• First UG Primary Major
• First UG Primary Minor
• First UG Secondary Major
• First UG Secondary Minor

All Views except for SAH-Demographics-View and SAH-Admission-View

• Term Based Graduate Primary Major
• Term Based UG Primary Major
• Term Based UG Secondary Major
• Term Based UG Primary Minor
• Term Based UG Secondary Minor

The following fields include New, Continuing, Returning and Visitors:

• "Student Enrollment Type First"
• "Student Enrollment Type"
• "Student Enrollment Type Current"

The following fields exclude Summer Terms:

• "Student Enrollment Type" from Term Based Student folder

• For the most current status: Current Student folder
• For the first status: First Student folder
• For term based status: Term Based Student folder

Looking for the first enrolled term of students 

• "Term Set - UG First Enrolled For All Terms", and "Term Set - Grad First Enrolled For All Terms", include summer terms.
• "Term Set - UG First Enrolled", and "Term Set - Grad First Enrolled" exclude summers.

Cumulative units fields should not be aggregated

• Attempted Units are the number of units attempted to be completed by a student, and are at the course level.
• Attempted units Term are the total number of units on a student record during a given term.  Class Sections with a W (withdrawal notated on the transcript) are included. Class Sections dropped without a W are not included. Class Sections without a grade are not counted in ISIS.
• Attempted Units Current Cumulative are the total number of units on a student record, for the student level.

• SAH-Demographics-View
• SAH-Enrollment-View 
• SAH-EnrollmentCensus-View
• SAH-Degree-View
• SAH-RetentionDetail-View
• SAH-Student Stats Per Term-View

• Current Student Measures
• Enrollment Measure
• Degree Awarded Measures
• Retention Detail Measures
• Term Based Measures
• Term Cumulative Measures

• Completed Units: This value is the attempted units minus the W and I grades.
• Completed Units Term: For a term the Completed Units are the term attempted units less any W and I grades for that term.
• Completed Units Current Cumulative: are the number of cumulative attempted number of units on a student record, less any W and I grades.

SAH-StudentStatsPerTerm-View,

SAH-Degree-View,
SAH-Enrollment-View

SAH-EnrollmentCensus-View, 
SAH-RetentionDetail-View 

• Current Student Measures
• Enrollment Measure
• Degree Awarded Measures
• Retention Detail Measures
• Term Based Measures
• Term Cumulative Measures

The completed units are included in the census views once available as a courtesy to support analytic needs. 

It is presumed that analysts working with the data are aware of that grades / completed units are not available at the census date and are indeed end of term measures.

This is a design decision.

• Current UG Primary Minor
• Current UG Secondary Minor
• First UG Primary Minor
• First UG Secondary Minor

Some times "Student Classification" for some students in their first year is 'Sophomore' although their "Applicant Type" is 'New Freshman/High School', this is because some students have a lot of credits transferring from their high school that they are considered sophomore in their first year.

What is the difference between "W" and Null in grades?

If a student withdraw a course after census dates their grade is "W", but if they drop the course before the census dates, they don't have a grad at all and their grade is Null, or blank. In either case, Class Section Enrollment Status = "Drop" and Class Section Enrollment Flag = "No"

"Student PID" is the lowest level in Demographics view.

All the measures in "Current Student Flag Measures" and "Current Student Measure folder" folder need to be fixed at the the student level:

Tableau report developers: {FIXED[Student ID]:MIN([...Count...])}

The lowest level of granularity in the Enrollment & EnrollmentCensus views/data sources is "Class Section ID".

Tableau report developers: {FIXED[Student ID], [Class Section ID] : Aggregation([%Count%])}

Why the Applied Count is very close to admitted count in the Admission view?

The drop in Applied Count is a difference in the way data is imported into ISIS. Before ApplyUC, started in 2018 they would import all applications into ISIS. After ApplyUC, now they only import Admitted students into ISIS. Therefore there's a drop in APPLIED_COUNT in 2018 and forward. Applied Count is actually Applied and Admitted students after that point. Admitted Count is actually the number of students who actually came (some decide to go elsewhere after they are admitted).

"Course Highest Grade Earned Points"
"Course Highest Letter Grade Earned Points"

The aggregation for "Class Section Enrollment Limit" should be set to max

How long is a student still a student after their last enrolled term? 

If a student graduates in Winter or Spring s/he can take summer classes as a continuing student, but if s/he graduates in Fall s/he cannot.  

The followings are excluded from "UCSD UG Transfer Flag": 

• Summer student
• Visitors
• Employee applications
• Students who are not registered or enrolled at all or have a CF (Cancelled for Fees not paid) registration status code

Total units passed from courses and exams transferred into UCSD from outside institutions:

• UG Cumulative Transfer Units
• UG Cumulative Transfer Units Current 
• UG Cumulative Transfer Units First 

• SAH-Student Stats Per Term-View
• In general most views are joined with SAH-Student Stats Per Term-View and include term based information, except for SAH-Demographics-View and SAH-Admission-View

"Waitlist Flag Current" from the "Current Student Flags" folder

"Waitlist Position Current" from "Current Student" folder

• Term Based Students
• Current Students

Looking for current undergrad Athletes:

Since "registration status" filter has been removed from the logic of "Student Athletics Team Current", all the athletes are now coming through.



However the students who are already graduated should be filtered out. This can be done by setting the "Graduation Date UG Latest" to Null, if you are only looking for undergrad athletes.

• Current Students

The following fields are sourced from EVC (Academic Affairs Information Services), and not ISIS:

• Course Department
• Course Department Code
• Course Division

• SAH-Enrollment-View
• SAH-EnrollmentCensus-View
• SAH-InstructorAssignment-View
• SAH-instructorAssignmentCensus
• SAH-LMS-StudentStatsPerDay-View
• SAH-StudentSchedule-View

Right now, SAH provides the following information about Applicant Type:

• Applicant Type Code Current
• This field reflects the Applicant Type Code from the most recent student application.
• For example, when a student has been readmitted this value will be READ.
• Applicant Type Code First
• This field reflects the Applicant Type Code from the student’s first admission to UCSD.
• For example, the value in this field may be VIS if that is the value on their first application to attend UCSD.
• Applicant Type Code
• This is a term based field that will reflect the most recent acceptance application.
• This field would allow for a term by term review of accepted student applicant types for the student’s career at UCSD.

Important Note: There are very few cases where the student "Applicant Type Code First" is 'Vis' but the "Applicant Type Code Current" or "Applicant Type Code" might be 'READ' instead of 'TRAN' or 'ICT'. In this case if you have a filter to just look for TRAN or ICT, then you might miss those student.

All views that are joined with the following views:

• SAH-Demographics-View 
• SAH-Student Stats Per Term-View

• Current Student
• First Student
• Term Based Student

An ICT is an inter-campus transfer student. 

These are students that apply to UC San Diego who have matriculated at another UC campus (excluding extension) during a regular term prior to applying here and it is their last school of attendance. 

Students who have an applicant type of TRAN are transfer students whose last school of attendance is not a UC, but there is a possibility they attended another UC Campus before transferring to their current institution.

All views that are joined with the following views:

• SAH-Demographics-View 
• SAH-Student Stats Per Term-View

• Current Student
• First Student
• Term Based Student

We also have the following fields related to identifying Transfer students:

• UCSD UG Non-Transfer Flag / Count / Term %
• UCSD UG Transfer Flag / Count / Term %

All views that are joined with the following views:

• SAH-Demographics-View 
• SAH-Student Stats Per Term-View

• Current Student
• First Student
• Term Based Student

Attempted Units Term are a summarization at the end of the term and are sourced from Grade activities. Therefore since grades aren’t posted until the end of the term,  there aren’t records for  Attempted Units Term in the current term, yet.

However "Attempted Units" which is per student per class section, is available in the Enrollment view as well as for current term.

• SAH-Enrollment-View
• SAH-EnrollmentCensus-View

All views that are joined with the following views:

• SAH-Demographics-View 

• Term Set - UG Admit
• Term Set - Graduate Admit

Official UCSD admission = use UG Admit Term.  First time registering = use UG First Enrolled Term

All views that are joined with the following views:

• SAH-Demographics-View 

• UG Admit Term
• UG First Enrolled Term
• UG First Enrolled Term All

I want to see Enrollments for Future Terms

Note: Students must have enrolled in at least 1 class in the future term in order to be seen in SAH

Term Based Student

Student Count

Enrolled at End of Term Count

Enrolled at Census Date Count

Military Status Current - This is self-reported by the student and not verified

Parents Education Level Current

Gender Derived

Any more gender information is restricted.  Email ir@ucsd.edu for more information.

I want to use Ethnicity EDI Current and Term Based Fields

Any more detailed ethnicity information is restricted.  Email ir@ucsd.edu for more information.

I want to use the Freshman Summer Program Flag

I want to use the Athlete Current Flag

I want to use the International Current Flag

I want to use the First Generation Current Flag

The very first term a student was admitted to and later attended UCSD at the undergraduate level. Also know as UG Accepted Term.

Can included Fall, Winter, Spring or Summer terms.

For the Cohort: a portion of time within a year when academic studies are performed.

Undergrad non-transfers only. Fall only.

If you are looking for the status of a student registration for prior terms:

Use the desired "Term" along with "Registration Status" from "Term Based Student" folder.

Current fields show the student most recent records and activities. This doesn't necessary mean that the current fields refer to today.

Example:

If a student is graduated 5 years ago and their "Registration Status Current" is showing 'Registered', then this record refers to the status of their registration 5 years ago.

SAH-Demographics-View or any view pre-joined with SAH-Demographics-View

Current Student

All views that are joined with the following views:

• SAH-Demographics-View