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.
