Ad Hoc Query is a tool that enables you to access and report data from Human Resources. It involves choosing the selection and output fields.
You can use Ad Hoc Query to report on the following data:
- HR master data, data from Time Management, and payroll results (logical database PNPCE)
- Applicant master data (logical database PAP)
- Data from Personnel Planning (logical database PCH)
Unlike standard reports that use logical databases to retrieve data, Ad Hoc Query selects the requested data directly from the database. As a result, the performance of Ad Hoc Query is better than that of standard reports. The standard authorization check is performed when data is selected and output.
You do not need programming skills to use Ad Hoc Query. Instead, you can choose selection and output fields simply by clicking on them or by using drag and drop.
Overview of Ad Hoc Query
Ad Hoc Query offers the following features:
- Drag and drop:
- You can choose selection and output fields easily by using the drag and drop function. Select the fields you need and drag them to the Selection or Output area. If the field names of a field group have values and text, you can either use the text, the value, or both.
- Personalization:
- When you exit Ad Hoc Query or logoff from the system, the system saves your user settings (for example, for the last queries you accessed) and reloads them the next time you start the query.
- Object selection:
- You can switch off object selection and work in basic mode by choosing Extras → Switch Off Object Selection. This enables you to use all basic modes, such as selections using texts.
- Output preview:
- You can output real data on the Ad Hoc Query screen.