Assignment Detail Information#
Functionality:#
This function retrieves information as seen on IEAS, for an employee's assignment information.Parameters:#
EASD_ID | The actual ID for the assignment detail record belonging to the employee you are getting data for |
WHAT | Identifies which data you wish to retrieve |
WHAT Parameter Values#
- Any field name from P2K_HR_ASSIGNMENT_DETAILS
- EAS.xxxxx - Any field name from P2K_HR_ASSIGNMENTS
- PREV.WAGE_RATE - The wage rate from the previous assignment where it had been different (note that this may not be the immediately preceding assignment detail). If no wage change has ever been made, NULL will be returned.
- PREV.WAGE_DATE - The effective date when the wage was set to be the wage indicated on the passed assignment detail record. If no wage change has ever been made, NULL will be returned
Returns: #
Varchar2 (regardless of the type of data being requested)Errors: #
- *BAD EASD_ID When there is no assignment detail record with the ID provided
- *BAD WHAT When the WHAT parameter is not one of the values supported