SAH Core Views Quick Start Guides

SAH Core Views Quick Start Guides

 

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

This page assumes you have read SAH Quick Start Guides

Search the SAH Core Quick Start Guides:

Student Activity Hub Basics


  • Student information has been tracked in the 'Student Activity Hub' since the inception of ISIS.

  • Current fields show a student's most recent activities and information.

  • Term Based fields show a student's historical activities and information.

  • First Term fields show a student's first recorded activities and information.

  • Census views include student information from the first 3 weeks of the term.

  • Student Activity Hub will not match the STUREG Table for WI22 census date records, since the extract for that table has NOT been run for the correct census date for WI22. Student Activity Hub will continue to match the correct census dates.

Finding a Field Name


The Activity Hub Field List report can help you find the field you are looking for. You must be on the VPN to access this report.

Find the View You Need


In general, SAH-StudentStatsPerTerm-View or SAH-StudentStatsPerTermCensus-View are they best places to start.

Data Source Name

Description

Lowest Grain

Contains

Data Source Name

Description

Lowest Grain

Contains

Instructional Scheduling Assistant (ISA)

Not a SAH deliverable.  Available only in Cognos.



No Demographics (Current Term, First Term)

No Student Stats Per Term (Per Term)

SAH-Degree-View

Information about students who have graduated and those who have applied for graduation.

Student / Degree

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-Demographics-View

Only current term and first term data.  For students who are no longer at UCSD the current term is their most recent term.

Student

Yes Demographics (Current Term, First Term)

No Student Stats Per Term (Per Term)

SAH-Enrollment-View

Enrollment data through the end of each Term.  Includes Course, Class Section, Primary Instructor and Grade data.

Use this view only if you need course, class section or grade information.

Student / Term / 

Class Section

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-EnrollmentCensus-View

Enrollment data where updates stop at the Census date of each Term. Includes Course, Class Section, Primary Instructor and Grade data up to the Census date of each Term and only Registered/Enrolled Students.

Use this view only if you need course, class section or grade information.

Student / Term / 

Class Section

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term Census (Per Term)

SAH-MajorMinor-View

Major/minor change data through the end of each Term per Student.

Student / Term

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-MajorMinorDetails-View

Major/minor change data through the end of each Term per Student.

This view only includes students who have changed their major / minor and does not represent a full listing of students in a given major.

Student / Term / 

Program

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-MajorMinorNarrow-View

Major/minor change data through the end of each Term per Student.

Student / Term / 

Program

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-MajorMinorNarrowCensus-View

Major/minor data where updates stop at the Census date of each Term per Student.

Student / Term / 

Program

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term Census (Per Term)

SAH-Retention-View

Retention data through the end of each Term.

Student / Cohort

Yes Demographics (Current Term, First Term)

No Student Stats Per Term (Per Term)

SAH-RetentionCensus-View

Retention data where updates stop at the Census date of each Term.

Student / Cohort

Yes Demographics (Current Term, First Term)

No Student Stats Per Term (Per Term)

SAH-RetentionDetail-View

Retention detail data through the end of each Term.

Student / Term / 

Cohort

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-RetentionDetailCensus-View

Retention data where updates stop at the Census date of each Term.

Student / Term / 

Cohort

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term Census (Per Term)

SAH-StudentSchedule-View

Student schedule information down to the day, time and place.

Student / Term / 

Class Section / 

Class Section Meeting

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-StudentStatsPerTerm-View

Student data through the end of each Term.

Student / Term

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term (Per Term)

SAH-StudentStatsPerTermCensus-View

Student data where updates stop at the Census date of each Term.

Use this view as a starting point for your reports.

Student / Term

Yes Demographics (Current Term, First Term)

Yes Student Stats Per Term Census (Per Term)