concat('ou=',c.categorycode,',dc=ffzg,dc=hr') as dn,
'organizationalunit' as objectClass,
c.categorycode as ou,
- c.description as description
+ c.description as description,
+ -- fake for SafeQ, we don't have numeric primary key
+ crc32(categorycode) % 1000 as objectGUID
from categories c