Hello SAH Developers - The below enhancements are included in this month's SAH Release.

Keep up with our future enhancements here: SAH Bugs and Enhancements In Progress. 

For access to the Student Activity Hub (SAH) you must be pre-approved by the registrar's office.  Please reach out to them directly.

Schedule

• Thursday, November 16, end of day: release enhancements to User Acceptance Testing

• Extended UAT due to the Thanksgiving Holiday

• Thursday, November 30, end of day: release enhancement to Production

• Friday, December 1, end of day: delete QA models

Reminder

Due to the winter break there will be no SAH monthly release in December.  The next SAH monthly release will be January 2024.

Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests.

• Dave Garrison
• Robert Musial
• Jonathan Whitman
• SIS Reporting Project

Renaming and Deprecating

As we've adapted the AH views to your needs, we have found changing field names is painful for both report developers and our team due to the name change breaking reports, data integrations and packages / data sources.  In an effort to avoid this pain, we are going to introduce a new name change strategy. 

1. ITS-BIA will release new fields with the revised field name in the views that contain the field to be renamed, or where a view is to be renamed ITS-BIA will release as a new view the view with the revised name.

2. ITS-BIA will allow a transition period for report developers to repoint their reports at the new fields / views.

3. ITS-BIA will remove the data from the old fields / views and allow a second transition period.  This will not break the report but will highlight where the fields / views are still in use as they will become blank.

4. ITS-BIA will deprecate the fields / views.  Any reports the have not transitioned by this point will break.

We'll be using this strategy on the following items that require name changes. 

In the January 2024 release we will set the following fields to null:

• UG Cumulative Transfer Units First will be replaced by UG Cumulative Transfer Passed Units First and UG Capped Cumulative Transfer Passed Units First
• UG Cumulative Transfer Units Current will be replaced by UG Cumulative Transfer Passed Units Current and UG Capped Cumulative Transfer Passed Units Current
• UG Cumulative Transfer Units will be not be replaced.

This update is due to the identification that the UC Cumulative Transfer Units fields were not using an accurate title and were pointed at the UG CCC Self Reported Transfer Units in SIS, which one on is using in their reports.

UG Cumulative Transfer Passed Units is the sum of all reported Transfer Units.

UG Capped Cumulative Transfer Passed Units is capped at 105 Transfer Units for non-exam and non-UC credits. Students with a value of over 105 may have additional exam units, UC units or may have enrolled prior to the cap.

New View

SAH-TestScores-View

BIA and the /wiki/spaces/SAH/pages/18354378 are excited to release the SAH-TestScores-View for UAT.  This view contains all of the Test Scores saved to SIS from an application, for all students who have accepted their UCSD offer.  SAH-TestScores-View is pre-joined with SAH-Demographics and available as part of SAH Core views.  Per our standard release process this view will remain in UAT until our next standard release in January 2024.

Epic:  

Enhancements will address the following SNOW tickets: CS1651028 

Unique fields to this view include:

• ACT Composite
• ACT Date
• ACT Subscore English
• ACT Subscore Math
• ACT Subscore Reading
• ACT Subscore Science
• ACT Subscore Writing
• AP Art History Date
• AP Art History Score
• AP Art Studio Art 2D Design Date
• AP Art Studio Art 2D Design Score
• AP Art Studio Art 3D Design Date
• AP Art Studio Art 3D Design Score
• AP Art Studio Art Drawing Date
• AP Art Studio Art Drawing Score
• AP Biology Date
• AP Biology Score
• AP Calculus AB Date
• AP Calculus AB Score
• AP Calculus AB Subscore Date
• AP Calculus AB Subscore Score
• AP Calculus BC Date
• AP Calculus BC Score
• AP Chemistry Date
• AP Chemistry Score
• AP Chinese Language Culture Date
• AP Chinese Language Culture Score
• AP Computer Science A Date
• AP Computer Science A Score
• AP Computer Science B Date
• AP Computer Science B Score
• AP Economics Macro Date
• AP Economics Macro Score
• AP Economics Micro Date
• AP Economics Micro Score
• AP English Language Composition Date
• AP English Language Composition Score
• AP English Literature Date
• AP English Literature Score
• AP Environmental Science Date
• AP Environmental Science Score
• AP Europe History Date
• AP Europe History Score
• AP French Language Date
• AP French Language Score
• AP French Literature Date
• AP French Literature Score
• AP German Language Date
• AP German Language Score
• AP Government Politics Comparative Date
• AP Government Politics Comparative Score
• AP Human Geography Date
• AP Human Geography Score
• AP Italian Language Culture Date
• AP Italian Language Culture Score
• AP Japanese Language Culture Date
• AP Japanese Language Culture Score
• AP Latin Literature Date
• AP Latin Literature Score
• AP Latin Vergil Date
• AP Latin Vergil Score
• AP Music Theory Date
• AP Music Theory Score
• AP Physics 1 Date
• AP Physics 1 Score
• AP Physics 2 Date
• AP Physics 2 Score
• AP Physics Date
• AP Physics Engineering Mechanics Date
• AP Physics Engineering Mechanics Score
• AP Physics Mechanics Date
• AP Physics Mechanics Score
• AP Physics Score
• AP Psychology Date
• AP Psychology Score
• AP Research Date
• AP Research Score
• AP Seminar Date
• AP Seminar Score
• AP Spanish Language Date
• AP Spanish Language Score
• AP Spanish Literature Date
• AP Spanish Literature Score
• AP US History Date
• AP US History Score
• AP World History Date
• AP World History Score
• IELTS Date
• IELTS Listening Score
• IELTS Reading Score
• IELTS Speaking Score
• IELTS Test of Written English Score
• IELTS Total Score
• SAT Date
• SAT Subject Test Score Bio-E
• SAT Subject Test Score Bio-M
• SAT Subject Test Score Chemistry
• SAT Subject Test Score Chinese Listening
• SAT Subject Test Score French
• SAT Subject Test Score French Listening
• SAT Subject Test Score German
• SAT Subject Test Score German Listening
• SAT Subject Test Score Hebrew
• SAT Subject Test Score Italian
• SAT Subject Test Score Japanese Listening
• SAT Subject Test Score Korean Listening
• SAT Subject Test Score Latin
• SAT Subject Test Score Literature
• SAT Subject Test Score Math 2
• SAT Subject Test Score Physics
• SAT Subject Test Score Spanish
• SAT Subject Test Score Spanish Listening
• SAT Subject Test Score US History
• SAT Subject Test Score World History
• SAT Subscore Math
• SAT Subscore Reading
• SAT Subscore Writing
• SAT Total Score
• TOEFL IBT Date
• TOEFL IBT Listening Score
• TOEFL IBT Reading Score
• TOEFL IBT Speaking Score
• TOEFL IBT Test of Written English Score
• TOEFL IBT Total Score
• TOEFL PBT DATE
• TOEFL PBT Listening Score
• TOEFL PBT Reading Score
• TOEFL PBT Test of Written English Score
• TOEFL PBT Total Score
• TOEFL PBT Written Expression and Structure Score

Your Requested Enhancements!

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.

All Views Joined With SAH-Demographics-View

Epic:  

Enhancements will address the following SNOW tickets: CS1513190, CS1712941

Name correction - this will break any report using this field:

• International Baccalaureate (IB) Passed Units Current Cumulative was updated.  "Bacccalaureate" with three c's was updated to "Baccalaureate".
  

Added the following fields:

• Intended Graduation Term Code Current
• Intended Graduation Term Current
• Intended Graduation Term ID Current
• Intended Graduation Term Is Academic Count Current
• Intended Graduation Term Is Academic Flag Current
• Intended Graduation Term Qtr Current
• Intended Graduation Term Year (YYYY) Current
• Intended Graduation Term Year Current
• UG Capped Cumulative Transfer Passed Units Current
• UG Capped Cumulative Transfer Passed Units First
• UG Cumulative Transfer Passed Units Current
• UG Cumulative Transfer Passed Units First

Views that include SAH-Demographics fields:

• SAH-CollegeDetail-View
• SAH-Degree-View
• SAH-Demographics-IR-View
• SAH-Demographics-View
• SAH-EnrollmentCensus-View
• SAH-Enrollment-View
• SAH-Housing-View
• SAH-LMS-AssignmentEvents-View
• SAH-LMS-CB-ConversationMessages
• SAH-LMS-CB-DiscussionTopicEntry-View
• SAH-LMS-CB-GroupMembers-View
• SAH-LMS-CB-StudentCourseStatsPerTerm-View
• SAH-LMS-CB-StudentStatsPerTerm-View
• SAH-LMS-CB-StudentStatsPerWeek-View
• SAH-LMS-CB-Submission-View
• SAH-LMS-CB-WikiPage-View
• SAH-LMS-CourseEvents-View
• SAH-LMS-CourseStudentStatsPerTerm-View
• SAH-LMS-DiscussionEntryEvents-View
• SAH-LMS-DiscussionTopicEvents-View
• SAH-LMS-EnrollmentEvents-View
• SAH-LMS-ExternalToolEvents-View
• SAH-LMS-FileEvents-View
• SAH-LMS-GradingEvents-View
• SAH-LMS-GroupEvents-View
• SAH-LMS-QuizEvents-View
• SAH-LMS-SectionStudentStatsPerTerm-View
• SAH-LMS-StudentStatsPerDay-View
• SAH-LMS-StudentStatsPerTermNarrow-View
• SAH-LMS-Student-View
• SAH-LMS-SubmissionEvents-View
• SAH-LMS-WikiPageEvents-View
• SAH-MajorMinorDetail-View
• SAH-MajorMinorNarrowCensus-View
• SAH-MajorMinorNarrow-View
• SAH-MajorMinor-View
• SAH-PersonDataAudit-View
• SAH-RetentionCensus-View
• SAH-RetentionDetailCensus-View
• SAH-RetentionDetail-View
• SAH-Retention-View
• SAH-StudentHoldsNarrow-View
• SAH-StudentSchedule-View
• SAH-StudentStatsPerTermCensus-View
• SAH-StudentStatsPerTerm-View
• SAH-StudentWithdrawalNarrow-View
• SAH-TestScores-View
• SAH-WaitlistAudit-View

SAH-ClassComponentSchedule-View and SAH-ClassComponentScheduleCensus-View

Epic:  

Enhancements will address the following SNOW tickets: SIS Reporting Project

Added the following fields:

• Course Schedule of Classes Text

SAH-Enrollment-View and SAH-EnrollmentCensus-View

Epic:  

Enhancements will address the following SNOW tickets: SIS Reporting Project

Added the following fields:

• Course Schedule of Classes Text

SAH-StudentSchedule-View

Epic:  

Enhancements will address the following SNOW tickets:  SIS Reporting, CS1739173

The grain of the view was changed due to the addition of Degree and Program fields.

Added the following fields:

• Class Offering ID
• Class Offering Workload Type At Census
• Class Offering Workload Type Code At Census
• Course Schedule of Classes Text

SAH-WaitlistAudit-View

Epic:  

Enhancements will address the following SNOW tickets: SIS Reporting Project

Added the following fields:

• Course Schedule of Classes Text

UAT - Customer Service Reminder

Follow our Enhancement User Acceptance Testing (UAT) Steps