Versions Compared

Old Version 1

changes.mady.by.user Saparnell

Saved on

compared with

New Version Current

changes.mady.by.user Saparnell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Hello SAH Developers - UAT has begun a day early so that we can migrated these enhancements to production prior to the Thanksgiving holiday. If you find an issue, please email busintel@ucsd.edu prior to end of day Tuesday, November 23 so we can address it before the Wednesday, November 24 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.

Table of Contents


Holiday Season

Given the upcoming holiday season, this will be the last SAH release for 2021.  We'll see you again in January 2022!

January 2022

With the addition of more Term, Term Cumulative and Current Cumulative fields we have identified that the original fields added to SAH would be easier to find if they were moved to the Current Cumulative Measures folder.

In January we will be moving the below Current Cumulative fields into the Current Cumulative Measures folder.  This will break Cognos reports using these fields.  There will be no impact to Tableau.

  • Advanced Placement (AP) Passed Units Current Cumulative
  • Education Abroad Program (EAP) Passed Units Current Cumulative
  • Grad UC Transfer Passed Units Current Cumulative
  • Graduate GPA Current Cumulative
  • International Bacccalaureate (IB) Passed Units Current Cumulative
  • Opportunities Abroad Program (OAP) Passed Units Current Cumulative
  • UG GPA Current Cumulative
  • UG UC Transfer Passed Units Current Cumulative
  • UG UC Transfer PNP Passed Units Current Cumulative


Your Requested Enhancements!

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


Ui expand
titleSAH-LMS-CBSubmissionEvent-Submission-View

SAH-LMS-

CB-Submission

SubmissionEvent-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-
2367
2391

Added the following fields:

  • Assignment Due At Date
  • Assignments Submitted Count
  • Assignments Submitted Delta Hours
  • Assignments Submitted Late Count
  • Assignments Submitted Late Course ID
  • Assignments Submitted Late Hours
  • Calendar Week End Date
  • Calendar Week Number
  • Calendar Week Start Date
  • Calendar Year Long
  • Calendar Year Number
  • Course Academic Term Code
  • Course Academic Term Week Number
  • Course Academic Week End Date
  • Course Academic Week Start Date
  • Course Academic Year Number
  • Course Is Major Term Count
  • Course Is Major Term Flag
  • Discussion Topics Count
  • Discussion Topics Graded Count
  • Discussion Topics Pending Review Count
  • Discussion Topics Submitted Count
  • Discussion Topics Unsubmitted Count
  • Is Assignment Late = field name will be changed to Last Assignment Flag in next release
  • Is Assignment Submission Late = field name will be changed to Last Assignment Submission Flag in next release
  • Is Submission Late= field name will be changed to Last Submission Flag in next release
  • Quiz Due At Date
  • Quiz Submission Due At Date
  • Quizzes Submitted Count
  • Quizzes Submitted Delta Hours
  • Quizzes Submitted Late Count
  • Quizzes Submitted Late Course ID
  • Quizzes Submitted Late Hours
  • SIS Linking ID
  • Submission Comments Count
  • Submission Count
  • Submission Due At Date
  • Submission Due At DateTime
  • Submission Published Score
  • Submission Score
  • Submission What If Score = only includes "graded" workflow state
  • Submissions What If Score = includes all workflow state
  • Submissions Delta Hours
  • Submissions Graded Count
  • Submissions Graded Score
  • Submissions Late Count
  • Submissions Late Course ID
  • Submissions Late Hours
  • Submissions Pending Review Count
  • Submissions Published Graded Score
  • Submissions Submitted Count
  • Submissions Unsubmitted Count
  • Submitted At Date
  • Quiz Submission Due At Date

Ui expand
titleSAH-Demographics-View et al

SAH-Demographics-View & SAH-Demographics-IR-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2329

Added the following fields:

  • College Attended Release Restriction
  • Current Academic Term Code
  • Date of Birth Release Restriction
  • Dates of Attendance Release Restriction
  • Degree honors Received Release Restriction
  • Degrees Received Release Restriction
  • Graduate Attempted Units Current Cumulative
  • Graduate Completed Units Current Cumulative
  • Graduate Grade Point Units Current Cumulative
  • Graduate Grade Points Current Cumulative
  • Graduate Passed Units Current Cumulative
  • International Directory Release Restriction
  • Major Release Restriction
  • Nat'l Student Clearing House Release Restriction = we are actively working to load this field so it may be empty for a few days during UAT
  • Next Academic Term Code
  • Officially Recognized Activities Release Restriction
  • Permanent Mailing Address Release Restriction
  • Permanent Telephone Release Restriction
  • Prior Fall Term Code
  • Prior Spring Term Code
  • Prior Winter Term Code
  • Student Classification First
  • Student Name Release Restriction
  • Student Personal Pronoun
  • UCSD Alumni or Development Release Restriction
  • UCSD Directory Release Restriction
  • UG Attempted Units Current Cumulative
  • UG Campus Email Release Restriction
  • UG Completed Units Current Cumulative
  • UG Current Address Release Restriction
  • UG Current Telephone Number Release Restriction
  • UG Grade Point Units Current Cumulative
  • UG Grade Points Current Cumulative
  • UG Passed Units Current Cumulative

These new fields will also be seen in the following views as they are joined with SAH-Demographics-View. See SAH Quick Start Guides for the full list of views.


Ui expand
titleSAH-StudentStatsPerTerm-View and SAH-StudentStatsPerTermCensus-View et al

SAH-StudentStatsPerTerm-View & SAH-StudentStatsPerTermCensus-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2355

Added the following fields:

  • Attempted Units Term
  • Attempted Units Term Cumulative
  • Completed Units Term
  • Completed Units Term Cumulative
  • GPA Term
  • GPA Term Cumulative
  • Grade Point Units Term
  • Grade Point Units Term Cumulative
  • Grade Points Term
  • Grade Points Term Cumulative
  • Passed Units Term
  • Passed Units Term Cumulative

These new fields will also be seen in the following views as they are joined with SAH-StudentStatsPerTerm-View or SAH-StudentStatsPerTermCensus-View.  See SAH Quick Start Guides for the full list of views.


Customer Service Reminder

Warning

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.


Follow our Enhancement Testing Steps

Tip
Use this UAT time to adjust your reports as needed prior to the Production release where your customers will be able to see any issues these enhancements cause. 
  • 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 Oracle 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?