Within Cintra iQ, you can create a snapshot of data for the set of payrolls of your choosing. The Gender Pay Gap - Snapshot Extract window displays the date to which the snapshot applies, its description, who created the extract, the details of when the extract took place, and the applicable payrolls.
Once you have created the snapshot, you can view all of its details or edit specific data in the Gender Pay Gap - View/Edit window. You can also save or print the extracted data.
To view/edit gender pay gap details
Go to Cintra iQ: Payroll> Payroll Tools> Gender Pay Gap> Snapshot Details
GPG Data Extract
Select from the GPG Data Extract drop-down list, select the snapshot extract you wish to view and/or edit.
Extract tab
Filter pane
You can filter the Extract data by double-clicking on a column header. The selection appears in the Filter pane.
- Click the Step Back button to remove the last filter added.
- Click the Clear Filter button to clear the filter options.
Data pane
Name | Description |
---|---|
Empt Id |
Employment Identification. |
Surname |
Last name of employee. |
First Name | First name of employee. |
M/F
|
Gender
|
Payroll Period
|
Relevant Payroll Period for the snapshot date.
|
Exclude
|
Use this to exclude any employee who you do not want to include in the statistics e.g. Contractors etc.
|
*
|
If visible, hover over the asterick to view the attached note.
|
Hourly Rate
|
Calculated Hourly Rate
|
Weekly Ord
|
Weekly Ordinary pay received in the relevant snapshot period
|
Weekly Bonus
|
Weekly Bonus pay received in the relevant snapshot period.
|
Weekly Bonus O/R
|
Use this to update the Weekly Bonus amount. Once the change is applied, this entry overrides the existing amount and the hourly rate is updated.
|
Weekly Hours
|
Weekly hours worked in the relevant snapshot period.
|
Weekly Hours O/R
|
Use this to update the Weekly hours. Once the change is applied, this entry overrides the existing hours and the hourly rate is updated.
|
On Full Pay
|
Yes: Employee is on Full Pay.
No: Employee is not on Full Pay. |
On Full Pay O/R
|
Use this to update whether the employee is on Full Pay. Once the change is applied, thi s selection overrides the existing value.
|
Ann. Bonus
|
Annual Bonus amount.
|
Ann. Bonus O/R
|
Use this to update the Annual Bonus figure. Once the change is applied, this entry overrides the existing amount.
|
Period Ord.
|
Ordinary pay received in the relevant period.
|
Bonus Period
|
Bonus pay received in the relevant period.
|
Post Titles
|
Employee's post.
|
Organisational Units
|
Organisation unit to which the employee belongs.
|
Notes
|
Comments.
|
How do I override an entry?
Click in the desired Override field and update the data accordingly. Click the Apply button to save the changes.
How does the Gender Pay Gap Snapshot account for employees not on full pay?
The hourly rate should only be taken into account for those employees on Full pay. If an employee is on reduced pay due to being on leave, their hourly rate should not be taken into account when calculating the mean, median and quartile figures.
When the snapshot data is extracted, an employee is marked as Full Pay = No in the following circumstances:
- The employee is receiving no pay.
- The employee is in receipt of company sick pay, at a rate of less than full pay, during the snapshot period.
- The employee has a calendar absence for an attendance category that is ticked as being Not Normally Paid.
- The employee is either starting or leaving part way through the snapshot period.
Note:
If there are other employees who you know to not be on full pay, then you should mark them as not full pay so that their hourly rate does not get included in the statistics.
Report tab
Once the hourly rate, the annual bonus and the gender has been gathered for each employee, the following calculations can be made, which the GPG report displays.