How to list out the Profile Attachments in the Classic HEAT Database.
The Profile attachments in HEAT Classic are not stored in the database. The physical files are stored in a folder structure designed by the HEAT Administrator. When attaching a file to a Profile record, the path to and name of the file are stored in the database as a link to the proper file from the folder structure.
To find all the links to Profile attachments, run the following query against the HEAT Classic database:
WHERE GCode = 'AP'