Student Number

The UniqueID Extract exports student data to meet the requirements of the Student Batch File, in an effort to enter students records into MOSIS for identifier assignment (student needs a new ID) or to manage student updates.

UniqueID Extract

The UniqueID Import takes the newly assigned student IDs provided by MOSIS and imports them into Campus. Data matches on the student's Social Security number and/or Student Number. If one or both of these do not match, an error generates. If the last name, first name, birth date and gender do not match, a warning generates but the state ID still imports.

UniqueID Import

A task runs hourly to manage some of the tasks needed to make interfacing with the MOSIS ID system easier.

Local ID cannot be blank when processing records in the MOSIS ID Assignment system.

StudentNumber is set to PersonID where a Person does not have a student number and has an active enrollment.

UPDATE Person
SET studentNumber = P.personID
FROM Person P
JOIN Enrollment E ON P.personID = e.personID
WHERE studentNumber IS NULL AND E.endDate IS NULL

A StudentNumberHistory record is generated when StudentNumber is updated. There is not a need to keep the record where studentNumber is personID so it will be deleted.

DELETE FROM StudentNumberHistory
WHERE CAST(personID AS VARCHAR) = studentNumber

After importing StateID numbers; Set StudentNumber to StateID where PersonID and StudentNumber are the same (this is the temporary student number condition).

UPDATE Person
SET studentNumber = stateID
WHERE stateID IS NOT NULL AND stateID <> studentNumber