SAH Core Views 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 2005.
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 |
---|---|---|---|
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. | 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. 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. | 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. | 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) |
Which Views to Use
Find the recommended views in these reporting scenarios:
|
|
|
|
---|---|---|---|
31 | Student Level Current | All views | Current Student |
32 | Awarded Degree and Term | SAH-Degree-View | Term Set - Awarded Term |
33 | Degree Reported Term | SAH-Degree-View | Term Set - Reported Term |
34 | For Graduate and Undergraduate Students: Primary and Secondary Major, Minor, Department, Division, Degree Type, Degree Group (Current and First Records) | All views |
|
35 | For Graduate and Undergraduate Students: Primary and Secondary Major, Minor, Department, Division, Degree Type, Degree Group (Historical) | All Views except for SAH-Demographics-View and SAH-Admission-View |
|
36 | Third Awarded Major, Minor, Department, Division, Degree Type, Degree Group | SAH-Degree-View | Third Major Awarded / Third Minor Awarded |
37 | Looking for all majors and minors of students in one field | SAH-MajorMinorNarrow-View | Term Based Program |
38 | Looking for all Undergrad and grad majors of students in one field | SAH-MajorMinorNarrow-View | Term Based Program |
39 | Looking for Programs that are Self-Supporting | SAH-MajorMinorNarrow-View | Term Based Program Flags |
40 | Looking for Freshman Summer Program Flag | All Views | Current Student Flags |
41 | 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 |
42 | The following fields include New, Continuing, Returning and Visitors:
The following fields exclude Summer Terms:
| All Views |
|
43 | 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 |
44 | "Primary Major Is Self-Supporting Flag" only applies to grad primary majors | All Views | Majors Minors Flags |
45 | Looking for the first enrolled term of students | All Views |
|
46 | Cumulative units fields should not be aggregated | All Views | |
47 |
|
|
|
48 |
| SAH-StudentStatsPerTerm-View, SAH-Degree-View, SAH-EnrollmentCensus-View, |
|
49 | 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 |
50 | CIP codes for minor programs are null in ISIS. | All Views |
|
51 | 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 |
52 | 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 |
53 | 'Term Year' and 'Term Year (YYYY)' are both academic years | All Views | |
54 | 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 |
55 | "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:
| SAH-Demographics-View | All measures in the Current Student Flag Measures folder All measures in the Current Student Measure folder |
56 | 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 |
57 | 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 |
58 | How to get the total number of student who applied to UCSD: Applied Count = CountD(Application ID - Application) | SAH-Admission-View | Apply UC Application |
59 | 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 |
60 | The aggregation for "Course Highest Grade Earned Points" | SAH-Enrollment-View & SAH-EnrollmentCensus-View | Enrollment Measures |
61 | The lowest level of granularity in the following views/data sources is "Class Section ID" | SAH-Enrollment-View & SAH-EnrollmentCensus-View | NA |
62 | The aggregation for "Class Section Enrollment Limit" should be set to max | SAH-Enrollment-View & SAH-EnrollmentCensus-View | Enrollment Measures |
63 | 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 |
64 | Transferred and waitlisted student are not included in Enrollment Count | SAH-Enrollment-View & SAH-EnrollmentCensus-View | Enrollment Measures |
65 | 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 |
66 | The followings are excluded from "UCSD UG Transfer Flag":
| All Views except for SAH-Admission-View | Current Transfer Flags |
67 | Total units passed from courses and exams transferred into UCSD from outside institutions:
| All Views except for SAH-Admission-View | Student Scores / Term Cumulative Measures |
68 | Looking for the enrollment of the students for the upcoming term |
| "Registration Status" from the "Term Based Student" folder |
69 | 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 |
70 | "Last Enrolled Term Code" does NOT consider future terms. | All Views except for SAH-Admission-View | Term Set - Student Last Enrolled |
71 | Use "Registration Status" in ('Registered', 'Enrolled') to see enrolled students for any term | All Views |
|
72 | 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. | SAH-Demographics-View |
|
73 | The following fields are sourced from EVC (Academic Affairs Information Services), and not ISIS:
|
| Enrollment Course |
74 | Right now, SAH provides the following information about Applicant Type:
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:
|
|
75 | 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:
|
|
76 | We also have the following fields related to identifying Transfer students:
| All views that are joined with the following views:
|
|
77 | 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. |
| |
78 | 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:
|
|
79 | Official UCSD admission = use UG Admit Term. First time registering = use UG First Enrolled Term | All views that are joined with the following views:
|
|
80 | If you want to only see current term code in your report, then you can filter the report for “Term Code” = “Current Term Code” or "Current Term Flag" = 'Yes' | All views that are joined with the following views:
|