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: #
NumericErrors: #
- 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'
Click to create a new notes page