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#

• If an AS_OF_DATE is not provided, then the system date will be used.
• The DES_ID defined on the P2K_HR_ASSIGNMENT_DETAILS will be used to determine if the assignment is active.
• Any STATUS_CODE defined on the P2K_CM_EMPLOYMENT_STATUSES table with a STATUS_TYPE of 'Active' or 'Leave' will be considered 'ACTIVE' by the funciton.

---

Notes#

Click to create a new notes page