Identity Information#

Functionality:#

This function retrieves information as seen on IEID, for an employee's identity information.

Parameters:#

EID_ID The actual ID for the identity record belonging to the employee you are getting data for
WHAT Identifies which field in the P2K_HR_IDENTITIES table you wish to retrieve

WHAT Parameter Values#

Any field name on P2K_HR_IDENTITIES
NAME Will return the First Name and Last Name of employee, separated by a space

Returns: #

Varchar2 (regardless of the type of data being requested)

Errors: #

  • *BAD EID_ID When there is no identity record with the ID provided
  • *BAD WHAT When the WHAT parameter is not one of the values supported

Example: #

P2K_PU.EID(~,'NAME') - Using Identity ID as the first parameter (~)

Will return the First Name and Last Name of employee, separated by a space

Notes#

Click to create a new notes page