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, September 19, end of day: release enhancements to User Acceptance Testing
Wednesday, September 24, UAT feedback due
Thursday, September 26, end of day: release enhancement to Production
Friday, September 27, end of day: delete QA models
Thank You Report Developers!
Special thanks to the report developers who submitted enhancement requests.
- Max Drenen
- Steven Newberg
- Aymme Olson
- SIS Reporting Project
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: - SAHR-1716Getting issue details... STATUS
Enhancements will address the following SNOW tickets: CS1892913, CS1657339, CS2021885, CS2076888, CS2192380
Added the following fields:
UG Accepted Admit Term Code
UG Accepted Applicant Type
UG Accepted Applicant Type Code
UG Cumulative Transfer Units Current
UG Cumulative Transfer Units First
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-3713Getting 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-3731Getting 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-3726Getting 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
Data in UAT is not ready to be shared with end customers, is not considered completely validated and can change suddenly. For optimal customer satisfaction, do not connect your production solutions to packages / data sources that are in UAT. If you choose to share UAT items with end customer, be explicit that the data and report is in UAT and can change suddenly or be broken by UAT changes.
A duty cycle has been implemented for Hana QA. During this time, Hana QA will not be available. Please schedule your UAT work around this duty cycle.
- Hana QA will not be available from 7pm-5am nightly
- Hana QA will not be available Saturday and Sunday
- Data loads will occur from 5am-10am on weekdays
Follow our Enhancement User Acceptance Testing (UAT) Steps
- Cognos: Use the packages in Cognos DEV > Student Activity Hub > Student Activity Hub Packages UAT to build your report and select Hana QA. Do not select Hana Prod as the report will fail. Using Hana QA will allow you to see the below enhancements with Production data.
- Tableau: Sign into Tableau on your Tableau desktop tool and open your report. Add a new data source with the same name and -QA at the end of the title. Using this data source will allow you to see the below enhancements with Production data.
- Hana QA: SAH data in Hana QA is production data loaded daily, just like in Hana PROD.
If you find an issue, please include in your email to busintel@ucsd.edu the following:
- What browser are you using?
- What environment are you using? Cognos DEV, QA or PROD? Or Tableau?
- What data source / package are you using?
- What results were you expecting?
Reminder: QA data sources will be deleted the Friday after the enhancements are migrated to Production.