!!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'),'01')}} 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'}]