a txtSchoolID is automatically created when an admissions record is first generated / inquiry first made.
I believe the first few digits are the TIME that record was first made e.g. 103341705547 was at 1033 and 084849888271 at 0848.
Can we PLEASE change it so that it doesn't have a leading zero, is just a pain!
The use of a number field with leading zeros is a serious flaw in DB design. For one, everytime you export data from iSAMS the zeros get truncated.
I have asked this to be fixed in the past but got the "cannot be fixed at this time." I have been able to get past it by using a number format of twelve zeros as all numbers that start with a 1 are longer and all the others that do not start with a 1 had leading zeros. However, a student that was recently created started with ‘08’ but was 13 digits long, so this removes the ability to use a number format of twelve zeros as if I add thirteen, the others have two leading zeros.
iSAMS, please fix this.
Leading 1 would be good. Or if there's any concern about duplication of existing values, how about prefixing it with a 2 digit year? i.e. all of this year's new records would have txtSchoolID beginning with 25
Even if they all started with a 1 this would be OK. Just have 1..... and then the usual code that follows normally. Simple fix?