Versions Compared

Old Version 6

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.


Warning

Due to the size of this release and some last moment name changes, ITS BIA is still updating the BI models and will release them to UAT as soon as we finish.  If you are expecting to see an updated view and do not, please check back later in the day.


Hello SAH Developers - The below enhancements are available for you in Hana QA now.  If you find an issue, please email busintel@ucsd.edu prior to end of day Wednesday, August 31 so we can address it before the Thursday, September 1 Production 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


Hana QA Duty Cycle: 7pm-5am Nightly

A duty cycle has been implemented for Hana QA.  During this time, Hana QA will not be available:

  • Hana QA will not be available from 7pm-5am nightly
  • Hana QA will not be available Saturday and Sunday
  • Data load will occur from 5am-10am weekdays

Please schedule your UAT work around this duty cycle.


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests. 

  • David Garrison
  • Bhavya Guntupalli
  • Patti Honda Nations
  • Rachael Lapidis
  • Elizabeth Perez
  • Janni Pedersen
  • Anthony Slay
  • Jonathan Whitman


Renaming and Deprecating

As we've adapted the SAH 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.

August Step 1&2 - Announcing that this field will be retired.

  • Instructor Name - will be replaced by Instructor Full Name.

August Step 2 3 - Field to be retired has been set to null.

  • Message Has Attachements - will be replaced by Message Has Attachments

Ui expand
title*Impacted Views and Column Groups

Impacted Views

  • SAH-InstructorAssignment-View
  • SAH-InstructorAssignmentCensus-View
  • SAH-LMS-CB-ConversationMessages-View

Impacted Column Groups

  • None



New View Going to Production September 29: SAH-StudentHoldsNarrow-View

BIA and the Registrar's Office are excited to  release a new view that will allow report building per student per hold.

Per our regular release for new views, SAH-StudentHoldNarrow-View will remain in UAT for an extended period and go to Production in our September release in order to provide additional UAT time.

Ui expand
titleSAH-StudentHoldsNarrow-View

SAH-StudentHoldsNarrow-View

Epic:  

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

Added the following fields:

  • All fields from SAH-Demographics-View

  • Hold Affects Admission Count

  • Hold Affects Admission Flag

  • Hold Affects Award of Degree Count

  • Hold Affects Award of Degree Flag

  • Hold Affects Financial Aid Count

  • Hold Affects Financial Aid Flag

  • Hold Affects Housing Count

  • Hold Affects Housing Flag

  • Hold Affects Payment Count

  • Hold Affects Payment Flag

  • Hold Affects Registration Count

  • Hold Affects Registration Flag

  • Hold Affects Transcript Count

  • Hold Affects Transcript Flag

  • Hold Code

  • Hold Deleted Count

  • Hold Deleted Date

  • Hold Deleted Flag

  • Hold Description

  • Hold End Date

  • Hold Placed Date

  • Hold Start Date

  • Hold Type

  • Hold Type Code



Your Requested Enhancements!

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


Ui expand
titleSAH-Enrollment-View and SAH-EnrollmentCensus-View

SAH-Enrollment-View and SAH-EnrollmentCensus-View

Epic:  

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

Enhancements will address the following SNOW tickets: SIS Reporting Project

Added the following fields:

  • Class Section Academic Dishonesty Allegation Count

  • Class Section Academic Dishonesty Allegation Flag

  • Class Section Academic Dishonesty Allegation Status

  • Class Section Activity Certified Count

  • Class Section Activity Certified Flag

  • Class Section Activity Certifier Employee ID

  • Class Section Activity Certifier Name

  • Class Section Activity Certifier Type

  • Class Section Activity Comment Text

  • Primary Instructor Email Address

  • Primary Instructor Full Name

  • Primary Instructor Middle Name



Ui expand
titleSAH-InstructorAssignment-View and SAH-InstructorAssignmentCensus-View

SAH-InstructorAssignment-View and SAH-InstructorAssignmentCensus-View

Epic:  

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

Enhancements will address the following SNOW tickets: SIS Reporting Project

Added the following fields:

  • Class Section Zero Enrolled Count

  • Class Section Zero Enrolled Flag

  • Instructor Email Address

  • Instructor Full Name

  • Instructor Middle Name



Ui expand
titleSAH-LMS-CB-Submission-View

SAH-LMS-CB-Submission-View

Epic:  

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

Enhancements will address the following SNOW tickets: CS1074837

Added the following fields:

  • Class Section Enrolled At End of Term Count

  • Class Section Enrolled At End of Term Flag

  • Class Section Grade

  • Class Section ID

  • User Role



Ui expand
titleAdded to all Views that include SAH-Demographics-View

Added to all Views that include SAH-Demographics-View

Epic:  

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

Enhancements will address the following SNOW tickets and Projects: SIS Reporting Project, IR Reporting Project, CS1008621, CS1160996, CS1172952, CS1155865

Added the following fields:

  • Academic Standing Hold Count Current

  • Academic Standing Hold Flag Current

  • Advising Hold Count Current

  • Advising Hold Flag Current

  • Clinical Resident First Enrolled Term

  • Clinical Resident First Enrolled Term All

  • Clinical Resident First Enrolled Term Code

  • Clinical Resident First Enrolled Term Code All

  • Clinical Resident First Enrolled Term ID

  • Clinical Resident First Enrolled Term ID All

  • Clinical Resident First Enrolled Term Qtr

  • Clinical Resident First Enrolled Term Qtr All

  • Clinical Resident First Enrolled Term Year

  • Clinical Resident First Enrolled Term Year (YYYY)

  • Clinical Resident First Enrolled Term Year (YYYY) All

  • Clinical Resident First Enrolled Term Year All

  • Clinical Resident Primary Degree Group Current

  • Clinical Resident Primary Degree Group First

  • Clinical Resident Primary Degree Level Current

  • Clinical Resident Primary Degree Level First

  • Clinical Resident Primary Degree Level ID Current

  • Clinical Resident Primary Degree Level ID First

  • Clinical Resident Primary Degree Type Code Current

  • Clinical Resident Primary Degree Type Code First

  • Clinical Resident Primary Degree Type Current

  • Clinical Resident Primary Degree Type First

  • Clinical Resident Primary Degree Type ID Current

  • Clinical Resident Primary Degree Type ID First

  • Clinical Resident Primary Degree Type Short Current

  • Clinical Resident Primary Degree Type Short First

  • Clinical Resident Primary Major CIP 2 Digit Current

  • Clinical Resident Primary Major CIP 2 Digit First

  • Clinical Resident Primary Major CIP 4 Digit Current

  • Clinical Resident Primary Major CIP 4 Digit First

  • Clinical Resident Primary Major CIP 6 Digit Current

  • Clinical Resident Primary Major CIP 6 Digit First

  • Clinical Resident Primary Major CIP Description Current

  • Clinical Resident Primary Major CIP Description First

  • Clinical Resident Primary Major Code Current

  • Clinical Resident Primary Major Code First

  • Clinical Resident Primary Major Current

  • Clinical Resident Primary Major Department Code Current

  • Clinical Resident Primary Major Department Code First

  • Clinical Resident Primary Major Department Current

  • Clinical Resident Primary Major Department First

  • Clinical Resident Primary Major Division Current

  • Clinical Resident Primary Major Division First

  • Clinical Resident Primary Major Division ID Current

  • Clinical Resident Primary Major Division ID First

  • Clinical Resident Primary Major First

  • Clinical Resident Primary Major Short Current

  • Clinical Resident Primary Major Short First

  • Current Term Code

  • Current Term ID

  • Did Not Advance To Candidacy Hold Count Current

  • Did Not Advance To Candidacy Hold Flag Current

  • Earl Warren College ADM Hold Count Current

  • Earl Warren College ADM Hold Flag Current

  • Earl Warren College Max Units Hold Count Current

  • Earl Warren College Max Units Hold Flag Current

  • Earl Warren College Minimum Hold Count Current

  • Earl Warren College Minimum Hold Flag Current

  • Earl Warren College Missing Fin Aid Documents Hold Count Current

  • Earl Warren College Missing Fin Aid Documents Hold Flag Current

  • Eleanor Roosevelt College ADM Hold Count Current

  • Eleanor Roosevelt College ADM Hold Flag Current

  • Eleanor Roosevelt College Fin Aid Hold Count Current

  • Eleanor Roosevelt College Fin Aid Hold Flag Current

  • Eleanor Roosevelt College Max Units Hold Count Current

  • Eleanor Roosevelt College Max Units Hold Flag Current

  • Eleanor Roosevelt College Minimum Hold Count Current

  • Eleanor Roosevelt College Minimum Hold Flag Current

  • Graduation Date Medical Latest

  • Graduation Date Pharmacy Latest

  • Housing Notice Hold Count Current

  • Housing Notice Hold Flag Current

  • Incoming Student Training Hold Count Current

  • Incoming Student Training Hold Flag Current

  • John Muir College ADM Hold Count Current

  • John Muir College ADM Hold Flag Current

  • John Muir College Max Units Hold Count Current

  • John Muir College Max Units Hold Flag Current

  • John Muir College Minimum Hold Count Current

  • John Muir College Minimum Hold Flag Current

  • Medical Admit Term

  • Medical Admit Term Code

  • Medical Admit Term ID

  • Medical Admit Term Qtr

  • Medical Admit Term Year

  • Medical Admit Term Year (YYYY)

  • Medical Attempted Units Current Cumulative

  • Medical Cohort Group

  • Medical Cohort Term

  • Medical Cohort Term Code

  • Medical Cohort Term ID

  • Medical Cohort Term Qtr

  • Medical Cohort Term Year

  • Medical Cohort Term Year (YYYY)

  • Medical Completed Units Current Cumulative

  • Medical First Enrolled Term

  • Medical First Enrolled Term All

  • Medical First Enrolled Term Code

  • Medical First Enrolled Term Code All

  • Medical First Enrolled Term ID

  • Medical First Enrolled Term ID All

  • Medical First Enrolled Term Qtr

  • Medical First Enrolled Term Qtr All

  • Medical First Enrolled Term Year

  • Medical First Enrolled Term Year (YYYY)

  • Medical First Enrolled Term Year (YYYY) All

  • Medical First Enrolled Term Year All

  • Medical GPA Current Cumulative

  • Medical Grade Point Units Current Cumulative

  • Medical Grade Points Current Cumulative

  • Medical Passed Units Current Cumulative

  • Medical Primary Degree Group Current

  • Medical Primary Degree Group First

  • Medical Primary Degree Level Current

  • Medical Primary Degree Level First

  • Medical Primary Degree Level ID Current

  • Medical Primary Degree Level ID First

  • Medical Primary Degree Type Code Current

  • Medical Primary Degree Type Code First

  • Medical Primary Degree Type Current

  • Medical Primary Degree Type First

  • Medical Primary Degree Type ID Current

  • Medical Primary Degree Type ID First

  • Medical Primary Degree Type Short Current

  • Medical Primary Degree Type Short First

  • Medical Primary Major CIP 2 Digit Current

  • Medical Primary Major CIP 2 Digit First

  • Medical Primary Major CIP 4 Digit Current

  • Medical Primary Major CIP 4 Digit First

  • Medical Primary Major CIP 6 Digit Current

  • Medical Primary Major CIP 6 Digit First

  • Medical Primary Major CIP Description Current

  • Medical Primary Major CIP Description First

  • Medical Primary Major Code Current

  • Medical Primary Major Code First

  • Medical Primary Major Current

  • Medical Primary Major Department Code Current

  • Medical Primary Major Department Code First

  • Medical Primary Major Department Current

  • Medical Primary Major Department First

  • Medical Primary Major Division Current

  • Medical Primary Major Division First

  • Medical Primary Major Division ID Current

  • Medical Primary Major Division ID First

  • Medical Primary Major First

  • Medical Primary Major Short Current

  • Medical Primary Major Short First

  • Parent 1 Email Address

  • Parent 2 Email Address

  • Pharmacy Admit Term

  • Pharmacy Admit Term Code

  • Pharmacy Admit Term ID

  • Pharmacy Admit Term Qtr

  • Pharmacy Admit Term Year

  • Pharmacy Admit Term Year (YYYY)

  • Pharmacy Attempted Units Current Cumulative

  • Pharmacy Cohort Group

  • Pharmacy Cohort Term

  • Pharmacy Cohort Term Code

  • Pharmacy Cohort Term ID

  • Pharmacy Cohort Term Qtr

  • Pharmacy Cohort Term Year

  • Pharmacy Cohort Term Year (YYYY)

  • Pharmacy Completed Units Current Cumulative

  • Pharmacy First Enrolled Term

  • Pharmacy First Enrolled Term All

  • Pharmacy First Enrolled Term Code

  • Pharmacy First Enrolled Term Code All

  • Pharmacy First Enrolled Term ID

  • Pharmacy First Enrolled Term ID All

  • Pharmacy First Enrolled Term Qtr

  • Pharmacy First Enrolled Term Qtr All

  • Pharmacy First Enrolled Term Year

  • Pharmacy First Enrolled Term Year (YYYY)

  • Pharmacy First Enrolled Term Year (YYYY) All

  • Pharmacy First Enrolled Term Year All

  • Pharmacy GPA Current Cumulative

  • Pharmacy Grade Point Units Current Cumulative

  • Pharmacy Grade Points Current Cumulative

  • Pharmacy Passed Units Current Cumulative

  • Pharmacy Primary Degree Group Current

  • Pharmacy Primary Degree Group First

  • Pharmacy Primary Degree Level Current

  • Pharmacy Primary Degree Level First

  • Pharmacy Primary Degree Level ID Current

  • Pharmacy Primary Degree Level ID First

  • Pharmacy Primary Degree Type Code Current

  • Pharmacy Primary Degree Type Code First

  • Pharmacy Primary Degree Type Current

  • Pharmacy Primary Degree Type First

  • Pharmacy Primary Degree Type ID Current

  • Pharmacy Primary Degree Type ID First

  • Pharmacy Primary Degree Type Short Current

  • Pharmacy Primary Degree Type Short First

  • Pharmacy Primary Major CIP 2 Digit Current

  • Pharmacy Primary Major CIP 2 Digit First

  • Pharmacy Primary Major CIP 4 Digit Current

  • Pharmacy Primary Major CIP 4 Digit First

  • Pharmacy Primary Major CIP 6 Digit Current

  • Pharmacy Primary Major CIP 6 Digit First

  • Pharmacy Primary Major CIP Description Current

  • Pharmacy Primary Major CIP Description First

  • Pharmacy Primary Major Code Current

  • Pharmacy Primary Major Code First

  • Pharmacy Primary Major Current

  • Pharmacy Primary Major Department Code Current

  • Pharmacy Primary Major Department Code First

  • Pharmacy Primary Major Department Current

  • Pharmacy Primary Major Department First

  • Pharmacy Primary Major Division Current

  • Pharmacy Primary Major Division First

  • Pharmacy Primary Major Division ID Current

  • Pharmacy Primary Major Division ID First

  • Pharmacy Primary Major First

  • Pharmacy Primary Major Short Current

  • Pharmacy Primary Major Short First

  • Registrar Hold Count Current

  • Registrar Hold Flag Current

  • Revelle College ADM Hold Count Current

  • Revelle College ADM Hold Flag Current

  • Revelle College Max Units Hold Count Current

  • Revelle College Max Units Hold Flag Current

  • Revelle College Minimum Hold Count Current

  • Revelle College Minimum Hold Flag Current

  • Seventh College ADM Hold Count Current

  • Seventh College ADM Hold Flag Current

  • Seventh College Max Units Hold Count Current

  • Seventh College Max Units Hold Flag Current

  • Seventh College Minimum Hold Count Current

  • Seventh College Minimum Hold Flag Current

  • Sixth College ADM Hold Count Current

  • Sixth College ADM Hold Flag Current

  • Sixth College Max Units Hold Count Current

  • Sixth College Max Units Hold Flag Current

  • Sixth College Minimum Hold Count Current

  • Sixth College Minimum Hold Flag Current

  • Student Active Hold Codes Future

  • Student Birth Date

  • Student Success Coaching Eligible Count

  • Student Success Coaching Eligible Flag

  • Student Suspension End Term Code Current

  • Student Suspension End Term ID Current

  • Thurgood Marshall College ADM Hold Count Current

  • Thurgood Marshall College ADM Hold Flag Current

  • Thurgood Marshall College Max Units Hold Count Current

  • Thurgood Marshall College Max Units Hold Flag Current

  • Thurgood Marshall College Minimum Hold Count Current

  • Thurgood Marshall College Minimum Hold Flag Current

  • UCSD First Time Clinical Resident Student Term

  • UCSD First Time Clinical Resident Student Term Code

  • UCSD First Time Clinical Resident Student Term ID

  • UCSD First Time Clinical Resident Student Term Qtr

  • UCSD First Time Clinical Resident Student Term Year

  • UCSD First Time Clinical Resident Student Term Year (YYYY)

  • UCSD First Time Medical Student Term

  • UCSD First Time Medical Student Term Code

  • UCSD First Time Medical Student Term ID

  • UCSD First Time Medical Student Term Qtr

  • UCSD First Time Medical Student Term Year

  • UCSD First Time Medical Student Term Year (YYYY)

  • UCSD First Time Pharmacy Student Term

  • UCSD First Time Pharmacy Student Term Code

  • UCSD First Time Pharmacy Student Term ID

  • UCSD First Time Pharmacy Student Term Qtr

  • UCSD First Time Pharmacy Student Term Year

  • UCSD First Time Pharmacy Student Term Year (YYYY)

  • UG Admin Missing Documents Hold Count Current

  • UG Admin Missing Documents Hold Flag Current

  • Village at Torrey Pines Hold Count Current

  • Village at Torrey Pines Hold Flag Current

  • We Are Tritons Hold Count Current

  • We Are Tritons Hold Flag Current

  • Written Off Hold Count Current

  • Written Off Hold Flag Current



Ui expand
titleAdded to all Views that include SAH-StudentStatsPerTerm-View and SAH-StudentStatsPerTermCensus-View

Added to all Views that include SAH-StudentStatsPerTerm-View and SAH-StudentStatsPerTermCensus-View

Epic:  

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

Enhancements will address the following SNOW tickets and Projects: SIS Reporting Project, CS0934113

Added the following fields:

  • Clinical Resident Primary Degree Group

  • Clinical Resident Primary Degree Level

  • Clinical Resident Primary Degree Level ID

  • Clinical Resident Primary Degree Type

  • Clinical Resident Primary Degree Type Code

  • Clinical Resident Primary Degree Type ID

  • Clinical Resident Primary Degree Type Short

  • Clinical Resident Primary Major

  • Clinical Resident Primary Major CIP 2 Digit

  • Clinical Resident Primary Major CIP 4 Digit

  • Clinical Resident Primary Major CIP 6 Digit

  • Clinical Resident Primary Major CIP Description

  • Clinical Resident Primary Major Code

  • Clinical Resident Primary Major Department

  • Clinical Resident Primary Major Department Code

  • Clinical Resident Primary Major Division

  • Clinical Resident Primary Major Division ID

  • Clinical Resident Primary Major Short

  • Medical Primary Degree Group

  • Medical Primary Degree Level

  • Medical Primary Degree Level ID

  • Medical Primary Degree Type

  • Medical Primary Degree Type Code

  • Medical Primary Degree Type ID

  • Medical Primary Degree Type Short

  • Medical Primary Major

  • Medical Primary Major CIP 2 Digit

  • Medical Primary Major CIP 4 Digit

  • Medical Primary Major CIP 6 Digit

  • Medical Primary Major CIP Description

  • Medical Primary Major Code

  • Medical Primary Major Department

  • Medical Primary Major Department Code

  • Medical Primary Major Division

  • Medical Primary Major Division ID

  • Medical Primary Major Short

  • Pharmacy Primary Degree Group

  • Pharmacy Primary Degree Level

  • Pharmacy Primary Degree Level ID

  • Pharmacy Primary Degree Type

  • Pharmacy Primary Degree Type Code

  • Pharmacy Primary Degree Type ID

  • Pharmacy Primary Degree Type Short

  • Pharmacy Primary Major

  • Pharmacy Primary Major CIP 2 Digit

  • Pharmacy Primary Major CIP 4 Digit

  • Pharmacy Primary Major CIP 6 Digit

  • Pharmacy Primary Major CIP Description

  • Pharmacy Primary Major Code

  • Pharmacy Primary Major Department

  • Pharmacy Primary Major Department Code

  • Pharmacy Primary Major Division

  • Pharmacy Primary Major Division ID

  • Pharmacy Primary Major Short

  • Student Provost Honors Term Count

  • Student Provost Honors Term Flag



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.


Warning

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 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 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?