X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=blobdiff_plain;f=sql%2Fhreduperson.sql;h=b3cb5b3e1db1ce7a600d0da8fb02ce1f27defef3;hp=cbf08112c87f2182399f1d96871b355ba6e67453;hb=cdf5334694219b628813a512b37f3115535907a1;hpb=5bb14e63038006514db929f1469080d318f8b832

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index cbf0811..b3cb5b3 100644
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -12,12 +12,16 @@ select
 	concat(firstname,' ',surname)			as cn,
 
 	-- SAFEQ specific mappings from UMgr-LDAP.conf
-	borrowernumber					as objectGUID,
+	b.borrowernumber					as objectGUID,
 	surname						as displayName,
-	rfid_sid					as pager,
+	a.attribute					as pager,
 	email						as mail,
 	categorycode					as memberOf,
 	categorycode					as ou,
-	concat('/home/',borrowernumber)			as homeDirectory
-from borrowers
+	categorycode					as department,
+	concat('/home/',b.borrowernumber)			as homeDirectory
+from borrowers b
+left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
+
+