The Banner view that Scott Wood assembled for the library, aka allBannerInfo.txt, includes the following fields. The number indicates their positions in the array and the field names in the users db table are in bold:
- 0 - barcode: barcode
- 1 - altID: externalSystemId
- 2 - ?cred:
- 3 - last name: personal.lastName
- 4 - first name: personal.firstName
- 5 - middle name: personal.middleName
- 6 - suffix:
- 7 - street1: personal.addresses.addressLine1 *
- 8 - street2: personal.addresses.addressLine2
- 9 - city: personal.addresses.city
- 10 - state: personal.addresses.region
- 11 - zip: personal.addresses.postalCode
- 12 - country: personal.addresses.countryId
- 13 -
- 14 -
- 15 - campus address: personal.addresses.addressLine1 **
- 16 -
- 17 -
- 18 -
- 19 -
- 20 -
- 21 -
- 22 -
- 23 -
- 24 -
- 25 -
- 26 - email address: personal.email; parsed to provide JSON with a username
- 27 -
* 7-? : addressType = Home
** 15 : addressType = Campus