Employee Attributes Monthly

Ad Hoc Reporting Guide
Version
R2025.2.1
Employee Attributes Monthly

The Employee Attributes Monthly report displays a series of employee attributes that have been pre-calculated for each completed month.

Fields

Fields included in the report template
Field Name Group by Sort Order Totals
Year      
Month      
Employee Id      
Efficacy Flag      
Exhaustion Flag      
Observation Date      

Work Energy

     

The following previously active fields have been deprecated from the template:

  • Company Tenure
  • Department Tenure
  • Job Tenure
  • Most recent Tenure
  • Time since last Base Rate
  • Time since last Base Salary
  • Time since last Employment Reason
  • Time since last Employment Status update
  • Time since last Employment Status change
  • Time since last Hire Date
  • Time since last Location
  • Time since last Normal Weekly Hours
  • Time since last Pay Class
  • Time since last Pay Type
  • Time since last Termination Date
  • Time since last Work Assignment
  • Time since Original Hire Date
  • Unique Base Rates
  • Unique Base Salaries
  • Unique Departments
  • Unique Employment Statuses
  • Unique Jobs
  • Unique Locations
  • Unique Work Assignment

Custom Fields

Calendar Month

The Calendar Month custom field displays the monthly abbreviation from the Gregorian calendar. It uses the following expression:

@CASE WHEN EmployeeAttributeMonthly.MonthId = '1' THEN 'Jan'
WHEN Employee AttributeMonthly.MonthId = '2' THEN 'Feb'
WHEN Employee AttributeMonthly.MonthId = '3' THEN 'Mar'
WHEN Employee AttributeMonthly.MonthId = '4' THEN Apr'
WHEN Employee AttributeMonthly.MonthId = '5' THEN 'May'
WHEN Employee AttributeMonthly.MonthId = '6' THEN 'June'
WHEN Employee AttributeMonthly.MonthId = '7' THEN 'July'
WHEN Employee AttributeMonthly.MonthId = '8' THEN 'Aug'
WHEN Employee AttributeMonthly.MonthId = '9' THEN 'Sept'
WHEN Employee AttributeMonthly.MonthId = '10' THEN 'Oct'
WHEN Employee AttributeMonthly.MonthId = '11' THEN 'Nov'
WHEN Employee AttributeMonthly.MonthId = '12' THEN 'Dec'

ELSE' '

Sort Month

The Sort Month custom field sorts the month. It uses the following expression:

@CASE WHEN EmployeeAttributeMonthly.MonthId = '1' THEN 'Jan'
WHEN Employee AttributeMonthly.MonthId = '2' THEN 'Feb'
WHEN Employee AttributeMonthly.MonthId = '3' THEN 'Mar'
WHEN Employee AttributeMonthly.MonthId = '4' THEN Apr'
WHEN Employee AttributeMonthly.MonthId = '5' THEN 'May'
WHEN Employee AttributeMonthly.MonthId = '6' THEN 'June'
WHEN Employee AttributeMonthly.MonthId = '7' THEN 'July'
WHEN Employee AttributeMonthly.MonthId = '8' THEN 'Aug'
WHEN Employee AttributeMonthly.MonthId = '9' THEN 'Sept'
WHEN Employee AttributeMonthly.MonthId = '10' THEN 'Oct'
WHEN Employee AttributeMonthly.MonthId = '11' THEN 'Nov'
WHEN Employee AttributeMonthly.MonthId = '12' THEN 'Dec'

ELSE' '