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

Example: #


Notes#

Click to create a new notes page