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 - The below enhancements are available for you in UAT for this week.  If you find an issue, please email busintel@ucsd.edu right away with the subject line “SAH UAT due July 28” so we can address it prior to the 3pm release to Production on Thursday, July 29.  Enhancements to SAH are always released to UAT on the third Thursday of each month.

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.

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.

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? 

Table of Contents


Provide Feedback on our Newest View!


Ui expand
titleSAH-StudentSchedule-View

SAH-

StudentClassSchedule

StudentSchedule-View

Epic:  SAHMAINT-1437

This view is designed to provide insights into the Class Components within each Class Section.  This view is Student centric and therefore if a student is not enrolled in the class section then you will not see that class section in this view.  Please notes that BIA is working on SAH-ScheduleOfClasses-View that will include all class sections regardless of student enrollment.

This view includes all fields from SAH-Demographics-View and SAH-StudentStatsPerTerm-View plus some of the fields from SAH-Enrollment-View.  Unique fields for this view are listed here:

  • Applicant Decision Code First
  • Applicant Decision First
  • Building Area
  • Building Area Code
  • Building Code
  • Building Name Full
  • Building Type
  • Building Type Code
  • Class Component Additional Meeting Type
  • Class Component Additional Meeting Type Code
  • Class Component Attendance Required
  • Class Component Contact Hours
  • Class Component Contact Minutes
  • Class Component Enrollment Count
  • Class Component Enrollment Flag
  • Class Component Meeting Day of Week
  • Class Component Meeting Day of Week Code
  • Class Component Meeting End Date
  • Class Component Meeting End Hour
  • Class Component Meeting End Minute
  • Class Component Meeting End Time
  • Class Component Meeting Start Date
  • Class Component Meeting Start Hour
  • Class Component Meeting Start Minute
  • Class Component Meeting Start Time
  • Class Section Remote Count
  • Class Section Remote Flag
  • Class Section Title
  • Enrolled Current Term Count
  • Enrolled Current Term Flag
  • Enrolled Future Term Count
  • Enrolled Future Term Flag
  • Primary Instructor Name
  • Room Capacity
  • Room Capacity Current
  • Room Code
  • Room Type
  • Room Type Code
  • Rounded Class Component Meeting End Time
  • Student Classification Code Current





Test Your Requested Enhancements!

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


Ui expand
titleSAH-Admissions-View

SAH-Admissions-View

Epic:  SAHMAINT-2186
Added the following fields:

  • Applied Flag Application
  • Applied Count Application
  • First Choice Major Department Code Application
  • First Choice Major Department Application
  • First Choice Major Code Application
  • First Choice Major Application
  • Second Choice Major Department Code Application
  • Second Choice Major Department Application
  • Second Choice Major Code Application
  • Second Choice Major Application
  • Primary Major Department Code First
  • Primary Major Department First
  • Primary Major Code First
  • Primary Major First

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

SAH-Enrollment-View & SAH-EnrollmentCensus-View

Epic:  SAHMAINT-2202
Aggregation change:

  • Course Highest Grade Earned Point set to Maximum aggregation
  • Course Highest Letter Grade Earned Point set to Maximum aggregation
  • Class Section Enrollment Limit set to Maximum aggregation

Ui expand
titleSAH-LMS-Student-View

SAH-LMS-Student-View

Epic:  SAHMAINT-2181
Added the following fields:

  • IP Address
  • User Agent


Ui expand
titleSAH-LMS-StudentStatsPerDay-View

SAH-LMS-StudentStatsPerDay-View

Epic:  SAHMAINT-2218
Added the following fields:

  • Academic Week Start Date
    • V
    • LMS Event Term Week Start Date
    • LMS Event Term Week End Date
    • LMS Event Calendar Week End Date
    • LMS Event Calendar Week Start Date
    • LMS Event Term Week Number
    • LMS Event Calendar Week Number
    • LMS Event Term Code
    • LMS Event Term ID
    • LMS Event Term Year
    • LMS Event Term Year (YYYY)
    • LMS Event Term Year (YY-YY)
    • LMS Event Calendar Year (YYYY)


    Ui expand
    titleSAH-LMS
    -Submission-Events
    -SubmissionEvents-View

    SAH-LMS-SubmissionEvents-View

    Epic:  SAHMAINT-2190

    Added the following fields:

    • IP Address
    • User Agent




    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.