Payroll Data for Gender Pay Reporting

This report is designed for customers in the United Kingdom to use when fulfilling their gender pay reporting requirements. It displays data about your employees and their pay so that you can calculate your organisation’s gender pay gap figures.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number
Employee Gender
Employment Status Group Name
Base Rate
Normal Weekly Hours
Pay Frequency Name
Weekly Denominator
Earning Code Name
Earning Name
Units
Pay Run Earning Rate
Pay Run Earning Amount
Category of Earnings
Pay Run Pay Date
Snapshot Date
Current Snapshot Period

Custom Fields

Snapshot Date

The Snapshot Date custom field displays the snapshot date used to generate the report. It uses the following expression:

@SnapshotDate

Current Snapshot Period

The Current Snapshot Period custom field uses the following expression:

case when  PRPayRun.PeriodEnd  >= @SnapshotDate then 1 else 0 end

Weekly Denominator

The Weekly Denominator custom field uses the following expression:

CASE WHEN ISNULL([PayFrequencyCulture].[ShortName], [PayFrequency].[ShortName])  = 'Semi-Monthly' THEN 2.166750 
WHEN ISNULL([PayFrequencyCulture].[ShortName], [PayFrequency].[ShortName])  = 'Bi-Weekly' THEN  2 
WHEN ISNULL([PayFrequencyCulture].[ShortName], [PayFrequency].[ShortName])   = 'Monthly' THEN  4.333314
WHEN ISNULL([PayFrequencyCulture].[ShortName], [PayFrequency].[ShortName])   = 'Weekly' THEN  1
WHEN ISNULL([PayFrequencyCulture].[ShortName], [PayFrequency].[ShortName])   = '4-Weekly' THEN  4
ELSE
0
END

Filters

The template includes the following filters: