Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au

Skip to end of banner
Go to start of banner

TAP-908 SITS/Jarvis Integration - Business Logic

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 16 Next »

Status

IN PROGRESS

Owner

Manpreet Sidhu

Contributors

albie.roets satparkash.kaushik rommel.ngo pat.dennis

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

  • AW – Awarded

  • CF - Conferred

2 Changes (Future Updates)

Address or other contact updates or degree status has change (?? Which object will push changes)

Assumptions/Facts:

  1. SITS contains all Sydney Student data, future, current and graduated;

  2. SITS does not contain short course students information;

  3. People that have completed their studies are captured in the SAW (Student Awards) Table

  4. This includes people that ,

  5. We only want people that have received their degrees

  6. 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)

  7. Dummy date for the awarded degrees and actual date to be received from conferred degrees;

  8. SITS Final status is Graduand and there is no ALUMNI status in SITS, calculated during integration. (Jarvis Specific)

    1. If alumniGraduandType = 'Graduand' and awardlist is not blank and conferredDate exists with a valid date value, then status = ‘Alumni’ 

    2. 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.  

Y

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

Awarding 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)  

Y

HS

Honours

This 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

Similarly used by the Student Records team for students who have completed a course but are “progressing to masters” 

Y

RE

Research Exam

This 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

DECIDED / IN REVIEW / OTHER

  •  

  • No labels