Get Employee EEMID value#
Functionality:#
This function retrieves the ID for P2K_HR_EMPLOYMENTSParameters:#
PERSON_CODE | Optional. The PERSON_CODE for the employee. |
GOVERNMENT_CODE | Optional. The GOVERNMENT_CODE for the employee. If you prefix the government code with the letter "E", then the EXTERNAL_RETIREMENT_ID field (without the "E") is used to retrieve the EID_ID |
AS_OF | Optional. The AS OF date is used to search for an active employment on or after that date. If not provided then the current date is used. |
Returns: #
NumericErrors: #
- If no data is found (the employee cannot be found using either code), zero 0 is returned
- If any error occurs during data retrieval, -1 is returned
- If neither person code or government code parameters are passed, then NULL is returned
Example: #
P2K_PU.GET_EEM(~)
will get the EEM_ID value for the passed person code, for the active employment record with the most future hire date prior to today (current date)
P2K_PU.GET_EEM(0,~)
will get the EEM_ID value for the passed government code. Note that the first parameter is optional, but must still contain a value.
Notes#
- If you pass both GOVERNMENT_CODE and PERSON_CODE (as non-ZERO values), Government Code will be used first.
- If the GOVERNMENT_CODE parameter starts with the letter "E" then this is tripped off, and the value left is used to inquire on EXTERNAL_RETIREMENT_ID
- GOVERNMENT_CODE will be filled with leading zeroes, to make it nine digits long, and any hyphen separators provided, will be stripped out.
- The AS_OF parameter is used to locate the employment record for the most future active record (by HIRE_DATE). If there are no active records (no TERMINATION_DATE) then the most future record by hire date is returned.