Identity Information#

Functionality:#

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

Parameters:#

EEM_ID The actual ID for the identity record belonging to the employee you are getting data for
WHAT Identifies which element of the sundry line you wish to retrieve

WHAT Parameter Values#

GOVERNMENT_CODESALUTATIONFIRST_NAMEMIDDLE_NAMELAST_NAME
BIRTH_DATE GENDER NAME

Returns: #

Varchar2 (regardless of the type of data being requested)

Note that PERSON_CODE may be retrieved with P2K_SMGCD('EID',eid_id)

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