Any Ad Hoc report created within a reporting User Group will be available to all users in that group.

Adhoc Query can also be executed from within the Manager's Desktop and from within the Human Resources Information system.

For further details on the Human Resources Information System refer to procedure Using the Human Resources Information System.

For further details on the Manager’s Desktop refer to procedure Using the Manager’s Desktop.

For details on executing reports please refer to procedure Run an Adhoc Report.

The screens, or infotypes, listed on the left side of the screen are dependent on your user settings; for example if you are an HR User you will see different information to a Payroll User.

It is not Mandatory to create all reports from scratch; the system comes supplied with a number of standard reports which can be selected using rather than using create. Such reports can have print fields and selection fields added or removed as required. When saving these reports to ensure the template report is not overwritten, select è Ad Hoc Query è Save as instead of normal save.

According to your access on the system you may be assigned to one or more of the following reporting User Groups. You should select the one you require.

HRUSERGRP for all HR Fields.

HRNOPAY for all HR except fields which contain Pay Information.

HGHRREC for Recruitment fields.

PYADM for Payroll fields.

When creating new Ad Hoc Reports you should use only the following Functional Areas.

HRUSERGRP_FA for all HR Fields.

HRNOPAY_FA for all HR except fields which contain Pay Information.

HGHRREC_FA for Recruitment fields.

PYADM_FA for Payroll fields.

You are presented with 3 columns of check boxes.

Column One represents Selection or Only If Fields.

Column Two represents fields to print.

Column Three represents text descriptions.of Coded fields to print.

Note the field is now checked and example output is beginning to build in the bottom window on the screen.

You can change the Column Order in the bottom window by selecting a column and then dragging and dropping it in the position you require. You can also sort a column by right clicking it and following the on screen selections. Report details can also be sorted and manipulated after report execution.

Note the Annual Salary is already selected for display.

You are presented with 3 columns of check boxes.

Column One represents Selection or Only If Fields.

Column Two represents fields to print.

Column Three represents text descriptions.of Coded fields to print.

Note the Annual Salary is now presented as a selection field in the window on the right of the screen.

In this example, you require a report on employees with salaries from £20,000 to £40,000 inclusive.

You can select single operations by clicking in the Opt (Option) column. If this were sufficient, you could use the following operators:- equals; greater than or equal to; greater than; less than or equal to; less than and not equal to.

In this example, you will select employees within a salary range.

The tabs can be used as follows:-

You are now selecting only Employees who have Annual salary over 20000 and less than 40000 inclusive

Note the icon to the right of the Value field now has a green bar on it to indicate that there are additional selections behind it.

You can select any period for your Ad Hoc report data selection.

In this example there are 14 employees who, as at today's date, have a basic pay between £20,000 and £40,000 inclusive.

Note the name of the Query, and consequently the heading, has been automatically generated. Once a report has been saved and re-opened it displays the Title as it's heading. See Step 9

For details on report output processing options please refer to procedure Run an Adhoc Report.

The Title field will be used as the heading for the report once the report is saved and re-opened at a later date.

The system displays the message, "Query RJP_SALARY_1 was saved in user group HRUSERGRP".