!!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|Edit:Internal.GET_EID] [{InsertPage page='Internal.P2K_PU.DES_TYPE' default='Click to create a new notes page'}]