Answered my own question. Looks like the tool takes text or numeric field types for Inspection ID, however in the process it converts it to numeric and I'm guessing when it tried to join the tables it refused. I changed the Inspection ID to numeric from text and the process worked and all fields appeared correctly. Going to add a suggestion that ESRI create documentation for best field formats when using their solutions.