Qustion about caching/temp files on disk
I have a general question about the technical workings of Filemaker Pro. I am the IT manager at a genetics lab. We use Filemaker Server (v.11.0.4) to host our databases. We use Filemaker Pro (v.11.0.4) on many workstations and laptops (Windows and Macintosh). Some of our databases contain sensitive data or PHI (Patient Health Information). Our campus security has asked us to identify which of our computers are storing PHI on them. So what I really need to know is, how does FileMaker Pro handle caching of data? For example, if one of our users opens a FMP database containing PHI, does FMP cache the data locally on the laptop? Is the data written to the hard drive in a cache or temp file? Or is the cache only in physical memory (RAM)? Also, how is the cache stored? Text? SQLite? Is it encrypted at all or can it be easily accessed?
Thanks in advance for any input on this.