put categorycode also in department attribute
[virtual-ldap] / sql / hreduperson.sql
1
2 select
3         concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
4         'person
5         organizationalPerson
6         inetOrgPerson
7         hrEduPerson'                                    as objectClass,
8
9         trim(userid)                                    as uid,
10         firstname                                       as givenName,
11         surname                                         as sn,
12         concat(firstname,' ',surname)                   as cn,
13
14         -- SAFEQ specific mappings from UMgr-LDAP.conf
15         borrowernumber                                  as objectGUID,
16         surname                                         as displayName,
17         rfid_sid                                        as pager,
18         email                                           as mail,
19         categorycode                                    as memberOf,
20         categorycode                                    as ou,
21         categorycode                                    as department,
22         concat('/home/',borrowernumber)                 as homeDirectory
23 from borrowers
24