Secure Query is a query and reporting tool that enables you to request specific information from the database tables in Sage HRMS. For example, if you need information about your employees' demographics in a hurry to prepare for a meeting, Secure Query makes it easy to get the information you need.
When you use Secure Query, you can select which fields to output, sort results in ascending or descending order, build record filters, and group and summarize fields. When finished, you can choose to output the query as a report, spreadsheet, text file, or database table. You can also create and save the queries to be reused any time you need the information.
Ad Hoc Reporting Security
Use Ad Hoc Reporting Security to restrict the database files and fields available to a security group who uses Secure Query. Ad Hoc Reporting Security lets you assign an access level to each field contained in your Sage HRMS databases.
Setting a group’s Ad Hoc Reporting Security Level works in conjunction with setting Ad Hoc Reporting Security. When you set up group security, (by selecting Setup > System > Group Security link ), you establish an access level that determines which fields in the Sage HRMS system databases are able to be accessed by the security group’s users whenever they use Sage HRMS Secure Query.