The PIM Reports are a robust reporting method that enables users to generate reporting based on all fields in the PIM module as well as a set of commonly used canned reports. This feature helps to retrieve information such as Employee Turnover - Hiring Report, Employee Turnover - Termination Report, Head Count Report (Per Location), Head Count Report (Per Sub Unit), License Expiry Report, etc.
This feature allows admins to create custom reports and select fields in the PIM module that needs to be displayed on the report. The user can generate detailed and precise PIM reports by adding relevant fields and setting relevant criteria to process the report.
Go to PIM -> Reports, to view the available Reports.
Step 1 - Click the 'Add' button on the top right corner of the screen. Then, Add Reports Screen will appear as below.
Step 2 – Give a name for the report and click on the "Next" button.
Step 3 – Through "Selection Criteria", you can define which records to be included in the report by selecting the fields. Click the "Additional Selection Criteria" if you want to select additional fields that aren't listed on the screen.
Step 4 – Select default tabs and custom field sections from the drop-down. The fields available in the chosen section will be listed (includes custom fields). Then select the necessary fields to define the selection criteria. Once selected click the "Save" button.
Note - Out of custom fields, only the types listed below are available as selection criteria.
- Drop Down
- Radio Button
Step 5 – Repeat steps 3 and 4 until you have all the fields you want, selected.
Step 6 – Use the selected fields to set the selection criteria you want. Some fields like "Sub Unit" allow multiple values. Once selected, click on the "Save" button.
Step 7 – Click the "Add Display Field Group" button, in order to add any fields to display.
Step 8 – From the drop-down list, select a PIM tab. The fields of the tab selected will appear as below.
Step 9 – Select which fields you want to show on the report.
Step 10 – Repeat steps 6 and 7 until you have all the fields required selected.
Step 11 – Click on the "Save" button to save the report.
Note: The salary components can be added as separate columns in the report. The following screen displays the salary component selection criteria.
The report will display the salary components as columns and all the deductions will follow the Earnings.
It is also possible to filter and view employees who are supposed to be terminated in the future by PIM report by adding the future dates for the 'From' and 'To' dates.
The following screen displays job component selection criteria.
You can select "Current employees Only" from the 'Include' filter and add a termination date range from the "Termination Date" filter. These filter criteria will generate a report that shows the employees who are supposed to be terminated in the future between the selected termination date range.
The “Show Chart” icon is visible once the user creates the PIM report. The icon is displayed on the top right corner. Once the user selects the show chart option, the system displays the options for the user to select the chart type and proceed with creating the chart by providing the chart settings to create the desired chart type.
Step 1: Upon clicking the "Show Chart" icon, the system displays the following window to set the chart settings.
|Chart Type||Select the chart type Ex: Bar chart, Pie Chart|
|Group By||This the value that you have to select as the X-axis|
|Aggregate||This the value that you have to select as the Y-axis|
|Aggregate Type||If the user selects a numeric field as the aggregate value the available options are "count". If the user selects a non-numeric field as the aggregate value the available options are "Count", "sum", "average"|
|Show Summary Table||Enable/disable summary table|
|Hide Detailed Data||Enable/disable Detailed data information|