Get Employee TOTAL_FTE value#

Functionality:#

Provides the total amount of FTE across all ACTIVE assignments. ACTIVE statuses will be defined to any status code found on P2K_CM_EMPLOYMENT_STATUSES table with a status type of Active or Leave.

Parameters:#

EEM_ID Required. The EEM_ID from P2K_HR_EMPLOYMENTS belonging to the employee in which FTE is to be gathered
AS_OF_DATE Required The as-of date in which the FTE is to be totaled. If not provided, the current date is used.

Returns: #

Numeric

Errors: #

  • If any error occurs during data retrieval, 0 is returned

Example: #

P2K_PU.TOTAL_FTE(~)

will get the TOTAL_FTE for the passed EEM_ID as of the system date.

P2K_PU.TOTAL_FTE(~,'01-Jan-2017')

will get the TOTAL_FTE for the passed EEM_ID as of '01-Jan-2017'.

Notes#


Notes#

Click to create a new notes page