Status |
| ||||||
Owner | |||||||
|---|---|---|---|---|---|---|---|
Contributors | |||||||
Approved | |||||||
Due date |
| ||||||
Decision | Business Logic for SITS records to be integrated to Jarvis | ||||||
On this page |
|
❓ Problem statement
Business agreement on award status in scope for integration.
💡 Research insights
📊 Solution hypothesis
Business Requirement for SITS/Jarvis Integration (TO-BE)
Business Requirements
Business Requirement for SITS data needed in Jarvis | Signed off |
|---|---|
1 New (First Time) Students that have graduated with a degree (not short courses). SIT data that will be pushed and ingested
2 Changes (Future Updates) Address or other contact updates or degree status has change (?? Which object will push changes) |
Assumptions/Facts:
SITS contains all Sydney Student data, future, current and graduated;
SITS does not contain short course students information;
People that have completed their studies are captured in the SAW (Student Awards) Table
This includes people that ,
We only want people that have received their degrees
SIT data that will be pushed and ingested = AW – Awarded; CF - Conferred - No other records prior to that point. (ie No …EL - Eligible; CA - Calculated)
Dummy date for the awarded degrees and actual date to be received from conferred degrees;
SITS Final status is Graduand and there is no ALUMNI status in SITS, calculated during integration. (Jarvis Specific)
If alumniGraduandType = 'Graduand' and awardlist is not blank and conferredDate exists with a valid date value, then status = ‘Alumni’
If alumniGraduandType = 'Alumni' and awardlist is blank and conferredDate = null or not valid then status = 'Graduand'
🌈 Technical Solution Design
SITs data that will be pushed and ingested:
Award Codes (AWS) Records
Code | Short Name | Definition | Integration In Scope Y/N | |
|---|---|---|---|---|
AC | Awarded/Conferred | For Higher degrees like Masters, PhD's, Doctorates) : completion of all requirements. (Eligible to graduate) | Y | |
CA | Calculated | Anyone with an AWARD.* progression outcome, but this status is temporary and does not guarantee that students will be awarded. If the student is a potential graduand they will be awarded, if they are not a pot grad they will eventually have the calculated award removed and status updated to allow further enrolment. | NY | |
CF | Conferred | After the above statuses have been confirmed, students with an EL or AW status will be updated to CF (conferred) or AC (Award conferred), which enables them to attend a graduation ceremony. | Y | |
DR | Deferred | ?? | NAwarding of student has been deferred | Y |
EL | Eligible | For Graduate Certificates, Graduate Diplomas, Diplomas and Bachelor degrees): for Higher degrees like Masters, PhD's, Doctorates) : completion of all requirements. (Eligible to graduate) | NY | |
HS | Honours | ?? | NThis is a special award status used by the Student Record team in case a student’s award and honours have the same title (e.g. Award: Bachelor of Music Studies, Enrolled: Bachelor of Music Studies (Honours), we update the awarded course to ‘Converted to Honours’) so they are not allocated to a ceremony and conferred. | Y |
MS | Masters | ?? | NSimilarly used by the Student Records team for students who have completed a course but are “progressing to masters” | Y |
RE | Research Exam | ?? | NThis special award status is placed on a research degree that is under examination for a example a PhD, which may take a long time before the thesis has been reviewed and passed or has to be resubmitted | Y |
Future updates:
Changes to the following fields will drive updates
Address
Email
…. ???
# AS-IS
# Changes Needed
💎 Source files
/wiki/spaces/IP/pages/1352368226
✅ Follow up
Decision | Status | Next steps | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||