put categorycode also in department attribute

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index cbf0811..568e5f5 100644 (file)
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -18,6 +18,7 @@ select
        email                                           as mail,
        categorycode                                    as memberOf,
        categorycode                                    as ou,
        email                                           as mail,
        categorycode                                    as memberOf,
        categorycode                                    as ou,

+       categorycode                                    as department,

        concat('/home/',borrowernumber)                 as homeDirectory
 from borrowers
 
        concat('/home/',borrowernumber)                 as homeDirectory
 from borrowers