Database question here.
We normally use bullhorn1.BH_UserWorkFile to link document to database records, which has worked well in the past.
However we've starting finding that documents are missing from that table and were in bullhorn1.BH_UserMessageFile instead.
Does anyone know what the difference between these two tables is and which is best used to link documents to db records?
UserMessageFile is used for emails, UserWorkFiles is part of View_CandidateFile and is used for files in the UI normally.