New Students - Applied but may not be enrolled

SAH-APP views (restricted)

Student

New Students - Accepted Offer but may not be enrolled

SAH-Demographics-View (if for current term)

SAH-StudentStatsPerTerm-View (for future term)

Current Student

New Students - Have enrolled

SAH-Demographics-View (if for current term)

SAH-StudentStatsPerTerm-View (for future term)

SAH-Enrollment-View (for future term)

Term Based Student

TSS Student Number

All views

Current Student

Course ID, Transfer Entity

SAH-Enrollment-View

Current Students

SAH-Demographics-View

Current Student

Awarded Degree and Term 

SAH-Degree-View

Term Set - Awarded Term 

For Graduate and Undergraduate Students:

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

(Current and First Records)

All views

• 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

Third Awarded Major, Minor, Department, Division, Degree Type, Degree Group

SAH-Degree-View

Third Major Awarded / Third Minor Awarded

Looking for all majors and minors of students in one field 

SAH-MajorMinorNarrow-View

Term Based Program 

Looking for all Undergrad and grad majors of students in one field 

SAH-MajorMinorNarrow-View

Term Based Program 

Looking for Programs that are Self-Supporting

SAH-MajorMinorNarrow-View

Term Based Program Flags

Looking for Freshman Summer Program Flag

All Views

Current Student Flags

How to sort the records of students in a list report based on the enrolled terms

All Views

Use "Term ID" from a proper "Term Set" folder 

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

All Views

• For the most current status: Current Student folder

• For the first status: First Student folder

• For term based status: Term Based Student folder

All undergraduate major programs are state-supported - Therefore any self-supporting flags for undergrad students will always indicate "No" and 0 for any  self-supporting counts

All Views

Majors Minors Flags

"Primary Major Is Self-Supporting Flag" only applies to grad primary majors

All Views

Majors Minors Flags

Looking for the first enrolled term of students 

All Views

• "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

All Views

• 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.

Census Views

NA

CIP codes for minor programs are null in ISIS. 

All Views

• 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.

All Views

Student Current / Term Based Student

Want to only count / see the students who remain enrolled by the end of the term

SAH-Enrollment-View & SAH-EnrollmentCensus-View, 

Student Class Enrollment Status, Class Section Enrollment Flag

'Term Year' and 'Term Year (YYYY)' are both academic years

All Views

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"

SAH-Enrollment-View & SAH-EnrollmentCensus-View, 

NA

"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...])}

SAH-Demographics-View

All measures in the Current Student Flag Measures folder
All measures in the Current Student Measure folder

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%])}

SAH-Enrollment-View & SAH-EnrollmentCensus-View

NA

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).

SAH-Admission-View

SIS Application Flag Measures

How to get the total number of student who applied to UCSD: Applied Count = CountD(Application ID - Application)

SAH-Admission-View

Apply UC Application

The "DFW Count Term" is at the term level and "DFW Count" is at the course level.




These should not be used together with Course subject course. because they are at a different levels of details.

SAH-Enrollment-View & SAH-EnrollmentCensus-View

Term Based Measures

 The aggregation for 

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

 need to be set to max

SAH-Enrollment-View & SAH-EnrollmentCensus-View

Enrollment Measures

The lowest level of granularity in the following views/data sources is "Class Section ID"

SAH-Enrollment-View & SAH-EnrollmentCensus-View

NA

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

SAH-Enrollment-View & SAH-EnrollmentCensus-View

Enrollment Measures

The last enrolled term is the last term a student enrolled in a class - This would be based off of Classes

SAH-Enrollment-View & SAH-EnrollmentCensus-View

Enrollment Measures

Transferred and waitlisted student are not included in Enrollment Count

SAH-Enrollment-View & SAH-EnrollmentCensus-View

Enrollment Measures

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.  

All Views except for SAH-Admission-View

Term Set - Student Last Enrolled

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

All Views except for SAH-Admission-View

Current Transfer Flags

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 

All Views except for SAH-Admission-View

Student Scores / Term Cumulative Measures

Looking for the enrollment of the students for the upcoming term

• 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

"Registration Status" from the "Term Based Student" folder

Looking for the waitlisted students for the upcoming term and their position on the waitlist

SAH-Enrollment-View or SAH-EnrollmentCensus-View.

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

"Waitlist Position Current" from "Current Student" folder

"Last Enrolled Term Code" does NOT consider future terms. 

All Views except for SAH-Admission-View

Term Set - Student Last Enrolled

Use "Registration Status" in ('Registered', 'Enrolled') to see enrolled students for any term

All Views 

• 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.

SAH-Demographics-View

• 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

Enrollment Course

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

For the visitor students we expect to see null for their admit term. This is the logic of this field and is expected.

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

SAH-StudentStatsPerTerm-View

Term Based Student

Student Count

Class Section Enrollment Count

SAH-Enrollment-View / SAH-EnrollmentCensus-View

Enrollment Measures

Enrolled at End of Term Count

Enrolled at Census Date Count

SAH-Enrollment-View / SAH-EnrollmentCensus-View

Term Based Measures