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. |
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'
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation