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)
  • PREV.WAGE_DATE - The effective date when the wage was set to be the wage indicated on the passed assignment detail record.

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