!!Get Employee P2K_PU.GET_EAS

!Functionality: Determine the [EAS_ID] from the [P2K_HR_ASSIGNMENTS] table using the [EEM_ID], an [ASSIGNMENT_CODE]

!Parameters:

|EEM_ID     | ''Required''. The [EEM_ID] for the employment.
|ASSIGNMENT_CODE   | ''Optional''. The [ASSIGNMENT_CODE] as defined on the [P2K_HR_ASSIGNMENTS] table for the matching [EEM_ID]. If not provided then the value '00' is used. 

!Returns: 
Numeric

!Errors:  
* If no [EAS_ID] can be found a null value will be returned
* If TOo_MANY_ROWS than -1 will be returned
* All other errors will result in a 0 

!Example: 

{{P2K_PU.GET_EAS(~)}}

will get the [EAS_ID] value for the passed [EEM_ID] and [ASSIGNMENT_CODE] '00'. 

{{P2K_PU.GET_EAS(~),'PRIMARY')}}

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

{{P2K_PU.GET_EAS(P2K_PU.GET_EEM_ASOF(~,'01','01-Jan-2017'),'02')}}

will determine the correct [EEM_ID] as of the provided date for an employees with the [EMPLOYMENT_TYPE] of '01-Employee'. It will then capture the [EAS_ID] from the passed [EEM_ID] and matching [ASSIGNMENT_CODE] of '02'

[{InsertPage page='Internal.P2K_PU.GET_EEM_ASOF' default='Click to create a new notes page'}]