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_CODE | SALUTATION | FIRST_NAME | MIDDLE_NAME | LAST_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