* Add zeros padding to PERSON ID
X.PERSON.ID.LEN = LEN(A.PERSON.ID)
X.ZEROS.TO.PAD = 7 - X.PERSON.ID.LEN
IF (X.ZEROS.TO.PAD GT 0) THEN
A.PERSON.ID = STR("0", X.ZEROS.TO.PAD) : A.PERSON.ID
END
My Ellucian's Colleague playground with all tips and tricks I learned as a programmer.
Thursday, August 18, 2016
Padding preceding zeros to Colleague ID
In Colleague, ID numbers often have preceding 0s, and these are often truncated as the data is imported into Colleague. To add a small check to the ID to make sure it always is 7 number-long, you can add the following:
Subscribe to:
Posts (Atom)