Get Employee EASD_ID value for the latest prime assignment#
Functionality:#
This function retrieves the ID for P2K_HR_ASSIGNMENT_DETAILS for the Prime Assignment detail record that is the most future, linked to the last hire date.Parameters:#
| PERSON_CODE | Optional. The PERSON_CODE for the employee. |
| GOVERNMENT_CODE | Optional. The GOVERNMENT_CODE for the employee. |
Returns: #
NumericErrors: #
- If no data is found (the employee cannot be found using either code), -2 is returned
- If no employment record is found (corrupt data), -3 is returned
- If no prime assignment record is found expiring at the end of time, -4 is returned
- If any error occurs during data retrieval of the IDENTITY record, by Government Code then -99 is returned
- If any error occurs during data retrieval of the IDENTITY record, by Person Code then -96 is returned
- If any error occurs during data retrieval of the EMPLOYMENTS record, then -98 is returned
- If any error occurs during data retrieval of the ASSIGNMENT/ASSIGNMENT_DETAILS records, then -97 is returned
Example: #
P2K_PU.GET_EASD(~)
will get the EASD_ID value for the passed person code
P2K_PU.GET_EASD(0,~)
will get the EASD_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.
- GOVERNMENT_CODE will be filled with leading zeroes, to make it nine digits long, and any hyphen separators provided, will be stripped out.
Here is an example of how to use this function to update a User Defined Field from an excel spreadsheet.
