How do I view/edit gender pay gap snapshot details?

Modified on Tue, 10 Dec at 2:28 PM

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.

Attachments (2)

67584ffb8946....png
41.7 KB

67584ffb8946....png
70.4 KB