ID Numbers: Auto-Generated with Numeric Range by School Location


For schools that let the SDS program assign student ID numbers to new students as they are added to the system, SDS has added the option to specify an id number range. This will require you to set up a view for the table Z_Schoollocation including these two fields, first student id and last student id. You can set the first and last valid id number for each location.

For location 2, you can specify 2000001-2999999, etc.

The program will check, based on the student location entered for the student, and look within this range to get the next id number.

If the student location doesn’t have these fields filled in, it will do as it always has – get the next highest available number.