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.xxxx - Any field name from P2K_HR_ASSIGNMENT_DETAILS. The value returned will be the value from the immediately preceding effective record on that table. If there is no immediately preceding effective record, then NULL will be returned.
  • NEXT.xxxx - Any field name from P2K_HR_ASSIGNMENT_DETAILS. The value returned will be the value from the immediately following effective record on that table. If there is no immediately followingeffective record, then NULL will be returned.
Special values:
  • 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. If you want the value from the immediately preceding record instead of the previous value, you can obtain this with a recursive call as in:
    • p2k_pu.easd(p2k_pu.easd(ID,'PREV.ID'),'WAGE_RATE')
  • 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