3 concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr') as dn,
7 hrEduPerson' as objectClass,
10 firstname as givenName,
12 concat(firstname,' ',surname) as cn,
14 -- SAFEQ specific mappings from UMgr-LDAP.conf
15 b.borrowernumber as objectGUID,
16 surname as displayName,
19 categorycode as memberOf,
21 categorycode as department,
22 concat('/home/',b.borrowernumber) as homeDirectory
24 left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'