How to calculate FTE metric for each month?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We are looking to build a query based portlet and want to display the data in terms of FTE rather than hours. From our investigation the FTE conversion is different for each month and based on the number of the working days in that month.

Is there a way to calculate this?

Environment

Release : 16.0.2

Resolution

The FTE conversion for each month is stored in RPT_CALENDAR table. You can check "select start_date,end_date,fte from rpt_calendar where period_type='MONTHLY'"