2021-07-29 SAH Production Release Notes

Hello SAH Developers - The below enhancements are available for you SAH Production.  Reminder - Due to the Cognos upgrade, these enhancements will not be available in Cognos production until end of day July 30.

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.


Waitlist Added to SAH-Enrollment-View & SAH-EnrollmentCensus-View

The SAH-Enrollment-View and SAH-EnrollmentCensus-View now include Waitlist, Transfer and Enrollment records.  A new row has been added for students who are on the waitlist.  If you are reporting on a current term or future term, you may need to filter the waitlist students out if you only looking for enrolled students per class section.

If you are counting distinct PIDs in the SAH-Enrollment% Views then you will be impacted by this, your numbers will increase to included enrolled + waitlisted.  You will want to add a filter on Waitlist Flag = 'No'

If you are using Class Section Enrollment in SAH-Enrollment-View or SAH-EnrollmentCensus-View then you will not be impacted as waitlisted students are not considered enrolled.


Your Newest View!




Test Your Requested Enhancements!

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





Follow our Enhancement Testing 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:  FINAH data in Hana QA is production Oracle 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? 



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.