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

• Friday, January 19, end of day: release enhancements to User Acceptance Testing

• Wednesday, January 24, UAT feedback due

• Thursday, January 25, end of day: release enhancement to Production

• Friday, January 26, end of day: delete QA models

Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests.

• Max Delbono
• Dave Garrison
• Robert Musial
• SIS Reporting Project

Mail List Change

This month BIA will start migrating our mail lists out of Emma and into Google Groups.  Our goal is to improve our communication efficiency and allow you all to benefit from announcements made by source systems when relevant.  This will require us to manually add everyone from the current list to the new Google Group.  You will all receive a notification that you have been added.  If you are member of multiple BIA mail lists then you will be notified as you are added to each new one.  We apologize for the extra email notifications.

Using Google Groups you will still be able to leave and join our mail lists.  We will be adding instructions to our collab site.

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:   SAHE-3676 - Getting issue details... STATUS

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: CS1798624

Added the following fields:

• Graduate Admit Major

• Graduate Admit Major Code

• Graduate Admit Major Department

• Graduate Admit Major Department Code

• Graduate Admit Major Division

• Graduate Admit Major Division ID

• UG Admit Major

• UG Admit Major Code

• UG Admit Major Department

• UG Admit Major Department Code

• UG Admit Major Division

• UG Admit Major Division ID

Views that include SAH-Demographics fields:

• SAH-CollegeDetail-View
• SAH-Degree-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

All Views Joined With SAH-StudentStatsPerTerm-View

Epic:   SAHE-3713 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets: CS1752801

Added the following fields:

• Athlete Count
• Athlete Flag
• Mens Baseball Count
• Mens Baseball Flag
• Mens Basketball Count
• Mens Basketball Flag
• Mens Crew Count
• Mens Crew Flag
• Mens Cross Country Count
• Mens Cross Country Flag
• Mens Fencing Count
• Mens Fencing Flag
• Mens Golf Count
• Mens Golf Flag
• Mens Soccer Count
• Mens Soccer Flag
• Mens Swimming Count
• Mens Swimming Flag
• Mens Tennis Count
• Mens Tennis Flag
• Mens Track Count
• Mens Track Flag
• Mens Volleyball Count
• Mens Volleyball Flag
• Mens Water Polo Count
• Mens Water Polo Flag
• NCAA Recruitment Count
• NCAA Recruitment Flag
• Student Athletic Teams
• Womens Basketball Count
• Womens Basketball Flag
• Womens Crew Count
• Womens Crew Flag
• Womens Cross Country Count
• Womens Cross Country Flag
• Womens Fencing Count
• Womens Fencing Flag
• Womens Soccer Count
• Womens Soccer Flag
• Womens Softball Count
• Womens Softball Flag
• Womens Swimming Count
• Womens Swimming Flag
• Womens Tennis Count
• Womens Tennis Flag
• Womens Track Count
• Womens Track Flag
• Womens Volleyball Count
• Womens Volleyball Flag
• Womens Water Polo Count
• Womens Water Polo Flag

Views that include SAH-Demographics fields:

• SAH-Degree-View
• SAH-EnrollmentCensus-View
• SAH-Enrollment-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-RetentionDetailCensus-View
• SAH-RetentionDetail-View
• SAH-StudentSchedule-View
• SAH-StudentStatsPerTermCensus-View
• SAH-StudentStatsPerTerm-View
• SAH-StudentWithdrawalNarrow-View
• SAH-WaitlistAudit-View

SAH-Degree-View

Epic:   SAHE-3731 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets: SIS Reporting Project

Added the following fields:

• Award Application DateTime
• Degree Application College Advisor
• Degree Check Processed Count
• Degree Check Processed Flag
• Degree Rush Posting Count
• Degree Rush Posting Flag
• Primary Minor CIP 2 Digit
• Primary Minor CIP 4 Digit
• Primary Minor CIP 6 Digit
• Primary Minor CIP Description
• Primary Minor Department
• Primary Minor Department Code
• Primary Minor Division
• Primary Minor Division ID
• Secondary Minor CIP 2 Digit
• Secondary Minor CIP 4 Digit
• Secondary Minor CIP 6 Digit
• Secondary Minor CIP Description
• Secondary Minor Department
• Secondary Minor Department Code
• Secondary Minor Division
• Secondary Minor Division ID

SAH-Enrollment-View and SAH-EnrollmentCensus-View

Epic:   SAHE-3726 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets: CS1820654

Added the following fields:

• AIP Faculty Advisor First Name
• AIP Faculty Advisor Full Name
• AIP Faculty Advisor Email Address
• AIP Faculty Advisor Employee ID
• AIP Faculty Advisor Employee PPS ID
• AIP Faculty Advisor Home Department Name
• AIP Faculty Advisor ID
• AIP Faculty Advisor Identity Active Directory ID
• AIP Faculty Advisor Last Name
• AIP Faculty Advisor Middle Name
• AIP Faculty Advisor Occupational Subgroup
• AIP Faculty Advisor Occupational Subgroup Code
• AIP Faculty Advisor Rank
• AIP Faculty Advisor Title
• AIP Faculty Advisor Work Phone Number Current

UAT - Customer Service Reminder

Follow our Enhancement User Acceptance Testing (UAT) Steps