Compensation Cycle Details

Ad Hoc Reporting Guide

Version
R2025.2.1
Compensation Cycle Details

The Compensation Cycle Details report uses the Compensation Management topic to display details for your organization's compensation cycles. It lists all of the employees getting rewards under each cycle and includes the different reward types.

Fields

Fields included in the report template
Field Name Group by Sort Order Totals
Compensation Cycle Yes Ascending  
Employee Name Number      
Employee Local Currency      
Pay Type      
Compensation Manager      
Manager      
Pay Component      
Current Salary      
Current Hourly Rate      
Current Compa-Ratio (%)      
Eligible Salary      
Target      
Target (%)      
Guidelines (%)      
Guidelines (Flat Amount)      
Allocated (%)      
Allocated      
Allocated Effective Date      
Allocated IsPosted      
Allocated Posting Type      
Reason Code      
Earning Code      
Allocated Hourly Rate      
Proration Factor      
Lump Sum      
Lumpsum Effective Date      
Lumpsum IsPosted      
Lumpsum Posting Type      
Lumpsum Earning Code      
New Salary      
New Hourly Rate      
New Compa-Ratio (%)      
Total Target Cash      
Total Actual Cash      
Bonus Factor Guidelines      
Bonus Source      

Custom Fields

Guidelines

The Guidelines field displays the compensation guideline amount for that employee. It uses the following expression:

CONCAT(CAST(CPCompensationCycleManagerWorksheetEmployeePayComponent.RecommendedPercentEnd AS decimal(18, 2)), '-', CAST(CPCompensationCycleManagerWorksheetEmployeePayComponent.RecommendedPercentStart AS decimal(18, 2)))

Bonus Factor Guidelines

The Bonus Factor Guidelines field displays the bonus factor guideline amount for that employee. It uses the following expression:

CONCAT(CAST(CPCompensationCycleManagerWorksheetEmployeeBonusFactor.RecommendedPercentEnd AS decimal(18, 2)), '-', CAST(CPCompensationCycleManagerWorksheetEmployeeBonusFactor.RecommendedPercentStart AS decimal(18, 2)))

Filters

The template includes the following filters:

Filters available for the report.