SMS StudentUnitCourse Status v Connect Enrolment Status

The SMS.StudentUnitCourse table details a Student’s status in each of their Unit Availabilities.

The following ruleset will be used to check/set a student's enrolment status in Connect each morning.
Date based changes (Withdrawals, Pre-SOS and COS) are handled separately, please see Key SMS dates v Connect Enrolment Status for details.

Notes: This table and ruleset built from all existing states in the SMS as of 8/6/2020.

The T1 SMS Integration ‘push’ occurs every 10 minutes. This process enrols students into newly mapped units, or newly enrolled students into existing mappings, throughout the day.
At busy periods, the process may take longer than 10 minutes causing delays in the timing of subsequent batches.

UnitStageCd	UnitStageDesc	UnitSttsCd	UnitSttsDesc (SSP Status)	Present Enrolment Status	Updated Enrolment Status	Notes
ADM	Admitted	PLN	Planned	n/a	n/a
CANC	Cancelled	CANC	Cancelled	n/a	n/a
COMP	Completed	ADVNG	Advanced Standing Not Granted	n/a	n/a
COMP	Completed	CR	Credited	Student	Student COS
COMP	Completed	EX	Exempt	Student	Student COS
COMP	Completed	FAIL	Failed	Student	Student COS
COMP	Completed	PASS	Passed	Student	Student COS
COMP	Completed	PLN	Planned	n/a	n/a
ENR	Enrolled	ENR	Enrolled	Student COS	Student*	Updated only if COS date not yet reached.
ENR	Enrolled	PASS	Passed	Student	Student COS
ENR	Enrolled	PLN	Planned	n/a	n/a
OFF	Offered	PLN	Planned	n/a	n/a
PLN	Planned	ADVUA	Advanced Standing Under Assessment	n/a	Student	UA StudyMode must also be RPL Connect unitcode must be RPL No PreSoS
PLN	Planned	PASS	Passed	n/a	n/a
PLN	Planned	PLN	Planned	n/a	n/a
PLN	Planned	WD	Withdrawn	n/a	n/a

Initial Student enrolment handled by T1 integration. Subsequent Student enrolments to correct Swap/Drops and other errors only.