The Raiser's Edge will create temporary tables during some processes, but these should be removed automatically (but not immediately). They are used by The Raiser’s Edge to help implement user-level security in preventing specific data from showing for users depending on who is running the query. 

In the SQL database, the temporary table names will be prefixed with tmp. For example: tmp4556188_215242586_2