The job I've been tasked with is to "import the users from Active Directory", which I think I can do with some of the tutorials I've found on here. What I'm unclear on is if I can link a second table that is "manually" populated by our HR department, containing more sensitive information that they do NOT want put into Active Directory (like emergency contact info, home phone number, etc).
I'm hoping to display accounts in particular AD containers in the directory, but then query a second SharePoint list to see if there is any "sensitive information" in it that should also be displayed.
Is there a way to "merge" the search results with the table (ugh...I mean "list" -- sorry, I'm still old school DB) of "sensitive info" and display it together?
Someone needs to write a book on just building employee directories with SharePoint.