TCC Script Using 2 Products

I have a TCC script that is using the Requisition entity in the Recruiting product. I want to pull in Employee from SmartOrg in a subquery

Based on the Hiring Manager on the Req, I would like to pull in that Hiring Managers manager from the employee table into the Req export to provide a hierarchy in the requisition export.