Table of Contents

Student Number

Starting with the 23-24 school year. Student Numbers and PINs are going to be different. Student Numbers are now going to match the Student's MOSIS number. PINs should now be exclusive to Food Service and Library systems.

UniqueID Extract

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

UniqueID Import

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

Student Number Scheduled Task

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

Temporary StudentNumber

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

Delete StudentNumberHistory

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

Set StudentNumber to State ID

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