Can anyone tell me which table in SQL you can use to match the path with the document?

I have a filename that is not appearing in search but is showing as being in a wait state by a deleted user - I am trying to track down where it is (I assume the file is deleted) - just looing for a simple table where I can match PathID with DocumentID.

Thanks