I have a task to find all resumes per CANDIDATE id in Talent Acquisition (TA) to be uploaded to another application.
I have found the CandidateDocument table that provides some info but nothing regarding the location for the file(s).
SQL code:
select * from LMGHRDB.lm_ghr.CANDIDATEDOCUMENT cd
where cd.DELETEFLAG = 0
and cd.CANDIDATE = 9494
SQL result:

Any ideas for where to look?
Thanks