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: #
NumericErrors: #
- 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.
