Overview

Scope

Currently, most downstream systems integrate with EUCLID using the legacy EUGEX database, which has limitations such as specific update times, ongoing maintenance requirements, and susceptibility to failure.  Tribal roadmap is to make API (Application Programme Interface), available in the future (next SITS versions) but only to cloud clients. Change-based event integrations with EUCLID have already been implemented for some systems e.g. P&M student fees, Enquiry Management and the new Student Case Management System.  

The project will deliver generic students and programmes/courses related API which abstract downstream systems from Tribal technologies. Downstream applications will fetch the most up-to-date student and applicant data from EUCLID. 

 

Out of scope

  • the success of the project is to deliver/make the API available, but it will not deliver the integration to downstream systems (those using EUGEX or StuTalk). This is dependent on resources and requirements available and would require further work outside student systems or require external resources for development and testing.  

  • The file generator is used to generate the csv from a number of EUGEX views for different end users. Replacing the file generator integration to these applications/users is out of scope for this project for two reasons: 1) for resource constraints, 2)this project will focus on delivering the API for student records. Once we have a set of APIs available, then we can look at replacing the existing integration/technologies with API. It will require more coordinated effort with the stakeholders to move from file-based integration into API based integration. So, ideally this will be delivered by a separate  project. 

Objectives and Deliverables

 

Ref 

Objectives 

Deliverables 

Priority 

Benefits 

O1 

Analyse generic API  

D1-Articulate the level of access security required 

 

D2-Improve current change-based events to make the triggers of SITS change more generic, incl error handling & notifications

 

D3- Analyse the CAM requirements for the degree finder, clarify what’s in scope for tuition fees

 

D4- Analyse the Timetabling requirements  

D3.1/4.1 Define the data model for each API, i.e. what the properties does a ‘student’ ( and ‘a programme’) have  

 

D5- Analyse the future SITS API  

 

Must 

 

Must 

 

 

Should 

Should

Should 

 

Should 

D1/D2: 

  • consistent mechanisms for data transfer, 

  • streamlining integration processes using API/ Tribal’s STUTALK 

  • it should improve overall system performance and facilitating seamless data exchange between EUCLID and downstream systems 

D3- replacing the current use of csv files, which are manual steps 

 

D4- replacing the current EUGEX integration built for EventMap 

 

D5-when supplier's SITS API becomes available, this could be used 

O2 

Build API 

D6-Build API for Programme and Course information incl tuition fees 

 

D7-Build API for Student information and Student Course Enrolment 

 

Must 

 

Must 

  • Future integrations with downstreams systems do not rely on EUGEX update/feeds anymore, reducing dependency on the EUGEX database, especially if we move to the cloud as per Tribal roadmap 

  • Scalability, and reducing dependency on SSP development resources to write integrations 

O3 

Test cases the new built API 

D8-Deliver test case: the generic API can integrate with Degree Finder and Timetabling EventMap. SSP will deliver the platform for other services to integrate to. The success of the test case will be to test the data is available to the end points in EUCLID when fetching data. 

 

D9-Test the change notifications are sent correctly from EUCLID . 

 

D10-Build dashboard to represent the availability of the end points. 

Must 

 

 

 

 

Must  

 

 

Could 

The expected benefit of this project will be for developers of systems looking to integrate using the API (e.g. Degree Finder, Timetabling) can be confident that the API is robust, and that the integration can be tested/implemented successfully. 

Noting that future benefits if the Degree Finder delivers a separate project to access new API would be significant:  

  • Programme data feed, benefit to prospective student web: remove the need for manual work uploading data files into Degree Finder and reducing the overall risk of data errors 

  • Entry Requirement (ER): For users, enables future opportunities to present international ERs within programme page and use richer experiences, instead of user needing to navigate a separate website. Reduces numbers of enquiries and wasted applications, by improving presentation and accuracy of information, prospective students are able to better self-serve and self-identify 

  • Course information: Reduces need for users to navigate through other systems to find information important to them. Users can better identify if the programme is right for them. Reduce numbers of enquiries because prospective students are more easily able to identify if a programme is right for them.

O4 

Documentation 

D11-Documentation on how downstreams applications can consume the SITS data  

D12-Articulate the Data Access Protocol 

Must 

 

Must 

Wiki documentation. New API is updated in Abbacus 

 

The Data Access Protocol process is reviewed in light of the new available API for passing sensitive student data 

 

Success Criteria

The success  will be  to confirm  the data is available to the end points in EUCLID when fetching data, evidenced by test cases working with Timetabling and Degree Finder services.

Project Milestones

Stage Milestone Due Date
Plan Project brief sign off 26-Aug-2024
Analyse Analyse- Engagement, capture requirements, review design 18-Sep-2024
Build Build API 1st set: course and programme 07-Oct-2024
Build Build API 2nd set: Students 28-Oct-2024
Integrate Testing API 25-Nov-2024
Accept Test case with CAM 02-Dec-2024
Accept Test case with Timetabling 16-Dec-2024
Accept Rework API 15-Jan-2025
Deliver Deploy API 31-Jan-2025
Deliver Review DSOR 14-Feb-2025
Close Close 28-Feb-2025

Project Info

Project
Delivering Student Records API
Code
SAC106
Programme
Student Systems Partnership SSP
Management Office
ISG PMO
Project Manager
Franck Bergeret
Project Sponsor
Lizzie Beattie
Current Stage
Build
Status
In Progress
Project Classification
Grow
Start Date
10-Jun-2024
Planning Date
28-Aug-2024
Delivery Date
27-Jan-2025
Close Date
28-Feb-2025
Overall Priority
Normal
Category
Discretionary

Documentation

Plan