!!Get Employee EEMID value

!Functionality:
This function retrieves the ID for [P2K_HR_EMPLOYMENTS]

!Parameters:

|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: 
Numeric

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