Relevant Employees 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 a list of employees who were employed by your organization on the snapshot date - these are referred to as "relevant employees."

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

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:

Report filters.