-# Net::LDAP::Entry will lc all our attribute names anyway, so
-# we don't really care about correctCapitalization for LDAP
-# attributes which won't pass through DBI
-my $sql_select = q{
- select
- trim(userid) as uid,
- firstname as givenName,
- surname as sn,
- concat(firstname,' ',surname) as cn,
-
- -- SAFEQ specific mappings from UMgr-LDAP.conf
- surname as displayName,
- rfid_sid as pager,
- email as mail,
- categorycode as ou,
- categorycode as organizationalUnit,
- categorycode as memberOf,
- categorycode as department,
- borrowernumber as objectGUID,
- concat('/home/',borrowernumber) as homeDirectory
- from borrowers
-};
-