create view ldap as select agency as objectclass,
   (agency || '-' || folderid) as dnqualifier,
   (fname || ' ' || lname) as cn,
   lname as sn,
   fname as givenname,
   org as o,
   orgunit as ou,
   city as l,
   cp as postalcode,
   adr as postaladdress,
   country as c,
   email as mail,
   tel as telephonenumber,
   fax as facsimiletelephonenumber,
   photo as photoid,
   cert as certid,
   comment as description
   from userspool
   where state = 'ACTIVE'