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 from P2K_HR_IDENTITIES
• NAME - Will return the First Name and Last Name of employee, separated by a space
• EEM_ID-nn - Will return the ID of the P2K_HR_EMPLOYMENTS record that has the most future hire date for the employment type identified by nn. If no employment type is provided (i.e. the parameter is just "EEM_ID-" (with the hyphen)) then the most future hire dated employment ID will be returned, regardless of employment type.

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

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

Will return the ID of the current employment ID for employment type = 01 (Employee). Note that this does not restrict to active records - the employee may be terminated on this record. This can be used in a qualification record to compare if the EEM_ID retrieved is equal to this most current record.

---

Notes#

Click to create a new notes page