These links are for files that are designed for use by spread sheets. This can result in an empty field, for example if a person has no middle initial. This number is no longer included. The translation is the same for both sets. Within each file you first get the name, surname, first name, middle initial.
All subsequent fields are numeric.
An entry may be 0, but otherwise it is up to 8 digits. These numbers can be checked against the master list at the BoR, Search on the number 01013 at Depts at BoR 2. Start of State service, year. Birthdate, yyyymmdd 5. Search on 01028 at Ranks 6.