SAH Support for SIS Reporting

Owned by Saparnell
Last updated: Apr 22, 2024
3 min read

The Business Intelligence and Analytics team is supporting the project by prioritizing ESR SIS related requests for Student Activity Hub (SAH) enhancements.

A number of reports have been identified by the ESR SIS Report Remediation project and those reports are currently being remediated. You can view the included reports in the ESR SIS Report Inventory.

If your report is not on the ESR SIS Report Inventory then the divisional/departmental report developer is responsible for rebuilding the report, including working with the BIA team to add any missing fields to SAH.

What is a Report or Reporting Tool?

A report provides access to data. It can be a snapshot (PDF, Excel) or interactive (web interface). Often multiple databases feed data into this location.

It does not allow you to modify or update the data in the database.

Examples: Cognos, Tableau, query link

What is an Application?

An application is a tool that allow you to input data into a database. It is interactive, it can be a desktop installation or web interface. Can be used to feed data into other locations.

May be replaced by the new SIS. Unique data should be added to the Student Activity Hub.

Example: ISIS, DARs, UC Apply

What is Data Integration?

Data Integration moves data from one location to another via an automated process.

Any data moving into or out of the data warehouse via a script or file transfer must be updated to use the Student Activity Hub instead of the data warehouse.

Example: script, file transfer, nifi, api

Steps for the SAH Report Developer to remediate their Report or Reporting Tool

  1. Check the ESR SIS Report Inventory to see if your report is included in the ESR SIS Report Remediation project.

    1. If yes then no further action.

    2. If no then continue to #2.

  2. Identify the SAH Report Developer who will be rebuilding the report (it may be you).

  3. Compare the fields in the report with the current fields in SAH via the Activity Hub Field List report.

    1. Note, this report is available to everyone and contains all of the fields in all of the Activity Hubs so it takes a minute to initially load.

  4. The SAH Report Developer emails busintel@ucsd.edu asking to have their list of missing ISIS fields added to SAH.

    1. Please include the original source location from ISIS.

    2. If the source is not ISIS please check the data source list to see if your source has been requested.

  5. The BIA team meets with Jonathan Whitman’s technical team to talk about the missing field.

    1. The field may not from ISIS. If so, the field is evaluated for it’s impact to the ESR SIS Report Remediation project.

    2. The field may be calculated in the DW. If so, the calculation is investigated.

    3. The field may be in ISIS, but nobody has asked for it yet.

  6. The BIA team bring the ISIS field to the SAH Data Definitions Committee.

    1. The field may no longer be in use. If so, the ESR SIS Report Remediation project manager is notified.

    2. If the field is in use, a field name and description is identified, and the data source is confirmed.

  7. Then the new field is added to SAH Enhancement Monthly Release.

    1. If the field is not yet in SAH then it will need data integration and will not be scheduled for a SAH enhancement release until the data integration is complete.

    2. If the field is already in SAH but not viable to customers the field will be added to the next SAH enhancement release.

  8. Once the missing fields have been added to SAH the SAH Report Developer can then rebuild the report in Cognos or Tableau.

 

To see a list of SAH Enhancements In Progress visit .

To see a list of SAH Enhancements Completed visit .