Dreamisdead

Add a second Script Filter downstream from your first one that lists the selected contact's details.
 
As you say, you can't return items of type "contact", so you can't use Alfred's contact viewer with your own data. Your only option is to create your own viewer based on a Script Filter. That or integrate your employee directory into Contacts.app.

Thanks!
 
 
Not really. Pass the details to the second Script Filter via variables or arg (perhaps as JSON-encoded data), or read them from cache. After that, it mostly depends which actions you want to connect the contacts to. For phone and email, I think you can just tell Alfred to open a tel: or mailto: URL respectively. Message/IM might be a bit trickier (dunno; never tried it).

I don't know if I get it right, but if you want to search for a contact and get the output like the default contact search of Alfred, then you can search your address book database using a File Filter based on your contact name that you get from your first script filter and send the found contact to open in Alfred (if Alfred is set to "Open Contacts in Alfred").
 
What I mean is:
[Your Script Filter] -> {query is now your contact name} -> [The File Filter that gives you a list of matches] -> [Open the match in Alfred]
 
Here is an example: https://d.pr/f/yIPU1v
 
Just change the "ys" keyword object to your Script Filter
 
If you Employee name is always the first in the list then you can rapidly press a second Enter to go directly to the Alfred Contact Viewer (or automate this second Enter key press)
 
It could be done by using a second Script Filter, but if you want to access your contacts database directly then I think using the File Filter could be an easy way
 
To give credits, my File Filter that search the Address Book database is a modified version of @Vero workflow that you can find here: 
 

Hello guys!
Just wanted to share workflow I created for Mountain Duck app.
Heavily based on Cyberduck Favorites by Kasoki


Just use "md" and "mt" keywords for searching your bookmarks list of ftp\sftp\basically any type of server to quickly mount\unmount or ssh to it. 
It's based on apple script menu bar item click integration, but is very reliable, at least for me.
Workflow
GitHub
 
Happy for any kind of feedback

Hello guys!
Just wanted to share workflow I created for Mountain Duck app.
Heavily based on Cyberduck Favorites by Kasoki


Just use "md" and "mt" keywords for searching your bookmarks list of ftp\sftp\basically any type of server to quickly mount\unmount or ssh to it. 
It's based on apple script menu bar item click integration, but is very reliable, at least for me.
Workflow
GitHub
 
Happy for any kind of feedback