Hi,
We recently uploaded documents under document of record for all the employees.
I intend to write a query to validate if the correct file is uploaded for all the 1600 employees but cannot seem to find the appropriate table name for retrieving the file name uploaded under document of record.
The following records don’t give me the document categories, document type ,document name etc but not filenames uploaded:
SELECT * FROM HR_DOCUMENTS_OF_RECORD WHERE PERSON_ID IN (SELECT DISTINCT P.PERSON_ID FROM PER_ALL_PEOPLE_F P WHERE P.PERSON_NUMBER = ‘10077899’