Get Employee EEM_ASOF#

Functionality: The purpose of this function is capture the corresponding EEM_ID from P2K_HR_EMPLOYMENTS using a PERSON_CODE, EMPLOYMENT_TYPE and as of date. #

Parameters:#

PERSON_CODE Required. The PERSON_CODE for the employee.
EMPLOYEE_TYPE Optional. The EMPLOYMENT_TYPE as defined on the IMLN lexicon X_EMPLOYMENT_TYPE. If not provided then the value '00' is used.
AS_OF Optional. The employment that has this date that fall between the HIRE_DATE and the TERMINATION_DATE will be returned. If not provided then the current date is used as the as of date. If the employment has overlapping dates, the record with the greatest hire date based on the as of date will be returned. If the employment has a null value for a TERMINATION_DATE than the end of time will be used as a date.

Returns: #

Numeric

Errors: #

  • If no data is found (the employee cannot be found using either code), zero a null value is returned
  • If any error occurs during data retrieval, 0 is returned
  • If the employment has overlapping dates (To many employments), the record with the greatest hire date based on the as of date will be returned.

Example: #

P2K_PU.GET_EEM_ASOF(~)

will get the EEM_ID value for the passed person code, for the employment record with the most future hire date prior to today (current date) with an employment type of '01-Employee'

P2K_PU.GET_EEM_ASOF(~,'03')

will get the EEM_ID value for the passed person code if the employment type is '02-Retiree'.

P2K_PU.GET_EEM_ASOF(~,'01','01-Jan-2017') will get the EEM_ID value for the passed person code, for the employment record with a HIRE_DATE less than and TERMINATION_DATE greater than '01-Jan-2017' with an employment type of '01-Employee'

Notes#


Notes#

Click to create a new notes page